SUMMARY

• Over 10 years of experience as Oracle DBA and 4 years as Database Machine Administrator (Exadata).
• Worked extensively on Oracle 12c, 11g, 10g, 9i, 8i and Exadata Database Machine, involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, replication, database security, cloning, space management and also, I experienced using Oracle VM on an Exadata Database Machine
• Working as a part of team and providing 24x7 supports on a Production database and System support environment.
• Worked onsite in Australia to Migrate Oracle database’s to Exadata Server’s
• Experience in managing databases under various environments.
• Excellent knowledge of 10g, 11g architecture, good understanding of new features.
• Monitoring and maintaining Oracle cluster DB’s for their Optimal Performance and ensuing 100% availability of the DB’s.
• Deep dive into problems using OEM12c and AWR, AWR Diff reports to pinpoint problems
• Install, configure and troubleshoot Oracle 12c/11G R2 RAC databases on Exadata Machine
• Managing Oracle Exadata servers X2 - 2, X3-2, X4-2, X5-2, X6-2 servers on various rack’s environment.
• Implemented GoldenGate replication (unidirectional, Bidirectional & peer to peer configuration of Oracle 12c and 11g).
• Troubleshooting GoldenGate replication issues in prod and non-prod servers.
• Hands on experience on Exadata Patching and Exadata machine backup and restore procedure
• Good experience in Exadata Storage Server Administration and Exadata network monitoring and troubleshooting.
• Experience in Oracle Spatial and Graphs
• Support databases in Exadata environment and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues
• Assisted in management and database administration of Oracle database applications on Exadata platforms
• Worked on large-scale databases with size more than 20TB in large system environments
• Executed processes for evaluation of system space, database allocation and storage metrics.
• Monitoring the InfiniBand Switches/ports, HCA ports on DB/CELL nodes and IB topology
• Implementation and maintaining Database Security (create and maintain users and roles, assign privileges).
• Troubleshooting InfiniBand/RDS performance issues
• Knowledge on Oracle Exalogic or any other oracle engineered systems Super clusters.
• Well verse with recovery procedures in archive and no archive database log mode.
• Strong at Database backup and Recovery using RMAN.
• Setup configure support Oracle standby databases on multiple locations using Oracle Data Guard and Active Data Guard in Oracle 11g/12c
• Implemented Disaster Recovery Solutions using Oracle Active Guard technology.
• Resolving Oracle database performance tuning issues. Creating Profiles to stabilize SQL plans.
• Reorganizing of database, Rebuilt of index.
• Experience working with SQL Tuning tools like SQL Trace, Explain Plan and SQL profiles.
• Expertise in Tuning Memory, I/O and CPU Utilization, Disk Usage and Space Utilization.
• Handled multiple Microsoft SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning
• Good knowledge on Oracle Networking.
• Troubleshooting day to day issues in RAC environment.
• Switchover, Failover, Activating the Standby to Primary and No data loss.
• Applied Patches and upgraded the databases
• Involved in Migration of a non RAC database to 10g RAC database using Rconfig tool.
• Experience in configuration and troubleshooting DataGuard. (Standby).
• Setting up OEM and installing agents on servers.
• Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM.

TECHNICAL SKILLS

Operating systems: Linux (Red Hat & Oracle Enterprise Linux), Windows, SolarisHP-UX, Confidential -AIX

Databases: Oracle 8i/9i/10g/11g/12c, MS SQL Server 2008

Appliances: Oracle database Appliances, Exadata V2/X2/X3/X4/X5/X6

High Availability: Oracle Database 10g, 11g and 12c Real Application Cluster and on an Exadata Database Machine.

Replication: Oracle Streams, Materialized View, GoldenGate, and Oracle DataGuard.

Tuning Tool: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDMSQL PROFILES

DB Monitoring Tool: Oracle Enterprise Manager (OEM), Enterprise Manager Grid Control, Enterprise Manager Cloud Control, Toad

DB Backup & Recovery: Recovery Manager (RMAN), Datapump and Export, Import, ZFS storage snapshots.

Data Loading: Datapump, Export and Import, SQL Loader and External table.

PROFESSIONAL EXPERIENCE

Confidential, MI

SENIOR DATABASE ANALYST

Responsibilities:

• Monitoring and maintaining Oracle cluster DB’s for their Optimal Performance and ensuing 100% availability of the DB’s.
• Configured Data Guard and tested for failover & switchover.
• Configured Data guard for production Database
• Taking backups using RMAN.
• Performed Node Eviction issues.
• Patched and upgraded 11.2.0.2 databases to 12.1.0.1.
• Implemented GoldenGate replication (unidirectional, Bidirectional & peer to peer configuration of Oracle 12c and 11g).
• Troubleshooting GoldenGate replication issues in prod and non-prod servers.
• Support databases in Exadata environment and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues
• Assisted in management and database administration of Oracle database applications on Exadata platforms
• Setup 12c databases in preparation for migration from 11g.
• Setup 2 node and 3 node RAC databases.
• Move 15TB 11g standalone database to 11g 5-node RAC.
• Perform Performance Tuning analysis and resolution.
• Deep dive into problems using OEM12c and AWR, AWR Diff reports to pinpoint problems.
• Assist development teams in SQL plan analysis and performance improvement.
• Setup 200 targets on OEM 12c.
• 24/7 On-call rotation.
• Assisted Oracle Engineer in replacing the Disk’s and Server Batteries.
• Monitoring the InfiniBand Switches/ports, HCA ports on DB/CELL nodes and IB topology
• Planning Recovery Procedures and Performing backups in both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Maintenance: Setup corn jobs to monitor database status and to alert on-call DBA, to backup databases, to monitor space usage, and to generate status reports. Refresh non-production databases using Oracle export and import, using RMAN restore and recovery. Provide 24/7 general database support.

