EXPERIENCE SUMMARY:

• Oracle Certified Master & Senior Database Specialist / Oracle DBA Subject Matter Expert with 13 year’s Extensive experience in managing a variety of mission critical databases for large organizations.
• Oracle Certified Master (OCM)
• Oracle Database Cloud Administrator Certified Professional
• OCP 8i/10g/11g
• Oracle Certified Expert, Oracle RAC 11g and Grid Infrastructure Administrator
• ITIL® V3 Foundation certified
• Proven experience in coordination with different globally spread teams for successful implementation of Projects.
• Proven experience for cost saving efforts for various clients.
• Extensive experience of managing production high volume, transactional 24x7x365 Databases on Unix (Solaris / Linux/HP - UX, Confidential -AIX ) Systems.
• Handle Oncall issues and jump into Sev1 /2 calls and ensure timely restoration of database services . Take care of critical Database tasks and ensure end-to-end delivery of work
• Strong communication skills, Effortlessly interact with stake holders, clients, vendors and staff.
• Thoroughly experienced in meeting client expectations thru effective communication, exemplary team work and superior technical knowledge.
• Extensive experience on Oracle Exadata engineered systems (X2-X6)
• Extensively worked on high availability features like 10G/11G/12c RAC, 9i/10g/11g DATAGUARD, VCS, HACMP
• Installation/Setup & Maintenance of multiple 10GR2/11GR2/12c RAC environments with ASM on multiple Operating systems
• Implementation of Oracle database backup and recovery strategies using RMAN/Hot/Logical Backups for RAC/Non-RAC databases, Implementation of Golden gate for Non-RAC / RAC databases
• Extensive experience using RMAN for all type of Critical Recovery scenarios
• Extensively used RMAN for Cloning, Stage database refreshes, DR creations
• Migrations, Upgradation and Maintenance of RAC/Non-RAC Databases, Performance Tuning
• Extensive client facing experience .Lead/participate in meetings with stakeholders Application teams and suggesting and convincing for implementing appropriate solutions . Exposed to working in mission critical projects, large database environments and Complex architectural setups
• EXTENSIVE EXPEREINCE IN IMPLEMENTING 10g/11g/12c RAC ON LINUX, OVM, VMWARE, SOLARIS AND OTHER FLAVOURS OF UNIX.

TECHNICAL SKILLS:

Oracle Enterprise Edition (12c, 11g, 10g, 9i, 8i, 7): EXADATA X2X7 using ZFS, Cell management, monitoring etc. Migration from Non-Exadata to Exadata

RAC 10gR2/11gR2/12c: Real Application Clusters (two/three/four node) on HP-UX, Sun Solaris, Linux Installation and configuration of 2/3 Node 10GR2 / 11GR2/12c RAC setups with ASM on Linux & HP-UX

Upgrade CRS / ASM / RDBMS: from 10.2.0.3 to 10.2.0.4 & 11GR1 to 11GR2, Upgrade 10GR2 (10.2.0.4) RAC setups to 11GR2 (11.2.0.4) RAC on Linux, Upgrade to 12c RAC

Dataguard 9i/10G/11G/12c: Creation / Maintenance of Physical Standby Databases,Created & administered 10g/11g/12c RAC-Standby setups Expert Level in RMAN. Use RMAN for cloning, DB refreshes, standby DB creation etc.. OEM (Oracle Enterprise Manager 10g/11g/12c), Performance Tuning using tools like statspack / AWR & SQL tuning Applying critical Patches to all components of RAC i.e CRS Bundle, Latest PSUs/CPU Patches etc. Backup & Recovery (RMAN with TSM/ Veritas Netbackup, Hot and Cold, Exp/Imp, Data Pump)

Database Upgrades: ( 8i to 9i, 8i to 10gR2, 9i to 10gR2 & 10gR2 to 11gR2 ) and Patching Oracle Installation on Unix (AIX, HP-UX, Solaris, Linux etc), Scripting ( Unix Shell )

EXPERIENCE:

Confidential

Senior Solution Specialist - Database & Cloud Platform, Austin, TX

Responsibilities:

• Senior Database Specialist with North America Public Sector Consulting at Oracle.
• Database expert in all areas of Oracle RDBMS including RAC, Exadata (X2-X7), MAA architecture, Dataguard, Oracle Cloud technologies - (PAAS/IAAS), Performance Tuning, RMAN Backup/Recovery & Enterprise Manager 12c/13c
• Consulting in Exadata, Oracle Cloud (Exadata Cloud Machine, Oracle Cloud Infrastructure, DBAAS etc.. ), Database Performance Tuning, Disaster Recovery, High Availability & Data Replication (Goldengate)
• Responsible for end-to-end PoC/PoV execution / production Deployments for Clients across US/Canada .
• Routinely assist customers that require advance resolution of database problems.
• Design and propose enterprise database solutions to customers.
• Specialize in Exadata (X2-X6), RAC version 10g-12c, Dataguard 10g-12c, OEM Cloud Control 12c/13c, Backup & Recovery, Performance Tuning
• Troubleshooting & Performance benchmarking of Oracle Databases on Exadata and Non-Engineered systems
• Create RAC-Dataguard Setups (On-Premise to On-Premise, On-premise to Oracle Public Cloud) etc..
• Perform Migration of Databases from On-premise to Oracle Cloud (OPC), Configure backups to Cloud etc
• Perform zero downtime migrations using Goldengate
• Implemented TDE for multiple customers and have done performance benchmarking

