EXPERIENCE SUMMARY:

• Over 11 years of experience in the areas of Oracle Application DBA, Cloud Admin DBA(Oracle/AWS/Azure), Fusion Middleware DBA, Oracle RAC and Oracle DBA.
• Installed Oracle Applications 11.5.10.2, R12.1.1, R12.2.0.
• Upgraded Oracle Applications Version from 11.5.10.2 to 12.1.3.
• Installation and Upgraded EBS from R12.2.0 to R12.2.X.
• Worked on 3 major implementation projects of R12.2.x.
• Upgraded Oracle EBS D Confidential base from 9.2.0.8 to 11.1.0.7 and to 11.2.0.3,11.2.0.4
• Upgraded Oracle EBS D Confidential base from 11.2.0.3 to 12.1.0.2.
• Applied latest PSU patches on D Confidential base other Oracle HOME and RPC patches on EBS.
• Experience in managing 10g, 11g d Confidential base with ASM/non - ASM, backup using RMAN
• Implemented High Availability solutions (D Confidential Guard) on Oracle 11.2.0.4, 12.1.0.2 with EBS.
• Implemented the Switchover & Failover D Confidential guard during D Confidential center disaster recovery scenario, using DG broker.
• Implemented, Configured & Maintained RAC enabled d Confidential bases version - 11gR2
• RAC-RAC & RAC-NON RAC cloning using RMAN Duplicate (Active) and PITR, for EBS d Confidential bases.
• Implemented Services for Load balancing and fault tolerance at the Application/Instance level.
• Upgraded Grid Infrastructure (RAC) from 11.2.0.1 to 11.2.0.3.
• Defined Custom Concurrent Managers to run the special requests in a dedicated queue.
• Configured and Implemented Shared APPL TOP.
• Pre-patch analysis, document preparation with pre and post patch installation steps.
• Applied India Localization Patch, NLS patches on EBS 11.5.10 and on R12 as well.
• Installed and configured OEM 12c R1, along with mass agent Deployment
• Upgraded OEM 12cR1 to 12cR3, along with the agents.
• Configured OEM AMP for E-Business Suite, in 12cR1 for CMS and Cloning.
• Experience in Oracle Apps DBA activities like Cloning, Patching and Administration, Troubleshooting.
• Experience in monitoring performance of d Confidential base and applications OEM Grid and other tools.
• Configured RMAN backup strategy and worked with Symantec NetBackup for Automated DB Clone.
• Worked on optimizing the d Confidential base performance by implementing various tuning techniques & recommendations using OEM
• Provided proactive management to Client by using custom UNIX scripts.
• Rapid Planning Implementation on Weblogic with APCC
• Material Planning Implementation on Weblogic with APCC.
• Installed and Configured Oracle Gateways to connect SQL Server heterogeneously.
• Installed R12.2.0 and Upgraded EBS R12.2.5 on AWS cloud, with Custom Domain
• Configured Public IP Route queries with Route 53 on AWS Cloud for EBS.
• Configured REST services in EBS R12.2.5 & SOA implementation on AWS cloud.
• Configured DR, with D Confidential guard broker for EBS on Oracle Cloud DbaaS and IaaS cloud.
• Worked on Shareplex installation, configuration for table level replication.

TECHNICAL SKILLS

Operating Systems RHEL/OEL: Confidential -AIX (6), ORACLE Solaris (8, 9, 10), Win NT 4.0

Oracle Applications: Oracle E-Business Suite R12 (R12.2.6, R12.2.5, R12.2.4, R12.2.3, R12.1.3, R12.1.1, R12.0.6)

Languages: SQL, Shell Scripting & HTML

Forms Server Fusion Middleware: 10g, Dev2000 (1.6.1) Dev9i/6i (forms and reports).

Oracle Tools: RMAN, OEM, TOAD, SQL Developer, Sqlldr, exp/imp, Discoverer, Enterprise Manager (OEM), OAM, Weblogic, Demantra, ODI.

D Confidential Base Servers: Oracle 12c, 11g/10g/9i/8.x RAC with ASM

Application Servers: Fusion Middleware 10g, Apache Server, 9iAS and 10gAS (portal, SSO, Discoverer), Weblogic 11g and 12c. SOA 11g.

Application Tools: Workflow Builder, Microsoft TFS

Other Tools: OBIEE, ODI, Demantra, Vmware Vsphere

Cloud Servers: Amazon Cloud, MS Azure Cloud & Oracle Cloud

PROFESSIONAL EXPERIENCE

Confidential

Project support

Responsibilities:

• DR implementation for EBS, SOA, OBIA and AppsWorx tool, using Virtual Hostname.
• Upgrade all current d Confidential bases to 12.1.0.2.
• Implement OEM13c.
• SOA to REST services movement.
• Day-to-Day Project DBA support for the Dev.
• Monitor Remedy Queues for tickets on clones, tasks etc.

Confidential

Responsibilities:

• Installation of EBS R12.2.0.
• Upgrade to R12.2.4 with SDH, PDH & CDH modules licensed.
• Patched Weblogic and D Confidential base with Mandatory patches.
• Installation of EDQ and configuring it with Oracle D Confidential base.
• Installation of EDQP and configuration with Oracle D Confidential base.
• Support EDQ & EDQP performance issues on Weblogic.
• Deployed OAF objects on PROD.
• Custom TOP creation and code migration to PROD.

Confidential

Responsibilities:

• Initial Server Configuration/Sizing estimate with a full detailed checks for new server.
• Installation of EBS(VCP) R12.2.0 & Upgrade to R12.2.3
• Installation of OBIEE
• Configure APCC dashboards with SSO to EBS
• Installation of Demantra 12.2.3 and integrate with VCP 12.2.3
• Installation of Manufacturing Operations Center for EBS.

