OBJECTIVE

• A challenging and rewarding career in an organization of repute, where I can use my knowledge to the fullest and which would help in my personal development. As a Oracle Applications Database Administrator, I am keenly interested to serve the organization skillfully and efficiently to attain the defined goals of the organization and get better exposure to the cutting edge of technology.

SUMMARY

• Over 10+yrs of experience in IT Industry as an Oracle Apps DBA in implementation, Administration, Testing, Maintenance and support.
• Extensive experience as an ORACLE Applications DBA in a variety of different environments like AIX, SUN SOLARIS, Linux and WIN NT/2000/2003
• Installation, Configuration & Deployment of Oracle E - Business Suite 11i/R12.1.3/R12.2.4
• Extensive Experience in Oracle E-Business suite applications (R12.2.4,R12.1.1,11.5.10.2, 11.5.9,11.5.3) on Linux, HP, AIX & Sun Solaris.
• Oracle Applications Release R12.2,R12.1, 11i installation & Configuration Good problem-solving capabilities.
• Served as Oracle Applications DBA. Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning. Duties included database creation, database tuning, SQL statement tuning, Web Server, backup/recovery, general troubleshooting, script development, and documentation.
• Installed and patched R12.2.R12.1.1, 11.5.9,11.5.10.2 instances through adop and adpatch tools,
• Provide support to Discoverer 11g/10g/4.1.48.06 versions.
• Worked on AD utilities like adpatch, adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig, etc.
• Cloning R12, 11i databases using through oracle applications and rapid clone technique.
• Appling the OS patches for Linux R12,11i and Oracle Application patches and upgrade the Application databases from 9.2.0.4 to 9.2.0.5/10g/11g/12c.
• Very strong in Auto Patch, Upgrade, cloning.
• Management of schemas, objects & Partitioning the tables & indexes.
• Performed backups and tested crash recoveries using conventional Hot & Cold backups and RMAN
• Expertise in installing, maintaining and administering Oracle Applications 11i (11.5.3, 11.5.9, 11.5.10, R12) instances.
• Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
• Upgraded the RUP version from 3 to 7 in Oracle Applications 11.5.10.2.
• Upgraded the Oracle Applications from 11.5.10.2 to R12(12.1.1).
• Upgrade Oracle Applications R12.1.1 to R12.1.3
• Configured Discoverer 11g and integrated with Oracle Applications.
• Deploying JRE for Windows Clients in Oracle Applications
• Implemented shared appltop application systems and configured BigIP to load balance mid-tiers
• Integrated Oracle Applications 11i with OID/SSO
• Expert in monitoring databases and applications using Oracle Enterprise Manager/Oracle Applications manager (OAM)
• Troubleshooting expertise for all tiers (Apache, Forms,Concurrent,Admin, Jinitiator and database)
• Upgraded the database from 9.2.0.8 to 10g to 11g as part of R12 upgrade.
• Production DBA Experience on Oracle releases12c/11g/10g/9i/8i
• Expertise in configuring various oracle application modules likeDiscoverer, Workflow
• Performed backups and tested crash recoveries using conventionalHot&Coldbackups and RMAN.
• Expertise on Installation, Configuration of Oracle Application Server 10g.
• Expertise in handling Many Oracle Applications Databases with sizes varying from 300 GB to 10 Tera Bytes.
• Experienced in Oracle Apps Administration and Sysadmin tasks
• Experience in supporting Oracle Application modules like Oracle Financials - Financials Accounting Hub(Subledger Accounting),AP, AR, GL, FA, FCG, CM, HRMS, LM, SCM, Iprocurement, Iexpense
• Performed Sysadmin activities on Oracle Financials - Financials Accounting Hub(Subledger Accounting) module by creating module users,responsibilities,menus,submenus,request groups.
• Interacted with Oracle Financials - Financials Accounting Hub(Subledger Accounting) users and fixed the users issues on the technical side as well as on Oracle application side.
• Interacting with the developers of Oracle Financials - Financials Accounting Hub(Subledger Accounting) team fix the development issues related to the Financials Accounting Hub module and migrate the Codes from dev to uat and Prod environments.
• Tune and applied patches on the Oracle Financials - Financials Accounting Hub(Subledger Accounting) module.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard). Thorough Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard
• System Administration of Oracle Application using Application Object Library and System administration module, using listed tasks: Registering New Application, Registering New schema, Registering Customized Tables using Application Standards, Creating new customized responsibilities, Menus, Request group, Functions, Concurrent programs. Administering Concurrent Processes and Managers and Automating the Request.
• Good experience in Installing and providing support In OBIEE applications as well.
• Good presentation and communication skills to provide support to the Customer.
• Ability to work flexibly as a team member.
• Dedication with an inner drive to succeed and accomplish goals.
• Ability to perfectly plan and execute the given job to perfection.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/2003/ XP, Sun Solaris 8.0 and 9.0 and s everal flavors of Linux.

