oracle DBA

Abhijit Reddy Puli

********.****@*****.*** 616-***-****

Database administrator with extensive experience in installation, configuration, upgrades and

migrations of Oracle 9i,10g and 11g databases on Unix, Linux and Windows platforms. Proficient in

trouble shooting and performance tuning of the databases. Worked extensively with rman backups,

data guard, golden gate and data pump. Areas of expertise include:

Oracle 9i/10g/11g,12c database administration/installation

Oracle RAC and ASM administration/installation

Upgrades

Migrations

Data Pump/ Export Import

Backup/Recovery using RMAN/SQL Backtrack

Data guard

Oracle database capacity planning, storage allocation

Golden Gate

Performance tuning using AWR,ADDM,V$ views and other tools

SQL Tuning

24x7 DBA support for production databases

TECHNICAL SKILLS

Languages

SQL, PL/SQL

Database

Oracle 9i,10g, 11g, 12c Enterprise/ Standard Edition

Backup Recovery Tools

SQL Backtrack, RMAN, Flashback, DDBoost

Development &

Administration Tools

Oracle Enterprise Manager, OEM 12C, Toad, SQL Developer,

SQL Plus, HP Service Center, Service Now, Benthic Golden

Utilities

SQL Loader, Export / Import, Data Pump, Golden Gate, Oracle

Data Guard

Operating Systems

Linux, Unix, Solaris, Windows

CERTIFICATIONS

Oracle Certified professional (OCP) – Oracle 10g Database Administrator

PROFESSIONAL EXPERIENCE

Thermo Fisher Scientific, Pittsburgh, PA Oct 2016 – Till Date

Role: Oracle DBA

Key Contributions:

Working on Oracle 10g, 11g and 12c databases

Provide 24x7 support to multi node RAC databases

Installed 12c multitenant on lab environment for testing

Upgraded 10g/11g databases to 12c lab environment and converted them to pluggable databases.

Plugging and unplugging databases from container.

Performance tuning of the databases using: OEM, OEM12C, Toad, AWR, ASH, SQLT, DBMS stats, explain plan

Setup, administer and maintain data guard on oracle databases

Perform backup and recovery techniques using RMAN

Perform database refreshes using datapump, export import

Regular DBA activities of Space Management and Performance Monitoring

Environment: Oracle 12C, 11g, 10g, Linux/Unix, Toad, OEM, OEM 12C, Golden Gate, Tera Term, Putty, SQL Developer, RMAN

HCL, Client: FedEx, Pittsburgh, PA June 2013 – Sep 2016

Role: Oracle DBA

Key Contributions:

24x7 support for 2,4 and 8 Node production and non-production databases

Installation of Grid Control and creation of 10g and 11g databases with ASM for Testing, Development and Production

Performance tuning of the oracle databases using the following tools/utilities: OEM, OEM 12C, AWR, ASH, Explain plan, ADDM, tkprof, DBMS stats

Oracle 10g/11g Physical and logical Data guard installation and maintenance

Performed Data Guard switchover/failover as per the requirements

Experience in Backup and Recovery techniques using RMAN

Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option

Convert all databases to use ddboost for backups

Use Expdp/Impdp, Data Pump utility to perform data refresh

Configuration, Administration and tuning of Golden Gate

Monitor Golden Gate processes and GG cleanup scripts function properly

Patch Set Update (PSU) installation, Critical Patch Update (CPU) installation

Regular DBA activities of Space Management and Performance Monitoring

Environment: Oracle 11g, Oracle 10g, Linux, UNIX, Windows, Toad, OEM, Golden Gate, OEM 12C,

Tera Term, SQL, Developer, SQL*Plus, RMAN, DB Artisan

FEDEX, Pittsburgh, PA March 2012 – June 2013

Role: Oracle DBA

Key Contributions:

Providing production support for 24X7 database availability for Oracle Database

Worked on 2,4 and 8 node RAC databases with volumes up to 2.5TB

Continuous performance monitoring and tuning of the databases and application using OEM, AWR, ASH, Explain plan, ADDM, tkprof, DBMS stats

Migration of Oracle on Unix to Oracle on VM

Migration from SQL Backtrack to RMAN as backup utility

Convert the databases to use Data Domain

Oracle active data guard installation and maintenance

Performed Data Guard switchover/failover as per the requirements

Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option

Use expdp/impdp, Data Pump utility to perform data refresh

Configuration, administration and tuning of Golden Gate

Regular DBA activities of Space Management and Performance Monitoring

Environment: Oracle 11g, Oracle 10g, Linux, UNIX, Windows, Toad, OEM, Golden Gate, OEM 12C,

Tera Term, SQL, Developer, SQL*Plus, RMAN, DB Artisan

WellPoint, Richmond, VA June 2010 – Feb 2012

Role: Oracle DBA

Key Contributions:

Providing production support for 24X7 database availability for Oracle Database

Performed Database migration from Oracle 10g to 11g

Partitioning of large tables for fine tuning performance, tuning the application using OEM, AWR, ASH, Explain plan, ADDM, tkprof

Assisted developers in tuning SQL statements in the applications

Perform database refreshes using expdp/impdp, Data Pump

Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option

Carried out the setting up of RMAN back up schedules of databases

Configured and managed physical standby database using data guard for critical production databases

Patch Set Update (PSU) installation

Critical Patch Update (CPU) installation

Environment: SQL*Loader, SQL*Plus, Oracle 10g/11g, Oracle Enterprise Manager, Golden Gate,

PL/SQL, RMAN, Linux

Zion’s Bank, Salt Lake City, Utah April 2008 – May 2010

Role: Oracle DBA

Key Contributions:

Created test databases from the production environment as per development team requirement for testing purposes

Performed database backup and recovery using Oracle Recovery Manager and UNIX Shell scripts

Performed cold and hot backups of database on a regular basis

Tuned the performance of the SQL’s using AWR reports, stats and OEM

Interacted with user for troubleshooting problems with database performance and SQL query tuning

Maintained database security by managing user’s roles, privileges and auditing users

Coordinated with System administrators, application developers for various activities

Generated working documentation for the DBA team use

Environment: SQL*Loader, SQL*Plus, Oracle 10g/11g, Oracle Enterprise Manager, PL/SQL,

RMAN, Linux

EDUCATIONAL QUALIFICATIONS

Bachelors of Engineering in India

Contact this candidate