SUMMARY

• Over 8+ years of experience as an Oracle Database Administrator having experience in the database administration, production support, installation, configuration, upgrades, patches, data guard, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix Confidential scripting and documentation.
• 24x7 production oracle database support.
• Troubleshoot and maintain 8 node 10G and 11GR2 RAC Production and Development Clusters.
• Oracle Database Administration experience in variety of different environments like Sun Solaris, AIX, Linux, HP - Unix and Windows.
• Worked with Oracle Databases (11g/10g/9i/8i) on Unix/Windows platforms.
• Installation, Configuration, Troubleshooting Golden Gate Replication for Oracle-to-Oracle.
• Migration of Database using Golden Gate technology 10G to 11GR2.
• Installed and configure the GRID CONTROL SERVER on 11G/12C.
• Expertise in database upgrades from 9i to 10g and 11g.
• Expertise in installation, configuration of DataGuard both in standalone/RAC in both 10g/11g.
• Planned and implemented high availability solutions using Oracle 10g/11g RAC/Standby DataGuard.
• Experience in database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Expertise in using 10g, 11g features like Data Pump, Flash-Back Recovery, ASM, AWR, ADDM and Active DataGuard.
• Apply CPU patches and BUG patches on the database.
• Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Proactive monitoring, identifying areas that need to be improved in the application and database
• Good experience in Logical and Physical Database Design, Backup and Recovery procedures.
• Proven ability to adapt to demanding schedules and changing priorities
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Solaris 8, 10, AIX 5.3, 6.1, RHEL 4, 5,6, Windows NT/XP/2000/2003

RDBMS: Oracle 11g/10g/9i

Languages: SQL, PL/SQL, UNIX Confidential Scripting

Tools: RMAN, ASM, OEM, SQL*Loader, EXP, IMP, Expdp, Impdp, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Sr.Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Apply Critical Patches and PSU’s on 11gR1/11gR2.
• Refresh databases from Prod to Test and Cert environments for performance testing.
• 12C Grid Server and applied latest bundle patch to plugins.
• Setting Monitoring templates in OEM 11G/12C.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Configured ASM disk groups to store Data files, redolog files, and control files.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Taking RMAN Backups on scheduled time and monitoring scheduled Backups
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Performed partitioning of tables, indexes to improve the Sql performance and oracle maintenance.
• Implemented range, list and hash sub partitions.
• Creating and refreshing materialized views for better performance.
• Creating and dropping of users, granting and revoking rights as and when required.
• Cloning databases and Disaster Recovery Database.
• Expertise in refreshing database for the development and test purpose.
• Expertise in Duplicating the database using the RMAN Duplicate commend.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Expertise in AWR, ADDM ASH reports for performance monitor and tuning.
• Diagnose and troubleshoot Database problems and failures
• Monitoring of database for growth and performance.
• Ensuring proper online and offline backup. Periodical checking backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Handling day-to-day activities

Environment: Oracle Server 11g/10g, Red Hat UNIX, HP Linux

Sr. Oracle DBA

Confidential, Houston, TX

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Creating,maintaince of databases in 8 Node Oracle 11gR2 RAC.
• Cloning Test/Development database from Production database using Net App Snap Shot Technology.
• Migration of RAC databases from 10G 8 Node RAC Cluster to 11G 8 Node RAC cluster using Net App Snap Shot.
• Performed Cross Platform Migration of 10TB RAC database from Unix(10G) to AIX standlone(11GR2) using Golden Gate Replication.
• Performed 10G to 11G upgrade of Standalone and RAC databases.
• Participated in Data-Center Fail-over excersise.
• Configure and troubleshoot Net App Snapshot Backups for RAC aand Non RAC databases.
• Analyze alert Log and User trace Files and Diagnosing the Problem.
• Providing Solutions to the problem paced by end users or programmers.
• Scheduling jobs through Oracle job Scheduler.
• Providing Solutions to the problem paced by end users or programmers.
• Automation of Startup Shutdown on database servers.
• Developed scripts for Health Check of Databases, Analyzing of Tables, Cold Backups, ASM reports and ASM metadata backups.
• Pull AWR, ADDM ASH reports for performance monitor and tuning.

Confidential, Phoenix, AZ

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Experience in setup and maintenance of a 2 Node Oracle 11gR2 RAC.
• Running RAC CHECK UTILITY for RAC servers.
• Implemented OS Watch scripts on Oracle servers for monitoring logs.
• Upgrade databases from 10.2.x to 11.2.0.3 on Linux platforms.
• Apply Critical Patches and PSU’s on 11gR1/11gR2.
• Refresh databases from Prod to Test and Cert environments for performance testing.
• Installed and Implemented 12C Grid Server and applied latest bundle patch to plugins.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Configured ASM disk groups to store Data files, redolog files, and control files.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Involved in developing a disaster recovery plan.
• Periodic Index maintenance to avoid performance issues due to fragmentation.
• Conducting sizing & capacity planning for Oracle databases.
• Work closely with System Administrators regarding database storage and hardware requirements.
• Analyze alert Log and User trace Files and Diagnosing the Problem.
• Scheduling jobs through Oracle job Scheduler.
• Providing Solutions to the problem paced by end users or programmers.
• Automation of Startup Shutdown on database servers.
• Refreshing Dev/Test database from Prod using RMAN duplicate, Import/Export commands.

