SUMMARY

• 12 years of experience as an Oracle Database Administrator having hands on experience in Production Support, Installation, Configuration, Upgrades, Patching, Performance Tuning, RMAN Backup and Recovery, ASM/RAC Administration, Golden Gate Replication, Cloning, Space management, Database Security, Auditing.
• Progressive experience in Oracle database Design and Architect. Proven track record of providing strategic direction while deploying tactical technical solutions.
• Exceptional analytical and problem solving skills. Excellent ability to look Confidential problems from a macro level and a detailed level, always keeping the appropriate business prospective
• Excellent experience in Installation, configuration and cloning of Oracle 8i, 9i, 10g, 11g, 12c and 11g RAC and standalone in UNIX/LINUX and Windows 2008/2012
• Duties included installation, patching, upgrading, performance tuning, space allocation and maintain Oracle Server according to Oracle OFA Standards.
• Good hands on experience and working on oracle 10gR1, 10gR2, 11gR1, 11gR2 RAC, ASM and Data Guard.
• Expert with Data Guard, creation of Physical standby and resolving the gaps between primary and physical standby databases.
• Good experience in working with Data Replication tool Materialized Views, Data Guard, and Golden Gate
• Build - Installation, configuration, upgrading and migration across platforms of Oracle (9i, 10g &11gr2 RAC- DATAGUARD).
• Work with (VLDB) Very Large Databases such as multi-terabyte Databases.
• Hands-on experience in Planning & Designing Oracle Backups and Recovery strategies like RMAN, export/import, Data pump, Hot/Cold Backup &Logical &Physical Backup
• Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability.
• Large high volume site experience with database monitoring and tuning on OLAP 24*7*365 systems.
• Work with Architect and planning teams to identify right technology investments and technical architectures upgrades.
• Active participation in Data Centre Migration
• Perform Data file recovery from logical and physical block corruptions
• Knowledge on Designing and implement database structures for all instances of Meter data management (MDM ) and Meter Asset Management (MAM)
• Expertise on Cluster management, event management, application management, connection management, storage management, load balancing and availability.
• Hands on experience with Switchover/Failover activities
• Expertise in performance- tuning, SQL tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL, TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN
• Experience in platform migration from Sun Solaris to HP Linux using traditional export/import and datapump utilities

TECHNICAL SKILLS

Database Admin: ORACLE 12c,11gR1, 11gR2,10g/9i, EXADATA

RDBMS: Oracle, Microsoft SQL Server, MySQL, DB2

High Availability: 10G,11G,12C, RAC, Data Guard, ASM, Golden Gate

Languages: SQL, PL/SQL, Shell Script, C

Operating System: LINUX (4.x, 5.x, 6.x), Sun Solaris 8/9/10, SuSE Linux Advanced Server, and HP-UX 10/11.x, IBM AIX 5.1, 5.2, 5.3 & Windows Server 2003/2000/NT

Development Tools: SQL Developer, Toad, SQL*plus, SQL* Loader

Database Tools: SQL*PLUS, TOAD, Putty, OEM( 11g & 10g), RMAN, EBU, SQL* LOADER, imp, exp & Data pump (expdp and impdp).

Web Tools: IMPACT, Rational Clearcase, Clear Quest, Remedy

Web Technologies: Html

Ticketing Tools: Remedy, Impact, JIRA

Tuning Tools: TKPROF,EXPLAINPLAN,STATSPACK,AWR,ADDM, ASH,OEM

PROFESSIONAL EXPERIENCE

DB2 Database Administrator

Confidential

Responsibilities:

• Responsible for interacting with the client on a daily basis and understand the current problem and future requirement.
• Provide technical solution (enhancement of existing functionality/ propose new functionality) to client. This requires frequent face to face interaction with the client also be responsible for performing technical risk assessment and prepare the mitigation plan accordingly (both proactively and reactively). Provide technical guidance to team members and developers.
• Perform consolidated health check reports for the entire application which includes Database server utilization and generating reports for the underlying database, Web Sphere Portal database health check and bellow mentioned activities
• Analyse the bottlenecks and performance issues and provide resolution with efficient database, query tuning for smoother functionality of database with best response time.
• Analyse and resolving any technical issues in the applications related to the Project.
• Working with DB2 utilities for maintenance (Reorgchk/Reorg/Runstats), data movement (Export/Import/Load/Move/Look)
• Perform Backup and restore databases and Deployments
• Monitor the performance of the system and resolving any issues to ensure stable performance.

Environment: DB2 v9.7.0.1 AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, MQ, WebSphere, CURAM and Hadoop

Oracle Database Administrator

Confidential, Dallas, TX

Responsibilities:

• Handlle high availability (24/7) database in onshore-offsite model
• Creation and Maintenance of 8 Node RAC 12C production database with 65 TB size of data
• Creation of Physical standby database for PRODUCTION environments.
• Involved in 24x7 production support for 180 Oracle databases and 60 Sql Server Database and Applications Administrator
• Involved in the project of creating and supporting new DEV, SIT, UAT, BAU, TechTest and Prod /DR Oracle 11.2.0.3 databases
• Create new Cluster environments, ASM and databases as per the requirements.
• Involved in Implementing Oracle Golden gate between Production databases Active - Active configuration with CDR implementation.
• Migration of around 2000 Schemas across 65 prod databases to New 8 Node 12c PROD RAC database
• Creation of Deployment plans for the Cut overs activities

Environment: Oracle 10g, 11g, 12C, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux( RHEL 4.x, 5.x 6.x), Sun OS 5.8/5.9/5.10 , AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Oracle Database Administrator

Confidential, Dallas, Tx

Responsibilities:

• Involved in 24*7 production support for multiple Oracle and SQL Server databases
• Develop, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 11g/10g databases
• Handling high availability (24/7) database in onshore-offsite model
• Responsible for Installation, Up-gradation, Migration, Applying Patches, Cloning
• Configure Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.
• Implement and maintain database structures for all instances of Meter data management (MDM ) and Meter Asset Management (MAM)
• Work with multiple teams for to Maintain complete data for MDMS databases ( Command centre and LCIS )
• Work with Maximo implementation teams for MAM database instances maintenance and support.

Environment: Oracle 11g/10g, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Confidential, Dallas Texas

Oracle Database Administrator

Responsibilities:

• As a Oracle DBA my role was to support Client's Production and Development databases
• Supporting/monitoring 3-node Production Oracle 11g RAC on Oracle Cluster ware platforms on high availability environment and writing shell scripting for various database maintenance and alerting activities
• Creating RAC databases in various environments when ever required.
• 365 X 24/7 Production support and deployments of new releases.
• Maintained large sized prod and Disaster recovery databases of around 35 TB size
• Creation of New Cluster environments, ASM and Databases
• Created new ASM disk groups using RAW disks, LUNS and adding, dropping disk members from ASM.
• Working extensively with Oracle support for Sev 1 issues like Datafile corruption, Block corruption problems in Production environment.

Environment: Oracle 11g/10g/9i, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux(RHEL 4.x,5.x),Sun OS 5.9/5.10, AIX OS 5.1,5.2,5.3, Toad, Performance Tuning Shell Scripting, PL/SQL, SQL*Plus.