SKILLS SUMMARY

• Results - driven Oracle Certified Database Administrator with over 8 years of hands-on experience in the daily administration of production Oracle 10g, 11g, 12c databases in Oracle Cloud as well as AWS. Installation and configuration of both standalone and Oracle Real Application Cluster (RAC) databases, database migration and refresh using Oracle Data Pump, Oracle database replication using Oracle Data Guard for Disaster recovery and Golden Gate for real time data replication and Oracle 12c Cloud Control OEM configuration and monitor.
• Responsible for patching, upgrade, database troubleshooting and supporting development effort with regards to production deployment releases, database schema refreshes.
• Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
• Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
• Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF, AWR, ADDM and OEM.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Technical Lead DBA

Responsibilities:

• Administer Oracle databases and MS sql server databases on AWS cloud
• Use Bitbucket and Gitlab source control. Database deployment using Visual Studio SQL Server Data Tools
• Extensive experience working with business intelligence and data warehousing tools, includingMicrosoftSQLServer2008-R2, 2012 RDBMS, Integration Services (SSIS) and Reporting Services (SSRS).
• Involved in Real Application Cluster (RAC) administration including 10g, 11g and 12c Database cloning, tuning, patching and monitoring concurrent manager processing, etc.
• Use Oracle OEM CLOUD 12c to monitor multiple databases across heterogeneous platforms
• Monitoring and Troubleshooting GoldenGate Replication issues. Utilize all of the existing GoldenGate tools, such as GGSCI and Logdump, the health check scripts and the Streams Performance Advisor (UTL SPADV) to troubleshoot system issues occurring to both classic extract/replicat and integrated extract/replicate.
• Wrote several shell scripts for checking Oracle errors in alert file and database backup log files.
• Cloning of application Schema from production environment to test environment and applying of patches (CPU and PSU)
• Creating users with restricted access, with default and temporary table spaces.
• Creating different kinds of partitions on tables and indexes.
• Expertise in performance-tuning using SQL tuning advisor with EXPLAINS PLAN, TKPROF, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance
• Creating profiles, roles and granting to users based on their group requirements.
• Sizing SGA, sizing database buffers, shared SQL area, log buffer based on requirements.
• Oracle Export, Import, SQL*Loader and data pump utilities.
• Installed and configured Oracle 10g, 10g RAC on Linux & RHEL.
• Estimate growth of database size by detail analysis of company's future policies and generating reports for management to act in advance.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.).

Confidential, Irving, TX

Oracle DBA Prod Support

Responsibilities:

• Involve in 24x7 on-call support for production databases
• Administer and monitor databases running on Exadata machine using OEM 12c, ExaChk, CellCLI and DCLI and running Health check
• Automate, developed and maintained UNIX shell scripts to collect and monitor database metrics and Produces Database health reports Using AUTOSYS.
• Use ServiceNow for Incident Managementto restore normal service operation as quickly as possible while minimizing impact to business operations and ensuring quality is maintained.
• Utilized Grid Control 12C OEM to administer multi-node RAC database also managed redo and undo in RAC environment. Load balancing of RAC instances.
• Monitoring space, wait events, locks and long operations running on database.
• Implemented Golden Gate Replication. GoldenGate Unidirectional and Bidirectional replication.
• Perform Primary/Standby database switchover/failover using DataGuard Broker.
• Supported Oracle Financial Services Lending and Leasing (OFSLL) application.
• Monitoring database for growth and added space to table spaces as per demand.
• Generating AWR reports on regular basis to identify database performance at peak load.
• Tuning SQL statement by analyzing explains plan and ADDM reports.
• Upgrade/Migration of databases from Oracle 10 to 11g, 12.1 to 12.2 cross platform migration.
• Experienced in using 10g and 11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Control Monitoring and Recycle Bin.
• Upgraded Oracle 10g to Oracle 11g R2 and 12.1 to 12.2 database version.
• Documented Standard Operation Procedures (SOP) for peers to follow.
• Applying upgrade patch, maintenance and interim (Opatch) patches on all databases.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$ views, DBA views and Data Modeling, Logical and Physical databases design using tools like Erwin and Visio.
• Refreshing Dev and Test instances with data from Production on regular basis using Datapump and RMAN Duplicate.
• Wrote RMAN scripts for Backup of databases (Full, incremental and cumulative), maintenance of archive logs for databases.

Confidential, White Plains, NY

Oracle Database Administrator

Responsibilities:

• Installing Oracle EM 12C and Oracle Management Agent, management Service and Management Repository.
• Deploy Agents to Host and register targets to be monitor using OEM 12c.
• Responsible for installing and configuring Oracle OEM CLOUD 12c to monitor multiple databases across heterogeneous platforms.
• Installed Management Agent OMA.
• Responsible for DataCenter Migration from old Datacenter to new datacenter.
• Migrated and upgraded single instance database to multiple instance databases using export/import, datapump, Transportable Tablespace and RMAN.
• Configure Data Guard on both standby and primary for 45 production databases.
• Performance Tuning, i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Upgraded the Databases from Oracle 10g to 11g and 12cR1to 12cR2and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage.
• Utilizing Shell Scripts to automate my nightly jobs on CRONTAB.
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot.
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability.
• Experienced with SRVCTL, OCR and Voting Disk of 11g RAC.
• Handled RAC Node hangs and node eviction issues.

Confidential, Evansville, IN

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 12c Golden Gate for Real-Time Data Integration and Heterogeneous Database Replication for zero down time and continuous availability.
• Involve in 24x7 on-call support for production databases using Oracle 12c Cloud Control for Alert Monitoring and Notification.
• Upgrade databases from11.2.0.4 to 12.1.
• Configured DataGuard and Broker for administration of seamless switchovers.
• Upgrade GI and DBs from 11g to 12c with physical standby DBs in place.
• Utilized SPM SQL Baselines, SQL Profiles and SQL Tuning Advisor for troubleshooting and providing tuning recommendations to application teams.
• Generated and analyzed EXPLAIN PLAN, SQL*TRACE, TKPROF trace files to identify root cause of SQL performance issues.
• Analyzed AWR, ASH and ADDM reports and draw conclusions that aid in troubleshooting performance issues.
• Applied upgrade patch, maintenance and interim (opatch) patches on all databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Monitoring and troubleshooting GoldenGate Replication issues.
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating switched over services.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

Confidential, Columbus, IN

Oracle Production Support Database Administrator

Responsibilities:

• Installed, setup and configured Oracle version 10g, 11g and 12c Release2 64 Bit on RHEL, Solaris 10 and HP-UX11.
• Migrating from Oracle 10g Sun Solaris 10 to Oracle 11g SUSE Linux (SLES) 10.
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose.
• Perform planned switchover and failover to physical standby database with and without Data Guard Broker to verify availability status.
• Refresh Test/Dev/QAT/Training/Sandbox environment from Production for Apps Team using Datapump and Rman Duplicate
• Regularly applying all CPU & PSU Patches to All Oracle Databases using Opatch
• Creating and monitoring SR with Oracle Support.
• Tuned parameters for a large monthly SQL*Loader job resulting in 90% reduction of operation time.
• Working with Materialized views with Query Rewrite, Bitmapped Indexes, etc.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.