SUMMARY

• Accomplished Oracle - certified DBA with expertise in Oracle 10g &11gR2, 12c RAC database administration, crisis management, and high availability scalable solutions to increase reliability, maximize productivity, and introduce system efficiencies.
• Experience in the design, configuration, installation and upgrades of Oracle RDBMS software and databases (version 7.x - 11g.x/12c.x). Core understanding of database design and maintenance, experience in the use of ASM architectures, backup/recovery, performance tuning using a variety of Oracle database monitoring tools and enforcing database/data security.

TECHNICAL SKILLS

Oracle Database: Oracle 7.x, 8i.x, 9i.x, 10g.x,11g.x,12c

Backup Technology: RMAN, Exports/Data Pump, Traditional Hot/Cold backup (Shells Scripts)

Replication Technology: Oracle Standby/Data Guard, Oracle 10g Streams,Oracle Golden Gate.

Languages: SQL, PL/SQL,Shell scripting (KSH,C & Bash), HTML, JSP, Perl

O/S: OEL 3.0x - 7.0, Win 2008/2012, Solaris, HP-UX 11.x, IBM AIX 6.3, RHEL, VMware, VirtualBox, Oracle VM

Database Tools: BMC Patrol, SQL Developer, OEM 12c Grid control and Quest TOAD

PROFESSIONAL EXPERIENCE

Confidential

Snr. O racle DBA

Responsibilities:

• Supported a mix of over 50+ instances of Oracle 11gR2/12c Standalone and RAC databases ranging in size between 300GB to 10TB.
• Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, Data Guard and Golden Gate replication technology. Installed, deployed and supported Oracle 11g/12c Grid infrastructure/Oracle DB RAC 11g Release 2 (ranging from 2 to 4 nodes) on OEL Linux 6.x VMware with ASM for different clients hosting Oracle 11g RAC technology stack that supports both OLTP and DSS databases.
• Configured services for load balancing and wrote scripts to automatically start and relocate services to their preferred node in an event. Periodically apply quarterly PSU, CPU, and one off security patches as well as bug fixes to Oracle 11g/10g, Oracle Golden gate11/12, ASM and RAC databases.
• Experience Upgrading Oracle 4 nodes RAC 11g - 12c RAC and Single Instance 11.2 databases to 12c database.
• Installed and configured High Availability/Disaster Recovery sites utilizing Oracle 11gR2 Active Physical Standby database/Data Guard in compliance with Oracle's Maximum Availability Architecture (MAA) using Maximum Availability & Performance modes. Managed Data Guard environment, created configuration for primary database, added standby sites, configured log transport modes and flashback features to support failover.
• Tested switch over role transition and re-instatiated standby database after a successful failover exercise.
• Install and setup of Oracle Golden Gate 11g/12c based replication for bi-directional (Active-Active), Broadcasting and unidirectional configuration in Oracle two node RAC architecture. Configure Oracle Golden Gate based replications including Classic and integrated capture. Configure extracts, pumps and replicat utility.
• Added error handler to ignore unwanted or false transaction during the Replication. Added new tables and excluded tables not required for replication. Troubleshooting complex Goldengate issues in extract and replicat abends and other Golden gate errors, WAN latency optimization and conflict resolution.
• Configured shell scripts for daily RMAN and Data pump backups. Periodically refreshed development databases for development work with production data. Implement Oracle Enterprise Manager Grid Control (11g and 12c) and agents on each monitored host to provide database monitoring, SQL Monitoring, performance tuning, monitoring of alerts and management of the databases in the environment.
• Used Grid control to generated and analyze AWR and ADDM report during tuning. Strong trouble shooting, problem solving and analytical skills and support in-house and offshore application developers with various requests.

Confidential

Snr. O racle DBA

Responsibilities:

• Tasks include support for a very large and complex 4 RAC node Oracle database environment supporting Operational Data Storage (ODS) and Enterprise Data Mart (EDM) databases. Worked with Java J2EE developers to develop and formulate capacity planning for 11g databases. Performed Installations, upgrades, deployments, PSU patching, proactive monitoring, troubleshooting and support for Oracle Grid/RAC 11g Release 2 RAC databases in a 24x7 Data Warehouse & OLTP environment on Linux 5/VMWare and AIX 6.1 with ASM. Configure Auditing on Oracle database to suite needs of security and management.
• Configure, install and maintain Oracle Enterprise Manager Cloud Control 12c environment. Configure, install, deploy and maintain Oracle Management Server (OMS), Oracle Management Repository (OMR) and OEM Agents. Setup, configured and maintained Oracle 11g R2 Physical Standby database / Dataguard for failover/switchover and successfully tested switch over role transition. Provide expertise and recommendations for, and implement, underlying storage structures and appropriate security structures
• Worked on Space Management projects using EXPDP/IMPDP, Index Rebuild on regular basis in order to avoid moving database to higher capacity box resulting in cost savings. Identify DB performance issues and supported Performance team to track and reach solution using EXPLAINPLAN, AWR & ASH. Worked on SQL Profiling to solve query performance issues. Upgrade Oracle databases from 10g to 11g for more than 100+ Production databases. Applied various patches such as CPU/PSU and Security patches. Performed recovery from Data Loss situation using internal end to end performance tracking and RMAN data recovery advisor. Provided on-call support on a rotational basis. Performed regular on-going maintenances with minimum downtime SLA.

