SUMMARY

• Senior Oracle Database Administrator having 8 Years of experience. I have strong technical knowledge as an Oracle Database Administrator, Oracle Golden Gate, Oracle weblogic Administration and Oracle EBS Apps DBA.
• Experience with large and complex database management systems.
• Installation and administration of Oracle 12c,11g on OEL, RHEL and Windows in OLTP and OLAP environment.
• Performed Migration, upgrade, applying patches, patch sets and critical patch updates of Oracle databases.
• Extensive experience in administering maintaining Oracle Applications E - Business Suite Application.
• Experience as DBA for Oracle Retail Applications like Oracle POS, Oracle SIM, Oracle RMS.
• Experience in installation/configuration of Oracle Retail 13.2 modules (ORMS, ORSIM, RIB, ORPOS).
• Expertise in implementing and configuring Oracle GoldenGate 12c on OEL.
• Discovery of Oracle GoldenGate in OEM 12c to monitor the status and lag of golden gate processes.
• Maintaining golden gate process to replicate data from production to reporting database.
• Good experience in troubleshooting issues related to Oracle GoldenGate replication.
• Worked on Oracle Exadata X2-2, X3-2, X5-2, X6-2 Machines.
• Good client facing experience having worked in UK & US.
• Good Knowledge in maintaining Oracle 12c database in Oracle cloud instance. Installation and configuration of Oracle database 11g, 12c RAC with ASM on multi node systems for OLTP environment.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Expertise in Oracle Weblogic server Administration.
• Configuration and Management of Data Guard on OEL.
• Experience with Data guard broker configuration and switchover.
• Experience in troubleshooting issues related to standby and production database sync using data guard.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Expertise in Oracle Apps application cloning R12.1.x and R12.2.4, database refreshes patching using ADOP (Online Patching), adpatch and Opatch, apply CPU patches, handling configuration changes using Autoconfig.
• Backup and recovery of Oracle Databases using RMAN.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Taking the RMAN incremental and cumulative backups.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental).
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Performing clone of EBS instances from storage and RMAN backups.
• Automation of redundant database and application monitoring jobs using shell scripts.
• Knowledge on managing databases on EXADATA machines.
• Migrating the databases from one platform to another platform.
• Involved in cut-over activities on all the implementations and upgrade projects.
• 8 years of experience working in mission critical production and non-production systems involving complex architecture.
• Experience in Performance Testing of client Server and Web based Applications.
• 2 4*7 on-call production database support and maintenance including remote database support.

TECHNICAL SKILLS

ERP Environment: Oracle E-Business Suite 12.2.4, Oracle Retail Point of Sale, Oracle Retail Merchandising System, Oracle Retail Integration bus, Oracle Retail Store Inventory System.

RDBMS: Oracle 11g/12c RAC, Data Guard, Oracle Golden Gate 12c

Programming Technologies: UNIX Shell Scripting, SQL Scripting

Tools: Oracle Enterprise Manager (OEM), SVN, SQL Developer

Utilities: OEM, SQL*Loader, ASM, Export/Import, RMAN, TOAD, DataPump, Crontab, Rapid Clone, Rapid Install, Autoconfig, Opatch, adpatch

Operating System: Linux and Windows

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Administrator

Responsibilities:

• As a Senior Administrator, I am responsible to handle first point escalation for all technical and process issues related to database.
• Provide technical subject matter expertise for Oracle database issues wherever required.
• Worked on Maintenance, Support, Patching and Cloning using Rapid Clone.
• Provide support to Oracle Data guard related issues and maintenance of it.
• Maintenance of Oracle Database 12c Two node Real Application Cluster (RAC) and responsible for high availability and load balancing.
• Worked on Oracle weblogic Administration.
• Identify the bottlenecks in Database operations and tune the performance as and when required.
• Ensure constant synchronization of data from Production to standby environments for all the databases
• Ensure proper communication and quick resolution as a crisis manager.
• Configured disaster recovery databases using Data guard and perform switchover & failover and monitor using Data Guard manager command line.
• Worked on Active data guard and performed Troubleshooting data guard environment.
• Performed complete Patch Analysis and application of Apps and DB Patches.
• Taking the RMAN incremental and cumulative backups.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Providing Application Support for performance and database related issues.
• Extensive experience in RMAN recovery in RAC and stand-alone database.
• Scheduling the backups for the database using EM 12C cloud control.
• Cloned schemas, objects and data between servers using Data pump.
• Experience in performing backup and recovery operations using RMAN.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performed Data file recovery using RMAN.
• Performed database refresh from production to test environment in both RAC and NON RAC environment using RMAN.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Building multiple databases in QA, Test and Production environments.
• Maintaining Production Oracle 12c RAC and non-RAC database.
• Involved in Hot and Cold backups of databases.
• Taking the RMAN incremental and cumulative backups.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• Configured disaster recovery databases using Data guard and perform switchover & failover and monitor using Data Guard manager command line.
• Troubleshoot issues related to Data guard in Production.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Scheduling the databases backup using Cron tab.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Troubleshooted the Cluster related problems.
• Worked on Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Support Oracle Data Integrated related issues.
• Performed Oracle Data Integrator upgradation in PROD.
• Upgradation of Oracle weblogic from 11g to 12c.
• Handle SOA composite and Mail configuration related issues to support SOA development team.
• Patch Application to Oracle EBS(E-Business suite), Databases as per schedule.
• Handling tickets raised by functional/technical/business users for applications including Oracle GTM, SOA, ODI, E-Business suite, Databases.
• Handling Alerts raised by alert monitoring system from Database and applications
• Schema Reorg Activities in Database to improve the performance
• Cloning of complete application and database from Production to Non-prod as per business requirements
• Performing Backup of RAC and non-RAC Databases and fixing issues related to backup/recovery
• Addressing Query response time and other Performance Issues with respect to E-Business suite
• Providing support to Oracle cloud instance.
• Regular database maintenance activities (tablespace management, datapump, purging logfiles)
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Designing Backup/Recovery policies which suits customer needs.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.
• Installing OEM agents and managing databases using 12c EM and End-to-end implementation of EM12c.
• Involvement in space management, rectification of lock problems, managed quotas.

Confidential

Senior Database Administrator

Responsibilities:

• As a Senior Administrator, I was responsible to handle first point escalation for all technical and process issues related to database.
• Provide technical subject matter expertise for Oracle database issues wherever required.
• Provide support to Oracle Data guard related issues and maintenance of it.
• Implementation and configuration of Oracle Golden Gate 12c by gathering business requirement.
• Maintenance of Oracle Database 11gR2 Two node Real Application Cluster (RAC) and responsible for high availability and load balancing.
• Worked on Oracle weblogic Administration.
• Identify the bottlenecks in Database operations and tune the performance as and when required.
• Ensure constant synchronization of data from Production to standby environments for all the databases
• Ensure proper communication and quick resolution as a crisis manager.
• Plan and schedule Changes (CR) to be performed across environments, coordinating with different stakeholders.
• Patch Application to Oracle EBS(E-Business suite).
• Perform RCA for Major Incidents related to DBA tower.
• Perform Trend analysis, identify top few incidents related to Databases and work with respective teams/individual to minimize the incidents, Hardware troubleshooting & Vendor coordination.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.
• Participate in business meetings with various stake holders on a need basis.
• Take corrective actions based on the customer satisfaction surveys.
• Training of new team members.
• Able to work on Knowledge acquisition and updates to related documents.