Over 15 years of experience Lead Oracle RAC DBA.

• Proficient in installing, upgrading, migrating, configuring and supporting Oracle Databases 7.x/8.x/8i/9i/10g/11g.
• Provided on call support/performance tuning troubleshooting.
• Oracle Exadata Database Machine
• Implemented Rollout Projects Mexico / Canada Implementation projects , IPAY/SSL and Advance collections
• Experience in CPU PSU patches / 11g upgrade
• Followed Oracle's best practice methods for standardization OFA implemented and performance.
• Exposure on working Mission critical environment DDW loads
• Advance security option implemented. Secure Backup at Disk and Tape backup by using RMAN. Transparent Data Encryption at column level implemented. Protect application schemas from system privileges. Comprehensive Audit Policy as per SOX complaint implemented. Database Vault. Oracle Label security. oracle Wallet implemented. Roles and Policy created.
• Attended crisis call handled escalation independently.
• Planned shift schedule and coordinated with the offshore team.
• Worked closely with the Tech Functional team to troubleshoot and resolve critical issues.

Qualities

• Mentored team attended team meetings participated in team building activities.
• Out of box thinker/ troubleshooter and team energizer/player.
• Enthusiastic in learning new skills, adapting to new processes and sharing ideas.
• Committed to delivering results and meeting project deadlines.
• Taking Complete Responsibility of tasks bringing them to closure.

Technical Skills

Professional Experience:

Confidential

Role: Senior Oracle DBA

Project Description:

• Production and Project Support.
• Worked in RAC multinode environment
• Global Implementation of EBS 12.1.3 and database 11.2.0.3 on Exalogic 2.0 and Exadata 2.2 servers.
• Database Tier: Implemented via two node Real Application Cluster RAC and Automatic Storage Management ASM disk management
• Patching / Cloning / SQL Performance tuning / providing support to Release Management team during Production migration.
• ExaData - OEL 5.5 Linux x86-64 4 Database Nodes - 12 Cores/Node
• 50 TB Usable Storge 1/2 Rack ,
• ExaLogic - OEL 5.5 - linux x86-64 Qtr Rack Exalogic - 8 compute nodes
• 12 cores/Node - Sun ZFS Storage 1/4 RACK exalogic. HP - Quality center 11.0
• Remote Desktop Manager - 9.1.4.0

Confidential

Role :Lead DBA

Team :5 1 onsite 2- Mexico 2 India

Description:Production and Project Support Involved in the Multinode environment.oResponsibilities:

• Implemented 11gR2 upgrade 64bit from 10.2.0.4 64 bit - Data migrated from 10.2.0.4 to 11.2.0.3.0.6
• Worked on SSL Implementation.
• Best practice methods adopted during Backup Recovery.
• Worked on DB clones.
• Troubleshooting various issues during go live projects/ Code moves. Involved in custom Code moves during Qtr releases

l

Provided

Production support for RAC and non-RAC during go live activities.

l

Applied

- CPU patches/PSU patches in 10g/11g environment.

• Oracle Configuration Manager implementation / SQLT implemented for sql query tuning
• Involved in the Performance tuning activity by using various tuning tools.
• Strong experience in database administration on 11g, 10g and 9i,
• Exposure on Weblogic Administration, Monitoring and Troubleshooting using Admin Console and Fusion Middleware Control / 10gAS, Oracle Fusion Middleware Technologies.
• Migrating databases to Oracle Exadata Database Machine for different clients.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing RAT
• Implementing Best Practices for regular databases to Oracle Exadata

Environment:

Sun Solaris 8, Oracle 10.2.0.2/10.2.0.4, 11g Exadata X2-2

Confidential

Confidential

o Role: Lead ERP DBA

o

Team size : 10 2 onsite and 8 offshore

o

Description: Production and Project Support Involved in the Multinode

RAC environment.

Responsibilities:

• 10g Installation and Production Support 24 7.
• Logical and Physical design of Database.
• Extensive experience with Oracle DBMS 9i and 10g in RAC Environment. Responsible for ensuring High availability and performance of the databases to support the system.
• Assists in the planning, implementation, integration and maintenance of the hardware and software infrastructure supporting a wide variety of applications.

Environment:

HP-unix / EMC SAN 9i and 10g RAC on a DMZ Environment Multiple Internet and Intranet Middle Tier Nodes

Confidential

Confidential

o Role: Project Lead

o Team size: 8 2 onsite 6 offshore

o Responsibilities:

l

Supported and

Implemented oracle-based applications.

l

Implementated

automating cloning

process of production instance to Reporting instance.

• Regular DBA activities, performance tuning , administering the GIEA suite of tools, user support etc.
• Disaster Recovery plan strategy and implemented Physical standby database / Datagaurd
• DBA tasks like clones/Patches/Backup and recovery / Monitoring / troubleshooting Database.
• Production 24 7 support.

Environment:

Solaris 5.9 Hitachi showdown Imaging Oracle DB 10.2.0/9i /forms 6i /Report 6i Appworx 6.1 / legacy Press / Loftware label print / Noetix V - 5.2 Views and EUL generator / Discoverer / OEM /Kintana Object Migrator /Option

Confidential

Role:Principal Consultant/ Sr. Apps DBA - Team size of 10

Responsibilities: GLM Project

• Exposure in 10g RAC installation/DB creation in RAC
• Administrating RAC like enabling disabling instances, working with spfile in RAC
• Environment, archiving schemes in RAC and Managing of OCR and Voting Disk Adding/Removing .
• High availability connections configuration like Configure Transparent Application failover TAF
• Involved in the Migration of RAC Single instance to multi-instance
• Adding deleting nodes in existing RAC. - Involved in the cloning and Patching
• Provided Support 24 7 production Database.

Responsibilities:

GE Project

• Primary DBA Activities for 35 databases, handling various alerts, backups, refreshes, migrations, loads and routine checks, tuning and recommending new features / upgrades.
• Supported more than 250 Prod/ test/ dev database for different application running in GE Corporate on Oracle7.x/8.x/8i/9.0/9.2 with Sun Solaris 8, Linux, Digital and NT boxes.
• Provided On call DBA 24x7 weekly support to the entire Oracle environment in CIS resolving production database issues over bridge calls.

Upgraded 15 databases from 7.x, 8.x, 8i to 9.2.0.2, 9.2.0.4, 9..0.5. And 10g 10.2.0

Environment :

Oracle DB 8.x/9i/10g on Solaris 8/RAC environment