RDBMS: Oracle9i, Oracle10g. Oracle 11g, Oracle GoldenGate Repository

ERP: Oracle Applications 12.2.4/12.1.1/12.1.3/11 i (R12.2.4,R12.1.1,R12.1.3,11.5.4, 11.5.9, 11.5.10.2)

Modules: HR Payroll,Subledger Accounting, AP, AR, GL, FA, FCG, CM, HRMS, LM, SCM, Iprocurement, Iexpense, INV, OM, Manufacturing

Other Tools: RMAN, Tkprof, Statspack, Forms and Reports6i, Discoverer

Network Protocol: Net 8, SQL*Net

Scheduling Tools: Cronjob (UNIX), Oracle Enterprise Manager

PROFESSIONAL EXPERIENCE

Confidential

Sr Oracle Apps DBA

Responsibilities:

• Active member in R12 (12.1.3) new implementation which includes multimode RAC on linux and multimode apps servers with PCP.
• Supporting Oracle application R12.2.4 environments with 12c databases.
• Performed Cloning on the R12.2.4 database.
• Performed patching on those environments through adop tool.
• Supporting oracle applications 12.1.3 production systems of size 4 Terabytes on 4 Node RAC and ASM
• Oracle E-Business Upgrades, Database Upgrades, Techstack Upgrades, Cloning, Configuring, Support, Patching, CPU and DST Patching, Patch Analysis, Migration, Backup & Recovery, Post Installation support and automation of DBA activities.
• Oracle E-Business Suite R12.2.4,R12.1.3, 11i/11.0.3/12.xxx Cloning, AutConfig, Upgrade, Patching, Database Refresh, Troubleshooting, Installation, Database specific UNIX shell scripts and Oracle 12c/10g/11g DBA Tasks and Oracle Enterprise Manager.
• Provided Application and Concurrent Manager load-balancing, Fail over, User creation, Roles and Managing Security & Concurrent Managers administration,Printers/Profiles.
• Configured standby databases for our existing Production databases and activated for testing.
• Data guard Implementation from TEST to PROD
• Cloning RAC to RAC, RAC to Non RAC and Non RAC to RAC
• Patching RAC nodes
• Administration of OEM like monitoring the databases, server load, invalid objects,cpu,blocking Locks, long running sessions, scheduling jobs and alerting based on the metrics.
• Monitor database alert log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization
• Adding and Deleting Oracle RAC from Nodes on Linux and UNIX Systems, diagnose problems for Oracle Real Application Clusters components using trace and log files
• Integrated Oracle Single Sign on (SSO) with Release 12/11i EBIZ.
• Converting Single-Instance Oracle Databases to Oracle RAC and Oracle RAC One Node
• Experience creating, managing troubleshooting physical and logical standby databases. Upgrading Databases in an Oracle Data Guard Configuration. Experience working on different scenarios while administering Oracle Data Guard configuration
• GoldenGate configuration review, implementation, test and performance analysis and tuning.
• Installed and configured Golden Gate software, patching, created manager, extract, replicate parameter files and tested the data flow from source to target database
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, MTTR Advisor, EXPLAIN PLAN, TK PROF, and DBV
• Experienced with tools/utilities: OEM, RMAN, Stats pack, TOAD, SQL Navigator, and SQL* Loader, Data Pump (expdp/impdp).
• Worked both as a Development DBA and a 24x7 Production DBA
• TAR management with Oracle support
• Monitoring and configuring OEM
• Handling production Crisis calls and finding the RCA
• Designing backup strategy
• Managing Users, working with SOX Team for validations
• Worked on 10g, 11g databases, and R12.1.1 applications.
• Shell scripting for the database and application monitoring
• Configured Oracle Discoverer 11g and integrated it Oracle applications
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Set up Printers and Workflow mailer in Oracle Applications R12.1.3 Prod, UAT,QA,DEV Environments
• Worked closely with Functional/Developers and helping them in fixing issues
• Upgraded Oracle applications from 11.5.10.2 to R12.1.1
• Upgrade Oracle Application from R12.1.1 to R12.1.3.
• Configuring the Internal and external certificates in Oracle applications as per bank standards.
• Apply patches to the database using opatch tool and usingADPATCH for e-business suite
• SSO/OID integration with Oracle Apps R11.5.10.2
• Collect and analyze performance statistics for resource consumption and performance improvement. Managing Tablespaces, Data files, Rollback segments and Temporary Tablespaces.
• Configuration of Parallel Concurrent Processing(PCP)E-business suite R11,R12.
• SQL tuning and Databaseperformance tuninghas been done based on reports generated by SQL Trace, TKPROF Reports, Explain Plan (10046), Stats pack, AWR, ADDM, ASH and monitor the database performance on daily basis.
• Administered theRACusing various utilities like SRVCTL, CRSCTL, ASMCMD and EM Database Control for R12 EBS.
• Applying latest patches from Oracle Support to the Test and Production Instances for resolving issues or Enhancing features.
• Cloning 11i & R12 ERP Instances from Production to Test, Development Instances and coordinate with Testing and Development Teams.
• Backups- Logical and Physical for Multiple Instances.
• Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Tablespace Quotas.
• Experience in Upgrading 11gR1 to 11gR2 for R12.1.1 Environment
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.
• Scheduled the Rman Backup scripts in a cron job.
• Applied Patches for Developers Bug fixes and Scheduled Maintenance on Oracle Applications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed the Oracle 10g,Oracle 11g databases and Created Tablespaces on ASM environment.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Performed the Restore of Oracle 10g/11g databases on a One node RAC environment.
• Tested the relocate of the One node RAC environment.
• Install, configure and write scripts for RMAN
• Daily DBA activities as Performance Monitoring, Instance Health Check etc
• Working with FNDCPASS to change Passwords of APPLSYS,APPLSYSPUB and SYSADMIN
• Provided 24*7 Production support in Oracle Production Databases as well as Oracle Applications environments.
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)
• Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.

