SUMMARY:

• Over 8 years of strong experience in Oracle database administration in heterogeneous system environment including Linux, Solaris, UNIX, and Windows, supporting a variety of mission critical applications on Oracle 12C, 11g and 10g.
• Experience creating Oracle Dataguard on Oracle Database Appliance
• Expert working knowledge of 12C, 11G, 10G, databases on Linux, Windows and Solaris operating systems.
• Performing complete and incomplete recovery during disasters, failures and user errors.
• Monitoring Day - to-Day Backups, Logs & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the incremental and cumulative backups using RMAN.
• Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility
• Managing Users and Resources, Granting and revoking privileges through Roles.
• Cloning of production databases as needed for testing and development using RMAN or scripts.
• Troubleshoot and resolved locking and concurrency issues, Excessive parsing, resource bottleneck (including memory and CPU bottlenecks) and recommending a solution
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
• Deployed Standby databases using Data Guard on Oracle 11G, 12.1.0.2, 12.2.0.1 (Maximum Performance, Maximum Availability, and Maximum Protection).
• Installed and maintained Real Application Clusters (RAC)
• Experience as On-Call 24x7 production DBA support development DBA.

TECHNICAL SKILLS:

Databases: Oracle 11G/10G/12C

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x Linux Enterprise Server 9, 10. Windows 95/98/NT/2000, Oracle Linux 5,6,7.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages: SQL, UNIX Shell Scripting, PERL.

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Datapump, TOAD, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential - Lehi, UTAH

Senior Oracle Database Administrator/Support

Responsibilities:

• Proficient in Oracle Dataguard, RMAN, Datafile/Block Corruption, Oracle Enterprise manager (OEM)
• Extensive experience RMAN, Data Guard and maintaining Standby databases.
• Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery
• Expert in configuring Oracle Dataguard configurations on versions 12C, 11G, 10G, and databases on LINUX and Windows and Solaris operating systems on Single instance and RAC Configuration (Multi-instance)
• Proficient in recovering from Index, data and Block corruptions
• Configure Oracle Dataguard broker using Oracle Enterprise manager as well as command line to manage Dataguard configuration
• Extensive knowledge in creating Oracle Dataguard (Physical standby, logical, Active Dataguard and Snapshot standby databases) on Oracle database Appliance and on Exadata machines
• Expert in performing Switchover and Failover operations using SQLPLUS, OEM, and Dataguard Broker command prompt
• Expert in performing RMAN referesh/Clones for testing and development purposes
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases on standalone and RAC configurations
• Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
• Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.

Confidential, Minneapolis, MN.

Oracle Database Administrator

Environment: Oracle 12.1.0.2, 12.1.0.1, 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, TOAD 11.0.

Responsibilities:

• Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases
• Installation, Configuration of ASM, RAC databases, Adding Services and maintaining GRID control.
• Migrated databases from 10g to 11gR2 and 12C using utilities like export/import, datapump and transportable tablespaces.
• Successfully performed installation, setup and creation of Primary & Standby database using dataguard to deliver no data loss with maximum availability mode.
• Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
• Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
• Fixed various database performance issues using Automatic Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
• Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.
• Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 12C,11g and10g.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Confidential - Morrisville, NC

Database Administrator

Environment: Oracle 11g/10g/Linux, Solaris, SQL Developer, Toad, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Responsibilities:

• Installation of oracle 11g databases in production, development and test environments depending on project requirements.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Designed Logical and physical database for business transaction functionality.
• Refreshing development/test database from production using Export/Import & RMAN backups.

Confidential . Skokie, IL.

Junior Oracle Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.2, Sun Solaris 10.0.

Responsibilities:

• Estimating table sizes, table spaces.
• Created database objects like tables, tablespaces, buffer pools, indexes and views.
• Analyzing tables and indexes for performance tuning.
• Resolve connectivity issues on Client side and Server side.
• Take Daily hot backups using scripts and RMAN.
• Weekly Cold backups with and without RMAN. Prepared business requirement document (BRD) and functional requirement document (FRD) to provide details of each business and functional requirement, development and implementation plan of these requirements, timelines, owners, etc.
• Performed comparative analysis and gap analysis to meet HIPAA and PCI DSS compliance requirements
• Creation of logins and user ids and setting up privileges and procedures for protection of data