SUMMARY

• Having 9+ years of experience as an Oracle Applications Implementations and administration of Oracle Databases 9i/10g/11g/12c, Oracle Applications 11i/R12.1 R12.2, and Oracle Fusion Middleware.
• Experienced in Installation, Configuration, Patching, Cloning, Sysadmin, Concurrent manager, users and security and up gradation of Oracle E - Business Suite 11i/R12.
• Experienced in Patching using Adpatch, Adopatch.
• Performed Cloned application database from singe node to multi node system using Rapid clone
• Good Experienced on performance tuning of Concurrent programs, Concurrent Mangers.
• Expertise in performance tuning of large databases.
• Implementation of High Availability solutions with Oracle 10g/11g/12c RAC with ASM, Physical and Logical Standby Databases (Data Guard).
• Migration of Oracle Application 12.1.3 with Database 11.2.0.4 on HP-UX to Oracle Database Appliances (ODA).
• Primarily responsible in designing Architecture for Applications on ODA.
• Experience in E-biz Database upgrade from 10g to 11g R2 .
• Experience on OEM (12.1.0.4, 12.1.0.5) Installation, configuration, monitoring admin tasks..
• Experience on Create objects like Table spaces, Segments, User management, Networking and security.
• Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump,
• Experience working with Oracle Identity Manager, Access Manager and Internet Director.
• Good knowledge on OAM,ODI,OEM, flat forms
• Monitoring the Infiniband Switches/ports, HCA ports on DB/CELL nodes and IB topology on Exadata machines.
• Troubleshooting Infiniband/RDS performance issues on Exadata.
• Experience in setting up and maintaining Golden Gate for bi directional replication.
• Implemented Golden gate bi directional replication to ensure zero data loss.
• Worked on Data Guard setup along with Data guard Broker.
• Experience in DATAGUARD and DISASTER RECOVERY support.

TECHNICAL SKILLS

ERP: Oracle Applications (EBS) 11i, R12, SAP HANA S/4 1.1X.

Database: Oracle 9i, 10g, 11i, 12c, Oracle Exadata, Sql Server 2012

Operating System: Red hat Linux, Solaris, HP-Unix, Windows server 2012 R2

Oracle Tools: OAM, OIM, ODI, OID, Golden Gate.

ETL Tools: Informatica 11, SAP BODS 4.1.

Reporting Tools: OBIEE, SAP BO4.1 (Web, dashboard, Crystal Reports).

Utilities: Export, Import, RMAN. Sql Loader,TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Texas

Technology Lead

Responsibilities:

• performed the upgrade tasks of Oracle EBS applications version 12.1.3, 12.2.3 and12.2.5 Upgraded Oracle databases from version 11.2.0.3 to 12.1.0.2.
• Applying Oracle EBS patches using online patching(ADOP).
• Performed Cloned application database from singe node to multi node system using Raid Clone
• Implemented disaster recovery solution for Oracle EBS applications and databases using Oracle Data guard. Proficient in database switchover and failover using Oracle Data guard.
• Creation of metrics and monitoring mechanism for Oracle applications and databases using OEM 12c.
• Administration and maintenance of Oracle WebLogic 11g instances.
• Configuring IORM/DBRM and Implementing Oracle Exadata best Practices.
• Migrating databases to Exadata.
• Setting and Monitoring Exadata using EM12c.
• Maintain and Troubleshoot Exadata Cell/Storage and DB/Compute node performance issues.
• Experience on Data Guard, RAC on DEV, TEST environment Instances.
• Applying Oracle EBS patches on multi node for bug fixes and quarterly patches.
• Performing Patch analysis and applying the patches and troubleshooting Patch issues.

Environment: Oracle Applications EBS 11i, R12 Database 10g, 11g and 12c, OEM 12c, Data guard, RAC, Fusion middleware 11g, SOA, OID, Web Logic 11g

Confidential, New Jersey

Technology Lead DBA

Responsibilities:

• Periodic Cloning of Development, Quality and Testing from Production using Database hot backup.
• Apply of Jan2016 patches on OEM Grid Database home (12.1.0.2), OMS Home (12.1.0.5.0 ) and Agent Home (12.1.0.5.0 ) and regular patches for issue of EBS Application and Database.
• Database Refresh/clone doing complete/incomplete recovery using cold and hot backups.
• Upgraded some of our databases from 11gR1 to 11gR2. Worked with Oracle support to resolve the bugs related to 11gR2.
• Attends Status meeting with Client on periodic basis for the Projects.
• Delivery Weekly status report of DBA team to Client.
• Monitor of Performance issues of Concurrent Requests, Managers, Application and Database and resolved
• Good exposure and support experience on Fusion Middleware products OBIEE, SSO/OAM Oracle Access Manager, Oracle Identity Management (OIM), Oracle Internet Directory (OID), Web Logic, SOA Suite
• EBS Security is maintained by following Single-Sign-On, Limit on Access and Authentication, Audit Trail.
• Performing regular backups of Applications and Database (Cold and RMAN utility) and ensuring backups
• Implementation of OEM 12c for database monitoring (Including Exadata Database systems).

Confidential

Associate DBA Consultant

Responsibilities:

• Performing clones from Production EBS to DEV, INT and UAT instances.
• Analyzing and applying the patches, troubleshooting patch issues.
• Upgrading Applications from 11.5.10.2 to 12.1.3 and database from 10.2.0.4 to 11.2.0.3
• RMAN backup and Monitoring Implementation
• Troubleshooting Issues related Applications and Database
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, one off patch, Security patches etc.
• Troubleshooting issues at various layers of Oracle Applications
• Upgrade of Database from 10g to 11gr2
• Installation and configuration web cache 10G
• High availability DR BUILD CONFIGURATION
• Convert NON-ASM to ASM
• Configured oracle applications Release 11i with 11g RAC.
• Database DB refresh, Performance Tuning
• RMAN backups and restores, cold and hot backups to tapes and file system.
• PCP configuration.

Environment: Oracle Applications EBS 11i, R12 Database10g, 11g and 12c, OEM 12c, Data guard, RAC

Confidential

Associate Consultant

Responsibilities:

• Scheduling jobs for daily backups and monitoring daily backup reports.
• Performing Patch analysis and applying the patches and troubleshooting Patch issues.
• Collecting monthly maintenance data, finding log errors and troubleshooting them
• Experience developing secure, reliable, scalable, python applications on the AWS cloud.
• DB upgrade from 11.1.0.7 to 11.2.0.3
• Upgraded Discoverer from 10g to 11g
• Configured Active Data Guard for all production databases.
• Managing the mount points and cleaning log directories.
• Created shell scripts for automation of application and database clone configurations.

Environment: Oracle Applications EBS 11.5.10.2, 12.1.3, Oracle Database 11g, Discoverer 10g & 11g, Data guard

Confidential

Associate Consultant

Responsibilities:

• Worked in Day to day production support.
• Upgraded applications from 11i (11.5.10.2) to R12 (12.1.3).
• Upgraded Database base from 9i to 10g and then further to 11g.
• Worked on Noetix Installation (6.0.1), Upgrade (5.8.4 to 5.8.7 and 6.0.1) and Implemented the Security with Noetix Admin.
• Worked on Character set conversion in DB level and installed NLS languages in Applications.
• Implemented the Audit Vault & Database Vault to tracking all DBA tasks.

Environment: Oracle Applications EBS 11i, Database 9i and 10g, Linux 4, Hp-Unix, Oracle 10g