Environment: Oracle Database11g, Oracle Database 10g,Oracle Applications 12.2.4/12.1.3/11.5.10.2 , Toad, DBartisian, MobaXterm, ASM, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES6,AIX 5

Confidential, Omaha,NE

Oracle Apps DBA

Responsibilities:

• Providing Support to Oracle R12(12.1.1) Application.
• Upgraded the Oracle Databases from 10.2.0.5 to 11.2.0.4
• Worked on 10g, 11g databases, and R12.1.1 applications.
• Maintaining, Monitoring and Administering for Oracle applications environmeny on RAC architecture
• Performed Multi Node installation of Oracle EBS R12.1.1
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Setup the RAC one node.
• Set up Printers and Workflow mailer in Oracle Applications R12.1.1 Prod, UAT,QA,DEV Environments
• Worked closely with Functional/Developers and helping them in fixing issues
• Upgrade Oracle Application from R12.1.1 to R12.1.3.
• Applying latest patches from Oracle Support to the Test and Production Instances for resolving issues or Enhancing features.
• Cloning 11i & R12 ERP Instances from Production to Test, Development Instances and coordinate with Testing and Development Teams.
• Backups- Logical and Physical for Multiple Instances.
• Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Tablespace Quotas.
• Experience in Upgrading 11gR1 to 11gR2 for R12.1.1 Environment
• Raising the Service Request and working with Oracle Team.
• Installed and configured 10g Discoverer on a Oracle Application environment.
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.
• Scheduled the Rman Backup scripts in a cron job.
• Applied Patches for Developers Bug fixes and Scheduled Maintenance on Oracle Applications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed the Oracle 10g,Oracle 11g databases and Created Tablespaces on ASM environment.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Performed the Restore of Oracle 10g/11g databases on a One node RAC environment.
• Tested the relocate of the One node RAC environment.
• Install, configure and write scripts for RMAN
• Daily DBA activities as Performance Monitoring, Instance Health Check etc
• Working with FNDCPASS to change Passwords of APPLSYS,APPLSYSPUB and SYSADMIN
• Provided 24*7 Production support in Oracle Production Databases as well as Oracle Applications environments.
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)
• Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.