Confidential

Senior Exadata DBA Consultant / Subject Matter Expert, Boston, MA

Responsibilities:

• SME DBA for Oracle technology.
• Oracle Linux, Exadata machines (X2-X5 using ZFS storage), 11g databases, up to 8-node RAC database, up to 30TB size
• Oracle Databases migration into Exadata machine
• Oracle Data Guard (Standby): setup/maintaining environments for DR purpose
• Performance Tuning tasks
• 2nd/3rd level support
• Oracle database versions: 11g, 12c

Confidential

Senior Oracle DBA / Advisor Database Admin, RI

Responsibilities:

• SME DBA for Oracle technology.
• Participate in the development of POC of new database solutions.
• Production support DBA. Responsible for other duties/projects as assigned.
• Work closely with Database vendors, Infrastructure groups, other DBAs, and application teams to proactively develop database solutions, subject matter expertise for providing maximum benefit to CVS I/T’s operations and innovation projects.
• Proficient in Oracle Exadata based systems with expertise in migration of databases from Non-Exadata to Exadata and implementation of Exadata features.
• Oracle Exadata X3 (using ZFS storage): 11g databases, up to 8-node RAC (Linux), up to 25TB sizes
• Proficient in 10G/11G/12c RAC Installation/Maintenance and Troubleshooting CRS/Grid Infrastructure and ASM issues
• Replication using Goldengate . Zero-downtime migrations, setup Uni-directional CDC
• Configuration of RMAN backups for databases using TSM /DDBOOST. Design and Optimize backup & recovery strategy, refresh stage databases
• Creation of new RAC databases on physical servers/vmware, conversion from single instance to RAC.
• Planning and Implementation of upgrades of RAC/standalone and Databases from 11.2.0.3 to 11.2.0.4, Upgrade 11.2.0.3 RAC databases to 11.2.0.4/12.1.0.1 etc …
• Extensively working on new builds of 11gR2 RAC / RAC-ONE / Dataguard environments with ASM on Linux/AIX platforms.
• Setup and Configuration of OEM 12c . Agent installations using various methods & configuring target hosts/databases for monitoring. Set up alerts and notifications from 11g OEM
• Creation of new Disk groups, Disk addition/deletion etc…
• Performance tuning of problematic queries

Confidential

Lead Oracle DBA / Tech. Subject Matter Expert

Responsibilities:

• Handle Oncall issues and jump into Sev1 /2 calls and ensure timely restoration of database services . Take care of critical Database tasks and ensure end-to-end delivery of work .
• Extensively working on multiple 10g/11gR2 RAC environments on ASM, 10g/11g DATAGUARD setups & RMAN
• Applying quarterly PSU Patches to RAC/Non-RAC databases.
• Applying CRS Bundle patches/PSU to CRS on RAC clusters.
• Upgradation of CRS/ASM/RAC databases from 10.2.0.4 to 10.2.0.5 & 11.1.0.6 to 11.2.0.3, 10.2.0.5 to 11.2.0.3 etc..
• Upgradation of 10.2.0.4 CRS/ASM to 11.2.0.1 GRID Infrastructure
• Space Management in ASM Diskgroups, Addition of new disks etc…
• Troubleshooting RAC, DATAGUARD, and ASM issues
• Creation of new RAC databases, conversion from single instance to RAC .
• Installed and Configured 2/3 Node 10gR2/11gR2 RAC setups with ASM on Linux & HP-UX
• Configuration of RMAN backups/Monitoring for RAC databases, refresh stage databases
• Setup 11g Standby database setups, Active Dataguard
• Setup and configured OEM 10G Grid Control agent installs on servers, configure new databases for monitoring, Setup job s, alerts, notifications etc.
• Support RAC & Single Instance Production/Stage/Dev databases on VERITAS Clusters (VCS)
• Setup multiple Dataguard Setups (deployed Dataguard Broker-DGMGRL) for 2/3 Node 10g RAC Clusters, Enabled Fast start Failover
• Perform DR drills e.g Switchover/Switchback using DG Broker etc
• Upgraded RAC-Dataguard setups from 10.2.0.3 to 10.2.0.5
• Export and import of tables, schemas and Full db as per development/Application team req. using Data pump /Exp-Imp
• Configure RMAN backups for databases and schedule them through Crontab Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.
• Resolve common database issues like Locking, FreeSpace, connectivity issues,Applying patches etc…
• Performance Tuning of problem queries.