Confidential

Snr. Oracle DBA

Responsibilities:

• Responsible for maintenance and 24x7 Support of multi-terabyte databases Oracle 10g/11g RAC in production, test and development environments hosted on Red Hat Linux 5.x servers. Setup and configured Oracle 11gR2 Grid Infrastructure and configured Oracle 11gr2 RAC Database instances. Responsible for performing Oracle database 10g & 11gR2 tasks including installation, configuration, backup, recovery using RMAN and performance tuning. Created and maintained Oracle Data-Guard configuration (primary and standby databases).
• Migrated Oracle 10gR2/11gR2 databases across OS platforms (from Solaris to AIX and HP-UX to Red Hat Linux) using RMAN transportable databases, RMAN convert database. Verified endianess and other prerequisites prior to conversion. Migrated Oracle 10g tablespaces/datafiles on Linux filesystem to Oracle 11g ASM. Created 16K blocksize tablespace in an 8K blocksize database. Configured and automated database refreshes with RMAN and datapump scripts to periodically refresh development databases for testing purpose with production data.
• Periodically applied quarterly PSU, CPU, Patch set and one off security patches as well as bug fixes to Oracle 11g/10g Clusterware, ASM and RAC databases. Installed, setup and configured Oracle Enterprise Manager Grid Control (11g and 12c) as a tool of administration to provide monitoring, performance tuning, monitoring of alerts and management of the Oracle 10g & 11g Single Node and RAC databases. Generated and Analyzed AWR and ADDM report using Grid control for system performance enhancement. Strong trouble shooting, problem solving, analytical and design skills, assisted offshore application developers with various requests. Advise on available technology alternatives, architect optimal design strategies, execute implementation and provide related ongoing support.

Confidential

Snr. Oracle DBA

Responsibilities:

• Fulfilled customer service requests for setting new Oracle databases and provided all database-related support for the production as well as test and lab databases for different markets. Installed and configured oracle 10g, 11g databases including RAC databases on Linux platforms and applied patch sets respectively on Test and Production environment. Implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases, including RAC databases on Linux platforms.
• Provided Oracle DBA implementation and support for Knonos / Oracle migrations and upgrades, including environments using Oracle 10g/11g Data Guard. Configured and provided support for Oracle Enterprise Manager Grid Control and Agents. Provide 3rd level escalation support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/Data Protector, trace analysis, service creation, cluster and system management.
• Provide after hours 24x7 database support, engineering and consulting for business customers. Engineered, implemented and supported Oracle 10g/11gR2 Meditech / Kronos environment (over 7Tb in size) to use Oracle Data Guard on Red hat Linux for over 4 years. Document and support new builds of new clusters to use Oracle 10g/11g RAC on HP-UX and Linux. Planned and executed multiple server upgrades and migrations from Oracle 9i to 10gR2, 11gR2 and coordinated capacity planning through in-depth trend analysis. Monitored space utilization and application growth, and projected database sizing.

Confidential

Snr . Oracle DBA / Streams Consultant

Responsibilities:

• Provide Oracle Database support for Confidential Well Operations & Data Management applications used for well drilling, planning and engineering projects. Installed, configured and implemented Oracle 10g R2 Streams Replication to support Confidential EMDRILL, EMWELL and WELLVIEW 8/9 applications.
• Setup the Streams Replication at schema level to capture, propagate and apply the DML, DDL changes to the replicated database. Purge the data queue by using DBMS packages available before re-sync the streams. Assisted in the design of schemas for development and test databases using ErWin/Toad etc. Developed PL/SQL error and drilling Apply Handlers for the Apply Process for WellView application Security. Configured complex capture and propagation processes and developed PL/SQL procedures to support BLOB, LONG RAW data types. Configured multiple apply processes for various critical risk and cost drilling assessment and performance analysis projects.
• Troubleshoot errors with data mismatch between a row LCR and the table for which the LCR is applying changes. Configured several internal streams (capture, propagation, apply of schema in same databases) and external streams (capture, propagation and apply and different database) for various projects. Developed Streams monitoring scripts to check status of apply, capture and propagation processes, checks for errors and display how LCR’s are currently being applied.