Gandhimani Subramaniam

Email : acp58g@r.postjobfree.com,

Phone : +1-469-***-****

Experience Summary

I am working as Oracle Database Administrator over 9 years. My main area of experience has been administrating business critical databases, installation and configuration of oracle, creating and upgrading databases. My technological forte is Oracle from versions 8i to 11GR2.

In-depth knowledge and experience in full life-cycle database including data architecture, logical and physical database design, implementation, and administration

Experienced in database administration of 8i/9i/10g/11g databases on heterogeneous and complex Datacenter environment

Experienced in Migrating databases from file systems to ASM

Experienced in implementing Real Application Clusters (RAC) on a variety of Oracle versions (10G,11GR1 & 11GR2) on Linux

Experienced in upgrading databases from one version of oracle to higher version

Capacity planning of critical production databases

Experienced in configuring Disaster Recovery Site for single instance and RAC databases

Experienced in various scenarios of Database Recovery and troubleshooting

Experience in Replicating/Cloning of production databases for creation of DEV/UAT environments

Solid skills in database optimization and performance tuning for servers, applications, and SQL queries

Applying the CPU/PSU patches to fix the existing bug as per the Business policy

Installation, Configuration, Administration and Patching of Grid Control / Oracle Management Agents

Experience in data migrations using data pumps between various environments

Implemented partitioning for better load balancing of data and to ease data purging in archival activities.

Experience in Implementing RMAN backup with Recovery catalog and optimizing the backup timing and utilization of backup resources and fast recovery of the system in case of Failure.

Experienced on implementing the Outline(9i) and AWR baseline (10G and above) for making the database plan consistency and improving the Query performance.

Implemented Bi-Directional replication between 11gR2 databases using Goldengate.

Experience with Oracle Enterprise Manager Monitoring/Performance Tuning/Real Time Advisor.

Experience on SQL Performance analyzer(SPA) and SQL Plan Management (SPM)

Experience using TOAD and SQL developer for database activities and monitoring.

Technology

Below is a list of important hardware, software products, tools and methods that I have worked with.

Software Products,

Oracle 8i / 9i/ 10g/11gR1/R2 SQL / PLSQL

Tools

SQL *Plus, OEM, TOAD, RMAN, Exp / Imp, SQLDR, PLSQL Profiler. Oracle Enterprise Manager.

Operating Systems,

Redhat Linux and Suse Linux.

Experience:

ATT – Dallas,TX

Senior Oracle DBA Dec 2014 to Till date

Responsibilities

Provided 24 X 7 Production support.

Implemented 2-node 11gR2 RAC in Production environments and administration with ASM.

OEM 12c (12.1.0.2) grid control setup with High availability at OMS level (2 node Active/Active OMS).

Performed following in OEM 12c administration - installing agents on targets, discovering the targets, installing plug-ins on OMS and agents, applying patches on OMS, OMR and agents, creating groups, creating incident rule sets for groups, creating and applying templates, creating metrics extensions, creating system and configuring services for each application.

Applied patches for 11gR2 RAC databases

Replication tool. Supported a large number of Development Databases.

Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.

Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes

Linux and debugging Golden Gate issues such as extract, replicate rebuild and abend.

Performed Backup and Recovery using RMAN and written shell scripts for scheduled online backups.

Troubleshooting RMAN backup and recovery related issues.

Migrated 10g database from Windows to Linux platform.

Converted a single instance database to Oracle RAC 11gR2

Setup of Standby database for faster disaster recovery and data guard setup for high availability.

Performed Cloning, export/import and Patching.

Implemented Golden gate replication with BATCHSQL to improve the performance of the existing replication process

Servicelinkfnf.com Aliquippa, PA.

Senior Oracle DBA Jan 2013 to Nov-2014

Responsibilities

Provided 24 X 7 Production support.

Implemented 2-node 11gR2 RAC in Production environments and administration with ASM.

OEM 12c (12.1.0.2) grid control setup with High availability at OMS level (2 node Active/Active OMS).

Performed following in OEM 12c administration - installing agents on targets, discovering the targets, installing plug-ins on OMS and agents,applying patches on OMS, OMR and agents, creating groups, creating incident rule sets for groups, creating and applying templates, creating metrics extensions, creating system and configuring services for each application.

Applied patches for 11gR2 RAC databases

Implemented Bi-Directional replication between 11gR2 database using Goldengate.

Implemented Golden Gate for Standby Configuration and developed procedures for Replication.