Confidential, NY

Lead Administrator

Responsibilities:

• Monitoring and maintaining Oracle cluster DB’s for their Optimal Performance and ensuing 100% availability of the DB’s.
• Configured Data Guard and tested for failover & switchover.
• Configured Data guard for production Database
• Taking backups using RMAN.
• Performed Node Eviction issues.
• Patched and upgraded 10.2.0.1 databases to 10.2.0.4.
• Support databases in Exadata environment and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues
• Assisted in management and database administration of Oracle database applications on Exadata platforms
• Executed processes for evaluation of system space, database allocation and storage metrics.
• Monitoring the InfiniBand Switches/ports, HCA ports on DB/CELL nodes and IB topology
• Troubleshooting InfiniBand/RDS performance issues
• Performed Database Cloning from Production to Test environment.
• Performed Query Tuning by Explain Plan and Tkprof utilities.
• Used ADDM for taking the advisories.
• Monitoring and optimizing the performance of the Database through AWR.
• Implemented ASMM feature in Memory Tuning.
• Incorporating user’s requests as per mails.
• Monitoring and Reorganizing Database Objects Tables & Indexes to minimize fragmentation in the database using logical backup and restoration. (Export and import) and Datapump.
• Backing up database using export/import.
• Maintenance and monitoring of Database and Listener.
• Checking Alert log, trace files, listener log and other database job logs.
• User creation and providing necessary Roles, Privileges and quota as per the Requirement.
• Resolving user’s day-to-day issues.
• Consistently interacted with client and team in resolving the queries.
• Performing RAC Health check on cluster.
• Monitoring the storage capacity of file systems and table spaces.
• Planning Recovery Procedures and Performing backups in both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage

Confidential, NY

Senior Oracle DBA

Responsibilities:

• Monitoring and maintaining Oracle cluster DB’s for their Optimal Performance and ensuing 100% availability of the DB’s.
• Configured Data Guard and tested for failover & switchover.
• Configured Data guard for production Database
• Taking backups using RMAN.
• Performed Node Eviction issues.
• Patched and upgraded 10.2.0.1 databases to 10.2.0.4.
• Support databases in Exadata environment and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues
• Assisted in management and database administration of Oracle database applications on Exadata platforms
• Executed processes for evaluation of system space, database allocation and storage metrics.
• Monitoring the InfiniBand Switches/ports, HCA ports on DB/CELL nodes and IB topology
• Performed Index Rebuilding
• Incorporating user’s requests as per mails.
• Backing up database using export/import.
• Monitoring and Reorganizing Database Objects Tables & Indexes to minimize fragmentation in the database using logical backup and restoration. (Export and import) and Datapump.
• Planning Recovery Procedures and Performing backups in both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.

Confidential

Oracle DBA

Responsibilities:

• Monitoring and maintaining Oracle cluster DB’s for their Optimal Performance and ensuing 100% availability of the DB’s.
• Configured Data Guard and tested for failover & switchover.
• Solving the Replication and streams issues on the Database.
• Configured Data guard for production Database
• Taking backups using RMAN.
• Performed Node Eviction issues.
• Patched and upgraded 10.2.0.1 databases to 10.2.0.4.
• Performed Database Cloning from Production to Test environment.
• Install and configure Two node RAC 11gR2 (11.2.0.3) on Oracle Database Appliance (ODA) Release 2.2 for Linux x86-64.
• Performed Query Tuning by Explain Plan and Tkprof utilities.
• Used ADDM for taking the advisories.
• Monitoring and Reorganizing Database Objects Tables & Indexes to minimize fragmentation in the database using logical backup and restoration. (Export and import) and Datapump.
• Backing up database using export/import.
• Maintenance and monitoring of Database and Listener.
• Checking Alert log, trace files, listener log and other database job logs.
• User creation and providing necessary Roles, Privileges and quota as per the Requirement.
• Decommissioning of Schema's as per approved requests.
• Resolving user’s day-to-day issues.

Confidential 

Associate Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle 11g on Linux.
• Managing data file objects including table space and data files, object sizing as well as monitoring database usage and growth.
• Performing status checks by monitoring the Alert log, Trace files of the database.
• Looking into action requests (tickets) and resolving issues, providing the root cause, providing the permanent fix.
• Monitoring and Reorganizing Database Objects Tables & Indexes to minimize fragmentation in the database using logical backup and restoration. (Export and import) and Datapump.
• Responsible for creating user logons and managing user accounts.
• Monitor the instance and plan for future availability of storage on user’s table spaces.
• Adding space to the data files according to table space growth.
• Backup and Recovery strategies for Oracle database using RMAN, exp/imp, Cold and Hot backups.
• Modifying Oracle parameter (init.ora) for Oracle performance and growth.
• Performed Database Cloning from Production to Test environment.
• Performed Query Tuning by Explain Plan and Tkprof utilities.