SUMMARY:

• Around 8 years of experience in the area of maintaining “Relational database management systems”. Successfully managed multiple versions Oracle, SQL Databases in mixed OS environments, demonstrate a consistently strong work ethic and capable of delivering timely results, possess strong analytic and problem solving skill, On - call support and Team leading skills.
• Handled around 800 servers running 1000+ databases in multiple environments. Handled Oracle 12c, 11g, 10g, 9i production databases.
• Configured GoldenGate 12.1.2.0.0 and replicated tables, schemas and performed Db Migration.
• Implemented Oracle GoldenGate Veridata and configured alerts to monitor extract and replicat processes.
• Proficient in Installation, Configuration, Maintenance and Tuning of 11g/10g/9i Linux and Windows Platform.
• Experience in 10g, 11g RAC Implementation, Administration and configuration. RAC installation on ASM.
• Have knowledge on Oracle Applications Ebusiness Suite R12 and performed DB Refreshes and EBS Cloning (11i/R12).
• Implemented Backup & Recovery strategies using RMAN and Logical backups for Oracle databases. Applied PSU Patches and Upgraded Production databases from 10g to 11GR2.
• Basic Knowledge on Apache Cassandra 3.0 version, MongoDB and SQL Server 2003.
• Monitoring Databases using OEM and performed OEM upgradation to 12.1.0.5.
• Experience in configuration, maintenance, switchover and failover of standby database/Data Guard.
• Cloning and Re-building the databases from Production to other Environments in a short time. RMAN cloning and Data Replication using GoldenGate 12.2.0.1.
• Sound knowledge of Linux, IBM-AIX, HP-UX, Solaris and Windows OS.
• Knowledge on Unix Shell Scripting and rewriting and editing database scripts.
• Excellent Communication and Interpersonal Skills. Strong technical skills combined with customer support and customer interaction skills
• Good understanding of ITIL Processes-Incident, Change and Problem Managements.

TECHNICAL SKILLS:

RDBMS: Oracle 9i, 10g,11g, 12c Multitenant Architecture, 11g Real Application Clusters (RAC), SQL 2003

ERP MODULE: Oracle Apps R12 EBS, SAP Basis

Middle Tier: Oracle Application server 10g

OPERATING SYSTEM: Linux, HP-UX, Sun Solaris, IBM-AIX and Windows

Oracle Tools & Utilities: RMAN, Export-Import, Datapump, OPatch, Tkprof,OEM12c Grid Control

TOOLS: Remedy, Service Now, TOAD, GoldenGate, Shareplex, Actifio, Delphix, GoldenGate Veridata.

Shell script: Unix shell scripting

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA Engineer/ Oracle Apps DBA

Responsibilities:

• Upgrading databases from 10 to 11g and 11g to 12c Multitenant Architecture.
• Performance Tuning and working with Oracle Support for Sev 1 related issues..
• Adding, removing disks from ASM disk groups.
• Using SPM 11g, SQL Tuning Advisor feature for performance tuning
• Working on POC/SOP’s for new Software Implementation.
• Proficiency in creating technical project documentation.
• Done daily DBA checklist for the non-prod environments and prod environments.
• Tracing Concurrent Programs, Forms Sessions (FRD) and User Sessions and widely used Tkprof to analyze traced files.
• Assisted in integrating Oracle E-Business suite instances with SSO.
• Worked with the Oracle Apps team on patching and job scheduling.
• Applied patches on Test, Development and Production instances using adpatch utility.
• Solving issues in case of a Backup failure, manually running the same
• Creation of RMAN catalog and automated the creation process using Shell script.
• Worked on database schema refreshes based on the requests from developers.
• Working on issues on Dataguard like resolving Archive log gap on Primary & Standby DBs
• Identifying Locks at DB level/Object Level and killing the same.
• Troubleshooting Performance issues at full DB Level.
• Actively participated on client calls/Meetings.

Confidential, Texas

Oracle DBA

Responsibilities:

• Analyzing and fixing of CPU run away process Issues, CPU busy, CPU utilization issues.
• Worked on various database alert log errors.
• Handled Blocking session Issues, Swap utilization, Invalid objects count
• Setup and configured 2 node Oracle 10g RAC with ASM.
• Troubleshooting RAC 10g and 11g Node eviction issue.
• Resolving some tuning issues on Locks or index statistics, Slowness and Hang issues.
• Expert in Patch sets, PSU, CPU.
• Creating and Managing Standby databases, Failovers and Switchover.
• Worked on job failed issues, DBA broken jobs, library cache issues
• Index Rebuilding (Normal / Partitioned), Table Reorg, Segment Shrinking, etc.
• Cloning the instances using Rapid clone utility from production to test instance, Development to test instance.
• Changing the initialization parameter values on requirement like db files value reached, etc.
• Collecting various advisories/reports like Segment Advisor, Undo Advisor, etc.
• Answering to customer queries related to performance issues, Performance Tuning
• Analyzing statspack reports, AWR, ASH
• Worked on various HA (High Availability) methods like, OS clustered standby, Physical standby, Real Application Cluster Environments.
• Unusual tablespace growth issues.
• Multiplexing redolog members, adding new redolog group, changing controlfile location.

Confidential

Oracle DBA

Responsibilities:

• Installing, configuring of Oracle 9i, 10g software and related products on test Server.
• Checking Alert Log analyzing for errors and making necessary actions to rectify them.
• Killing unwanted user sessions or processes.
• Perform Restore / Recovery on need basis.
• Gathering the table statistics.
• Performing RMAN and Logical Backups.
• Monitoring the size tablespaces and Archivelogs.
• User account creation and maintenance.