SUMMARY:

• 9+ years of experience as an Certified Oracle Database Administrator having hands on experience in Database Administration, Installation, Patching, Migration, Configuration, Upgrades, Performance tuning, Backup and Recovery, Space Management, Cloning, Database Security, Auditing, RAC, Data Guard, Golden Gate, Oracle Enterprise Manager Grid Control and 12c Cloud Control.
• Proficient in installation, administering and managing Oracle 12c,11g, 10g, 9i on SUN SOLARIS, HP - UX, IBM-AIX, WINDOWS and REDHAT-LINUX.
• Excellent track record in providing 24/7 on-call support for both production and development databases in result-oriented, time-critical environments.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using AWR, ASH, ADDM and Oracle Enterprise Manager.
• Extensive experience in High Availability solutions Real Application Clusters (RAC) Implementation, configuration, administration and troubleshooting.
• Expertise in building Standby databases, configuring disaster recovery site using Datagaurd. Also proficient with 11g features such as Active Datagaurd and Snapshot standby database.
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, contention Resolution and Defrag scenarios across diverse environments.
• Experienced in applying patches including Patchsets and CPU/ PSU, One-Off patches on Standalone, RAC and Standby Databases using Universal Installer and OPatch Utility, upgraded databases from 9i/10g to 11gR2.
• Experience in Database backup concepts and options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
• Created clone databases for development and test environments using RMAN Duplicate.
• Experienced in using 11g features Data pump, Flash-Back Recovery, Grid monitoring.
• Performing database reorganizations, statistics and other applicable utilities to ensure proper database function and performance based on Oracle best practice methodology.
• Proficient in working with Data guard for production system in case of disaster recovery, maintained primary and standby databases, Data Guard Broker.
• Experienced in using Oracle Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases.
• Expertise in performing Hot and cold backups with and without RMAN. Automated RMAN scripts using corn job and implemented VERITAS NetBackup to perform daily backups.
• Design and implement database backup and recovery procedures using RMAN.
• Strong experience in using SQL developer, SQL*Loader, Exp, Imp, Data pump (Expdp, Impdp), Putty, TOAD, Oracle Enterprise Manager (OEM), SQL*Plus tools.
• Strong oral and written communication skills. Ability to communicate effectively with support peers, end users, and all levels of corporate management. Manage vendor communication and create/host presentations.
• Experience on Data Replication using Golden Gate and Oracle Streams. Hands on experience on setting up the environment for unidirectional, bidirectional propagation in Oracle Streams.
• Hands on experience on DB2 10.5 and Teradata 14 databases.
• Scheduling jobs through Oracle Job Scheduler, Crontab (UNIX) and Scheduled Tasks (Windows).
• Strong ability to handle multiple projects simultaneously through completion and ability to work independently or in a team environment and ability to function successfully in a highly stressful environment.

TECHNICAL SKILLS:

Database: Oracle 12c/11gR2/11gR1/10g,9i, DB2 10, Teradata 14

Oracle Products: Real Application Cluster(RAC), Automatic Storage Management(ASM), Data guard, EXADATA, Import and Export, Data pumps, Recovery Manager(RMAN), TDE, Data Masking, Golden gate, Oracle Enterprise Manager(OEM) Cloud Control 12c and Grid Control

Operating System: Oracle Linux (OEL) 6.3, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x 5.x, Sun Solaris 9, 10, Microsoft Windows sever, IBM-AIX 6.1.

Languages: SQL, PL/SQL, Unix shell scripting

Tools & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, SQL * LOADER, ADDM, DBCA, VERITAS, Log Miner, TKPROF, Explain Plan, AWR, ASH, Toad, Putty, ERWIN, ETL tool, Net Manager

PROFESSIONAL EXPERIENCE:

Houston, TX, USA

Oracle DBA

RESPONSIBILITIES:

• Working as a part of team and providing 24x7 supports on a Production, development, staging database and system support environment.
• Planning, Installation and Configuration of Oracle 11gR2 Grid Infrastructure on 2 node RAC on Oracle Enterprise Linux (OEL).
• Automating Oracle backups to tapes using RMAN scripts for weekly full backups as well as daily incremental backups and monitoring the same using automated scripts.
• Interacting with client and team to resolve queries.
• Pro-active business users support including performance tuning the SQL queries for reports and discussing the same to meet their requirements.
• Upgraded Oracle 10.2.0.4 database to 11.2.0.4.
• Oracle security using Roles and Profiles and granting of the privileges according to the needs of the various users and adhering to the security and policies of the organization.
• Involved with the UNIX admin teams regarding disk and storage requirements and also regarding server tuning efforts in case of performance issues.
• Performed Database Tuning for I/O Contention, Memory contention, Locks etc.
• Performed Database Configuration Tasks like creating tablespaces for data and indexes, adding data files to tablespaces, monitoring tablespace size, tuning SGA for optimal database performance, modifying redo log sizes and groups depending on the requirement, monitor v$ views for database related information.
• O/S monitoring for CPU, Memory and Disk I/O utilization.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Installed and Configured Golden Gate for replication purposes.
• Configured and maintained replication of data using Golden Gate in Production and Non-Production environments for reporting.
• Managed Oracle SR research application bugs, apply patches, data-fixes to resolve application, user functional issues.

Environment: Oracle Database 10.2.0.4/11.2.0.4 , RH Linux 5.4, Oracle Linux 5.7, Oracle Golden Gate.

Sr. Oracle DBA

RESPONSIBILITIES:

• Installation, configuration and upgrading of Oracle software and related products (Oracle 12c/ 11g / 10g).
• Manages more than 300+ instances (Development, SIT, QA and Production).
• Establish and maintain sound backup and recovery policies and procedures.
• Upgrade / Migration of databases.
• Implemented advanced RMAN concepts as the backup strategy for the production databases. Have scheduled these backups in the CRON to run at scheduled timings.
• Configured dataguard on RAC databases for disaster recovery and setup the dataguard broker.
• Tested the dataguard switchover on the RAC databases manually and also using dataguard broker.
• Worked with different utilities like dataguard broker (DGMGRL), SRVCTL, CRSCTL and CLUVFY.
• Perform database tuning and performance monitoring.
• Configured RAC on oracle 11g R2.
• Developing shell scripts for monitoring database servers.
• Performed technical trouble shooting and give support to development team.
• Setup and maintain documentation and standards for database administration.
• Preparation of DR policy & implementation of Oracle Data Guard.
• Installing and configuring Grid agent for multiple nodes.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Coordinating and handling multiple teams for the Code releases.
• Performed cross platform migrations from Oracle 9i, 10g to Oracle 11g.
• Developed shell scripting for dataguard monitoring, purge alert logs, trace files.
• Upgrading data base from 9i/10g to 11g R2 by applying latest patch sets.
• Implemented zero downtime migration and upgrade of 10g to 11g database using Oracle Golden Gate.
• Installed Golden Gate on Linux environment.
• Development of PL/SQL and Web PL/SQL stored procedures.
• Proficient in Oracle Materialized view replications.
• Maintained L3 production on call databases timely.
• Used Data guard for data migration from various database’s.
• Installation and maintenance of Oracle 11gR2 database.
• Optimization and tuning SQL queries using AWR, ADDM, ASH, EXPLAIN PLAN and OEM.
• Maintained L3 Production, Development, Quality assurance database (QA) and Test databases.
• Worked on cross site (active-active) data replication using Golden gate.
• Replicated databases using Oracle Golden Gate for reporting purposes in OLTP environment with minimum lag.
• Installation and maintenance of Oracle 11gR1-R2 database from scratch.
• Upgraded oracle OEM 12cR1 - OEM 12cR3.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Restoration and recovery from backup.
• Developed and implemented Data Encryption techniques in various platforms.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Implementing standby database and database replication to provide high availability of database.

ENVIRONMENT: Oracle 12c, 11g / 10g / 9i, Grid Control, TOAD, UNIX HP, Red Hat Linux, Unix Sun Solaris 8 & 9 (Sun Fire 6800/6900), Microsoft Windows 2000, XP.

Providence, Rhode Island .

Sr. Oracle DBA

RESPONSIBILITIES:

