SUMMARY

• 9+ years of experience as an Oracle Database Administrator having hands on experience in Database Administration, Production Support, Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup and recovery, Cloning, Standby Database, Oracle GoldenGate & Veridata, Space management, Database Security, Auditing, Troubleshooting, Database design, TAR support, Unix shell scripting and Documentation.
• Worked on OLTP/DW database systems, managing large Oracle databases (VLDB).
• Worked with Oracle Databases (12c/11g/10g/9i) and 11gRAC/10gRAC on different environments like HP - UX, SUN SOLARIS, AIX, Red Hat Linux and Windows in ensuring Quality, Integrity and Availability of the Company’s data within Oracle Server.
• Experienced with SRVCTL, CRSCTL, Oracle Enterprise Manager (OEM) Grid Control, DBCA, VIPCA, OIFCFG, ASMCMD and SQL* Plus for administration of Services, ASM instances and RAC databases.
• Backup and restore Amazon DB instances through Amazon RDS with automated backups & DB snapshots.
• Hands on experience with Installation, Configuration, Upgrades, Migrations, Administration, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching of Oracle Databases.
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard (9i, 10g RAC &11g RAC).
• Excellent knowledge in logical backups, Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Experienced in Golden Gate Installation and Configuration for database replication purpose.
• Solid experience with Golden Gate versions v11.1.1.1, v 11.1.1.1.2, v 11.1.1.1.3, v 11.2.1.0.5 & v10g installation, configuration, upgrade, Administration, heartbeat monitoring etc.,
• Expertise in Oracle Golden Gate Veridata server & agent installation in various operating systems and GoldenGate Director Installation, configuration, administration.
• Proficient with Standby Database. Configured and maintained Standby Database in OLTP environment to automatically synchronize with production database.
• Database Performance Tuning using SQL TRACE, TKPROF, Explain plan, STATSPACK, AWR, and ADDM.
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Experienced in using 11g features Data Pump, Flash-Back, AWR, ADDM, Grid Monitoring, and Recycle bin.
• Hands on experience with OEM 12c installation & configuration and experienced in Performance tuning with Enterprise Manager 12c.
• Deployed Oracle Enterprise Manager 12c agents on IBM AIX 6.1 targets
• Experience in basic and advanced replication and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• In order to provide the highest quality of service to our customers configured the standard monitoring for data replication using GoldenGate.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Experienced in Performance tools TKPROF, EXPLAIN PLAN, STATSPACK to examine execution strategies and forSQL tuning to get a good estimate of resource usage used by the queries.
• Performing daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation.
• Excellent skills in shell scripting to automate jobs.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Good Programming Skills in SQL, PL/SQL, Shell Scripting, Partitioning, Data Modeling, Logical and Physical Design, Backup and Recovery Procedures.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Database replication using snapshots, materialized views and advanced replication methods.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.

TECHNICAL SKILLS

Operating Systems: UNIX, HP-UX 11.x, 10.x, Sun Solaris 10, 9, 8, AIX 6.1, 5.3, 5.2 Red Hat Linux RHEL 5.x, 4.x.3.x and Windows 98/ME/NT/2000/XP

RDBMS: Oracle 12c/11g/10g/9i, Oracle 11gRAC & 10gRAC, SQL Server 2008/2012

Replication tools: Oracle GoldenGate, Veridata, GoldenGate Direcotor, Oracle Streams, Materilizedviews

Languages: SQL, PL/SQL, C, C++, UNIX Shell & Perl Scripting

Tools: OEM 12c,11g, RMAN, SQLT, SQLD360, ADRCI, Autosys, Cron, RAT, ODI, Ab initio, Informatica, SQL*Loader, SQL Developer, EXP/IMP, expdp/impdp, TOAD, SQL*Net, SSIS/SSRS/SSAS

Tuning Tools: AWR, ADDM, ASH,TKPROF, EXPLAIN PLAN, STATSPACK, top, iostat, glance, netstat, topas, nmon, oem.

Others: Amazon RDS, Erwin 4.0,NetApp, VERITAS Net Backup, Hadoop, MS Visio, MS Office,, EMC, SAN, Siebel

PROFESSIONAL EXPERIENCE

