SUMMARY

• Implementation of backup and recovery strategies for Oracle Application software. Setup RAC nodes and data guard for disaster recovery.
• Performance tuning of large Oracle Applications installations. Identify and resolve various performance issues related to large database installations. Setup RAC and Grid infrastructure software.
• DBA operations of large multi - national global database installations.
• Implementation of tracking methods of Oracle Application code patches and fixes.
• Established rollout strategies for Oracle Application patches to multiple databases to improve accuracy of testing and reduce risk of error to the production database
• Configuration of OEM to monitor multiple database instances on different nodes and different database versions.
• Upgraded Oracle RDBMS Versions 7, 8, 8i, 9i, 10g,11g, 12.1.0.1, 12.2.0.1
• Implementation of ASM in 10g, 11g, 12.1.0.1 and 12.2.0.1
• Platform migration of Oracle E-Business suite to Linux x86 from AIX and HP.
• Implementation of Oracle Financial/ Manufacturing Applications in a large - scale global environment, involving three separate deployments of all Oracle ERP Applications in three nations. Excellent product knowledge of Order Management, Accounts Receivables, Oracle Inventory, Accounts Payable, Application Object Library
• Analysis of Oracle Financial systems versus user requirements and designed workable solutions and workarounds to meet users needs
• Provided technical troubleshooting support to client on functional and technical issues arising from user misconceptions, Oracle Financial Application bugs, and platform incompatibilities in Oracle Accounts Payable, General Ledger, Receivables, Fixed Assets and manufacturing applications
• Provided Oracle Applications System Administration support, and transferred knowledge to client IT staff on improved application administration operations
• Conducted technical infrastructure support, analysis and developed software distribution strategies to client IT staff to facilitate on - going maintenance of Oracle system
• Integration of various 3rd party software with Oracle ERP applications
• Configured and setup barcode, LaserJet and line printers in Oracle Applications
• Setup PDF printing using Exxor software.

TECHNICAL SKILLS

Applications: Oracle E - Business Suite version 9.3.7, 9.4.2, 10.4.1, 10.7, 11.0.3,11i, R12.1.3 and 12.2.7. Oracle RDBMS, Gentran integration software suite, Mercury Governance, Kintana, OBIEE, Oracle CRM & mobile applications, Primavera, Hyperion, SOA Weblogic, Golden Gate and Avamar backup managing systems.

Software: Oracle RDBMS, SQL*Loader, SQL*Plus, PL/ SQL, Oracle Application Server, Oracle OEM, Oracle Performance Tuning, SQL Server, Web logic, OBIEE, ODI.

Hardware: Intel x86, Sun Solaris, HP–UNIX, NT Server & MS Windows.

Databases: Oracle RDBMS Versions 6, 7, 8, 8i, 9i, 10g, 11g, 12c, 13c, iAS, 11g, 10g BIS, ASM. Extensive RAC expertise.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Applications DBA

Responsibilities:

• Upgrade Oracle ERP from R12.1.3 to R12.2.7.
• Upgrade Oracle ERP from 11i to 12.1.3.
• Cloning in 11i, 12.1.3 and 12.2.4 single tier & multi node RAC in ASM environment. Also, PCP, DMZ and shared application configuration architecture were adopted for setup applications
• Maintain OBIEE environment for data warehouse teams.
• Apply Oracle Application patches, developer patches, security patches and production support.
• Performed Oracle Application System Administrator duties
• Performance tuning Oracle Applications. Performance tuning at DB and application level.
• Using mercury governance software to perform code migrations and patch management. .
• Maintenance of mission critical databases in 9i, 10g, 11g, 12.1.3 and 12.2.4
• Setting up disaster recovery systems of mission critical applications/databases.
• Implement change management process and procedures.
• Implement iRecruitment and iSupplier configurations for external access.
• Implement non-ERP applications on AWS and cloud.
• EAM application integration with Oracle ERP.
• Exxor and Oracle Report workbench integration with Oracle ERP.

Confidential

Senior Oracle Applications DBA

Responsibilities:

• Cloning in 11i single tier & multi node RAC in ASM environment.
• Apply Oracle Application patches, developer patches, security patches and production support.
• Performed Oracle Application System Administrator duties
• Performance tuning Oracle Applications.
• Setting up DR systems of ERP and non-ERP environments.
• SQL server application maintenance.
• Maintenance of mission critical databases in 9i, 10g and 11g.
• Setting up disaster recovery systems of mission critical applications/databases.

Confidential . Plano, Texas

Senior Oracle Applications DBA

Responsibilities:

• Cloning in 11i single tier & multi node RAC.
• Apply Oracle Application patches, developer patches, security patches and production support.
• Performed Oracle Application System Administrator duties
• Performance tuning Oracle Applications.
• Setting up DR systems of ERP and non-ERP environments.
• Upgrade Oracle RDBMS from 9i to 11g and 10g to 11g.
• SQL server application maintenance.
• Maintenance of mission critical databases in 9i, 10g and 11g.
• Setting up disaster recovery systems of mission critical applications / databases.