SUMMARY:

• 10+ years of Oracle DBA/APPSDBA experience in Oracle 12c, 11g, 10g and 9i administration, Backup and Recovery, Performance Monitoring and Tuning, Implementation and maintenance on Production, Stage and Development environments.
• Oracle Database Administration experience in various environments like HP - UX, SUN SOLARIS 2.6,8,9,10, AIX4.33, 5L, 6, 7, Red Hat Linux.
• Implementation of High Availability solutions with Oracle 12c/11g/10g/9i, 10g RAC, 11g RAC, Standby Database, Data Guard, Replication.
• Oracle Applications Administration experience on 11i version.
• Hands of experience in Oracle 12c/11g/10g/9i Database installation, configuration, physical & logical database design, upgrading Databases (11gr2 to 12c, 10gr2 to 11g, 10g R1 to 10gR2, 9i to 10gR1), Oracle RDBMS patches (CPU and PSU).
• Experience in design, deployment, administration, management of Disaster Recovery solutions, proficient in Business continuity and High availability solutions using Data-Guard, RAC, ASM and GOLDENGATE.
• New Sever setups such as Solaris 9,10 and Aix 6,7 for Oracle 12c/11g/10g and Configuring & Maintaining RMAN Backups.
• Proficient in Database Administration, Production Support, Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup and Recovery, Cloning, Space Management, Database Security, Auditing, Troubleshooting, Database Design, TAR support, Unix shell scripting and Documentation.
• Efficient knowledge Monitoring, Troubleshooting RAC cluster using srvctl and oradebug.
• Strong experience in implementing and monitoring Physical Standby Database for Data Guard disaster recovery technique and DGMGRL.
• Organizing and Leading the DR drill for every 6 months.
• Experience in using OEM, Toad and Data Migrations using Export/Import, benchmarking using Load testing tools.
• Strong experience in installing OEM13C and configuring databases for monitoring Database performance.
• Strong experience in migrating database from Non-ASM to ASM and Non-Rac to Rac.
• Experience in installing and configuring GoldenGate v 12.2/11.2 /10.4.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• Proven experience in managing large databases with sizes over 30 TB.
• Good Knowledge on AWS.

TECHNICAL SKILLS:

Operating Systems: Redhat Linux, UNIX, AIX, HP-UX, Sun Solaris

Databases: Oracle 12c, 11.x, 10.x, 9.x

Incident Management: Remedy Expert Desk, HP OpenView Service Desk, SM7, IPM, AYSApplications & Utilities: Oracle Golden Gate, ASM, Oracle 12C/11g RAC, OEM Grid Control, Oracle Data Guard, RMAN, Weblogic, BPEL, JBOSS, cluvfy, crsctl, olsnodes, srvctl, Expdp, impdp, opatch, exp and Imp, SQL*loader, tkprof, ADDM, TFA Analyzer, AWR, TOAD, SQL Devloper.

EXPERIENCE:

Confidential, IRVING, TX

Senior Oracle DBA / Production support