• Installed Oracle versions 10gR1/R2, 11gR1/R2 on environments Solaris, Aix, Linux.
• Migrated databases from Oracle Versions 9i, 10gR1/R2 to 11gR1/R2.
• Handling Release management, Change management and Incident management calls.
• Performed various migrations from Solaris, Aix, Windows, Linux platforms to AIX.
• Performed various migration methodologies like RMAN convert, Export/Import, Expdp/Impdp, Transportable tablespaces, Cold backups and restore.
• Installed OEM cloud control 12c on AIX platform and agents on various AIX servers.
• Involved in conducting DR (Disaster Recovery) environments.
• Documented various migration methodologies.
• Experienced with cross site (active-active) data replication using Golden gate.
• Replicated databases using Oracle Golden Gate for reporting purposes in OLTP environment with minimum lag.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• Created shell and Perl scripts for automated tasks.
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, Sql Tuning Advisor.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Setup and monitored multi node RAC to RAC Data guard with real time apply for DR and offload backups.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Working on several databases across development, QA, UAT and PROD environments via use of command line and Oracle tools Oracle Enterprise Manager Cloud 12c.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Applied database patches using OPatch utility & building Clone instances for Development and Test teams.
• Hands on experience working with Golden Gate Director and configured ODI to use Oracle Golden Gate for Change Data Capture.
• RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR) of databases.
• Developed hot, cold and logical backup scripts to automate the backup procedures.
• Hands on experience in Data Vault, Advance Security (ASO), Data Encryption.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.

Environment: HP-UX 11.31, Linux, Exadata, Oracle 11G/10G/9i,CAD2.4(Oracle:10.2.0.4, RHEL 5.3)CAD 3.1(Oracle 11.2.0.2,RHEL 5.4), Oracle Golden Gate 10.4, Data Guard 10g Physical/Logical, Data Guard 11G Active Data Guard, ABINITIO 8.7.4,Power Designer 15, Oracle Enterprise Manager(OEM), SQL*Loader, OEM Grid Control 11.x, RMAN, Sybase 12.5, Windows XP/2000. 

Keene, NH

Oracle DBA

RESPONSIBILITIES:

• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.
• Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements.
• Upgraded Oracle 9.2.0.6 Database to 10.2.0.4 and migrated from HP- Tru 64 OS to Red Hat Linux 5.4 OS.
• Applied database patches using OPatch utility.
• Converted single node non-RAC 11.2.0.1 database to RAC database 11.2.0.1.
• Performing database Health checkups.
• Performed RAC Database Cloning from Production to Test, DEV environments (non-RAC)
• Job scheduling using Crontab.
• Monitoring various database activities like number of users, memory usage, alert log file, trace files.
• Generated AWR report for database performance health checkups.
• Handled Service Requests raised by application development teams.
• Maintained Checklist for monitoring Production and Test systems.
• Wrote various UNIX shell scripts to monitor databases, automate tasks, etc.
• Attending daily, weekly and bi-weekly calls with teams for discussing on-going activities and upcoming projects.
• Responsible for day to day trouble shooting, and maintenance. Responsible for automating database monitoring using OEM and shell scripts.
• Wrote scripts (Linux Shell) for database maintenance activities such as monitoring the growth rate of tablespaces and extents. Also wrote UNIX scripts to process batch jobs.
• Documented instructions for migrating & upgrading databases.

Environment: Oracle DB 10.2.0.4/11.2.0.1/11.2.0.4 , RH Linux 5.4/5.2, IBM-AIX 6.1/5.3, HP-Tru 64 OS

Santa Ana, CA

Oracle DBA

RESPONSIBILITIES:

• Implemented automated RMAN backups for all cloning needs.
• Used Export/Import and Datapump utilities for full/partial backup.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Sizing the SGA, db, buffers, shared SQL area, log buffer based on the requirements.
• Performed logical backup using export/import and data pump (remote export) utilities.
• Database refreshes based on Application requirements.
• Wrote shell script to perform backup and schedule it with Crontab.
• Optimize SQL queries for better performance.
• Carried out Optimizing performance and Query tuning using AWR, TKProf, and OEM.
• Use Explain Plan for monitoring the query execution.
• Installation and configuration of Oracle Client software and Tools.
• Provided Production DBA support, as needed, on a 24/7 basis. 
• Regular monitoring of Alert log file on day-to-day basis.
• Responsible for all regular DBA Maintenance procedures like backups, Cloning, performance tuning and Database maintenance.
• Configured 10g RAC setup on Linux platform and performed CRS home and RDBMS home from RAC systems using shared storage (SAN).
• Added a new node to Cluster environment.
• Troubleshoot database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora, sqlnet.ora.
• Migrating the Non-RAC database to RAC database.
• Check out CRS status and Administration of RAC instances using SRVCTL utility.

Environment: Oracle 10.2.0.4, RH Linux 4.0, RAC