SUMMARY:

• Oracle Certified Expert with 11+ years of progressive experience in the area Oracle Applications and Database Administration. Participating in meetings, conferences, mentoring DBAs and application developers for various projects. Effective in managing multiple projects simultaneously, troubleshooting, finding solutions to the most challenging technical problems and meeting tight deadlines.
• Expertise in Oracle Application Upgrades and Cross OS migrations from R12.1 to R12.2, 11i to R12.2
• Proficient in Installation, Configuration, Maintenance and Tuning of Oracle 11g/ 10g/ 9i / 8i and RAC, AIX 5.3, RHEL, Solaris 8, 9 and 10 platforms.
• Proficient in Oracle RAC implementations in EBS and non - EBS environment
• Expertise in Weblogic Administration in EBS R12.2
• Oracle E-Business suite 11i/R12.1/R12.2 Installation on RedHat 3.x/4.x/5.x/6.x, SunOS platform.
• Cross OS platform migration of Oracle EBS database 11gR2 from Solaris 10 to RHEL 6.0 using XTTS and expdp/impdp.
• Implemented Backup & Recovery strategies using RMAN and Hot/Cold backup for Oracle 10g/9i/8i databases in Windows and LINUX environment
• Oracle Database upgrade from 9i to 10g, 10g to 11gR2.
• Preparation of RFQ for hardware as per the workload forecast for Oracle Applications.
• Experience with Shareplex for DB migration from Solaris 10 to Linux.
• Experience in implementation of Discoverer in Weblogic Cluster
• Cloning/Patching of EBS 11i/R12.1/R12.2 in single-node and multi-node environment.
• Extensive experience in working with the utilities like OEM, TOAD, Export/ Import, SQL* Loader, SQL Analyze and Oracle Supplied packages
• TDE and Data Vault implementation in EBS/non-EBS environment
• Apps DBA Activities for Maintenance Process and documenting the same.
• Preparing Instance Strategy as per the ERP Implementation requirements.
• Experience in upgrade of MongoDB from 2.4.6 to 3.4.2 using Ops Manager and manual procedures
• Experience in recovery, addition and removal of MongoDB replica set nodes
• Experience with PCP, DMZ, Configurator, SSL, multi-node setup in R12.2.5
• Experience in team handling and project planning for implementation and upgrade projects

TECHNICAL SKILLS:

ERP: Oracle Apps 11.5.7/ 11.5.9/11.5.10.2, Oracle Apps R12.1.1/R12.1.3/R12.2.5

Programming: Unix Shell Script, PL/SQL, Python, JSON

RDBMS: Oracle 8.0/8i/9i/10g/11g/12c, MS Access 97, 2000

NoSQL DB: MongoDB 2.6.4/3.4.2 ( with Ops Manager)

Oracle Tools: SQL*Plus, SQL*Loader, SQL *NET, NET 8, SVRMGR, Export & Import, RMAN, Listener controls, Discoverer

Web Server: Apache

Packages: Ms Office, Lotus SmartSuite

Operating Systems: Windows NT, Windows 2003 Server, RHEL 6, Solaris 9, HP-UX 11.31,IBM AIX 6.1

Backup Softwares: IBM Tivoli, HP Data Protector

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis, MO

Applications Database Administrator

Responsibilities:

• Maintain technical relevance on Oracle EBS over product release lifecycles.
• Clone and refresh ERP/EBS environments.
• Automate and document processes within the database through PL/SQL, SQL, and cron/shell jobs.
• Plan, execute and support MongoDB (noSQL database) upgrades and operations in replica set configuration.
• Guide the work of more junior administrators to assist in accomplishing tasks.
• Ensure end-to-end monitoring of the platforms for both performance and availability.
• Provide on-call support per the published schedule.
• Perform Weblogic Administration in EBS R12.2.
• Resolve Oracle Database and Application incidents.

Confidential, Saint Louis, MO

Oracle Applications DBA

Responsibilities:

• Planning and execution of Oracle Applications upgrade including cross-OS migrations from 11i/R12.1 to R12.2.5. Oracle Configurator configuration on Oracle R12.2.
• Oracle Database 11gR2 cross OS migration from Solaris to Linux. Kintana Code Migration Workflow integration with Oracle EBS R12.2.
• Established ADOP process for EBS R12.2 environments.
• Performance and Tuning of EBS instances. Oracle 11gR2 RAC Configuration on RHEL 6- addition and removal of nodes, capacity planning.
• Implementation of best practices and procedures for Database Administration. TDE and Data Vault implementation on EBS non-EBS databases.
• Shell scripting including python scripting for automation of database administration process.
• Responsible for maintaining Standard Operating Procedures on new technology implementations in Database Administration and mentoring of DBA teams.
• Monitoring of database using OEM Grid control.
• Weblogic Administration and configuration of Managed servers in R12.2 environment.
• In depth experience with oracle application utilities such as RapidInstaller, Rapid Clone, adpatch, adadmin, adsplice, adctrl, adop.
• Experience in supporting complex EBS R12.2.5 environment with PCP, DMZ, SSL, Configurator and multi-node setup.

Confidential

Technical Lead

Responsibilities:

• Providing Apps DBA support for various divisions of Confidential .
• Cross Platform Migration of Oracle 11g databases from Solaris SPARC 10 to RHEL 6 using expdp/impdp, XTTS, Shareplex.
• Wireless Field Services (external node) implementation on Oracle Apps R12 instances.
• Oracle Configurator Configuration and support with Oracle 11i. Plan and Prepare POC on EBS, Discoverer advanced configuration.
• Oracle 11g OEM setup across organization on Solaris. Preparation of Oracle applications R12 clones as per the task requirements.
• Performance and Tuning of EBS instances.
• Oracle Database upgrade from Oracle 10.2.0.5 to 11.2.0.3 (Oracle Apps 11i). Oracle ASM upgrades from 11.2.0.3 to 11.2.0.4. Oracle Application Tablespace Model (OATM) implementation with Advanced Compression on Oracle Database 11gR2.
• Oracle Applications upgrade from 11.5.10.2 to Oracle R12.1.3. Cluster Configuration on RHEL 6.
• Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps.

Confidential

Apps DBA Consultant

Responsibilities:

• Preparation of Environment plan as per project requirement.
• Preparation of Instance Strategy in coordination with Functional Team as per the Oracle EBS Implementation requirement. Installation of Oracle Apps R12 on HP-UX Itanium.
• Migration of Oracle Apps R12 from HP-UX 11.31 to Sun Solaris 10. Configuration of Oracle Fusion Middleware 11g (Oracle Discoverer in Cluster setup) on Sun Solaris.
• Character set conversion of Oracle R12 from AL32UTF to AR1256WIN.
• Migrating single instances of Oracle R12 databases to 11gR2 RAC. Oracle 11g Grid installation on Sun Solaris 10.
• Preparation of Oracle applications R12 clones as per the task requirements.
• Code migration and Data migration as per project requirements in EBS and non-EBS environments.

Confidential

Apps DBA Consultant

Responsibilities:

• Preparation of RFQ for Hardware procurement as per the workload forecast. Preparation of Environment Plan and Backup Strategy as per the Organization requirements.
• Installation of Oracle Apps R12.1.1 on HP-UX Itanium. Upgradation of Oracle Apps R12.1.1 to R12.1.3.
• Installation of Oracle Fusion Middleware 11g (Oracle Discoverer) on HP-UX Itanium.
• Printer Installation on Oracle Applications R12.1.3.
• Creation of Alerts as per the Functional requirements.
• Hot backup and Cold backup Cloning of Oracle Apps R12 to create Test, Development and other environments.
• Applying Patches as per the requirements.
• Worked closely with Project team to ensure the project meets business needs.

Confidential

Apps DBA Consultant

Responsibilities:

• Preparation of RFQ for Hardware procurement as per the workload forecast.
• Preparation of Instance Strategy in coordination with Functional Team as per the Oracle EBS Implementation requirement.
• Installation of Oracle Apps R12.1.1 on Windows 2003 Server/ IBM AIX 6.1.
• Installation of OBIEE (Oracle Business Intelligence Enterprise Edition) on Windows 2003 Server.
• Troubleshooting issues encountered by Functional and Technical teams.
• Recording and managing project issues and escalating where necessary.
• Applying Patches as per the requirements.
• Worked closely with Project team to ensure the project meets business needs.

Confidential

Oracle Apps DBA

Responsibilities:

• Health Check of Database (9.2.0.3, 10.2.0.3) and Application (11.5.9,11.5.10.2). Cloning on HP-UX platform using Rapidclone.
• Patch Analysis. DB Refresh for various Oracle databases.
• Experience in patching on HP-UX platform.
• Managing various Oracle instances (on different OS) using Oracle Enterprise Manager.
• Providing support to development teams for Oracle Apps 11.5.9/11.5.10.2, Oracle Apps R12.

Confidential

Oracle Apps DBA

Responsibilities:

• Customization of STATSPACK reports on Oracle Database 10.2.0.3. Creation of Scripts for testing using Mercury Load Runner.
• Gathering CPU utilization data in a multi-node Solaris environment. Assisting Load Testing team to prepare Analysis report on the basis of data gather.
• Oracle Apps Health checks for 11.5.9/11.5.10.2 on Solaris platform.
• Troubleshooting Application User Problems.
• Planning and Implementation of Resource Consumer Groups and Plans on Oracle 9.2.0.7.
• Experience with Unix shell scripting.

Confidential

Oracle Apps DBA

Responsibilities:

• Cloned 11.5.10.2 on Dual-node and Single-node systems using Rapidclone.
• Generation of STATSPACK reports on 11.5.10.2 using OAM. Involved in Patching Oracle Apps 11.5.9 Dual-node installation on RHEL 3.0. Oracle Apps Health checks for 11.0.3 on HP-UX platform. Involved with physical standby database configuration.