Environment: Oracle Database10g, Oracle Database 11g,Oracle Applications 12.1.1, Toad, DBartisian, MobaXterm, ASM, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES6.

Confidential, Pittsburgh,PA

Oracle Apps DBA

Responsibilities:

• Providing Support to R12(12.1.1) Application users through ticketing system.
• Upgraded the Oracle Databases from 10.2.0.4 to 11.2.0.2
• Worked on 9i,10g, 11g databases, R12 applications.
• Maintaining, Monitoring and Administering for 12 Instances on RAC architecture
• Performed Multi Node installation of Oracle EBS R12.1.1
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Set up Printers and Workflow mailer setup in Oracle Applications R12 Prod, UAT,QA,DEV Environments
• Working closely with Functional/Developers and helping them in fixing issues
• Raising the Service Request and working with Oracle Team.
• Installed and configured 10g Discoverer on a Application environment.
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.
• Scheduled the Rman Backup, Obsolete, ageing of alert log jobs through Autosys in Oracle applications R12 environment.
• Applied Patches for Developers Bug fixes and Scheduling Maintanence on Oracle Applications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Migrated the Oracle forms and reports from One sever to another, compiled them through f60gen in Oracle Applications Environment.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed the Oracle 10g databases and Created Tablespaces.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Provided 24*7 and On Call support in Oracle Databases and Oracle Applications(11i.R12).
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)
• Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.

Environment: Oracle Database10g, Oracle Applications 12.1.1,Oracle Applications 11.5.10.2, Toad, DBartisian, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES4.

Confidential, Atlanta,GA

Oracle Apps DBA

Responsibilities:

