SUMMARY

• Over 8+ years of diversified experience in administration of production databases which includes High Availability Grid Infrastructure (RAC wif ASM), Stand alone database, Replication options known as Data Guard, Gloden Gate; In all of these expertise in Installation, configuration, Administration tuning, design, patches, upgrade, migration, capacity planning, OEM Grid Control, Flashback, RMAN backup and recovery, cloning, auditing, troubleshooting and documentation.
• 24*7 Production Oracle Database support(Size up to 30TB) and maintenance including supporting advance configurations such as Oracle ASM, Oracle RAC, Active Dataguard and Snapshot Standby databases, etc.
• Installation of Oracle 12c (Wif Multitenant Architecture me.e CDB and PDB) Database on Oracle Linux.
• Up - gradation of 11.2.0.4.0 to 12cR1 database.
• Converting Non-CDB 12c Database to 12c Multitenant Architecture(CDB and PDB).
• Good experience in administration of Oracle 11gR2 RAC (3 Nodes and 5 Nodes) and 10gR2 RAC (2 Nodes) on Linux and Sun Solaris.
• Implemented GlodenGate (till latest version) on11g Database RAC database servers.
• Monitored GlodenGate using shell script, 12c Glodengate plugin
• RMAN Backup and Restoration (Full Database Restore and Recover)
• Knowledge of Shareplex.
• Creation of Active Standby database using RMAN Duplicate(Manual Backup and Active Database).
• Cloning of Oracle Database using RMAN Duplicate(Manual Backup and Active Database).
• Good exposure in preparing Oracle Technology documentation .
• Implemented Oracle Patches (PSU) on teh Compliance databases Device a plan to patch them quarterly so that we can cover all teh databases in a year.
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support.
• Cloning, Backup and Recovery, Performance Tuning, and Documentation.
• Up-gradation of teh Databases 10.2.0.4 to 10.2.0.5.
• Re-Organization of Tables using EXPDP and IMPDP
• Analyzing AWR, ADDM and ASH reports.
• OEM Installation 10.2.0.5.0 on Windows
• Good Exposure on High Availability Concepts (RAC, Standby)
• Good experience in applying PSU patches on Databases.
• Application of Bug Fixes Patches on Production Databases
• Re-organization of tables using EXPD and IMPDP.
• Stats Gathering of Tables and Indexes.
• Proactive monitoring, identifying areas that need to be improved in teh application and database using
• EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports. Proven ability of providing production support for 24X7 on multiple databases.
• Strong in logical database backup and restore methods by using Oracle DataPump Export (expdp) and Import (impdp).

TECHNICAL SKILLS

OPERATING SYSTEM: UNIX, LINUX, HP-UX, AIX, SUN SOLARIS

TOOLS: /UTILITIES: RAC, RMAN, AWR, ADDM, OEM, OLTP, ASM, OEM Grid Control 10g/11g, Active Dataguard, Snapshot Standby Database, Shareplex and Gloden Gate

RDBMS: ORACLE 12c/11gR2/10gR2/9i

PROFESSIONAL EXPERIENCE

Confidential, Marlborough MA

Sr. Oracle DBA

Responsibilities:

• Installation of Oracle 12cR1 (Wif Multitenant Architecture me.e CDB and PDB) Database on Oracle Linux.
• Up-gradation of 11.2.0.4.0 to 12cR1.
• Converting Non-CDB 12c Database to 12c Multitenant Architecture (CDB and PDB).
• Administration of Oracle 11gR2 RAC(3 Nodes and 5 Nodes) databases.
• Managing and providing support for multiple databases in 24x7 production environment (from few 100 GBs to 30 of TB in size).
• Administration of Oracle Active Dataguard Standby and Snapshot Databases.
• Created Active Standby Database using RMAN Duplicate(Wif Manual Backup and Active Database).
• Cloning of Oracle 11gR2 Database using RMAN Duplicate(Wif Manual Backup and Active Database).
• Converted Physical Standby Database to SnapShot Standby Database and Vice Versa.
• Used Oracle Gloden Gate replication for Reporting.
• Monitored Glodengate using 12c Glodengate Plugin and shell scripts for alerting GG process down alerts.
• Worked on SharePlex.
• Adding and Dropping Disk from ASM.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Analyzing AWR, ASH and ADDM reports for resolving DB performance issues.
• Re-Org of Tables using EXPDP and IMPDP.
• Monitoring of databases using OEM.
• Application of Bug Fixes patches as per suggestions from Oracle.
• Application of PSU patches on quarterly basis.
• Working closely wif clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—halping to transform business requirements into environment specific databases.
• Closely Worked wif Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.
• Helped build extensive documentation for all Oracle related Administration.

