SUMMARY:

• Senior Oracle DBA with more than 20 years of progressive professional experience with Oracle Database Technologies.
• Extensive experience in Installing, Upgrading, Patching, Managing and Tuning Oracle Database 12c CDB/PDB, 11gR1, 11gR2, 10gR1, 10gR2, 9i, 8i and 7.x.
• Best practices for Oracle Database Infrastructure, Standards and Implementation.
• Implementation of best case scenarios for enterprise wide Database backup/recovery solution analyzing the specific business needs and optimizing the use of existing infrastructure
• Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise.Implement enterprise wide Database Development standards to eliminate time on Database tuning.
• Data Guard setup with Primary and Standby Databases. Both high performance and high redundancy.
• Worked on replication tool Golden Gate on oracle 11g and for a short period on 12c
• Strong Oracle RAC Installation, Configuration and Tuning Skills on Red - Hat Linux and Sun Solaris and HP.
• Implementation of Grid Control.
• Worked on Exadata Full/Half RAC (X5 & X4).
• Implement and Configure RMAN backup. Recover and Clone database using duplicating/cloning procedure with point-in-time recovery option.
• Strong sql/plsql skills to perform the data base operations.
• Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
• Physical database design, Logical database design, normalization, de-normalization
• Database security and auditing. Data capture using Streams.
• Setup procedure for Database statistics gathering Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Collections of performance data for specific time range using AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, SQL Trace.
• Analysis of Database Wait Events.
• Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan.
• Plan optimization applying corrective measures including code restructuring, identifying potential index issues and effective implementation of uniform coding structure to avoid optimizer re-parsing.
• Setting up Enterprise Manager notification procedures, who gets what notification, monitoring frequency, threshold limits for process memory, disk usages etc.
• Database trigger, stored procedure & packages PL/SQL coding.
• Excellent written and verbal communication skills.
• Result oriented, Self motivated, Team Player, Ability to work independently.

TECHNICAL SKILLS:

Operating System: SUN Solaris, HP-UX, AIX,, Linux

Database and Tools: Oracle7x, Oracle 8, Oracle 8i, Oracle 9i, 10G, 11gR1, 11gR2. ASM and RAC, Exadata SQL, PL/SQL, BMC Patrol, OEM, Grid, SQL*Backtrack, RMAN, EMC, 3PAR, Veritas Clustering, Raw disks, OPS, Partitioning, Server level SQL level performance tuning and capacity planning

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

Joined as Sr.Oracle DBA. Over 15 team members, Played major roll in patching and upgrading databases from 11g to 12c and moved the databases to VMs. Primary DBA for over 5 major applications Including RAC/ Exadata, Dataguard and all PEGA application. Diagnosed lots of performance issue, and came out with right fix to eliminate all major performance issue. Installed and configured RAC over physical and VM servers, and configured Data Guard for multiple databases. Created multiple 12c Normal and container databases. Added both List and Range partitions for over 50 tables for future use across various databases. Created and modified various instillation, upgrade and patching documents. Handled over 80TB databases on Exadata servers.

Confidential, Atlanta GA

Sr. Oracle DBA

My Responsibilities:

• Supported developers in tuning SQL’s and application for optimal performance.
• Played a major roll in upgrading all the PEGA applications from 6.x to 7.x
• Analyzing AWR reports on daily basis for optimal performance.
• Monitor Objects growth and provide DB capacity planning for application expansions.
• Designed and implemented daily database monitoring check list for all the databases.
• Troubleshoot and fixed the site wise major performance problem.

Confidential, Atlanta, GA

Sr. Oracle DBA

My Responsibilities:

• Install, configure, and upgrade software: CRS, ASM, Oracle binaries & Patches.
• Creating and managing the production databases in various platforms.
• Preparing logical and physical Backup strategies.
• Supporting 24x7 production system
• Performed Archiving of old data from the production databases.
• Database and application process error tracking and fixing up the production problems.

Confidential, Duluth, GA

Sr. Oracle DBA

My Responsibilities:

• Part of 24X7 On call support rotation Team
• Tuned various SQL’s
• Supported Many PeopleSoft databases sizes up to 2TB
• Installed various oracle databases in Sunsolaris platforms
• Migrated few databases from AIX to sun zoned env

Confidential, Norcross, GA

Sr. Oracle DBA

My Responsibilities:

• Created some 10g databases in Linux Env
• Involved with other team members across nation and supported various databases.
• Restored some critical databases during some unfrozen situations.
• Troubleshoot and fixed various customer issues

Confidential, Atlanta, Georgia

Senior DBA (Contractor)

My Responsibilities:

• Installed oracle 10g
• Created 4 database for Different applications.
• Installed 10g RAC on linux in a 2 node coluster.
• Supporting Documentum Developers in installing)

Confidential, Atlanta, Georgia

Senior DBA

My Responsibilities:

• DBA for GPS databases which monitors over 17000 service vehicles for Bellsouth.
• Support over 1tb size databases.
• Planned and successfully implemented more than 6 Production migrations to Sun-E10K/EMC environments.
• Support People soft / CRM / Siebel applications with Oracle as back-end.
• Implemented table and index Partitions for Datawarehouse application.
• Have done lots of performance tuning from analyzing Application SQLs, UNIX Kernel, Oracle Init.ora to I/O Sub-systems on EMC DMX, Sun Stoeredge, HP Auto-Raid
• Revamped all batch processes of a Channel and Territory management application for performance and manageability.
• Introduced centralized monitoring system for all the production databases.
• Have done very critical recoveries of large-scale complex applications including Tablespace level and datafile level.
• Lead DBA with the BellSouth Phoenix Project; total budget $80-90M; a relative large initiative of the company’s full complement of core financial applications in an ORACLE 7-PeopleSoft-HP-UX environment. Managed over 70 databases (some 50-200 GB) across many PeopleSoft apps (PS AM/PA/FS/AP); provided strategic support to the Technical Infrastructure team with strong emphasis on performance tuning during stress & volume testing.
• Implemented seamless cloning as well as Oracle replication across all PeopleSoft instances.
• Architect DR solutions for PeopleSoft database as well as a comprehensive capacity Reporting & Planning
• Implemented EMC BCV solutions for Reporting and DR refresh