Sr ORACLE DBA

Confidential, Tysons Corner, Virginia

Environment: Oracle Server 12c/11g/10g/9i, MS SQL server, Siebel, Oracle GoldenGate, Veridata, GoldenGate Director, 11gRAC, ASM, OEM Grid Control 12C & 11g, RMAN, Data Guard, Informatica, Udeploy, SQL Developer, PL/SQL, Sun Solaris, HP-UX, AIX 6.1, RedHat Linux, SQL*Loader, Data pump, Control-M, ERWIN

Responsibilities:

• Involved in installation and configuration of Oracle 11gR2 RAC.
• Involved in Oracle GoldenGate installation, configuration, and administration in Oracle RAC/ASM and standalone environments.
• Performed cross-platform migration of databases (from one server to another server) using Goldengate.
• In order to provide the highest quality of service to our customers configured the standard monitoring for data replication using GoldenGate.
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory and Tuning.
• Install, configure and manage MongoDB. Familiar with the features and capability of this NoSQL database.
• Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6
• Working knowledge in Oracle Grid control. Maintaining the grid control alerts, configuring the rules, notifications, setting up metric settings, blackouts, advisors (Segment Advisor, SQL Tuning Advisor, Memory Advisor, SQL Access Advisor), and administration and performance tuning of databases and servers.
• Involved in COB test with GoldenGate target databases. This will allow the business to perform normal business activities on the COB database without losing any information.
• Involved in migrating users between primary and GoldenGate target database, if there is any release implementation on primary.
• Designed and outlined standard instructions to install/uninstall GoldenGate. This includes the tasks like preparation, pre-install, installation and post install activities.
• Involved in database renaming activities with Oracle NID utility.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents etc.
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate
• Upgraded DBs from 11.2.0.4 to 12.1 using the latest 12c Parallel Upgrade feature and used other 12c features like Table and partition recovery using RMAN, concurrent statistics gathering, Invisible columns etc.
• Analyze SQL statements, reorganize Database objects and design indexes to improve response of queries.
• Creation of Database maintenance plans, rebuild indexes and integrity checks.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Cloning of production Database to the test environment using Recovery Manager (RMAN) and refresh lower environments with production data for business purposes.
• Performed full and incremental backups using RMAN.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database and managing user groups, Database security, OS space monitoring etc.
• Export and Import of Database objects to copy from one Database to another Database and refresh databases.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP.
• Working with Tuning Tools like “Explain plan”, “TKPROF”, “SQL TRACE”, “AWR” “ADDM” Gathering statistics, Statspack etc.
• Cloning databases using scripts as well as RMAN.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Redesign the existing database based on Business rules to overcome the existing issues
• Data Modeling, Database Design and Creation.
• Created Database objects - tables, views, functions, triggers and stored procedures for implementing application functionality.

Sr. ORACLE DBA

Confidential, Jacksonville, Florida

Environment: Oracle Server 11g/10g/9i, SQL server, Oracle GoldenGate, Veridata, GoldenGate Director, 11gRAC, ASM, OEM Grid Control 12C & 11g, RMAN, Data Guard, DBCA, DG Broker, ADRCI, Ab initio, SQL Developer, PL/SQL, Sun Solaris, HP-UX, AIX 6.1, RedHat Linux, TOAD, SQL*Loader, Data pump, ODI, Hadoop

Responsibilities:

