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 shell scripting and documentation.
• 24x7 production oracle database support.
• Configuration, Supported, troubleshooting OLAP and OLTP RAC and Non - RAC databases 10g/11G versions.
• Install, configure 12CR1,12cR2 and performed database migration.
• Configure Physical Standby for 12C Production databases.
• Implementing SQL Profiles using SQL tuning Advisor reports.
• Migration of SQL Profiles.
• Duplicate target database using Rman Active Database.
• Redirect on-premises RMAN Backup directly to AWS S3 Bucket.
• Validate database for block corruptions.
• Performed database upgrades from 9i/10G/11G to 12CR2.
• Create Backup, Restore Scenarios documents for reference.
• 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 (12C/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 and 11GR2 to 12C.
• Installed and configure the GRID CONTROL SERVER on 11G/12C/13C.
• Expertise in database upgrades from 9i to 10g,11g and 12C.
• 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 and 12C 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:

HP: UX 10.x, 11.x, Solaris 8, 10, AIX 5.3, 6.1, RHEL 4, 5,6, Windows 2000/2003,Oracle Enterprise Linux

RDBMS: Oracle 12C/11g/10g/9i/8i, Postgres SQL,Vertica

Languages: SQL,UNIX Shell Scripting

Tools: RMAN, ASM, OEM 10/11/12/13c, SQL*Loader, EXP, IMP, Expdp, Impdp,DBVerify,Dbca,Asmca,Dbua,Srvctl,Crsctl

Backup Tools: - EMC-Networker,AWS Secure Backup to S3

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Sr.OracleDBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Duplicate databases using RMAN Active Database commands.
• Patching and monitoring EBS,Demantra and soa large databases.
• Migration of 9i/10/11g databases to 12C using Golden Gate and EXPDP/IMPDP utility.
• Installed and configure 12C database for Pre-Production on Oracle Enterprise Linux 6.
• SQL Profiles implementation for sql query performance improvements.
• Migration of SQL Profiles.
• Installed and implemented 12 Oracle Internet Directory for tnsentry Repository.
• Migration of RMAN Catalog Clients to higher RMAN Versions.
• Upgrade RMAN Catalog Schemas.
• Performing Dev/Test/Stage Cloneing activity using Active RMAN clone and RMAN backups from Production.
• Performed 9i,10G,11G to 12C database migration.
• Apply Critical Patches and PSU’s on 11g and 12C.
• POC on RMAN on-premises backups directly to AWS S3 Buckets.
• Reclaim un-used space using table on-line redefinition for clob and blob tables.
• 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.
• 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.
• Handling day-to-day activities.

Environment: Oracle Server 12C/11g/10g/9i/8i, Red Hat UNIX, HP Linux, AIX, Oracle Enterprise Linux 5, 6, 7

Confidential

Sr. Oracle DBA

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.
• Configured Physical DataGuard for Disaster Recovery.
• Performed Cross Platform Migration of 10TB RAC database from Unix (10G) to AIX standalone (11GR2) using Golden Gate Replication.
• Performed 10G to 11G upgrade of Standalone and OLTP and OLAP RAC databases.
• Participated in Data-Center Fail-over exercise.
• Configure and troubleshoot Net App Snapshot Backups for RAC and 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.