SUMMARY

• 7 + years of experience in the IT industry involving Production Database Administration.
• Oracle Database Administration experience in variety of different environments like HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation.
• Installation, configuration and Maintenance of Oracle 10g RAC/11g RAC
• Experienced in installing and setting up Oracle 11g/10g, 9i, 8i/7.3 databases.
• Worked with team to support 24/7 production environments.
• Experience with Data Modeling, Logical and Physical database design.
• Demonstrated ability to identify root causes of problems, consider both long and short-term impact of proposed solutions and develop workable solution. Ability to manage multiple project tasks with changing priorities and tight deadlines.
• Expertise in Oracle performance tunning using STATSPACK, SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, ADDM
• Effective troubleshooting of database and performance problems.
• Experience in SQL, PL/SQL.
• Proactive monitoring, identifying areas that need to be improved in the application and database.
• Management of schemas, objects & partitioning the tables & indexes.
• Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW Databases.
• Experience in Data warehousing and ETL.
• Experience in Data Migrations using oracle Transportable Tablespaces, Transportable Database, Export/Import, datapump, sqlldr.
• Experience in Benchmarking and capacity planning using oracle statspack/awr historical data analysis.
• Performed backups and tested crash recoveries using conventional Hot & Cold backups and RMAN.
• Proficient in using OEM and RMAN.
• Good Experience worked on large Environment
• Expertiese in data warehousing design and ETL Tools .
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.

Education:

• Bachelor of Technology

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3
RedHat Linux RHEL 4.x/5.x and Windows 95/98/ME/NT/2000/XP
RDBMS : Oracle8i, Oracle 9i, Oracle 10g (RAC), Oracle 11g (RAC),DB2, SQL server.
Languages : SQL, PL/SQL, C, C++, UNIX Shell
Tools : RMAN, ASM, OEM, SQL*Loader, EXP, IMP, DataPump, ERWIN, TOAD
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR,ADDM
Database Modeling: Erwin 4.0
ETL Tools : Informatica 5.1, Data stage
Other : NetApp, Veritas NetBackup, TSM, MS Office Tools
Web Tools : HTML, XML

Professional Experience:

Confidential,Kansas City, MO Mar 2010 to Present
Sr. Oracle DBA.

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation ,Configuration and Maintenance of Oracle 10g RAC/11g RAC, Stand by database
• Migration oracle databases from windows to linux.
• Database patching using opatch
• Proactive database monitoring using OEM Grid Control
• Performance monitoring and tunning using statspack, explain plan, SQL Trace, tkprof, AWR, ADDM
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 11g.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Carried out Backup and Recovery with Online (HOT) and Offline (COLD) strategy.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed Backup validations using RMAN.
• Implement Hot, Cold, Logical, Incremental (Differential, Cumilative) backup plans.
• Customization and development of Korn shell scripts.
• Data analysis in RDBMS.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using shell scripting and SQL*Loader, External Tables.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• SQL, PL/SQL Programming. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Perform other regular DBA activities including space management and performance monitoring.
• Replication using Oracle Streams, GoldenGate,
• Data Extraction,Transformation, and Loading (ETL)
• Monitor regularly whether primary and standby databases are in sync and clearing the backed up archive log files after confirming that they are applied on the standby database.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Real Application Clusters, Oracle Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.

Environment: Oracle Server 11g RAC/10g RAC /9i, SQL, PL/SQL, SQL*Loader, ASM, DataPump, HP-UX, AIX ,Sun Solaris, RedHat Linux Shell scripting.

Confidential,St. Louis, MO May 2009 to Feb 2010
Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation ,Configuration and Maintenance of Oracle 10g RAC/11g RAC, Stand by database
• Database dot release upgrades using oracle universal installer and catpatch.sql.
• Monitering the backup jobs.
• Logical and Physical database desiging.
• Provided support to Application Database Administrators in designing the database.
• Carried out Backup and Recovery with Online (HOT) strategy.
• Installed and Implemented Backup & Recovery procedures.
• Clonning the database using Cold, Hot and RMAN Backups
• Customization and development of Korn shell scripts.
• Involved in Designing Project specifications.
• Continuous Performance monitoring and tunning using statspack, explain plan, SQL Trace, TKprof, AWR
• Management of schemas, objects partitioning the tables & indexes.
• Conducting sizing & capacity planning for Oracle databases.
• Partioned large table for better performance and manageability
• Good experience working with Infastructure Team planing and assembling the severs configaration.

Environment: Oracle Server 11g RAC/10g RAC /9i, SQL, PL/SQL, SQL*Loader, ASM, DataPump, AIX ,Sun Solaris, RedHat Linux Shell scripting.

• Confidential,New York,NY Apr 2008 – Apr 2009
• Oracle DBA

Responsibilities:

• Provided 24X7 support for all the production and development databases.
• Installed and configured Oracle 10g RAC and Physical & Logical standby databases.
• Performed upgrades from Oracle 9i to 10g, 10g to 11g.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
• Applied Oracle Applications and database patches.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN .
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Customization and development of Korn shell scripts.
• Continuous monitoring of database performance during peak and non-peak loads using statspack, explain plan, SQL Trace, tkprof, AWR, ADDM

Environment: Oracle Server 11g RAC/10g RAC /9i/8i, SQL, PL/SQL, SQL*Loader, ASM, DataPump, HP-UX, AIX , RedHat Linux Shell scripting.

Confidential,Los Angeles,CA Apr 2007- Mar 2008
Oracle DBA

Responsibulities:

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 9i databases. Migrated production and development environments from Oracle 8i, Oracle 9i, Oracle 10g RAC environment. Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. performing periodic cold and hot backups.
• Database cloning done to create test and training environments.
• SQL, PL/SQL Programming. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Partitioned large tables to increase the performance and manageability.
• Written scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Analyze, design and implementation of the Database for e-commerce system.

Environment: Oracle Server 10g RAC/9i/8i, SQL, PL/SQL, SQL*Loader, ASM, DataPump, Sun Solaris, RedHat Linux.

Confidential,India Jan 2005- Mar 2007
Oracle DBA

Responsibilities:

• Installed, Configured and Administered Oracle 8i/9i/10g databases
• Responsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers with coding PL/SQL
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Monitored for unusual conditions in database against contention, load throughput and cache utilization.
• Performed Monthly Cold Backup, Daily Hot Backup. Incremental backups using RMAN.
• Testing of Backup’s and Documenting backup strategies. Created scripts for automating online daily backup
• Automating data loading from flat files using shell scripts, SQL*Loader.
• Developed Database Triggers and Stored Procedures for populating and updating data into different tables on ORACLE 8i Database Management Systems. Developed scripts for exporting and importing database.
• Dataloads using SQL*Loader
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.

Environment: Oracle 10g/9i/8i/7.3, SQL, PL/SQL, SQL*Loader, ASM, DataPump, Sun Solaris, HP-UX RedHat Linux.

Confidential,Chennai, India Dec 2003 – Jan 2005
Role : Jr. Database Administrator

Responsibilities:

• Performed installations of oracle 8i/9i and SQL Server 2000 databases.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Analyze and suggest improvements to SQL queries and statements written by others.
• Instance cloning done to create test and training environments.
• SQL, PL/SQL Programming. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database(RDBMS).
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Customization and development of shell scripts.
• Performed Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Analyze, design and implementation of the Database for e-commerce system.

Environment: Oracle 9i/8i/7.3, SQL, PL/SQL, SQL*Loader, Sun Solaris, Windows