• 24x7 Production Database administration, support and monitoring to ensure a proactive problem recognition and resolution of Database issues
• Involved in Oracle GoldenGate installation, configuration, and administration in Oracle RAC and standalone environments.
• Hand on experience in configuring GoldenGate Uni & Bi-Directional setup in AIX & Solaris operating systems.
• Building a 2-node RAC database (Oracle Clusterware, Oracle ASM and Oracle RDBMS)
• Providing support to the SA team for Oracle RAC compatible hardware configuration
• Performed Oracle fail safe and cold failover cluster as a part of testing RAC.
• In order to provide the highest quality of service to our customers, configured the standard monitoring for data replication using GoldenGate.
• Involved in COB test with GoldenGate target databases. This will allow the business to perform normal business activities on the COB database without losing any information.
• Involved in migrating users between primary and GoldenGate target database, if there is any release implementation on primary.
• Verification of data synchronization using GoldenGate Veridata and fixing out of sync situations using Veridata perl/xml scripts.
• Installation, configuration, & performance tuning with Enterprise Manager 12c.
• Deployed Oracle Enterprise Manager 12c agents on IBM AIX 6.1 targets
• Monitoring OGG processes between two live databases using GoldenGate Director Tool and GG heart beat tables.
• Applying GoldenGate latest patches, keeping application bug free, and improving data integrity.
• Troubleshooting replication lag issues by tuning GoldenGate extract, pump & replicat parameter files.
• Resolved different types of GG replicat lag issues during BATCH jobs on source, by tuning GG param files with adding replicat BATCHSQL options.
• Analyze Capacity planning reports on a quarterly-basis to estimate the additional resources required for GoldenGate trail file directories.
• Involved in COB switch scenarios if primary database is crashed due to any SAN types of issues.
• Involved in resolving major GG extract abend issues such as core dump generation in OGG home directory, missing archive logs, data corruption on source, checkpoint files missing etc.,
• Performed GoldenGate/Veridata failover during node failure scenarios, OS maintenance patching
• Designed and outlined standard instructions to install/uninstall GoldenGate. This includes the tasks like preparation, pre-install, installation and post install activities.
• Involved in configuring Oracle RAC High Availability for GoldenGate application.
• Performed Veridata with Oracle Grid Control to monitor the Veridata compares and out of synch alerts.
• Installing and configuring GoldenGate Director to monitor the real-time actions of the GoldenGate processes.
• Adding and removing data sources from Director based on business requirements.
• Supported different Databases like Production Development Testing UAT and Training.
• Performed decommission of Oracle RAC databases in ASM environments.
• Involved in Hadoop cluster setup for Oracle standby databases.
• Configured server/client side load balancing and Involved in designing and creating db objects.
• Query optimization for reporting and ETL and Created Partitions on large tables for easier manageability.
• Performed day to day activities such as managing user privileges, tablespaces, file system and indexing.
• Migrated single instance database to multiple instance database (RAC).
• Performed cross-platform migration (AIX to LINUX) using Transportable Tablespace (TTS).
• Upgraded databases, applied CPU patches.
• Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Configuring Recovery Manager (RMAN) and taking differential, cumulative level backups using RMAN.
• Involved in designing of disaster recovery using Data Guard, High Availability using RAC.
• Deciding the naming conventions of data file, redo log files, table spaces, and segments.
• Writing scripts for backup and recovery, Import and export procedure.
• Used Active Data guard makes a read-only replication of a given database.

Sr. ORACLE DBA

Confidential, New Britain, Connecticut

Environment: Oracle Server 11g/10g/9i, 10g&11g RAC, PL/SQL, Solaris, AIX, RHEL, Windows, RMAN, ASM, OEM Grid Control, SSIS/SSRS, SQL*Loader, DBCA, DG Broker, Oracle GoldenGate 10g/11g, Streams, Data pump, exp/imp

Responsibilities:

• 24 X 7 Production Oracle database support and administration.
• Involved in the implementation of High Availability solutions with Oracle 10gRAC, 11g RAC.
• Installation and configuration of Golden Gate for database advanced replication purpose.
• Backup and Recovery using RMAN with external tape backup system.
• Responsibilities include replication between homogeneous and heterogeneous database systems using Oracle Golden Gate.
• Involved in configuring Oracle RAC High Availability for GoldenGate application.
• Performed decommission of Oracle RAC databases in ASM environments.
• Created Recovery Catalog to store multiple database backups.
• Detect corrupted blocks by using DBVERIFY utility.
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM etc…
• SQL, PL/SQL, Shell Scripting.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Involved in RAC administration, Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Conducting sizing & capacity planning for Oracle databases.
• Cloned environments to create patch test, development and QA environments.
• Created scripts to monitor and manage the databases.
• Creating of databases for Testing, Development and Production.
• Created backup plans and scripts.
• Worked on different types of storage structures (SAN/NAS).
• Extensive knowledge in reporting tools like Business Objects and crystal reports
• Performed hot, cold, RMAN incremental backups.
• Performed Veridata with Oracle Grid Control to monitor the Veridata compares and out of synch alerts.
• Installing and configuring GoldenGate Director to monitor the real-time actions of the GoldenGate processes.
• Adding and removing data sources from Director based on business requirements.
• Applied High priority, security patches downloaded from Metalink.
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades.
• Implemented database auditing, data security and Remediate high-risk violation in production environment.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Upgraded databases from 9i to 10g and 10g to 11g
• Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) to Linux.
• Writing Shell scripts for monitoring, cloning, backups and problem identification.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Sr. ORACLE DBA