Confidential

Responsibilities:

• Provide production support for Oracle Applications R12.1.3 environment
• Patched UAT & PROD with CPU patches
• Upgraded the D Confidential base to 12.1.0.2 from 11.2.0.3.
• Built the DR d Confidential base on 12.1.0.2
• Worked on IP address change on PROD boxes and configured the applications
• Performed DR Drill activity and switched the PROD to DR, on a planned day.
• Documented DR Drill Activity and Emergency Switch over.
• Monitored the D Confidential bases from OEM.
• Tuned various High cost SQL’s via OEM.
• Applied Product specific Patches and post installation patches in ERP
• DR Sync issues resolved via RMAN Incremental backup.

Confidential

Responsibilities:

• Installation of Demantra 12.2.4.1 on DEV
• Upgrade Demantra Schema & Application via BAL upgrade on existing 12.2.3 DEV to 12.2.4.1.
• Export the Upgraded Demantra Schema.
• Import the Upgraded Demantra Schema on the DEV for regression testing of the upgraded objects on new 12.2.4.1 Demantra.

Confidential

Responsibilities:

• Creating the Pilot Instance.
• Migration of VMs from Oracle VM to VMWare VM.
• Creation of DEV/TEST(11) environments for technical, functional and business purposes
• Installed and Configured RAC 11.2.0.3 on DB and Oracle APPS R12.1.3
• Implemented Load balancing internally on the RAC Nodes
• Installed RUP Patches for AP, CORE Financials.
• Implementing RMAN Duplicate (Active) and PITR for RAC-RAC Clones.
• Troubleshooting the issues with RMAN backup strategy.
• Monitor d Confidential bases and application through OEM Grid Control.
• Applied EBS RPC2 Mega Patch.
• Implemented Shared APPL TOP.

Confidential

Responsibilities:

• Installed and Configured EBS 12.1.3 on VM (VMWare ESX servers)
• Patched with latest VCP patch
• OBIEE 11.1.7.0 Installation
• APCC configuration and SSO implementation
• SSL Implementation on VCP
• SSL Implementation on OBIEE
• SSL Integration with SSO between VCP and APCC(OBIEE).
• Server Migration
• Production CLONE from SSL to NON-SSL instance
• Implemented Material Planning onVCP.

Confidential, USA

Upgrade and Migration

Responsibilities:

• Upgrade of existing R12.0.6 EBS to R12.1.3
• Upgrade of existing 11.1.0.7 DB to 11.2.0.3.
• Implementation of Global HR
• Ship Console Implementation
• Server Sizing and PCP Configuration setup alteration after upgrade.
• Custom TOP creation from OAM and Migration of Reports from SAP to EBS
• OEM 12cR1 implementation
• OEM 12cR1 upgrade to 12cR3 and Health Check Report configuration.
• AMP Plug-in Installation for CMS and EBS Health Check.
• DC Migration from Navylist DC to Angio DC(Windows Azure Cloud)

Confidential

VCP Implementation

Responsibilities:

• Installed VCP(ASCP) instance R12.1.1, upgraded it to R12.1.3 & applied 12.1.3.8 VCP patch
• Created DB links from Source instance to Planning instances.
• Clone of APSDEV to APSTEST.
• Server migration from US DC to Mumbai (TCS - DC), with Server upgrade to RHEL 6.4.
• Implemented RMAN Backup Strategy with Symantec NetBackup tool.
• Automated DB Clone via Symantec NetBackup tool.
• Configured Workflow on the new Office365 Exchange Server.
• Regular Production Support

Confidential

Responsibilities:

• Upgraded the Oracle Applications from
• Upgraded applications from 11i (11.5.10.2) to R12 (12.1.3) for DEV and TEST.
• Upgraded D Confidential base base from 9i to 10g and then further to 11g.
• Migrated the DB from 32-bit to 64-bit Platform
• Migrated the APPS from 32-bit to 64-bit Platform
• Worked on clone of Oracle application 11i/R12.
• Tuned various High cost SQL’s via OEM
• Worked on issues related to custom forms and resolved them.

Confidential

Responsibilities:

• Applied CUP2 patches to 11.5.10.
• Upgrade ERP d Confidential base from 10g R2 to 11g R1.
• Implemented India Localization Patch and NLS patches.
• Upgraded the d Confidential base from 10.2.0.4 to 11.1.0.7.
• Production support of current R12 ERP instance.
• Centralized D Confidential base monitoring using OEM Grid control.
• Extensively used and preferred RMAN Backup strategy for efficient and hassle-free restoration.
• Implemented Active Standby D Confidential guard setup for the current d Confidential base.
• Part of on call team that took part in on call rotation to provide 24/7 production support.

Confidential

Oracle DBA

Responsibilities:

• Involved in upgrade planning across TEST, UAT and Production servers for 38 different d Confidential bases across the country.
• Upgraded 14 D Confidential bases from 9i (9.2.0.x) to 10gR2 in Test environment and in UAT, finally to the Production.
• Implemented Physical Standby D Confidential base with RMAN (1+1) for 8 sites.
• Configured Logical Standby D Confidential base for reporting purpose for 3 sites.
• Installed Patchset update 3 to upgrade to 10.2.0.4.
• Installed CPU patches.
• Used RMAN as the main tool for performing Backup.
• Periodically tested the validity of the Backup sets on TEST, to avoid SPOF.
• Periodically checked for corrupt D Confidential files with the help of RMAN and DBV Utility.
• Periodical health checks and report preparation of d Confidential bases during on-site visit.