SUMMARY:

• 8+ years of experience as an 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:

Confidential, Houston, TX

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 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.
• Handling release management, problem management and change management calls.
• 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.
• Implemented Oracle advanced security across various database levels.
• 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.
• Cloning of application from production environment to test environment.
• Developed and implemented Data Encryption techniques in various platforms.
• Moving data from development to production through transportable tablespace exports.
• 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

Confidential, Providence, Rhode Island

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.

Confidential, Bedford, MA

Oracle DBA

Responsibilities:

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Installed 4-Node and 2-NodeRAC databases.
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR) of databases.
• Hands on experience working and managing VLDB’s up to 5TB.
• Performed cross platform migrations from Oracle 10g to Oracle 11g (Solaris-Linux)
• Installed OEM agents and monitored them timely.
• Replicated databases using Oracle Streams and Data Guard for reporting purposes in OLTP environment with minimum lag.
• Experience in Oracle Clustering services, VERITAS Cluster Services VCS (Quick I/O file systems) and High Availability features.
• Hands on experience in shell scripting for dataguard monitoring, purge alert logs, trace files,
• Proficient in migrating data base from 9i/10g to 11g R2 by applying latest patch sets.
• Replicated certain columns from a table and certain values from columns by using Oracle Streams.
• Used Oracle streams for data migration and data distribution.
• Involved in administration of over 150 Oracle 11g R1/10g R2 instances.
• Implemented Oracle advanced security across various database levels.
• Developed Oracle Forms and Reports for the user interface; a data load using PL/SQL and SQL*Loader; and Unix scripts to download and manipulate files
• Developed and performed the quality assurance activities and unit testing.
• Proficient in Oracle Materialized view replications.

Environment: IBM AIX, Linux, Windows, Solaris, Oracle 10G/9i, RAC, OBIEE, VCS, ASM, SAN, NAS, Data Guard, Power Designer 15, SQL*Loader, OEM Grid Control, RMAN, Informatica.