• Upgraded the Oracle applications from 11.5.10.2 to R12(12.1.3)
• Upgraded the Oracle Databases from 9.2.0.8 to 10.2.0.5
• Worked on 9i,10g, 11g databases and 11i(11.2.0.1,11.2.0.3), R12 applications.
• Supported the 2- node, 3-node, 4-node and multi-node RAC environment.
• Maintaining, Monitoring and Administering for 12 Instances on RAC architecture
• Performed Multi Node installation of Oracle EBS R12.1.1
• Migrating the Oracle Applications 11.5.10.2 and Oracle 10g databases from Confidential Servers to Confidential Servers.
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Set up Printers and Workflow mailer setup in Oracle Applications R12 Prod, UAT,QA,DEV Environments
• Working closely with Functional/Developers and helping them in issues
• Handling Tars
• Installed and configured SOA, BPEL, Single sign on Setup and Providing the Application support.
• Installing and providing support In OBIEE applications as well.
• Implemented SSO/OID with E-Business Suite
• Installed 10gias 10.1.4.0.1 infra as part of sso implementation
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.
• Scheduled the Rman Backup, Cleanup, size check, ageing of alert log jobs through Autosys in Oracle applications R12 environment.
• Applied Patches for Developers Bug fixes and Scheduling Maintanence on Oracle Applications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Migrated the Oracle forms and reports from One sever to another,compiled them through f60gen in Oracle Applications Environment.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed the Oracle 10g Datawarehouse databases and Created Tablespaces.
• Done Full Exports and Imports of the database at schema as well as tablespace level. and loaded data into database.
• Installed Oracle software 9.2.0.5, Upgraded it to 9.2.0.8 database.
• Experience in supporting Oracle Financial modules like Oracle Financials - Financials Accounting Hub(Subledger Accounting Subledger Accounting,AP, AR, GL, FA, FCG, CM
• Cloning the Oracle 9i/10g Databases from Production to UAT,QA,DEV databases through rman.
• Experience with OIM,SSO,OID integration with EBS.
• Worked Closely with Unix Team and Provided Specifications for Installing Oracle applications on a Red hat Linux 4 Enterprise Server.
• Performed SQL tuning, Database Tuning,Application Tuning and Improved the performance of database/applications.
• Created users, Profiles, Assign Grants, Granted Roles and Quota to users.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin
• Worked with Functional and Technical engineer and helped them in issues
• Prepared the documentation for day to day activates as apps dba for post production, architecture details, pre plan for Production Assessment

Environment: Oracle Database10g, Oracle Applications 12.1.1,Oracle Applications 11.5.10.2, Toad, DBartisian, Erwin, Oracle Enterprise Manager (OEM) Grid Control, RMAN,Red Hat Linux ES4.

Confidential, Atlanta, GA

Oracle DBA & Apps DBA

Responsibilities:

• Migrate the Oracle10g databases, Oracle Applications 11.5.10.2 from one datacenter to another datacenter.
• Installed and configured Single-Sign On (SSO), Oracle internet directory (OID)11g and Access manager 11g.
• Cloning the Oracle Applications from production to UAT & Dev & QA.
• Supported the 2- node, 3-node, 4-node RAC environment.
• Configured 2 node RAC with PCP for Ebusiness R12 along with DG setup
• Performing the Oracle Applications failover from Prod server to DR server and reverted back from DR to Prod server as per Client Standards
• Cloning the Oracle Applications Databases from Production to UAT,QA, DEV databases.
• Applied CPU patches in Oracle Databases 10g and Oracle applications 11.5.10.2 Every Quarter as per requirements.
• Setup XML Publisher 5.6.3 in Oracle Applications 11.5.10.2
• Upgraded Oracle applications from 11.5.10.2 to R12.
• Cloning the Oracle applications R12 environments.
• Performed Sysadmin activities on R12 environments.
• Implemented new features like Transportable Table spaces, Locally Managed Table spaces, Multiple Archive-Log Destinations that support Standby Databases
• Migrating the database character set from US7ASCII to UTF8
• Wrote UNIX scripts to monitor size of the tablespaces and scheduled it in crontab.
• Forms Patch set 19 Upgrade on 11.5.10.2 Instances.
• Performance Tuning of Applications and Databases using tkprof, explain plan.
• ORACLE TAR Management: Raised and monitored TAR s with Oracle Corporation for issue resolutions.
• Responsible for setting-up and managing Standby databases using Data guard for DR sites.
• Cron Job Validations & Additions for DBA Jobs like Analyze, monitoring..
• Work closely with the Developers and Application Users to fix there issues in Database and Applications.
• Experience in supporting Oracle Financial modules like Oracle Financials - Financials Accounting Hub(Subledger Accounting),AP, AR, GL, FA, FCG, CM
• Performing the Oracle Applications failover from One Prod server to another server.
• Installing a Oracle 10g Data Warehouse Environment and Maintaining the database.
• Applied the CPU patch in Oracle Application Databases and Core databases.
• Applied Patches and Doing Maintanence on Oracle Applications
• Cloning the Oracle Applications from production to Dev & QA.
• Created users and Assign Grants, Roles, Quota to users in Oracle Applications.
• Upgraded the 10g database from 10.2.0.1 to 10.2.0.2
• .Done Full Exports and Imports of the database at schema as well as table space level.
• Restoring the Applications databases from production to Dev & QA & UAT Databases.
• Migrating the Oracle applications database from Oracle9i to Oracle10g Database.
• Upgraded Oracle Applications Jinitiator version from 1.3.21 to 1.6.
• Executed the turnovers as per developer’s doc and migrated code from Development to remaining Oracle applications environments.
• Applied Patches for Developers Bug fixes and Scheduling Maintanence on Oracle Applications

Environment: Oracle Database10g, Oracle Applications R12,Oracle Applications 11.5.10.2, Toad, DBartisian, Erwin, Oracle Enterprise Manager (OEM) Grid Control, RMAN,Red Hat Linux ES4.

Confidential, Dallas

Oracle DBA

Responsibilities:

• Install Oracle 10g software on the server and initial Creation of the database.
• Configuring listener using NETCA tool.
• Database upgrades (9i to 10g)
• Created users and Assign Grants, Roles,Quota to users.
• Monitoring the production and development databases by checking database
• Wrote Pl/sql procedure scripts to load PWS data from one server to another.
• Done Full Exports and Imports of the database at schema as well as tablespace level.
• Wrote UNIX scripts to monitor size of the tablespaces and scheduled it in crontab.
• Installed MetaSolve software in test environment.
• Creating Oracle scripts for Oracle exports, Hot / Cold backups, RMAN and Windows Scripts for Scheduling jobs through windows scheduler
• Interact with developers on SQL and Oracle support teams.
• Oracle patching for updates and Bug fixes using opatch utility
• Provided partitioning of the large tables to reduce the access time.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Using Spot light tool to monitor the databases and Toad, SQL developer for advanced coding.
• Taking care of the performance issues for the Confidential servers.
• Handing the regular Service tickets from the developers and application users for issues concerning to database.

Confidential, Atlanta, GA

Oracle Applications DBA and System Administrator

Responsibilities:

• Cloning 11.5.10.2 Production Instance to Test, Dev Instances.
• Applying patches through adpatch utility for all the Financials and Procurement team.
• Worked on Ad utilities like adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig etc.
• Experience in Doing Oracle Applications Upgrade from 11.5.9 to 11.5.10.2.
• Writing scripts for backup and recovery process and implementation of RMAN in a catalog mode.
• Creating Users, Granting roles, creating tablespaces, alter tablespace.
• Implementation of 10g RAC in apps 11i test instances.
• Data guard configuration
• Installing 10gAs, 10g Business Intelligence and Maintenance of the Discoverer instance.
• Experience in supporting Oracle Financial,HR,SCM modules like Oracle Financials - Financials Accounting Hub(Subledger Accounting),AP, AR, GL, FA, FCG, CM
• Creation of Eul and assigning the EUL role to particular users.
• Administer and support technology components such as Forms server, reports server and HTTP server.
• Performing the Administration for Web Server and Forms Server technologies.
• Upgradation of Oracle 10g database from 10.2.0.2 to 10.2.0.3
• Experience in working PL/SQL and SQL ability to investigate application performance issues.
• Experience in understanding Oracle Applications design principles (physical and logical) structure.
• Able to create and review explain plans and develop optimized code from the development and review there of.
• Installation and Upgradation experience on 9i and 10g Application Servers
• Scheduling and Maintenance of interface processes and concurrent manager process in production.
• Experience in providing technical Support to functional people and if needed used to raise a Tar with oracle for resolution of issues.
• Good experience to check the performance of Sql Scripts and Proficient in Generating Sql and Pl/Sql coding.
• Generated Some discoverer reports for Financials, Procurement modules.
• Scheduling of concurrent programs as per the client requirements for all financials, procurement team.
• Creating Users, assigned responsibilities to users for all the financials and procurement team .
• Creating Custom responsibilities, Request Groups, Menus and submenus through
• System administrator responsibility for all the AP, AR,GL,FA,CM, I Procurement,
• . I expenses modules.
• Interacting with Financials, Procurement Users team and resolving there Issues.
• Performing Network Infrastructure analysis like tnsnames.ora, listener.ora, sql*net.
• Migration of Users, responsibilities, Request Groups, Menus through FNDLOAD Command.
• Experience with OEM tool to check the status of the system and also the performance.
• Installed 10g Database (10.2.1.0) Database Upgraded to 10.2.0 created SOA Schema through IRCA script, installed 10.1.3.0 SOA Suite.
• Installed Database, Created BPEL MANAGER SCHEMA by running irca scipt and installed BPEL (10.2.3.0) on the same oracle home.
• Good Experience in Management and Administration of 9i and 10g Application Server.
• Good Experience in Implementation of RMAN Catalog and Non Catalog environment through EMC Data Management Software
• Experience to Perform database transaction and security audits
• Migration of form and Self Service personizations for all modules.
• Experience in Maintaining C++, Java Databases.
• Done DMZ setup for IProcurement,Iexpense modules.
• Migration of users and their roles at the database level through export and import Command.
• Installing ADI for the Individual Financials Client users.
• Interacting with users and resolving all the issues.
• Developed and executed Unix Shell Scripts for frequent cloning.
• Performance Tuning for database level as well as application level.
• Proficient in writing Unix Shell Scripts For taking Backups and in Migration of Databases.
• Assigning roles and granting privileges through User Management Responsibility for the Financials and Procurement Users team.
• Installing Oracle 10g database, Oracle Discoverer Business Intelligence at the Client Systems.
• Perform Tuning of the Sql Scripts through Toad tool.
• Taking Care of WorkFlow administration Activities.
• Implementing GMS / DPS Modules, Maintaining the Issues for these Modules.
• Involved with Oracle Tools like OEM, Toad,Benthic,Veritas and StatsPack.

Environment: AIX5, Oracle Applications (11.5.10.2),Unix Shell Scripting,TOAD, VERITAS, Oracle 10g.

Confidential, California

Oracle Applications DBA

Responsibilities:

• Installation of Oracle software and Creation of Oracle Databases on Various platforms.
• Cloning, Patching, and Administering the Concurrent Mangers.
• Interacting with development team, carrying out the jobs as and when required/ as per schedule.
• Monitoring and supporting Production server issues.
• Refreshing the database.
• Troubleshooting the user issues, interacting with the end users/ coordinating between development team / Users to carry out the Patching/ implementing new changes to the system.
• Applying patches on production servers.
• Performed AD Utilities such as ADADMIN, Auto patch and ADCTRL etc.
• Good Understanding in Setting up the RMAN backup and recovery Scenarios.
• Worked On Modules like HRMS and Financials.
• Periodically cloning the production server on to Development Server.
• Concurrent Manager Administration & tuning.
• SGA Tuning
• Developing Hot, cold and logical backup scripts to automate the backup procedures. Planning for storage spaces requirements and placing them for optimum I/O performance.
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
• Tuning the databases for optimal performance.
• Meeting the end users to know database issues like performance
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Up gradation of Oracle Server and applying Database and Application patches. Writing scripts for the system and database for the effective functionality and report generation.
• Installation of Solaris and other OS and applying patches at OS level.
• Verifying the backups

Environment: Linux, Solaris, windows, Oracle Applications Rel.11i (11.5.9), Oracle 10g/9i, SQL, PL/SQL, TOAD.