Performed data replication, transformation and delivery of database transactions using Golden gate

Replication tool. Supported a large number of Development Databases.

Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.

Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes

Linux and debugging Golden Gate issues such as extract, replicate rebuild and abend.

Implemented Golden Gate for Standby Configuration and developed procedures for Replication.

Performed data replication, transformation and delivery of database transactions using Golden gate

Replication tool. Supported a large number of Development Databases.

Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.

Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes

Linux and debugging Golden Gate issues such as extract, replicate rebuild and abend.

Performed Backup and Recovery using RMAN and written shell scripts for scheduled online backups.

Troubleshooting RMAN backup and recovery related issues.

Migrated 10g database from Windows to Linux platform.

Implemented 11gR2 Active Dataguard for disaster recovery.

Converted a single instance database to Oracle RAC 11gR2

Setup of Standby database for faster disaster recovery and data guard setup for high availability.

Performed Cloning, export/import and Patching.

OEM SQL monitoring used to monitor and identify the performance issue.

OEM SQL Tuning advisor used to fine-tune the Real-time and history queries.

Used OEM ASH analytics and real time ADDM advisor.

Used OEM SQL access Advisor to rewrite the Query.

Used AWR for analyzing the performance bottlenecks

Using Oracle Enterprise Manager Created SQL profile for Query optimizations

AWR baselines created using Oracle Enterprise Manager for Query plan fixing.

Experience on SQL Performance analyzer(SPA) and SQL Plan Management (SPM)

Frontier Communication – Dallas-TX

Production Database Administrator Nov-2010 – Dec-2012

Responsibilities

Managing and maintaining more than 20 production databases

Installation of Oracle 11.2.0.1 Grid infrastructure and Oracle Database.

RAC 10R2 & 11gR1 (Grid Infrastructure 11gR2) administration and maintenance

Performed data migrations using data pumps, and transport tablespace between various environments

Installed and configured all systems with 11G oracle Grid control monitoring

Configuring alerts for DB health check, generating snap reports on regular basis and for monitoring space usage.

Developing archival policies in coordination with business.

Developed capacity planning by observing the trend of DB growth.

Configuring Migration databases for dry run.

Implementing partitioning for better load balancing of data and to ease data purging in archival activities.

Application and SQL performance tuning using TOAD DBA manager.

Used TOAD Database Monitor for review database performance.

Analyzed performance issue and created indexes based on application Query.

Trouble shooting 24*7 production environment issues.

Implementing Security features as specified by the Client’s Security policy.

Configured Recovery Manager for Backup & Recovery of Development / Testing Environment

Applying the CPU/PSU patches to fix the existing bug as per the Business policy

Installation, Configuration, Administration and Patching of Grid Control / Oracle Management Agents

Managing the Oracle Golden Gate replication process.

Used AWR for analyzing the performance bottlenecks

Using Oracle Enterprise Manager Created SQL profile for Query optimizations

AWR baselines created using Oracle Enterprise Manager for Query plan fixing.

Experience on SQL Performance analyzer(SPA) and SQL Plan Management (SPM)

Wipro Technologies – Nortel- Project Bangalore India.

Database Administration Sep–2004 to Oct -2010

Project:- CSE 1K product of Nortel -Database Administration Upgrade of databases from 9.2.0.8 to 10.2.0.4

Responsibilities

Prepared plan for Up gradation along with time lines

Performed upgrade in POC environment

Installation of Oracle 10.2.0.4 and upgraded the database

Building load test environments by migration/cloning DB’s across servers

Project:- CSE 1K product of Nortel -Database Administration (Sep-2004 to Oct-2010)

Responsibilities

24*7 production Support for production systems

Installation of Oracle 8i/9i/10g and database creation

Monitoring space, wait events, locks and long operations running on the database

Monitoring the alert log for the database performance and resolving the performance issues.

Generating stats pack reports on regular basis to identify the database performance at peak load

Tuning the SQL statement by analyzing the explain plan and ADDM reports

Implemented scripts to monitor and get information on free space, alert log errors

Design & developed PL/SQL Stored Procedures & Database Triggers to Implement Business rules & Security.

Reorganized the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.

Migrated the data from one database to the other using RMAN and Export / Import Utility.

Backup and Recovery of databases using Recovery Manager.

Education

MS from BITS, Pilani in 2008.

BCA from Bharathiyar University passed out in 2004.

Contact this candidate