Responsibilities:

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for the maintenance of the Oracle 12c/11g databases for the Production, Stage, QA and Development.
• Installed the OEM13C, configuration/registration of client databases in GRID.
• Installing the 13C agents through console and also installing manually on servers.
• Upgraded the OPatch version and OMSPatcher version for OEM13C.
• Installing 12c 4 node pluggable databases for OEM13C repository.
• Finding the fragmented tables and defragmenting the tables by expdp and moving the tables into new tablespaces.
• Troubleshooting the SQL performance issues.
• Configuring DB console for the PROD databases.
• Improving the SQL statements performance by implementing SQL profiles and implementing the TUNNING ADVISOR recommendations.
• Exporting non partition tables and importing to partition tables.
• Proactive monitored databases using Oracle Enterprise Manager (OEM).
• Managing ASM storage across all database environments - monitor utilization & performance, request new LUNs, create ASM disks & disk groups, allocate & reclaim ASM disks to/from ASM disk groups, drop ASM disks, return LUNs to storage team.
• Installing and configuring OEM console on PROD.
• Applying latest releases of RDBMS Patches using OPatch Utility.
• Experience in maintenance of Production, Testing, Development, RAC, Standby databases/ Dataguard for OLTP, Decision Support Systems (DSS) Data Warehouse environments and Design/Deploy Oracle Maximum Availability Architectures for Business Continuity - includes RAC, ASM, Active Data guard, Golden Gate.
• Implemented parallel GOLDEN GATE replicates on target server to reduce the lag and for better data synchronization.
• Responsibilities handled include supporting and maintaining Oracle GoldenGate v12.2/11.2.
• Golden Gate Replication, working with 1+TB databases.
• Upgraded Goldengate from 11g to 12c.
• Applying Patches, Upgrades, troubleshooting database issues, critical security updates and User Issues using Meta link.
• Maintain oracle 11gR2 RAC (ASM Real Application Cluster), Non- RAC(ASM) and File System based databases of varying sizes.
• Experience in Implementation of High Availability solutions with 11g RAC, Physical Standby Databases (Data Guard) and Golden Gate.
• Planning, Implementing and Documenting the DR Drill for all the PROD databases.
• Troubleshooting data synchronization issues in GoldenGate.
• Experienced with Oracle 10g and 11g RAC installation and configuration.
• Experienced with DATA GUARD Implementation and Point in time Recovery.
• Applied PSU patches on weblogic .

Environment: Oracle 12c/11g GRID, Oracle 11g/12c, OEM Grid Control, Oracle data guard, Golden Gate, logdump, oracheck, crsctl, srvctl, SQLTXPLAIN, TFA Analyzer

Confidential

Senior Oracle DBA / Production support

Responsibilities:

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for the maintenance of the Oracle 12c/11g/10g/9i databases for the Production, Stage, QA and Development.
• As a strong team player, shared the knowledge within the DBA team and participated in discussions with DBAs, Architects, Application and Testing teams and Project Managers.
• Installed the 12C grid agent and configuration/registration of client databases in GRID and Proactive monitored databases using Oracle Enterprise Manager (OEM).
• Manage ASM storage across all database environments - monitor utilization & performance, request new LUNs, create ASM disks & disk groups, allocate & reclaim ASM disks to/from ASM disk groups, drop ASM disks, return LUNs to storage team.
• Applying latest releases of RDBMS Patches using OPatch Utility.
• Experience in maintenance of Production, Testing, Development, RAC, Standby databases/ Dataguard for OLTP, Decision Support Systems (DSS) Data Warehouse environments and Design/Deploy Oracle Maximum Availability Architectures for Business Continuity - includes RAC, ASM, Active Data guard, Golden Gate.
• Migrated the production and development databases from 10g to 11g and 11g to 12c.
• Implementation and support of 10g and 11g migrations and upgrades from Oracle 10g and 11g databases, including RAC (Real Application Clusters) databases on Solaris and Linux.
• Installed and configured Oracle GoldenGate V 11.2.1.0.1 Bidirectional for Oracle 11g on AIX 6.1.
• Responsibilities handled include supporting and maintaining Oracle GoldenGate v12.2/11.2.
• Responsible for installing and configuring GoldenGate 10.4 on Oracle Servers.
• Golden Gate Replication, working with 1+TB databases.
• Applying Patches, Upgrades, troubleshooting database issues, critical security updates and User Issues using Meta link.
• Resolved the ASM and Cluster Issues (OCR), ASM was unable to communicate with cluster resources, raising the SR with Oracle support for the resolution of the issues.
• Maintain oracle 11gR2 RAC (ASM Real Application Cluster), Non- RAC(ASM) and File System based databases of varying sizes.
• Experience in Implementation of High Availability solutions with Oracle10g, 11g RAC, Physical Standby Databases (Data Guard) and Golden Gate.
• Identifying data synchronization issues in GoldenGate.
• Installing, configuring & patching Oracle software versions 10g & 11g.
• Experienced with Oracle 10g and 11g RAC installation and configuration.
• Migrated applications from WebLogic 9.2 to WebLogic 10.3.
• Upgraded WebLogic servers with necessary patches and service packs.
• Installed, configured, administered and troubleshot issues with JBOSS 4.x in clustered and non-clustered environment.

