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

Professional Experience

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

Responsibilities:

• 24x7 Oracle Production Database Administration.
• Installed, configured and maintained Oracle Databases and Applications.
• Oracle 11g/10g RAC installation, configuration and support.
• Table Partitioning, Creating Locally managed Table spaces.
• Focused on separate Partitions like data loads, index creation and rebuilding, backup/recovery.
• Worked with Materialized views.
• 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.
• Using expdp/impdp for export and import.
• Creating and maintaining Materialized Views for replication.
• Refreshing/cloning databases using RMAN.
• Created package for Online Redefinition of tables for every day column additions and conversion of tables to partitioned or non-partitioned tables.
• Working alongside programmers and contributing to the development process; Enabling and analyzing trace files for debugging issues.
• Defining and Setting backup and recovery procedures.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Partitioning large objects to improve the performance and manageability.
• Responsible for SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL , Data Guard, ASM and OEM
• Proactive monitoring of databases and applying RDBMS patches, security patches.
• Writing Shell Scripts for managing day-to-day activities.
• Usage of Partitions to improve the query performance and manageability.
• 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.

Client: Confidential, Sunnyvale, CA Dec 2008 - Jan 2010
Role: Database Administrator

Responsibilities:

• 24x7 Oracle Production Database Administration including Oracle 10g RAC
• Installed, configured and maintained Oracle Databases and Applications.
• Installing and configuring ASM.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Experience using Export/Import and Data pump for migration of databases.
• Working with Oracle 9i and 10g partitioned tables.
• Standby Database (Data Guard) setup and configuration.
• Creating and maintaining Materialized Views for replication.
• Cloning Oracle databases from Production to Development, Test
• Refreshing/cloning databases using RMAN.
• Working alongside programmers and contributing to the development process
• Defining and Setting backup and recovery procedures.
• 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.

Client: Confidential, St. Louis, MO Oct 2007 - Nov 2008
Role: Database Administrator

Responsibilities:

• Supporting production database system 24*7.
• Oracle DBA, Primary point of contact for client for production database support.
• Installation and Configuration of Oracle 10g RAC.
• Migrating Oracle databases from windows to Linux.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented Hot, Cold and Logical backup plans.
• Proactive database monitoring using 10ggrid control.
• Installation of Oracle RDBMS server software and version upgrades.
• SQL tuning using Stats pack, AWR, Explain plan, Tkprof.
• Installation, Configuration and Maintenance of Logical and Physical Standby databases.
• 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.

Client: 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.
• Extraction of data from flat files into Oracle Database using SQL*Loader.
• Defining and Setting backup and recovery procedures.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Tuning and balancing I/O by monitoring file system and table space I/O statistics.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
• Written SQL, PL/SQL functions, procedures, packages and triggers.
• Monitoring and managing the Storage Usage by Resizing Older Table spaces, Creation of New Table spaces and relocation of data files for better Disk I/O.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Optimal Space utilization in table space by avoiding fragmentation.
• Usage of Partitions to improve the query performance and manageability.
• Installation of Oracle RDBMS server software and version upgrades.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitoring of database objects like rollback segments, temp segments and table spaces.
• Automated the process of analyzing tables.

Environment: Oracle 10g/9i/8i, OEM (Grid Control), PL/SQL, RMAN, Data pump, SQL*Loader, Sun Solaris, RedHat Linux, Windows.