SUMMARY

• Over Eleven years of experience as Oracle Applications DBA.
• Seven years of experience in Pharma/Medical device organization.
• Extensive experience in Oracle E - Business Suite Applications R12, 11i (12.1.3, 12.0.6, 12.0.4, 11.5.10.2, 11.5.10, 11.5.9,) Installations, configuration, Cloning, Security, Patching, Upgrades.
• Good in Upgrades of Oracle ERP from 11.5.10.2 to 12.0.4, 12.0.4 to 12.0.6 and 12.0.6 to 12.1.1.
• ERP Upgrade from 11.5.10.2 to 12.1.3
• Well versed with Oracle 9i / 10g R2 /11GR2 RAC databases on Sun Solaris, AIX and Red Hat Linux.
• Proficient in database performance tuning
• Experienced in setting up Parallel Concurrent Processing
• Experienced in storage migrations from DMX1K to DMX4K and from DMX4K to VMAX10K
• DBA lead for successful migration of DR databases from GA to CO datacenter.
• Good in Setting up Logical/Physical Standby databases and Switchover and Switchback of Database in 10GR2 RAC
• Configured Shared Appl tops,OATM
• Automated Oracle cloning process.
• Experienced in Callibration/Orion utilities.
• Evaluated IBM Pureflex/Puredata systems
• Enabling Large pages in AIX
• Baseline patching for Oracle Apps extended support
• Very well versed in Rapid Install, DST patches, Security patches, Tech stack patches, AdPatch, Adadmin and Adctrl utilities for Oracle Applications.
• Proficient in Cloning using ad clone utility and adcfgclone using Hot and Cold Backups.
• Highly experienced in Cloning of Oracle applications from multinode to singlenode and singlenode to multinode
• Experienced in Configuring RMAN for Backups and cloning using RMAN Backups
• Skilled in Installation of OBIEE, OBI Applications and Informatica
• Have Installed UPK Software
• Upgraded 12.0.6 to 12.1.1,12.0.4 to 12.0.6,11. .0.4,11.5.9 to 11.5.10 and 11.5.8 to 11.5.9
• Database Upgrade from 9i to 10g and 10GR2 to 11GR2
• OS Migrations From Linux (11.5.10.2 and 9.2.0.8) to AIX and configuring Shared Appl Top
• Setting up of Dedicated Node for ASCP Managers
• Leading a Team of 15 DBA’s.
• Installation and Configuration of 10GAS,11G SOA Suite and 12C Grid
• Experienced in Setting Demantra Instance and Integrating with R12.
• Worked on Projects with Database size of more than 5 TB
• Enabling Load Balancing in a 12 Web-Tier Architecture
• Good insight into Vertex/Quantum upgrades

TECHNICAL SKILLS

Hardware: Sun 450, Sun Ultra, AIX, HP- UX

Operating Systems: Solaris 2.X, AIX, Hp-UX, Linux, Windows NT

Rdbms: 12c/11G/10G/9i/8i/8.X

Applications: ORACLE APPLICATIONS 11.5.8/11.5.9/11.5.10/12.0.6/12.1.3

Backup: RMAN and XBP (Backup tools),BCV, EMC Snap

Tools: /Others: Import/Export, OEM, TOAD and Quest software tools, OEM, and Backup and recovery using RMAN.

PROFESSIONAL EXPERIENCE

Confidential, Mahwah, NJ

Sr.Oracle Applications DBA

Responsibilities:

• Leading a team of 15 off-site DBA’s
• Well versed in validation requirements of Oracle Instances
• Well versed with Sarbanes/Oxley compliance standards
• Proficient in Validation of GxP systems
• Participated in Audit meetings with E&Y.
• Managing 11i/R12 instances with RAC
• Upgraded the Oralce Application from 11.5.10.2 to 12.1.3
• Managing 100+ ERP and Non-ERP databases.
• Participated in storage migration from DMX to VMAX platform
• Managed successful migration of DR databases from GA to CO datacenter.
• Managed databases across different geographical locations.
• Automated Oracle ERP cloning process.
• Migrated 50+ Non ERP Databases (9.2.0.8, 10.1.0.5 and 10.2.0.4,11.2.0.3) from Sun to AIX platform.
• Providing support to Demantra Applications, SOA Applications, MDM, Windchill,TrakWise
• Configured II engine for Demantra Application
• Worked extensilvely on ERP Stress testing projects
• Good in performance tuning of Oracle Instances
• Installed GL Wand utility for Financial Reporting
• Highly experienced in Cloning of Oracle application environment using Rapid clone
• Database Refresh/clone doing complete/incomplete recovery using cold and hot backups.
• Managing the Concurrent Managers and its operations.
• Troubleshooting Apps components like Forms, Apache and Concurrent Managers.
• Re-Org of critical ERP tables.
• Experienced in Callibration/Orion utilities.
• Evaluated IBM Pureflex/Puredata systems
• Providing support (24*7) and troubleshooting user (remedy) tickets.
• Technical Standards and documentation:
• Technical documentation including documenting standard operating Procedures.

