Summary

Over 7 years of experience in information technology which includes Oracle Database Administration and administration of UNIX and windows environments.

• Oracle Database Administration on 24x7 critical production and large databases using Oracle 10g RAC, 11g RAC, 9i, 8i.
• Implementation of High Availability solutions with Oracle 10g RAC, 11g RAC, Standby Database Data Guard for large financial applications.
• Installing and configuring ASM for the RAC storage implementation.
• Installations of Oracle 11g RAC, 10g RAC, 9i, 8i on Sun Solaris/Red Hat Linux, Oracle Enterprise Linux/HP-UX/IBM-AIX/Windows platforms and creating databases.
• Cloning database from production to test and development.
• Creating standby databases for disaster recovery and reporting purpose.
• Experience in Patching the Oracle Software and Databases.
• Upgrade/Migration of databases from Oracle 9i to 10g, 9i, 10g to 11g.
• Experience working with Export/Import, Data pump.
• Experience with Partitioned Tables.
• Working experience in OLTP and DSS environments.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup, RMAN incremental backups.)
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Experience providing 24X7 on-call support to maintain all Databases up and running in Production environment.
• Performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM.
• Replication using Oracle Golden Gate, Oracle Streams.
• Experience in capacity planning and benchmarking.
• Experience in hot/cold backup mechanisms, EMC BCV concepts
• Knowledge on Oracle Support processes for technical requests with Metal ink.
• Result oriented, self-motivated, Team player, ability to work independently.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.

Technical Skills

Databases : Oracle 8i/9i/10g RAC/11g RAC, SQL Server 2000/2005, Teradata.
Operating Systems: Red Hat Linux 4.x, 5.x, Sun Solaris 8, 9, 10,, HP-UX 10.x, 11.x,
IBM-AIX 5.1, 5.2, 5.3, Oracle Enterprise Linux, Windows
Languages : SQL, PL/SQL, UNIX Shell Scripting
Oracle Tools : RMAN, ASM, OEM Grid Control, TOAD, SQL*Loader,
Golden Gate, Streams
Hardware/Storage : EMC BCV, VERITAS Netback up, Tivoli Storage Manager (TSM)

Education

Bachelors of Technology (B.Tech) in Computer Science from Jawaharlal Nehru Technological University (JNTU)

Professional Experience

Confidential,TX Feb 2010 – Till Date
Role: Sr. Database Administrator

Responsibilities:
.

• Applying patches for both Server side and Client side.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrading of the oracle databases from 9i to 10g, 9i, 10g to 11g.
• Migrated databases from HP-UX to IBM AIX.
• Standby Database (Data Guard) setup and configuration.
• Global operations and maintaining database.
• Installation of Oracle RDBMS server software and version upgrades.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Installation, configuration and administration of Golden Gate Replication.
• Replication using Oracle Streams
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

Environnent: Oracle 10g RAC/11g RAC, OEM (Grid Control), Oracle Data guard, Golden Gate, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Data pump, SQL*Loader, Import Export, AIX, HP-UX, Sun Solaris and Red Hat.

Confidential,CA Dec 2008 – Jan 2010
Role: Database Administrator

Responsibilities:

• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Partitioning large objects to improve the performance and manageability.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK, AWR, ADDM
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environnent: Oracle 11g RAC/10g RAC/9i/8i, OEM (Grid Control), Oracle Data guard, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Data pump, SQL*Loader, Import Export, AIX, HP-UX, and Red Hat.

Confidential,MO Oct 2007 – Nov 2008
Role: Database Administrator

Responsibilities:

• Ensuring that all databases are backed up on a regular basis. Fix backup failures, address and implement resolutions.
• Conducting sizing & capacity planning for Oracle databases.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth.
• Applied patches to Oracle Database 10g,9i.
• Monitoring Growth of tables and undertaking necessary re-organization of database objects when required.
• Responsible for optimizing the queries and application tuning
• Oracle Database monitoring, troubleshooting and resolved the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environnent: Oracle 10g RAC/9i/8i, OEM (Grid Control), Oracle Datagaurd, ASM, RAC, PL/SQL, RMAN, Datapump, SQL*Loader, HP-UX, Sun Solaris, AIX, RedHat Linux.

Confidential,Hyderabad Jun 2004 – Aug 2007
Role: Oracle DBA/Developer

Responsibilities:

• 24x7 Oracle Production Database Administrations.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Working alongside programmers and contributing to the development process.
• Planning and recommendations for optimum performance.