SUMMARY:

• Over 6+ Years of Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals.
• Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production and development environments.
• Over (4) years, experience in configuring Golden Gate replication between OLTP to OLTP and OLTP to data ware housing environments.
• Experience in Oracle Golden Gate installation, configuration, and troubleshooting.
• Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
• Carried out migrations between different environments including production using STAT / Manually.
• Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
• Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.
• Team player with excellent interpersonal, analytical and communications skills
• Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
• Delivering Oracle Database performance - tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE, 11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• 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.
• Expertise in using oracle Export/import, Datapump utility to migrate data across schemas.
• Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases.
• Hands on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 11g features like Data pump, AWR, ASM, ADDM, OEM Grid control.
• Performed Installation, administration and maintenance of Oracle 11g and 12c databases.
• Designed and tested Backup solutions using RMAN and NetApp Snapshots/Flex Clones.
• Tuned Oracle databases, application programs and operating system.
• Strong experience in configuration of RMAN, Planning and scheduling Backups using CRONTAB.
• Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.
• Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby database (Data Guard), Materialized views, VCS, Oracle Streams Replication and Golden Gate.
• Experienced in Oracle Support processes for technical requests through Oracle and other Support.
• Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service. Extensive experience in 7*24 production database support.
• Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.
• Design, development, and testing of backup and recovery to ensure complete recoverability.
• Solid experience in disaster recovery, routine maintenance for Oracle databases.
• Security management for database, network, and operating systems.
• SQL Net installation/configuration/troubleshooting (Server and Client side

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g and 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

PROFESSIONAL EXPERIENCE:

Confidential - Cincinnati, OH

Oracle Database Administrator

Responsibilities:

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on Linux red-hart. Database sizes range from 4GB to 2TB (in ODS & EDW environments).
• Responsible for maintaining databases in various servers with 2 and 3 node RAC & Non - RAC, High Availability, Golden Gate Technologies.
• Experienced in Golden Gate Installation and Configuration for database replication purpose.
• Solid experience with different versions of Golden Gate installation, configuration, Administration, heartbeat monitoring etc.,
• Supported 400+ databases including RAC production database, a Data warehouse database and a lot of Development and Test databases and upgraded from 10g to 11g.
• Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
• Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
• Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
• Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
• Monitoring database performance and database operation to prevent downtime and slowness of the services.
• Worked closely with the system operations team on database deployment processes and database capacity planning.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Cloning RAC to RAC and RAC to NON RAC using hot backup and RMAN.
• Expertise in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operation
• Strong experience in Space and User Management, Capacity planning, standby setup, Backup & recovery (Import/Export, Datapump, RMAN)
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE and SQLT
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Manager).
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and db exports.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and Automatic Storage Management (ASM).
• Troubleshooting Space Management & User accounts and privilege issues while coordinating with Unix and application teams.
• Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
• Regular Security Patching and Critical patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.
• Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS on IBM AIX 6.1.
• Performed conversion of Single Node Instance to multi nodeRAC with ASM, and adding instance to existing RAC.
• Installed and configured 6 node oracle 11gR2 RAC for production environment.
• Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
• Production support for Oracle database 10g/11g RAC.
• Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle Management Server for maintenance and monitoring of production databases.
• Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Expert in monitoring database using Oracle Enterprise Manager (OEM).

Tools: Used: Oracle RMAN, Oracle 10g (9.2.0.8), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential - Waukon, IA

Oracle Database Administrator

Responsibilities:

• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Provided 24X7 support for all the production and development databases.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced 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.
• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced 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.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN