Oracle Database Administrator

NARESH PABBATHI Mobile: +91-789*******

Oracle DBA Email: ******.*****@*****.***

BIOGRAPHY

Having 6.6 years of Experience as Oracle Database Administrator on various versions of oracle from 9i till 12c and in all the phases of Database Management System on UNIX flavored environments like Exadata Machines, RedHat Linux, Sun Solaris, AIX, HP and Windows Servers.

EXPERTISE AREAS

1.Experienced in Installing and administrating of Oracle Standalone and RAC Databases.

2.Involvement in planned maintenance activities like Upgradations from 10g, 11g and 12c, applying Quarterly/Bug Patches in Standalone and RAC Environments.

3.Experienced in Database Backup & Recovery scenarios using RMAN and configuring Third party tool like (DDB), Used Exp/Imp, Datapump to take logical backups at Database level, Schema level and Table level.

4.Experienced in Active/Backup based Duplication, Cloning of databases, PITR of 12c CDB & PDB databases using RMAN and creating SOP Documentations.

5.Experienced in implementing and managing DataGuard configuration, using both DGMGRL and command line on Standalone and RAC environment (11g&12c).

6.Involved in the DR Drill activities on both RAC & Standalone environments using different methods based (viz., Flashback method, DGMGRL method and Normal Command line, Snapshot conversions) on the client requirement.

7.Experienced in deploying Oracle Advanced Security, including using TDE Wallets, SSL Keystores to encrypt entire tablespaces and protecting.

8.Gained strong knowledge overview on Oracle Exadata machine which helps to involve in activities.

9.Involved in configuring and administrating the Oracle GoldenGate Setup between databases.

10.Experienced in Install & Upgrade of OMS/OEM and Agents from 11g (11.1.0.1) to 12c (12.1.0.4).

11.Performance Tuning using tools/utilities by Automated Workload Repository (AWR), ADDM, explain plan, TKPROF and Statspack as well as rebuilding Indexes, checking Blocking sessions, SQL Query Tuning, finding Chained-rows and taking the appropriate action on time.

12.Worked in multiple Domains like Banking, Healthcare, Pharma and Financing with strict adherence to the predefined SLA’s in providing 24*7 remote supports for our clients.

13.Experienced in working on Remedy (Incident management / Change management) BMC Patrol.

14.Willingness to learn new technologies such as Cassandra, Couchbase, MongoDB, Postgres, MySQL,etc., openness to new ideas and ability to learn quickly as well as competence to work on own initiative as part of a team.

TECHNICAL & IT MANAGEMENT CERTIFICATIONS:

ITIL® 2011 Foundation Certified (Foundation Certificate in IT Service Management).

Oracle Database 12c Administrator Certified Associate (OCA).

SCHOLASTICS

MCA from St. Augustine PG College in the year 2011 with the aggregation of 72.5% in Hyderabad.

B.Sc. (Computers) from Gowthami Degree College in the year 2008 with the aggregation of 71.4% in Mahabubnagar.

TECHINCAL SKILLS

Operating Systems : RHEL, Sun Solaris, AIX, Windows server (2003, 2008 R2, 2012 R2)

Database : Oracle 12c/11g/10g/9i

Languages : SQL, Shell and Batch Scripting

Ticketing Tools : IMAN, Service Now (SNOW), BMC Remedy

Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM.

High Availability : RAC, Dataguard and GoldenGate

Professional experience with COGNIZANT Technologies Pvt Ltd from SEP 2014 to Till Date

Involved in working individual internal projects like configuring new databases and upgrading them as per the Application requirements. Worked on Oracle E-horizon, BMC Remedy ticketing tool.

PROJECT

Client WellsFargo and Novartis (Banking and Pharmaceutical Company)

Environment RedHat Linux, Sun Solaris, IBM Aix, Windows and Oracle 10g, 11g,12c

Designation Oracle DBA

Duration 09/2014 Till Date

Project Summary

Working as an Oracle Database Administrator for the Production Support Team containing 10 members.

Roles And Responsibilities

Performing day-to-day DBA activities including daily backup reports, Trouble-shooting, analyzing CPU load and monitoring performance affected areas.

Installing, Creating and applying latest patches for the 11g and 12c databases

Upgrading the databases from 10g to 11g as well as from 11g to 12c.

Renaming and Cloning of databases based upon requests either CDB or PDB databases.

Configuring Third Party Tool for RMAN i.e., DDB tool.

Configured OEM 12c tool for monitoring the databases by installing the agents in the respective servers.

Involved in Tablespace and User managements tasks with granting standard roles/privs, on CDB and PDB database level.

Preparing Standard Operating Procedures (SOP) for the repetitive tasks like cloning, database refresh and maintaining standard logs for patching and shift handovers.

Analyzing tables and indexes for better performance, Rebuilding Indexes/Monitoring Indexes.

Confguring Wallet on the database level (TDE /orapki) in 12c RAC databases.

Resolving issues such as Deadlocks, connection problems, runaway processes and privileges.

Working on Database, Schema, Table level refresh activities on all Boxes.

Monitoring, Troubleshooting and Administering the Oracle Golden Gate Setup and sync up.

Professional experience with iGATE Global Solutions Limited Pvt Ltd from FEB 2013 to AUG 2014

Worked as a Oracle DBA in Production Support team for the client Metropolitan Life Insurance (MetLife). Involving in BMC Ticketing tool which includes Incident management Ticket, Change management, Problem ticket having Blocking Session Request, Work on checking and compiling of invalid Objects, Monitoring the CPU usage, Monitoring Long Running queries. User account Related Issues, Tablespace management, File system space management, On request creating Objects in database, Checking Backup logs, Preparing Checklists, Deploying the Scripts, Generating AWR reports as per requested baselines.

PROJECT

Client Metropolitan Life Insurance (MetLife - Health Insurance)

Environment AIX Oracle 10g, 11g

Designation Oracle DBA

Duration 02/2013 08/2014

Project Summary

Worked as an Oracle Database Administrator for the Production Support Team containing 24 members.

Roles And Responsibilities

Configuring DGMGRL for the databases for DR Test activity like Switch over and Switch back using flashback, dgmgrl and normal method.

Capacity Planning and monitoring the database growth on the basis of periodic reports.

Allocating system storage & planning for future storage requirements of the database.

Performing day-to-day DBA activities including daily health checks, database backups, Trouble-shooting, analyzing CPU load and monitoring performance affected areas.

Upgrading the databases from 10g to 11g as well as Degrading from 11g to 10g.

Working in 24/7 environment in shifts.

Generation and analyzing AWR, ADDM and STATSPACK report.

Creation of tablespaces, Adding and resizing datafiles as per requirements.

Preparing Standard Operating Procedures (SOP) for the repetitive tasks like cloning, database refresh and maintaining standard logs for patching and shift handovers.

Installing Oracle Binaries, OEM agent on all boxes, creating databases and refreshing the data.

Analyzing tables and indexes for better performance, Rebuilding Indexes/Monitoring Indexes.

Gathering statistics of database on weekly basis.

Resolving issues such as Deadlocks, connection problems, runaway processes and privileges.

Co-ordination with all primary DBA's to work upon the efforts of the team putting at the right track to gain the better performance

Schema refresh activities from Prod to Dev, Test databases

DECLARATION

I hereby declare that all the details furnished above are true to the best of my knowledge and belief.

(Naresh Pabbathi)

Contact this candidate