Environment: Oracle 12cR1/11g/10g, Sun Solaris 5.8 sparc/, Linux, SQL Plus, ASM, RAC, Oracle Enterprise Manager (OEM), Gloden gate, Gloden gate, Gloden gate Director.

Confidential, Dallas,TX

Oracle Database Administrator

Responsibilities:

• Oracle 11gR2 RAC(3 Nodes) and 10gR2 RAC(2 Nodes) Database Administration.
• Administration of Oracle Active Dataguard Standby and Snapshot Databases.
• Created Active Standby Database using RMAN Duplicate(Wif Manual Backup and Active Database).
• Installation of Patches and Upgrades. (BUG FIXES, PSU,10.2.0.4 to 10.2.0.5).
• Monitoring of databases using OEM.
• Re-Organization of Tables using EXPDP and IMPDP.
• Index monitoring and maintenance (Index Rebuilding).
• Adding Disks and Disk Groups on ASM.
• Analyzing AWR and ADDM Reports.
• RMAN Backup and Restoration (Full Database Restore and Recover)
• Cloned a Single Instance Reporting database to 4 Node RAC Database.
• Stats Gathering of Tables and Indexes.
• Interaction wif client/users on various issues and requirements.
• Maintaining Physical Standby Databases.
• Performance Tuning
• Managing users
• System check for Oracle 11gR2 and 10gR2 instance
• Resolving Database storage management issues
• Creating and managing table-spaces and data-files
• Space maintenance across teh database objects
• Monitoring teh database growth
• Configuring archive log mode.
• Working closely wif clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—halping to transform business requirements into environment specific databases.
• Closely Worked wif Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.

Environment: Oracle 10g/11g, RHEL, Sun Solaris, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control

Confidential, San Mateo, CA

Oracle Database Administrator

Responsibilities:

• 10gR2 RAC(2 Nodes) Database Administration.
• Installation of Patches and Upgrades. (BUG FIXES, PSU,10.2.0.4 to 10.2.0.5).
• Using EXPDP and IMPDP.
• Grid Installation ( 10.2.0.5.0 ).
• Restoring and Recovering a Database using BCV backups.
• Cloning Of Database (Using Clod Backup)
• Index monitoring and maintenance (Index Rebuilding).
• Adding Disks and Disk Groups on ASM.
• Analyzing AWR and ADDM Reports.
• Stats Gathering of Tables and Indexes.
• Interaction wif client/users on various issues and requirements.
• Maintaining Physical Standby Databases.
• Performance Tuning
• Managing users
• System check for Oracle 10gR2 instance
• Resolving Database storage management issues
• Creating and managing table-spaces and data-files
• Space maintenance across teh database objects
• Monitoring teh database growth
• Configuring archive log mode
• Maintaining Users wif Access privileges in different Situations
• Application of Bug Fixes Patches on Production Databases.

Environment: Oracle 9i/10g/11g, RHEL, Sun Solaris, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control

Confidential

Oracle DBA

Responsibilities:

• 9i and 10g Database Administration.
• Installation of 9i and 10g Databases on Linux and Solaris.
• Using EXPDP and IMPDP.
• Stats Gathering of Tables and Indexes.
• Interaction wif client/users on various issues and requirements.
• Managing users
• System check for Oracle 10g instance
• Creating and managing table-spaces and data-files
• Configuring archive log mode
• Maintaining Users wif Access privileges in different Situations.
• Creating and Manageing Tablespaces.
• Creating Database users and giving necessary grants as per teh SOX complaince.
• Taking necessary actions on DB alerts which are coming from OEM grid control.
• Taking RMAN backup of database.
• Interaction wif teh application users/ Client for any specific requirements.
• Setting teh SGA parameters according to teh Database Perfomance.
• Applying Bug Fixes patches as per teh suggestion from Oracle Support.

Environment: Oracle 9i/10g, RHEL, Sun Solaris, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control.

Confidential

Intern Oracle DBA

Responsibilities:

• 9i Database Administration.
• Installation of 9i Database on Linux OS.
• Monitoring teh alert logs of databases on regular basis.
• Worked on DB alerts which are coming Third Party tools.
• Interaction wif application users to understand their requirements.
• Refreshing teh database using EXP and IMP.
• Creating Database users.
• Granting Roles and Privileges to user .
• Setting teh database SGA parameters.
• Analyzing teh DB tables using Analyze command.
• System check for Oracle 9i instance
• Creating and managing table-spaces and data-files
• Configuring archive log mode.
• Worked on EXP and IMP.