SUMMARY

• As a Senior DBA, I work independently and manage multiple task assignments within a structured methodology
• Implementing and Administering Multi Node Oracle Applications E - Business Suite R12.2, R12 and 11i Stack with 11g,12c,19c RAC databases and Exadata Machines.
• Extensive experience with Environment builds, Patching, Cloning and System Maintenance activities
• Performance Monitoring and Tuning Applications and Databases on timely basis.
• Experience in Load balancing Databases and Capacity planning.
• Performed Database and Application Upgrades to latest releases
• Experience in Administrating, Configuring, and Troubleshooting FMW products.
• Maintain, Perform and test Backup and Recovery Procedures
• Administering OEM 13c for Database Monitoring and Performance Tuning.
• Good experience on troubleshooting & handling Severity issues on timely basis.
• Administering Golden Gate Environments.
• Provide on call support for all enterprise-wide oracle databases for daily database activities.
• DR (Disaster Recovery) testing and support for EBS systems.
• Was involved in Business Process calls with Service Delivery Management and SME’s on daily basis.
• Performed RCA (Root Cause Analysis) for all critical issues and prepared process documents on need basis.
• Performed Production assessment and created a detailed business process document for the customer GO-LIVE.
• Provided technical support to development team for database issues.
• Experienced Production Support & On-call Rotation DBA.
• Planning Lead for Cloud Migration of Application and Databases to OCI Oracle Cloud from On-premise.
• Mentored new team members, providing trainings on the process flow and at Technology aspects.
• Worked as lead for Major Upgrades. This involves, working with customer and SDM and gathering the requirements for the project.
• Estimating the timelines for the project .
• Participating in customer calls and ensuring all requirements are documented
• Be point of contact for complete project, till the change is promoted and completed in production .
• Documenting all the issues occurred during Nonprod run and ensuring smooth

PROFESSIONAL EXPERIENCE

Confidential

Oracle Applications DBA

Responsibilities:

• Provide Production Support for multiple Oracle Databases and Applications on timely manner.
• Experience using OEM 13c for Database Performance Monitoring and Tuning.
• Defect fixes and resolutions on a very timely manner.
• Administrating, Configuring and Troubleshooting FMW products like WebLogic, OBIEE, Informatica
• Troubleshooting and tuning issues at various layers of Oracle Applications
• Cloning of 12.2 application file system from multi-node to multi-node and to single-node.
• Analyzed and applied CPU, PSU, bug fix patches for Oracle E-Business suite, Oracle Databases and Fusion Middleware Products
• Patch Management using ADOP, OPATCH utilities for Oracle E-Business Suite releases
• Develop, Maintain, Perform and test Backup and Recovery Procedures
• Work with other IT departments to make sure that data and systems are available and perform activities within SLA
• Provide on call support for daily database activities.
• Was involved in Business Process calls with Service Delivery Management on daily basis.
• Performed RCA (Root Cause Analysis) for all the issues and prepared process documents on need basis.
• Work independently and manage multiple task assignments within a structured implementation methodology
• Provided technical support to development team for database issues.
• Worked with Oracle support on critical and non-critical services requests

Confidential, Seattle

Oracle Database Administrator

Responsibilities:

• Monitored the EBS systems for Optimal Performance and provide improvements to enhance overall performance.
• Experienced in upgrading the Oracle ERP from 12.1 to 12.2.
• Administrating, Configuring and Troubleshooting fusion middleware products (Weblogic, SS0, OID, OAM)
• Installation, Configuration & Administration of Oracle Database 11g/12C, RAC, RMAN & Oracle Enterprise Manager (OEM).
• Experience in Configuration, Patching, Cloning & Administration of ORACLE Apps/Databases.
• Installation, Configuration and Administration of Oracle Golden Gate 11G, Discoverer, Workflow, Fusion Middleware 10g/11G components i.e. OBIEE, SOA and WebLogic
• Oracle EBS cloning: both DB and APPS from prod onto non-prod using RMAN for DB backup/ duplicate and using Oracle Rapid Clone for both DB and APPS clone.
• Performed Oracle Database Administration activities such as Upgrades, Migration, Patching, Backup & Recovery, Performance Tuning, capacity planning, shell scripting and Automation.
• Experience with On-boarding and training Off-shore & new On-Shore resources.
• Defect fixes and resolutions for Business-critical applications on a very timely manner.
• SSL setup and configuration for EBS Systems
• Supporting Golden Gate Extracts and Replicates
• Maintaining and registering Mining Databases
• Trouble shooting and Tuning Long Running Jobs across multiple Databases.
• Develop, Maintain, Perform and test Backup and Recovery Procedures
• Worked with Oracle support on critical and non-critical services requests
• Set up and Documented Standards and Policies for Database and E-business suite Upgrades
• Cross platform support for AWS systems.

Confidential - Virginia

Senior DBA - Application Services

Responsibilities:

• Responsible for managing all aspects of service and support for Confidential Client accounts.
• Responsible for working on wide variety of Oracle Platforms, Architectures and manage customer service programs (e.g System maintenance and strategic planning…)
• Responsible maintaining multiple Oracle E Business Suite Environments
• Responsible for Monitoring higher end production and non-production environments and assist with daily administrative issues
• Responsible for delivering project status to customer and Confidential management and work with Confidential client services team to provide timely, effective and efficient support for all Confidential customer systems
• Installation of R12 and 11g database.
• Install and Configure OAM/SSO and integrate with R12/12.2
• Performed upgrades from 12.0.6 / 12.1.3 to 12.2 and also database upgrade from 10g/11g to 12c.
• EBS (SSL), SSO (SSL), Discoverer on two load balanced application servers.
• OID integration with Active Directory .
• Cloning the instances regularly using RAPID CLONE (almost 3 to 4 clones per week).
• Applying latest releases of the application patches (with/without hot patch option) to resolve any kind of application issues.
• Applying the Application of Security Patches, RDBMS Patches, Functional Patches, JDK upgrade and Jinitiator upgrade patches, isetup Patches and isetup configuration.
• Troubleshooting of concurrent manager, concurrent requests related issues.

Confidential

Oracle DBA

Responsibilities:

• Performed Complete Server Validation which includes validating OS, File Systems, Network and firewall rules
• Maintain 11gR2 Grid Infrastructure for RAC databases
• Upgraded Grid Infrastructure from 11.2.0.3 to 11.2.0.4
• Upgraded RAC Databases from 11.2.0.3 to 11.2.0.4
• SSL for EBS 12.2 releases with F5 load Balancers
• Cloning of 12.2 application file system from multi-node to multi-node and to single-node.
• Patch Management using ADOP, OPATCH utilities for Oracle E-Business Suite releases
• Develop, Maintain, Perform and test Backup and Recovery Procedures
• Performance monitoring and tuning Applications and Databases on timely basis.
• Monitored the databases for optimal performance. Recommended improvements to enhance overall performance.
• Defect fixes and resolutions on a very timely manner.
• Provide on call support for daily database activities.
• Was involved in Business Process calls with Service Delivery Management on daily basis.
• Conducted Performance testing and Stress testing for EBS system for successful Go-live
• Performed RCA (Root Cause Analysis) for all the issues which involved high level escalations and prepared process documents on need basis.
• Mentored new team members, providing trainings on the process flow and at Technology aspects.
• Performed Production assessment and created a detailed business process document for the customer GO-LIVE.

Confidential

Oracle Applications DBA - EBS Prod Support

Responsibilities:

• Production Support and Maintenance of Oracle E-Business Suite R12
• Continuity of Business (DR) configuration, testing and support. Completed the DR drill test successfully for the year 2014.
• Performed Green Zone activity for Production instances, which involves taking a full back up of the instance, perform a complete shutdown of all the services, migrate all the code promotions, apply all the applicable patches, bring up the services, perform all the necessary post steps and released the instance as per the scheduled downtime.
• Troubleshooting the concurrent managers, Apache and Discoverer issues.
• Familiar with Workflow configurations.
• Performed business database and application patching, database capacity planning, and Oracle ASM configuration and implementation.
• Conducted performance tuning for large enterprise resource planning (ERP), systems
• Responsible for applying quarterly CPU patches
• Has extensive experience in cloning and instance refreshes of complex environments
• Analyzed and applied CPU, PSU, bug fix patches for Oracle E-Business suite, Portal, OID and Fusion middleware Discoverer components.
• Has good knowledge of DATAPUMP and physical backup's like COLD and HOT Backup, Restore and Recovery at different scenario
• Have worked on NON-RAC and RAC instances
• Has good experience in handling severity one production issues on timely basis
• Has performed RCA (Root cause Analysis) for all issues which involved high level escalations and prepared process documents on need basis
• Had provided technical support to development team for Database issues
• Had provided on call support for all enterprise wide Oracle Databases for daily database activities.
• Maintaining documentation for all kinds of activities for Knowledge management.
• Mentored new team members, providing trainings on the process flow, and at Technology aspects.

Confidential

Oracle Applications DBA - EBS Production Support

Responsibilities:

• Support and Maintenance of 11i/R12 E-business suite application with PCP (Parallel Concurrent Processing) configured.
• Supported and maintained Shared APPL TOP.
• CPU / PSU Patching, Autoconfig Stabilization, Apache Stabilization.
• Performed Pre Patch analysis, Pre-config and Pre-State Analysis
• Customization Updates and working on Code promotions.
• Have applied Tech Stack patches and RDBMS patches.
• Troubleshooting Concurrent manager issues, Setup custom managers, Performance tuning
• Trouble shooting Apache and Discoverer issues.
• Managing Forms, Report Servers and Web Servers
• Building ODP -Demand Planning Instance
• Managing and configuring the backups for the ORACLE databases such as EXPORT Backup, RMAN Backups, and HOT/ONLINE Backups.
• Monitoring alert log and trace files and tablespace growth proactively
• Provided on call support for all enterprise wide oracle databases for daily database activities.
• Provided technical support to development team for database issues.
• Provide on call support for all enterprise wide oracle databases for daily database activities.