Confidential, St. Louis, MO

Environment: Oracle Server 10g/9i, SQL server 2005/08, PL/SQL, Sun Solaris, HP-UX, AIX, Red Hat Linux, OEM Grid Control, RMAN, SSIS/SSRS, ASM, Data pump, SQL*Loader, SQL Developer, GoldenGate, Veridata

Responsibilities:

• Involved in 24x7 support Production RAC database and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Cloning databases for Testing, Development and Production.
• Taking periodic backup of the database and the software.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Involved in Goldengate installtion, configuration, administration in RAC environments.
• Analyzed and Resolved Out-of synch situations in data replication with Goldengate.
• Upgrading GG to newer versions to fix the extract bugs such as extract slow performance, extract crash abnormally, DDL trigger issue etc.,
• Used Export and Import tables, schemas, databases.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, Statspack., AWR, ADDM
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database
• Setup of Standby database for faster disaster recovery and RAC setup for high availability.
• Load balancing, databases/schema/table re-organization for faster performance.
• Installation of Oracle version 10g RAC.
• Experienced in maintaining high availability of databases for global operation using Oracle RAC and Data Guard/Standby databases. Create and manage Standby databases at remote data center as Disaster Recovery.
• Database dot release upgrades using oracle universal installer and catpatch.sql.
• Migration of Database from 9.2.0.6 and to 10.2.0.2.
• Was involved in developing a disaster recovery (DR) plan.
• Rebuilding of Indexes.
• Database replication between homogeneous and heterogeneous database systems using Oracle Golden Gate.
• Conducting sizing & capacity planning for Oracle databases.
• Handling Database storage.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Scheduling jobs through Oracle job Scheduler.
• Providing Solutions to the Problem Faced by end Users or Programmers.
• Automation of Startup Shutdown on all Production and Development Database.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Automated the process of analyzing tables every night.

ORACLE DBA

Confidential, Reston, VA

Environment: Windows NT/2000, HP-UX, AIX and Linux, Oracle 9i and 10g, Toad Database Tools/Utilities. Enterprise Manager (OEM), TOAD, TSM

Responsibilities:

• Installation, Configuration, Upgrade, Patching of Oracle RDBMS and Applications
• Responsible for administering and supporting production and development Oracle 9i/10g RAC Databases.
• Responsible for installing, migrating and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Implementing hot, cold and logical backups.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning Tables by determining the suitable methodology to improve performance and manageability
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Cloned Environments to create Patch Test, Development and QA Environments
• Partitioned large tables to increase the performance.
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation.
• Applied High priority, security patches downloaded from Metalink.
• Monitoring the Database storage and Day to Day activities.
• Configured scripts to monitor activity with database and SQL, PL/SQL programming
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Jr. ORACLE DBA/Database Developer

Confidential

Environment: Oracle Server 10g/9i, SQL, PL/SQL, HP-UX, Red Hat Linux, Windows, RMAN, TOAD

Responsibilities:

• Performed day-to-day DBA jobs for managing Production/Development databases.
• Management of tablespaces for different users by granting quota on Default & Temporary tablespaces.
• Estimated Storage capacity for database objects.
• Monitored the growth of the database objects using UNIX Shell scripting, Implemented for capacity planning.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.
• Utilized SQL*loader to load data into tables.
• Took a logical backup of the entire database using import/export utility.
• Created and implemented Oracle database backup and recovery strategies.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability.
• Performed Database and SQL tuning by using various Tools like STATSPA CK, TKPROF, and EXPLAIN PLAN. Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.