SUMMARY:

• Senior Oracle Apps DBA with 10 years of experience in Oracle Database 9i, 10g, 11g, 12c and Oracle Applications R11 and R12.
• Extensive experience in Oracle ERP implementation, Upgrade and post - implementation support experience.
• Supported Global Clients which include AMEX, Hertz, Global Foundries, EMC Corp, Financial Times, Lombard, Go-Ahead group, Eurostar, Mitie etc.
• Expert level proficiency in installation, configuration, troubleshooting, patching and cloning of Oracle E-business Suite 11i(11.5.10.2)/R12(12.1.3) instance for advanced topologies.
• 11.2.0 Two Node Real Application Cluster with ASM.
• Oracle Real Application grid infrastructure installation (11g R2) with conversion of non-RAC database to RAC and migration of file system to ASM.
• Installation of Oracle Access Manager (OAM 11g) using webgate and integration with R12 via accessgate.
• Implementation of Oracle ebusiness suite R12.1.3(Finance module) with 2 node application tier, 1 node external tier in DMZ and 2 node RAC database 11.2.0.2 from legacy system running mainframe, cobol etc.
• 11.2.0.1 Database upgrade from 11.1.0.7 of R12 database.
• Performed Oracle E-Business Suite Upgrade from Release 11i to R12(12.1.3).
• Working knowledge of Oracle Enterprise Manager 10g/11g Grid Control (OEM).
• 11.1.0.6 Database Upgrade from 10.2.0.3 of 11i and non-ERP databases.
• Performed Oracle E-Business Suite Upgrade from R12.0.4 to R12.1.3 along with database upgrade from 11.2.0.4 to 12.0.1(12c)
• Involved in disaster recovery preparation, planning and testing with working knowledge of Oracle Data Guard.
• Creation of external application node in DMZ with reverse proxy for Oracle iSupplier.
• Support and maintenance of environment running Oracle Weblogic with SOA and AIA.
• Installation and Configuration of 10.1.3.4 SOA Suite with BPEL and ESB.
• Installation, configuration and integration of Oracle Single Sign On (SSO) 10.1.2.0.2 with Oracle E-Business Suite using mod osso.
• Installation, configuration and maintenance of OBIEE 11g.
• Good exposure of Backup and Recovery (Oracle Recovery Manager (RMAN), Import/Export and Datapump).
• Cross-platform database migration using RMAN transportable database with minimal downtime.
• JVM tuning and analysis of current JVM stack performance and suggestion/solution based on client need for 11i instance.
• Installation, configuration and integration of Oracle Discoverer 10.1.2.0.2 with Oracle E-Business Suite.
• Configuration of Parallel Concurrent Processing (PCP) with database load balancing for concurrent managers.
• Web entry load balancing using hardware load balancer and oc4j based load balancing for forms in R12.
• Installation and configuration of 10g Enterprise manager for Grid Control, Deployment of Grid control agent on different platform.
• Good understanding of DB statistics reports/tools like statspack, AWR, ADDM, Trace, Tkprof, explain plan, SQL Tuning Advisor & SQL Plan Management (11g).
• Database SGA and core tuning involving init file parameters.
• Installation and configuration of SuSE Linux Enterprise Server (SLES) 9.2 (32-bit/64-bit).
• Facilitate the promotion of application code, setups, databases and related components from the various levels of development through staging and production. Working knowledge of Oracle Application Change Management Plugin (ACMP) through OEM Grid to promote code movement.
• Installation and configuration of Oracle Life Science Hub (LSH).
• Support and monitoring level knowledge of Oracle GoldenGate 10g.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Production, Development and Test Support for 11i/R12 Instance
• Troubleshooting of user issues based on the incidents raised.
• Upgradation of products to latest version which includes both database and application.
• On demand cloning for development, test instances from production.
• Creation of Physical standby for Disaster Recovery (DR) environment.
• Performed Oracle E-Business Suite Upgrade from R12.0.4 to R12.1.3 along with database upgrade from 11.2.0.4 to 12.0.1(12c).
• Installation of Oracle Access Manager (OAM 11g) using webgate and integration with R12 via accessgate.
• Configuration of Parallel Concurrent Processing (PCP) with database load balancing for concurrent managers.
• Web entry load balancing using hardware load balancer and oc4j based load balancing for forms in R12.
• Performance tuning of long running requests and other performance related issues.
• JVM tuning and analysis of current JVM stack performance and suggestion/solution based on client need for 11i instance.
• Upgrade JRE and JDK.
• Database SGA and core tuning involving init file parameters.
• Month end support for 11i/R12 production instances.
• Participate in change management discussion with clients to progress new changes to production.
• Mentoring junior DBA’s and sharing knowledge and expertise with them.

Confidential

Responsibilities:

• Production, Development and Test Support for 11i/R12 Instance
• Troubleshooting of user issues based on the incidents raised.
• Upgradation of products to latest version which includes both database and application.
• On demand cloning for development, test instances from production.
• Support and maintenance of environment running Oracle Weblogic with SOA and AIA.
• Working knowledge of Oracle Enterprise Manager 10g/11g Grid Control (OEM).
• Configuration of Parallel Concurrent Processing (PCP) with database load balancing for concurrent managers.
• Web entry load balancing using hardware load balancer and oc4j based load balancing for forms in R12.
• Performance tuning of long running requests and other performance related issues.
• Working knowledge of Oracle GTM and GRC.
• Facilitate the promotion of application code, setups, databases and related components from the various levels of development through staging and production. Working knowledge of Oracle Application Change Management Plugin (ACMP) through OEM Grid to promote code movement.
• Database SGA and core tuning involving init file parameters.
• Month end support for 11i/R12 production instances.
• Participate in change management discussion with clients to progress new changes to production.
• Mentoring junior DBA’s and sharing knowledge and expertise with them.

Confidential

Responsibilities:

• This project is to Support Production R12.0.4 instance with HRMS module for Hertz USA business unit and later upgrade it to R12.1.3 and database to 11.2.0.2.
• This project also involved supporting R11.5.10.2 instance with GL,AP,AR,FA module for Hertz Europe/Australia business unit and later upgrade it to R12.1.3.
• This project also involved implementing R12 finance module for Hertz USA business unit from legacy system using mainframe and cobol.

Oracle Applications DBA, Oracle DBA

Responsibilities:

• Production, Development and Test Support for 11i/R12 Instance
• Troubleshooting of user issues based on the incidents raised.
• Performed Oracle E-Business Suite (HRMS) Upgrade from R12.0.4 to R12.1.3 along with database upgrade from 10g to 11g.
• Performed Oracle E-Business Suite(Finance) Upgrade from R11.5.10.2 to R12.1.3 along with database upgrade from 10g to 11g.
• Implementation of Oracle ebusiness suite R12.1.3(Finance module) with 2 node application tier, 1 node external tier in DMZ and 2 node RAC database 11.2.0.2 from legacy system running mainframe, cobol etc.
• On demand cloning for development, test instances from production.
• Creation of Physical standby for Disaster Recovery (DR) environment.
• Installation of replication environment using Oracle Advanced replication methodology and configuration of table level replication with real-time data synchronization. Automated the failover process for Multi-Master configuration using shell scripting and PL/SQL.
• Installation, configuration and maintenance of OBIEE 11g.
• Cross-platform database migration(same endian format) using RMAN transportable database with minimal downtime from Solaris to Linux.
• Creation of external application node in DMZ with reverse proxy for Oracle iSupplier.
• Working knowledge of Oracle Enterprise Manager 10g/11g Grid Control (OEM).
• Configuration of Parallel Concurrent Processing (PCP) with database load balancing for concurrent managers.
• Web entry load balancing using hardware load balancer and oc4j based load balancing for forms in R12.
• Performance tuning of long running requests and other performance related issues.
• Facilitate the promotion of application code, setups, databases and related components from the various levels of development through staging and production. Use of change management tools like Harvest, SVN etc.
• Database SGA and core tuning involving init file parameters.
• Upgrade JRE and JDK.
• Month end support for 11i/R12 production instances.
• Participate in change management discussion with clients to progress new changes to production.
• Support and monitoring level knowledge of Oracle GoldenGate 10g.
• As Onsite co-ordinator did regular meeting with offshore DBA team, explaining them system and change requirement gathered from client and sharing work knowledge with them.

Confidential

Oracle Applications DBA, Oracle DBA

Responsibilities:

• Production, Development and Test Support for 11i/R12 Instance
• Troubleshooting of user issues based on the incidents raised.
• Upgradation of products to latest version which includes both database and application.
• On demand cloning for development, test instances from production.
• Creation of Physical standby for Disaster Recovery (DR) environment.
• Installation, configuration and maintenance of OBIEE 10g.
• Working knowledge of Oracle Enterprise Manager 10g(OEM).
• Configuration of Parallel Concurrent Processing (PCP) with database load balancing for concurrent managers.
• Performance tuning of long running requests and other performance related issues.
• Facilitate the promotion of application code, setups, databases and related components from the various levels of development through staging and production. Use of change management tools like Tortoise, SVN etc.
• Upgrade JRE and JDK.
• Installation, configuration and maintenance of Informatica 7.
• Install ATG.RUP6 on 11.5.10.2 environment.
• Database SGA and core tuning involving init file parameters.
• Month end support for 11i/R12 production instances.

Confidential

Oracle Applications DBA, Oracle DBA

Responsibilities:

• Production, Development and Test Support for 11i/R12 Instance
• Troubleshooting of user issues based on the incidents raised.
• Upgradation of products to latest version which includes both database and application.
• On demand cloning for development, test instances from production.
• Working knowledge of Oracle Enterprise Manager 10g(OEM).
• Configuration of Parallel Concurrent Processing (PCP) with database load balancing for concurrent managers.
• Performance tuning of long running requests and other performance related issues.
• Facilitate the promotion of application code, setups, databases and related components from the various levels of development through staging and production. Use of change management tools like Harvest, SVN etc.
• Month end support for 11i/R12 production instances.