SUMMARY

• Senior Oracle DBA Lead/Architect with more than 14 years of experience in Oracle Database 9i, 10g, 11g, 12c and Oracle Applications R11 and R12 and 5 years’ experience in AWS (cloud) migration.
• Extensive experience in Oracle ERP implementation, Upgrade and post - implementation support experience.
• Expert level proficiency in installation, configuration, troubleshooting, patching and cloning of Oracle E-business Suite 11i(11.5.10.2)/R12 (12.1.3/12.2 ) instance for advanced topologies.
• Real time implementation experience of EBS R12.2.4 and managing 12.2 environments which includes ADOP enablement and ADOP patching.
• 11.2/12c Two/Three Node Real Application Cluster with ASM.
• Installation and configuration of OEM 12c/13c.
• Cross platform database migration from solaris to Linux for EBS database.
• Migration of existing infrastructure (database, application etc) to Amazon Cloud (AWS)/ Virtustream.
• Migration of Oracle EBS 12.1.3/12.2.6 to Oracle Compute Cloud (IaaS).
• Oracle Real Application grid infrastructure installation (11g R2) with conversion of non-RAC database to RAC and migration of file system to ASM.
• Automation of upgrade, cloning, patching using ANSIBLE/Python.
• Patching, upgrading and managing oracle database for SAP environment.
• Installation, configuration and administration of Demantra using weblogic 11g.
• Creation of external application node in DMZ with reverse proxy for Oracle iSupplier.
• 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/12c 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.
• Good exposure of Backup and Recovery (Oracle Recovery Manager (RMAN), Import/Export and Datapump), EMC Networker.
• Knowledge of SAN based backup/restore using disk mirroring technology of Hitachi (HITACHI UR/VERITAS).
• Working knowledge of MS SQL Server, MongoDB administration.
• Extensive knowledge on Oracle GoldenGate and setting up unidirectional, bidirectional and peer-peer topology.
• Installation of Oracle Access Manager (OAM 11g) using webgate and integration with R12 via accessgate.
• Support and maintenance of environment running Oracle Weblogic with SOA and AIA.
• Transparent Data Encryption (TDE) with EBS.
• 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/12c.
• Installation and configuration of Oracle Application Testing Suite (OATS) v9.
• Exadata database machine administration (X3-2).
• 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.
• Working knowledge of configuration management and deployments tools like Kintana, Flex Deploy etc.
• 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.
• Configuration and maintenance of Hyperion planning and Essbase.
• 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.
• Support, configuration and maintenance of weblogic based application like GRC, Markview etc.
• Extensive programming and scripting knowledge using PL/SQL and Shell. Also used Python.

TECHNICAL SKILLS

Cloud: AWS, Oracle Cloud, Virtustream, Azure

RDBMS: Oracle, MS Sql Server, MySQL

No-SQL: MongoDB, DynamoDB

ERP: Oracle E-Business Suite, SAP, Seibel

Scripting: Shell, Pl/Sql, Ansible, Python, SQL

PROFESSIONAL EXPERIENCE

Confidential

Oracle Applications DBA, Oracle DBA

Responsibilities:

• Prepare and scope upgrade path for moving all Oracle databases to 12.2
• Java Web Start (JWS) implementation for application tier R12.1.3 with JRE 1.8.
• Upgrade of Oracle 12.1.3 infrastructure to R12.2(POC started)
• Preparation of the DEV, QA, PROD and DR environment and configuring the same for readiness.
• On demand cloning for development, test instances from production.
• OEM 13c upgrade from previous version.
• Performed database upgrade from 11.2.0.4 to 12.1.0.2(12c)/12.2.0.1.
• Automation of upgrade, cloning, patching using ANSIBLE.
• Patching oracle instances.
• Oracle Application Testing Suite Installation (OATS) and configuration.
• Use of Database replay for performance and load testing.
• Database platform migration from HP-UX to Linux using TTS.
• Creation of Physical standby for Disaster Recovery (DR) environment.
• 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.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities.
• Created Groups, roles, privileges and assigned them to each user group.
• 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

Oracle Applications DBA, Oracle DBA

Responsibilities:

• Prepare and scope migration path for moving the entire on-premise ERP into the cloud (Oracle/AWS).
• Working on POC’s and provide material proof to the customer about each individual piece migration path to be implemented here.
• Upgrade of Oracle 12.1.3 infrastructure to R12.2
• Preparation of the DEV, QA, PROD and DR environment and configuring the same for readiness.
• ADOP patching readiness for R12.2 system
• On demand cloning for development, test instances from production.
• OEM 13c installation and configuration.
• Performed database upgrade from 11.2.0.4 to 12.1.0.2(12c).
• Implementation of SHARED APPL TOP using isci drive.
• Patching oracle instances.
• Oracle Application Testing Suite Installation(OATS) and configuration.
• Database platform migration from HP-UX to Linux using TTS.
• Creation of Physical standby for Disaster Recovery (DR) environment.
• 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.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities.
• Created Groups, roles, privileges and assigned them to each user group.
• Participate in change management discussion with clients to progress new changes to production.
• Mentoring junior DBA’s and sharing knowledge and expertise with them.