SUMMARY:

• Excellent experience in managing large - scale OLTP databases in High Availability and Disaster Recovery setup.
• Installation, Configuration and Maintenance of Oracle Standby/Data Guard.
• Experience migration/consolidation of databases using Oracle 12c multitenant.
• Setup maintenance of Data Guard for disaster Recovery and reporting purpose with various modes.
• Planned, Installed and Configured Golden Gate setup to achieve unidirectional replication.
• Performed, developed and maintained database backup and recovery using RMAN.
• Refreshing/Cloning databases for the testing/developing purpose
• Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.
• Cross platform migration/upgrade of databases from 10g, 11g and 12c using transportable tablespaces from Linux to HP-UX
• Experience in install and support OEM Grid control 10G/11G/12c.
• Backup & Recovery using Data Pump, Hot, Cold, Logical and RMAN
• Executed and implemented user helpdesk tickets of various issues via REMEDY database from creating user accounts, read-only accounts on a database & table down to assisting them with logging into the database. Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Highly experienced in performance monitoring/tuning/troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, SQL TRACE. Applying patches under UNIX platform.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Apply security patches like Critical Patch Updates (CPU), Patch Set Updates (PSU) and One-off Patches.
• Worked in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Expertise in Performing Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, SQL*Trace, TKPROF.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

Oracle Database Administrator

Responsibilities:

• Troubleshooting ORACLE RAC issues using ORACLE cluster ware and Database logs.
• Applied the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one - off patches (for Bug resolution) using opatch.
• Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. as part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
• Installed Goldengate version 11 and version 12 with latest patches applied on DBFS filesystem and ACFS filesystem, also working testing new OGG 12.2 new features available.
• Implemented Goldengate 12C integrated replicat and co-ordinated replicat to improve the performance of data replication to targets
• Troubleshoot and maintain ORACLE Data guard environment for disater recovery
• Troubleshoot Database Performance issues using OEM, AWR, ASH, EXPLAIN PLAN
• Developed custom scripts and implemented standard procedures to troubleshoot Live Production issues by leveraging ORACLE ASH and AWR Data.
• Monitor Production Databases using various internal tools and custom scripts.
• Database Capacity Management (Working with Storage teams for ASM Disks) using automated scripts/processes and Reports.
• Experience managing Tablespaces, Data Files, Archive Logs, Redo Logs, and Standby Redo Logs and Logical Database Objects.
• Performing tuning of application using CBO, SqlTrace, Tkprof, Explain Plan, AWR and ASH/ADDM.
• Proficient in writing UNIX Shell scripts to automate business process and daily backups.
• Involved in capacity and resource planning.
• Exposure to new 12c Features, Container and Pluggable Database, FAR-SYNC Instance, Cascade Redo Transport Destination, allowed usage of SYNC and NOAFFIRM to extend Data Guard Range, Moving online Data file, etc.
• Sanitize behavior of SCAN.
• Perform failover failback testing.
• Follow up on SRs for different issues (SCAN behavior, Node eviction, Failover etc.)
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.
• Migration of database from one server to another server.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Responsible for configuring datagaurd physical and standby database setup for high availability and handling synchronization issues between primary and standby.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Managing, Monitoring and optimizing the performance of the databases on periodic basis using AWR, ADDM reports and providing recommendations.
• Handling and debugging of high priority and sudden database service interruption issues like service interruption due to ORA-600 errors in the dump and database hung due to ORA 7445 errors and restoring the service to normal and providing efficient root cause analysis.
• Upgraded stand-alone and RAC databases from 11.2.0.3 to 12c on QA database for proof-of-concept
• Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
• Experience with testing and pre-production and production of Oracle 10gR2 with 2 node RAC on Red Hat Linux with ASM
• Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.
• Capacity Planning for OLTP environment- Allocating system storage and planning future storage requirements for the existing and new databases.
• Proactive performance monitoring by implementing UNIX scripts and automated jobs (Grid) for alerts.
• Refreshing databases and Migration of databases from various environments for Testing, Development work.
• Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.

Confidential, McLean, VA

Oracle Database Administrator

Responsibilities:

• Disaster Recovery (DR) Plan Implemented using DATAGUARD (Physical Standby) for high availability/disaster recovery purpose on Oracle 11g.
• Implemented 11g Database compression feature for Development and test Instances to reduce the size of databases which help the client to save huge disk space.
• Performing DR switchover and failover operations.
• Syncing of DR databases with the Primary Database for any archival gaps.
• Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
• 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 Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
• Achieved optimal performance tuning by using explain plan, SQL TRACE, TKPROF utilities.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Used Data pump for exporting and importing tables, schemas and table spaces.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.
• Worked with application developers to address and clarify data requirements to resolve technical and functional issues.
• Reconcile functional and technical problems through interaction with the client by researching and identifying the defined issue and by fully testing and confirming possible solutions to the problem.
• Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.