Confidential

Lead DBA / Sr. Principal DBA

Responsibilities:

• Extensively working on 10g/11g RAC, ASM & RMAN
• Install and setup 11g RAC with ASM on Linux, HP-UX platforms
• Setup and maintain Oracle Data guard (Physical) with Fast Start Failover , Active Data Guard
• Setup and maintain 11g RAC-Dataguard setups
• Installation, Administration and Maintenance, Patching, Cloning, Upgrading Oracle 11g/10g
• Creation of new Diskgroups, Disk addition/deletion etc…
• Performance tuning of problematic queries
• Creation of new RAC databases, conversion from single instance to RAC
• Refresh RAC/Non-RAC databases from production to Dev/Test/QA using RMAN
• Use Data Pump, Exp/imp for Schema/table level refreshes
• Working on OEM 10g/11g . Agent installs on servers, configure new databases for monitoring, Setup job s, alerts, notifications etc.
• Configure RMAN backups for databases and schedule them through Crontab
• Resolve common database issues like Locking, FreeSpace, connectivity issues,Applying patches etc…
• Performance Tuning of problem queries
• Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios .
• Handle Oncall issues and jump into Sev1 /2 calls and ensure timely restoration of database services .
• RMAN Catalog maintenance, purging sufficiently old backups from tapes etc.
• Troubleshooting problems of development and application teams.
• Database refreshes using RMAN backups and hot backups also .Extensively using RMAN backup & restores
• Work on Physical Standby databases in Dataguard environment and perform related activities i.e
• Perform Role Switchover for maintenance of Primary database etc
• Created physical standby setups in Dev/Production environments in
• Maximum performance/availability mode
• Troubleshooting day - to-day Standby database issues
• Day-to-Day Maintenance of multiple 10G/11G RAC environments on ASM
• Applying Patches to RAC/Non-RAC databases.
• Upgradation of RAC databases from 11.2.0.1 to 11.2.0.3 etc
• Space Management in ASM Diskgroups.Addition of new disks etc

Confidential

Sr. Oracle DBA / IT Database Administrator

Responsibilities:

• Supporting 24*7 Production databases along with development and maintenance databases.
• Proactive monitoring is done through OEM 10G GRID Control.
• Database refreshes using RMAN backups and hot backups also.Extensively using RMAN for all types of recovery/backup scenarios.
• RMAN Catalog maintenance, purging sufficiently old backups from TSM Server etc.
• Troubleshooting problems of development and application teams.
• Upgradation of databases from Oracle 8i to 9i, 8i to 10GR2, 9i to 10GR2 etc..
• Day-to-Day Maintenance of multiple 10G RAC environments on ASM
• Applying Patches to RAC/Non-RAC databases.
• Upgradation of RAC databases from 10.2.0.1 to 10.2.0.2 etc…
• Space Management in ASM Diskgroups.Addition of new disks etc…
• Configuring TAF
• Work on OEM issues i.e
• OEM Agent Installation on servers
• Configure OEM monitoring for Databases, Manage OMS Processes etc..
• Work on Physical Standby databases in Dataguard environment and perform related activities i.e
• Perform Role Switchover for maintenance of Primary database etc.
• Created physical standby setups in Dev/Production environments.
• Troubleshooting day-to-day Standby database issues
• Installation and Creation of new databases in Dev and Production environments.
• Handling Production databases on High Availability Clusters (HACMP) on Confidential -AIX platform
• Export and import of tables, schemas and Full db as per development/Application team req.
• Configure rman backups for databases and schedule them through Crontab.
• Resolve common database issues like Locking, FreeSpace, connectivity issues,Applying patches
• Performance Tuning of problem queries
• Work on Materialized views and handle related issues
• Configure Listener and tnsnames configuration and troubleshoot related issues
• Tracing problem user sessions and analyzing TKPROF reports

Confidential

Oracle DBA

Responsibilities:

• Supporting 24*7 Production databases of up to 4.3 TB along with development and maintenance databases
• Proactive Monitoring is done through tools like BMC PATROL,DBSPI
• Database refreshes(Duplicate Database) using rman backups.
• Performance tuning of problem queries
• Troubleshooting problems of development and application teams.
• Handling Standby databases (Data Guard).
• Job Scheduling through Crontab and dbms job package
• Upgradation of databases from Oracle 8i to 9i .
• Complete and incomplete recoveries using rman
• Replicating data through Materialized views
• Scheduling rman backups and other scripts in crontab
• Migration of databases, reorganization
• Configuration of tnsnames and Callout listeners
• Installation and Creation of databases
• Export and import of tables,schemas and Full db as per development team req.
• Tracing problem user sessions and analyzing TKPROF reports
• Resolving locking issues, space management, applying patches etc .
• RMAN Catalog maintenance, Purging sufficiently old backups from TSM Server etc.
• Troubleshooting problems of development and application teams.