SUMMARY

• Over Six 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.
• Experienced in installing and setting up Oracle 10g, 9i, 8i databases.
• Planned and implemented high availability solutions using Oracle 10g RAC, Oracle 11g RAC Standby Database (Oracle Data Guard).
• Worked with team to support 24/7 production environments.
• 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, Tkprof, Explain plan.
• Effective troubleshooting of database and performance problems.
• Experience in SQL, PL/SQL.
• Worked with development teams and data administration staff to enhance Database and application performance.
• Monitoring, identifying areas that need to be improved in the application and database.
• Management of schemas, objects & partitioning the tables & indexes.
• Experience in managing Very Large Oracle Databases (VLDB) which includes OLTP as well as DSS. Experience in Data warehousing and ETL
• Excellent experience in Partitioning which includes List, Range, Hash and Interval partitioning.
• Experience in administration of large Oracle databases running in SAN environment, setting up databases for bank environment.
• Exeperinece in Replication, Oracle Streams and GoldenGate.
• Proficient in Logical Database Design, Physical Database Design and Normalization.
• Experience in Data Migrations using oracle export/import, datapump, sqlldr.
• Experience in Benchmarking and capacity planning
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN.
• Proficient in using OEM and RMAN.
• Excellent experience in OLTP/DSS database systems, implementing and managing Very Large Oracle Databases (VLDB) of size multiple TB. Expertiese in data warehousing design and ETL.
• Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.

TECHNICAL SKILLS

Operating Systems:

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3
RedHat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP.

RDBMS:

Oracle8i, Oracle 9i, Oracle 10g (RAC), Oracle 11g (RAC)

Languages:

SQL, PL/SQL, Java, C, PERL, UNIX Shell

Tools :

RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, ERWIN, TOAD, Oracle Streams, Golden Gate.

Tuning Tools :

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Database Modeling :

Erwin 4.0, Rational rose

ETL Tools:

Informatica 5.1 PowerCenter 7.1/6.1 /5.1, Power Mart 6.1 /5.1

Reporting Tools :

Business Objects XI/6.x/5.x, Crystal Reports 10.X/XI

Other :

EMC, NetApp, Veritas NetBackup, TSM, HP OmniBack

Web Tools :

HTML, XML

ERP Applications :

Oracle Applications 11i

• Bachelor of Technology

Experience :

Confidential,Stamford, CT August 2011 – Present
Sr.Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle

databases.

• Performed database cloning to setup test and development database.
• Installation,Configuration and Maintenance of Oracle 10g RAC, Oracle 10g RAC Stand by

database.

• Upgraded databases from Oracle 8i, 9i to Oracle 10g, Oracle 9i, 10g to Oracle 11g
• Applied patches to Oracle RDBMS
• Cloned/Refreshed Oracle Databases for development and testing.
• 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.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Setup of recovery catalog for RMAN.
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using

RMAN.

• Set up Cronjobs to monitor file systems usage, archive logs, backup logs and cleaning up

of these file systems periodically.

• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Involved in taking Backups using Oracle RMAN (Recovery Manager) and Veritas Netbackup

as a Media Management Layer. Configured Media and Storage devices for NetBackup.
Automate RMAN backup using scripts. Defined Veritas Netbackup policies like Storage unit
and media use, backup schedules etc.

• Customization and development of Korn shell scripts.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.
• 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.

• Optimization and tuning using TRACE FILE, TKPROF, EXPLAIN PLAN,

STATSPACK, AWR, ADDM.

• 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, Oracle Advanced Replication, Real Application Clusters, Oracle
Standby Serve.

Environment: Oracle Server 11g RAC, 10g RAC/9i, SQL, PL/SQL, HP-UX 11, AIX 5.3, RedHat Linux 5.x, Shell scripting

Confidential,Pleasanton, CA Oct 2010 – July 2011
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 RAC, Stand by database.
• Proactive database monitoring using 10g grid monitoring tool.
• 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 10g.
• Applied patches to Oracle Databases and Oracle Applications.
• Oracle Applications 11i Administration and support.
• Applied Oracle Applications and database patches.
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• 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.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• 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.

• Performance Tuning using TRACE FILE, TKPROF, EXPLAIN PLAN, STATSPACK,

AWR, ADDM

• 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, Oracle Advanced Replication, Real Application Clusters, Oracle
Standby.

• Code Promotions to UAT & Production environments.
• Code review to ensure that the new customizations were developed within corporate

programming standards.

• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment: Oracle Server 11g, 10g RAC /9i, SQL, PL/SQL, HP-UX 11, Sun Solaris 9, Red Hat Linux 4.x Shell scripting

Confidential,Fort Wayne, IN Dec 2009 – Sep 2010
Oracle DBA

Responsibilities:

• Provided 24X7 support for all the production and development databases .
• Installed and configured Oracle 10g.
• Performed upgrades from Oracle 9i to 10g.
• 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.
• Cloned/Refreshed Oracle Databases and Oracle Applications.
• 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.
• 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.

• Performance Tuning using TRACE FILE, TKPROF, EXPLAIN PLAN, STATSPACK,

AWR, ADDM

• 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, Oracle Advanced Replication, Real Application Clusters, Oracle
Standby Servers.

Environment: Oracle Server 10g/9i, SQL, PL/SQL, AIX 5.2, Shell scripting

Confidential,Herndon, VA Nov 2008 – Dec 2009
Oracle DBA

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i

databases. Migrated production and development environments from Oracle 8i to Oracle 9i
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. Conducted periodic cold and hot

backups.

• Instance cloning done to create test and training environments.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for maintenance activity like analyzing tables/indexes, and monitoring their

growth rate.

Environment: Oracle Server 9i/8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting

Confidential,Hyderabad, India June 2006 - Oct 2008
Oracle Developer/DBA

Responsibilities:

• Provided support for all the databases as an operational database administrator.
• Installed and configured Oracle 8i databases.
• 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.

• 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.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Analyze, design and implementation of the Database for e-commerce system.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Proactive database monitoring using automated scripts based on v$views.
• Frequent Database audits to ensure the SOX standards were not voilated.
• Developer Environments setup using database cloning and refresh procedures.

Environment: Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting