SUMMARY

• Over 10+ years of experience in IT industry as an Oracle Core DBA and Oracle Applications DBA in support and implementation projects.
• Proficient in Oracle 9i/10g/11g/12c Database Administration on Production, Development and Test Databases including Disaster Recovery, High Availability Solutions (RAC & Data Guard) and Backup & Recovery (RMAN).
• Proficient in Administration and installation of Oracle Applications ERP systems 11.5.10.2 & R12 in single node and multi nodes on Linux/Unix environments.
• Experience in 10g, 11g RAC implementation and support.
• Upgradation of EBS from 11.5.10.2 to 12.2.4
• Experience in Upgrade of database from 10.2.0.5 to 12c.
• Experience in Conversion of Single node instance to 2 Node RAC.
• Much familiar with 12.2 new feature of on - line patching (ADOP) and various options to reduce the downtime
• Worked in TDE (Transparent data encryption) as a part of security compliance.
• Worked in Automation of Cloning process for R12.2.5
• Experience in database reorganization, migration, capacity planning and high-availability
• Experience in Workflow Administration, Configuration and troubleshooting of workflow issues.
• Experience in XML Publisher administration and configuration and troubleshooting of xml report errors.
• Strong knowledge of administration processes and controls to meet security and compliance audit requirements for SOX.
• Installation and Configuration of APEX with Embedded PL/SQL Gateway/Oracle Application Server and Oracle WebLogic.
• Have experience on the installation, administration and maintenance of Oracle Fusion Middleware 12c and 11g products (WebLogic, SOA, OSB etc.) in a clustered environment.
• Experience in working with AWS Cloud for the internal HR application.
• Have good Experience in Oracle Golden Gate .
• Cloned Oracle applications R12, 11i and Databases.
• Applied product specific fix patches, family packs and maintenance packs.
• Supported 24/7 on-call in Production & Development environment.

TECHNICAL SKILLS

Programming Languages/Tools: SQL*Plus, UNIX Shell Script, PL/SQL.

RDBMS: Oracle 9i, 10G, 11G, 12C.

Cloud Computing: AWS

ERP: Oracle applications (11.5.10.2, R 12.1.1/12.1.3 , R12.2.4, R12.2.5).

DB Tools: Recovery manager (RMAN), Oracle RAC, Toad, Data guard, Exp/Imp, Data pumpApplication & Web servers 9iAS, 10g AS, WebLogic, Glass fish, Companion.

Operating systems: OEL5.10, RHEL, IBM AIX 6.1, Solaris.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Consultant

Environment: Oracle Apps 11.5.10.2, 12.2.5, FMW 12c and 11g (WebLogic/SOA/OHS)

Responsibilities:

• Supported the systems extensively for Oracle 12.2.5 upgrade from 11.5.10.2
• Worked in Automation of Cloning process for R12.2.5
• Worked in TDE (Transparent data encryption) as a part of security compliance.
• Worked in configuring F5 Load balancer for 5 Node Application tier for R12.2.5
• Installed and support for the tools like WF Builder, Discoverer.
• Documented the procedures of installations and automations.
• Drove best practices, process improvements and strategic initiatives for Oracle ERP Upgrades
• Worked in Exadata which is a part of internal system and managed CELL SERV and DB Server as a part of it.
• SOA purging configuration, scheduling and Maintains schema performance.
• Handling SOA and FMW outages.
• Troubleshooting various performance issues after upgrade to R12.2.5

Confidential, Winston Salem NC

Sr. Oracle Apps DBA/FMW Admin

Environment: Oracle 11.2.0.4/12 c, Oracle Apps 11.5.10.2, 12.2.4, FMW 12c and 11g (WebLogic/SOA/OSB/OHS)

Responsibilities:

• Provided support for upgrade from 11.5.10.2 to R12.2.4
• Troubleshooting various performance issues after upgrade to R12.2.4
• Providing support for Critical Oracle EBS Application and Databases which is of 20TB
• Worked in R12,2 instance configured with SSO (OAM).
• Worked in Cloning process of R12.2.4, Patching using adop and Troubleshooting.
• Providing DBA and Oracle Applications Sysadmin Support
• Troubleshooting of middleware issues like LBR and other Admin server issues.
• Involved in Load test of critical databases.
• Setup and Install 11gR2 Grid Infrastructure for RAC databases
• Set up and Documented Standards and Issues for EBS Upgrades
• Drove best practices, process improvements and strategic initiatives for Oracle ERP Upgrades
• SOA purging configuration, scheduling and Maintains schema performance.
• Expertise in Web logic 11g Administration and Installation.
• Handling SOA and FMW outages.
• Providing 24*7 support for Fusion Middleware Products Stack (WebLogic/SOA/OSB/WC).

Confidential, Westbury, NY

Sr. Oracle Apps DBA

Environment: Oracle 11.2.0.3/12 c, Oracle Apps 11.5.10.2, 12.1.3,12.2.4

Responsibilities:

• Worked as a onsite/offshore coordinator from Doyensys Inc office in Plano, Texas.
• Re-assigned concurrent requests to various custom concurrent managers for avoiding bottlenecks and to improve the performance of overall batch processing.
• Oracle Database Upgrade, Cloning, Patching and Troubleshooting.
• Migrate Forms / Reports from Development to PROD using FNDLOAD utility.
• Providing DBA and Oracle Applications Sysadmin Support
• Done Upgrade from 12.1.3 to 12.2.4
• Upgraded Database from 11g to 12c as a part of Ebiz upgrade.
• Performed Transparent Data Encryption and performed PCI Scanning as a Security measures.
• Involved in Load test of critical databases