Environment: Oracle Server 11g/10g/9i, RedHat Linux 4.x, 5.x, 6.x,AIX 6

Confidential, NH

Sr. Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Involved in migration of 9i database from HP-Unix to 10g IBM AIX servers.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Refresh databases from Prod to Test and Dev environments for Application testing using RMAN.
• Performed daily maintance and user requests.
• Applied Patches 10.2.0.3 to 10.2.0.5 to ASM, CRS, DATABASE home on 2-node RAC.
• Installed 11gR2 for Production environment on 2-node RAC.
• Installed and configure the 11g GRID server.
• Implementation of Logical standby database for reporting purpose on 10g/11g.
• Implementation and maintained Physical Standby for DR Senario.
• Installed the grid control agents in the RAC and Non-Rac database for monitoring.
• Applied bug Patches on the grid Control servers.
• Configure the RAC database, ASM instances in the grid servers.
• Implemented Confidential scripts to Purge the log,trace,trim,audit files on Prod,Dev servers.
• Continuous Performance monitoring and Tuning of the databases and application using OEM, AWR, ASH, ADDM etc
• Performed partitioning of tables, indexes to improve the Sql performance and oracle maintenance.
• Implemented range, list and hash sub partitions.
• Creating and refreshing materialized views for better performance.
• Analyze alert Log and User trace Files and Diagnosing the Problem.
• Providing Solutions to the problem paced by end users or programmers.
• Scheduling jobs through Oracle job Scheduler.
• Providing Solutions to the problem paced by end users or programmers.
• Automation of Startup Shutdown on database servers.
• Developed scripts for Health Check of Databases, Analyzing of Tables, Cold Backups, ASM reports and ASM metadata backups.
• Pull AWR, ADDM ASH reports for performance monitor and tuning.
• Perform node deletion in 3-node RAC database server.

Environment: Oracle Server 11g/10g/9i, SQL, AIX 5,6, RedHat Linux 5.x

Confidential, Littlerock, Arkansas

Sr. Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Experience in setup and maintenance of a 2 Node Oracle 11g RAC.
• Upgrade databases from 10.2.x to 11.2.0.1 on Linux and Solaris platforms.
• Apply Critical Patches and PSU’s on a periodic basis as a proactive measure to avoid any critical bugs and maintain security compliance.
• Refresh databases from Prod to Test and Pre-Prod environments for performance testing.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Configured ASM disk groups to store Data files, redolog files, and control files.
• Recover/Cloned the database from ASM to ASM, ASM to File System, File System to ASM using RMAN duplicate command.
• Involved in a Cross Platform migration of database from windows to UNIX using RMAN.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Setup of Standby database for faster disaster recovery and DataGuard setup for high availability.
• Involved in developing a disaster recovery plan.
• Periodic Index maintenance to avoid performance issues due to fragmentation.
• Conducting sizing & capacity planning for Oracle databases.
• Work closely with System Administrators regarding database storage and hardware requirements.
• Analyze alert Log and User trace Files and Diagnosing the Problem.
• Scheduling jobs through Oracle job Scheduler.
• Providing Solutions to the problem paced by end users or programmers.
• Automation of Startup Shutdown on database servers.
• Developed scripts for Health Check of Databases, Analyzing of Tables, Cold Backups, ASM reports and ASM metadata backups.

Environment: Oracle Server 11g/10g, SQL, PL/SQL, Sun Solaris 10, RedHat Linux 5.x

Confidential

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Designing the logical and physical database structure.
• Designing the security and database access strategies.
• Expertise in Install,configure of 10g.
• Expertise in install, configure ASM Disk Groups.
• Experience in setup and maintenance of a 2 Node Oracle 10g RAC.
• Upgrade Databases from 9i to 10.2.x.
• Experience in patch upgrade from 10.2.x to 10.4.x.
• Logical and Physical data modeling.
• Enforcing the Null and check constraints.
• Taking RMAN Backups on scheduled time and monitoring scheduled Backups
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Performed partitioning of tables, indexes to improve the Sql performance and oracle maintenance.
• Implemented range, list and hash sub partitions.
• Creating and refreshing materialized views for better performance.
• Creating and dropping of users, granting and revoking rights as and when required.
• Cloning databases and Disaster Recovery Database.
• Expertise in refreshing database for the development and test purpose.
• Expertise in Duplicating the database using the RMAN Duplicate commend.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Expertise in AWR, ADDM ASH reports for performance monitor and tuning.
• Diagnose and troubleshoot Database problems and failures
• Monitoring of database for growth and performance.
• Ensuring proper online and offline backup. Periodical checking backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Handling day-to-day activities

Environment: Oracle Server 10g/9i, SQL, PL/SQL, AIX 5.3, Confidential scripting