Confidential, Bridgewater, NJ

Lead Oracle Applications DBA

Responsibilities:

• DBA lead of team of 4 Applications DBAs
• Installation/Configuring Instances required for Implementation cycle.
• Upgrade of Database from 10.2.0.3 --> 10.2.0.4 --> 11.1.0.7
• Upgrade of Application from 12.0.4 --> 12.0.6 --> 12.1.1
• Cross Platform Migrations
• Demantra Installation and Integration with R12 Instances.
• Setting ASCP Managers
• Trouble-shooting of all oracle application problems.
• Copy/Clone of oracle application environment.
• DB/Application Backup.
• PCP Configuration for RAC Environments.
• DB refresh from RAC Environment to Non-RAC environment.
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl, adaimgr, adrelink, adsplice etc.
• Participated during the OS Migration from Linux to Aix
• Cluster Management and verifying cluster process to ensure smooth operations.
• Monitoring the all-running Instance to ensure everything working.
• Quantum upgrade and licensing the New Products.
• DB Upgrades and Database patches using Opatch tool.
• Interacting with oracle support to resolve application issues.
• Setting up of Oracle Configuration Manager

Confidential, Concord, MA

Oracle Applications DBA

Responsibilities:

• Upgraded the ERP from 11.5.9 to 11.5.10.2
• Provided Technical Support during the Go-Lives of 11.5.10.2 and OPM Modules
• Migrated the ERP Instance from Linux to Aix
• Trouble-shooting of all oracle application problems.
• Copy/Clone of oracle application environment.
• DB/Application Backup.
• PCP Configuration for RAC Environments.
• DB refresh from RAC Environment to Non-RAC environment.
• Monitoring the all-running Instance to ensure everything working.
• Quantum upgrade and licensing the New Products.
• DB Upgrades and Database patches using Opatch tool.
• Tablespace Maintenance like adding the increase the size of the data files.
• Interacting with oracle support to resolve application issues.

Confidential

Oracle Applications DBA

Responsibilities:

• Installations of Oracle ERP Applications
• Configuring ASM Instances
• Installing of BPEL Instances
• Trouble-shooting of all oracle application problems.
• Copy/Clone of oracle application environment.
• DB/Application Backup.
• Converting into Multi-Nodes.
• DB refresh and Clones.

Confidential, Ohio

Oracle Applications DBA

Responsibilities:

• Participated during the OS migrations of their Application Servers from AIX to linux
• Trouble-shooting of all oracle application problems.
• Copy/Clone of oracle application environment.
• DB/Application Backup.
• DB refresh and Clones.
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl, adlicmgr, adrelink, adsplice etc.

Confidential

Oracle Applications DBA

Responsibilities:

• DB refresh and Clones on RAW File systems
• Copy/Clone of oracle application environment.
• DB/Application Backup.
• Installation of OEM and configuring Alerts based on Thresholds

Confidential

Oracle DBA

Responsibilities:

• Providing DBA Support to ensure 24x7 DBA support.
• Trouble-shooting of all oracle database problems.
• Refresh of oracle database environment.
• DB Backup.
• Applying major Patches for DB upgrade
• Regular monitoring of production as well as Test application.
• Monitoring Performance, Locks using OEM, TOAD.

Confidential

Oracle Applications DBA

Responsibilities:

• Performance Analysis of client systems using EAP tools.
• Running perfstat data collections.
• By using EAP tools analyze the collected data.
• Finding the suitable recommendations based the data analysis.
• Running RDA scripts to find out system specific details.
• Running APPS RDA scripts to find out Application related details