Confidential, Westbury, NY

Sr. Oracle Apps DBA

Environment: Oracle 11.2.0.3/12 c, Oracle Apps 11.5.10.2, 12.1.3

Responsibilities:

• Providing support for Critical Oracle EBS Application and Databases which has various modules like Financial (AR, AP, GL), SCM (Order Management, iSupplier) and HR.
• Oracle Database Upgrade, Cloning, Patching and Troubleshooting.
• Provided support for the Oracle database with size of 3 TB.
• Migrate Forms / Reports from Development to PROD using FNDLOAD utility.
• Done Upgrade of Ebiz from 11.5.10.2 to 12.1.3
• Converting single node instance to two Node RAC.
• Implemented and supported backup using RMAN.
• Prepared checklist for cutover plan and execution.
• Troubleshooting the Concurrent Manager issues.
• Performed Transparent Data Encryption and performed PCI Scanning as a Security measures.
• Implemented Apex as a part of proactive monitoring and reporting.
• Monitoring databases and doing maintenance using 12c OEM.
• Install 12c agents to the clients using push method without logging in to target.

Confidential, New York City, NY

Sr. Oracle Apps DBA.

Environment: Oracle 10.2.0.5/ 11.2.0.4/12 c, Oracle Apps 11.5.10.2.

Responsibilities:

• Provided Oracle Applications Sysadmin and DBA Support.
• Created Custom manager and defining Work shift as a part of Concurrent Manager tuning.
• Migrate Forms / Reports from Development to PROD using FNDLOAD utility.
• Building Physical standby for the production instance.
• Creating DG Broker setup for the production instance.
• Implemented Apex as part of monitoring tool.
• Implemented and supported backup using RMAN.
• Involved in Load test of critical databases for various projects.
• Monitoring and troubleshooting the 6 Node RAC instance.
• Done Shrinking of huge tablespaces containing LOB segments.
• Implementation of OEM 12c for database monitoring.
• Performed switchover and failover of databases.

Confidential, Peachtree City, GA.

Oracle DBA

Environment: Oracle 10.2.0.3/9.2.0.6 with IBM AIX.

Responsibilities:

• Implementation of APEX as a Monitoring Tool for DBA Activity.
• Involved in all phases of the software development lifecycle (SDLC) such as analysis, design, development, testing, implementation and support.
• Software Installation, Database Design and creation of instance, considering User Requirements.
• Implemented 11gR2 RAC on IBM AIX
• Maintenance activity which includes reorganization, restructuring physical files, defragmenting the fragmented objects.
• Automating the DBA Manual Operations by Creating Scripts and scheduling them using Crontab.
• Customer interaction and Liaison with Oracle for Production Related Problems.
• Performance Tuning suggestions and implementation.

Confidential

Oracle Apps DBA

Environment: Oracle 11.2.0.3, Oracle Apps R12.1.3 with IBM AIX

Responsibilities:

• Done Upgrade of Ebiz from 12.1.1 to 12.1.3
• Database upgrade from 10.2.0.4 to 11.2.0.3
• Building Physical standby for the production instance
• Done pro-active monitoring measures for critical databases.
• Done Concurrent Tuning as a part of Enhancement
• Monitoring and troubleshooting the RAC instance.
• Patching of Oracle EBS, Applying Oracle RDBMS patches in RAC environment
• Cloning done using hot backup and cold backup.
• Prepared checklist for cutover plan.
• Done performance tuning with 12.1.1 Application.
• Implemented Golden Gate.

Confidential

Oracle Apps DBA

Environment: Oracle 10.2.0.3, Oracle Apps R12 with Windows 2003 Server

Responsibilities:

• Installation of Oracle E-business Suite Application R12 on windows 2003 server
• Applications Maintenance and Support
• Installation of EBS 12.0.6, SIT and DEV Instance (Multiple instances on Single Server)
• Applying Patches as per the request by functional teams.
• Upgrades of core database instances
• Implemented (ODAMS) Tools using APEX for Database Monitoring.
• Monthly cloning will be done from the cold backup as a part of testing.
• Applying Patches by following the Change Management process.

Confidential, Camp Hill, PA

Oracle DBA

Environment: Oracle 10gR2, Oracle Apps 11.5.10.2, Linux and SQL Server.

Responsibilities:

• Relocate the EM Agent Home as a part of Monitoring and upgraded the EM Agent Home from 10.1.0.4 to 10.2.0.3.
• Automating the DBA Manual Operations by Creating Shell Scripts and scheduling them using crontab.
• Re-assigned concurrent requests to various custom concurrent managers for avoiding bottlenecks and to improve the performance of overall batch processing.
• Involved in maintenance of Oracle E-Business Suite 11.5.10.2 on RAC on Linux Platform
• Upgraded the production database from 10.1.0.4 to 10.2.0.3
• Proactive monitoring of the database with respect to space, instance and application
• Server process availability using scripts and through EM Monitoring.
• Clone the production instance to support instance on a weekly basis using automated procedures for database refresh using RMAN backup.
• Prepared SOP documents for regular and critical activities performed.
• Migrate code like database objects / Forms / Reports from Development to Test Performing Impact analysis on Patches
• As a Part of Maintenance also maintained the SQL Server database which is used as a HYPERION database. (Tool used for three dimensional reporting).