SUMMARY

• Seven years of US Hands on experience as an Oracle DBA working in various environment such as; Linux, UNIX and Windows.
• Responsible for implementing Disaster recovery for production databases using Data guard and creating physical standby databases, and involved in converting physical to snapshot standby, and Active Data - guard.
• Worked on installation, configuring and maintenance of Oracle Golden Gate for replication, integration and transmission of data between different databases and applications.
• Performed 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 back up, incremental and cumulative backup. Implementing backup and recovery strategies.
• Experienced in full life cycle of database administration in Oracle. Worked as a Development Support DBA in Oracle.
• Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS.
• Data transferring with Data Pump and SQL* Loader.
• Performing complete and incomplete recovery during disasters, failures and user errors.
• Configuring user creation, their roles and privileges profiles to control access over database objects.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and "OPatch as well as database upgrades
• Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.
• Installed 12c pluggable databases and upgraded from 11g to 12c
• Deployed Standby databases using Data Guard 11G (Maximum Performance).

TECHNICAL SKILLS

• Oracle 11G/10G/12C
• 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 TKPROF, EXPLAIN PLAN, AWR, and ADDM SQL, PL/SQL, UNIX Shell Scripting
• RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Green Bay, Wl

Oracle DBA

Responsibilities:

• Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Configuration of data guard for disaster recover.
• Configuration of golden gate for data replication.
• Configured and managed a 2 node RAC.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Used DBCA to create database.
• Wrote scripts to create tables, views, indexes and synonyms required to meet with developers' needs.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g 12c

Confidential, Chicago, ILLINOIS

Database Administrator

Responsibilities:

• Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.
• Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
• 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.
• Configured and utilized data guard for high available, maximum protection and disaster recovery.
• Configured three node RAC.
• Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.
• Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
• Extensively used Data pump, 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, STATSPACK, SQL TRACE, TKPROF utilities.
• Ensured sound database definitions, structures and documentation.
• Created and cloned database from PROD to DEV, UAT and QA.
• Presented and analyzed database performance reports and improvement recommendations to client company's senior executives.
• Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, Data Guard, RAC, RMAN, OEM, Data pump, AWR, ADDM, ASH, TOAD 11.0