Environment: Oracle 12c/11c GRID, Oracle 11g/12c, Oracle 10g R1/l2, SM7, OEM Grid Control, Oracle data guard, Golden Gate, Weblogic, JBOSS, BPEL, oracheck, crsctl, cluvfy, srvctl, SQLTXPLAIN.

Confidential

Senior Oracle DBA / Production support

Responsibilities:

• Performing database backup strategies like HOT and COLD backup using RMAN
• Managing Installation and configuring Oracle RAC 10g/11g.
• Performed the Bpel node addition/removal to exiting 2 nodes to accommodate the high load.
• Supported the oracle Apex applications and performed the export and import of the applications from Dev to TEST and to PROD environments.
• Monitoring and troubleshooting the issues related to Rman backups for prod and non-prod environments.
• Performed the regularly changing the production passwords for to satisfy Sox and other compliance regulations.
• Weekly scheduled the applimation cycles to purge / archive data from production to Archive databases and resolved the failed and long running archive cycles.
• Oracle Golden Gate Installation, configuration and troubleshooting GG issues and very good Knowledge of Golden Gate implementation standards.
• Performing Database Refreshes and Database Cloning for Development, Test and Production databases.
• Installed, Migrated configured and tested Oracle 10g/11g/12c databases on various environments like Linux, Solaris, Unix etc.
• Configuring and Managed ASM disks/groups through both Grid Control and ASMCMD utility.
• Experience in project life cycle includes requirement gathering and analysis, database design and development using SQL/PLSQL and support.
• Conducting Installations of Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris and Linux Servers.
• Data modeling / Logical database design and implementation (including index design).
• Monitoring frees space in tablespaces, Archive log destination, Database/Listener availability, Blocking Locks monitoring etc.
• Worked on setting up Physical Standby Data Guard environment for Prod & non-prod databases.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Good experience in bouncing oracle applications 11i and troubleshooting concurrent manager issues.
• Applying Oracle application patches by adpatch.
• Bouncing BPEL Applications.
• Experience in BPEL Code deployments and BPEL Configuration changes.

Environment: Oracle Golden Gate, Oracle 11g/12c, Oracle 10g R1/R2, Oracle data guard, Oracle 11i Applications, JBOSS, APEX, Applimation, Service Now.

Confidential

Oracle DBA

Responsibilities:

• Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby database using Active Data Guard and Oracle Golden Gate.
• Prepare Golden Gate parameter files for Extraction and Replication and Setup Golden Gate Database User with necessary privileges.
• Worked on Upgradation of 10g database to 11g Rel2.
• Database refresh from one environment to other (Prod to UAT2).
• RAC Database and scan listener administration with srvctl.
• Administrating Database in Linux platforms.
• Applying Oracle RDBMS patches in UAT, TEST and DEV databases.
• Involved in the Database upgradation from 9.2.0.6 to 10.2.0.2.
• Performing sysadmin activities like creating database users and by setting the default temporary tablespaces, assigning roles, privileges and profile to users.
• Managing tablespaces, data files, redo logs, tables and its segments.
• Managing Users, Privileges and Roles.
• Creating public and private database links.
• Performing Code deployment.
• Administering Oracle 10g networking such as listener.ora and tnsnames.ora.
• Taking the backup of the database regularly by using RMAN, Cold and Hot Backup procedures.
• Performing RMAN backup and recovery.
• Performing Oracle 10g Data Pump Import and export utility.
• Purging unwanted log files on regular basis.

Environment: Oracle 11gRel2, Oracle 10g Rel2, OEM Grid Control