SUMMARY:

Over 11 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, space management, database security, cloning, migration, shell scripting and documentation.

TECHNICAL SKILLS:

RDBMS: Oracle … Oracle 10g (RAC, Data Guard & Streams), SQL Server 2005 and DB2, Oracle Applications … and R12.1.1

OPERATING SYSTEMS: HP - UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, … Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x,6.x,7.x and Windows …

LANGUAGES: SQL, PL/SQL, T-SQL,MYSQL,C, C++, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, TOAD Data Modeler, Rational Rose, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

WEB TOOLS: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.

PROFESSIONAL EXPERIENCE:

Sr Oracle DBA

Confidential, Brooklyn, NY

Responsibilities:

• Migrated Critical production databases from 11g database version to 12c database version using Golden gate replication.
• Configured Golden gate to replicate transactions from 11g source database (8 Node RAC) to 12c target database (5 Node RAC) so that we can cutover to 12c database with minimum downtime.
• Resolved Golden gate issues and tuned replication to reduce the lag.
• Tuned the Golden Gate replication to reduce the lag for the huge load with 12C integrated replicate.
• Configured different level of replication such as DDL replication, DML replication for table/schema level using Golden gate.
• Worked on applying Golden gate patches to resolve Golden gate bugs.
• Migrated and upgraded mission critical database (18TB) to 11g to 12c on Solaris and Linux systems with minimum downtime.
• Worked on Configuring 11 Node RAC and Supported critical application on this RAC database.
• Configured 11 node Data guard environment for disaster recovery of Production database.
• Worked on implementing Data guard role transitions like switch over operations and also provided POC for failover operations and also used DGMGRL utility for these role transition operations.
• Configured snapshot standby database from physical standby database for application testing before implementing major changes on production database.
• Configured 5 node Standby databases for 12c production database and also configured it as snap shot standby database so that we can test production load and performance using RAT (Real application testing).
• Converted Physical standby database to snap shot database so that we can capture 11g Production database and replay it on snap shot standby database using RAT for performance testing and tuning before cut over to 12c Database.
• Worked on recovering standby database using SCN incremental backups from Production primary database.
• Restored and recovered a dropped table using new RMAN features in Oracle 12c.
• Worked on applying latest PSU patches and also applied required CPU and one-off patches on both Linux and Solaris Operating systems.
• Installed and configured OEM 13c Enterprise Management system to monitor 12c production databases and deployed mass agents on Linux and Solaris platforms.
• Supported mission critical databases and extensively involved in resolving the performance issues.
• Worked on Configuring OEM 12c Enterprise management system on Solaris and IBM machines and installed all different platform agents to monitor the production databases.
• Worked on configuring and setting up notifications for database alerts and incidents from OEM 12c.
• Worked on implementing standard RMAN backup policies and successfully was able to restore huge database when required.
• Worked on resolving performance related issues with AWR,ASH,ADDM,SQLT reports and analyzing with Explain Plan and also tracing the SQL's.
• Assist with database administration activities as requested, responding and fixing all database issues
• Assist in sizing database objects for effective space management and optimal performance
• Worked on refreshing production databases on sandbox for application testing.
• Provided on call support for every 3 weeks and provided support on weekends.

Sr. Oracle DBA

Confidential, Westbrook, ME

Responsibilities:

• Golden Gate Implementation: Migrated critical application data from 10g Database to Exadata 11gR2 (11.2.0.3) using Golden gate technique.
• Migrated 4T application schema to Exadata Machine Database using Oracle Golden Gate with minimum down time.
• Provided support for 3 Oracle Exadata machines - Prod, DR, QA - to be used for mission critical applications.
• Architecting and implemented a RAC database solution for a global laboratory application. The database environment also includes a physical standby database for DR and a logical standby database for reporting.
• Designed and implemented a RAC database for in-house global CRM application.
• Worked on implementing RAC database and also implemented Physical standby database on Windows Environment.
• Maintained a 99.99% uptime for all databases by using DBA best practices and proactive monitoring.
• Supported 24T Data warehouse environment.
• Implemented and provided support to IDEXX Germany team in migration their production environments to the 11gR2 database server machines.
• Designing, implementing and supporting backup and recovery solutions using RMAN, Data Guard and flashback database technologies.
• Partitioned large tables using DBMS REDEFINITION technique, so that the applications never had downtime.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Played a key role in release management and change management for many production deployments.

Environment: Windows 2000/2003/XP, AIX 5.2/5.3 and Red Hat Linux 5.4, SOA, Oracle 10g and 11g, Exadata X2, TOAD 11.0, SQL tuning optimizer, Oracle Enterprise Manager (GC), EM12c, RMAN, RAC, ASM, DataGuard, ASM, SCP/SFTP, Shareplex, TKPROF, Explain plan, AWR, ADDM, ASH, SQL Developer, SQL* Plus, PL/SQL, Golden Gate.

Sr. Oracle DBA

Confidential, Dover, NH

Responsibilities:

• 24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Involved in installation of Oracle 11g RAC using cluster ware and ASM.
• Resolved complex RAC issues which involved with virtual IP addresses, Subnet masks while assisting the functional team.
• Managed and resolved RAC (10g, 11g), ASM and cluster ware issues.
• Successfully applied latest Patch Set Update (11.1.0.7.10 ) on 11gR1 databases.
• Used OPatch Utility to install one-off patches to fix specific bugs on Oracle Database.
• Tuned the database instances based on the reports generated by AWR,ADDM,EXPLAIN PLAN,
• TKPROF, ASH and STATSPACK.
• Performed sql tuning by generating execution plan and AWRSQRT reports for the required sql statements.
• Implemented cleanup strategy method to cleanup huge loads of old data in a well design techniques and executed the strategy successfully without having any impact on the business logic.
• Intensively worked with developers and helped them by improving the database performance.
• Responsible for providing documentation for database design, analysis, modifications, creating schemas etc.
• Management of schemas, objects partitioning the tables & indexes.
• Involved in refreshing the QA databases with PRODUCTION backups
• Effectively restored and recovered database by using Oracle RMAN techniques.
• Developed scripts for monitoring Tablespace sizes, alert log files, Tablespace growth and implemented Crontab job to alert if the tablespace size exceeds above 80%.
• Responsible for taking backup of schemas, tables and table spaces using Oracle 11g Data pump.
• Expertise in using the parameters of Oracle export/ import Data pump.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints and database access.
• Responsible for setting and managing user accounts and granting required privileges to users.
• Responsible for moving files to remote serves with secure SCP/FTP techniques.
• Played a major role in release management and change management for Production Deployments.
• Responsible in handling some critical and generic errors like ORA-600, ORA-7445 by creating SR's with oracle Tech support.

Environment: Windows 2000/2003/XP, AIX 5.2/5.3 and Red Hat Linux 5.4, SOA, Oracle 10g and 11g, TOAD 11.0, SQL tuning optimizer, Oracle Enterprise Manager (GC), RMAN, RAC, DataGuard, ASM, SCP/SFTP,Shareplex, TKPROF, Explain plan, AWR, ADDM, ASH, SQL Developer, SQL* Plus, PL/SQL, SQL* Loader, T-SQL, SQL Server 2005, Golden Gate.

Data collection and Verification Associate (DCAV)

Confidential

Responsibilities:

• Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
• Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
• Implemented Streams replication between RAC and non RAC database environments.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink)

Environment: HP-UX 11, Red Hat Linux4, Windows 2000/2003, Oracle 9.2.0.8/10.2.0.3/11 i, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, J2EE, ToadV9.7 & SQL, Navigator V6.1.