SUMMARY:

• Over total of 16+ years of extensive experience in Database Administration handling Oracle 12c/11g/10g/9i/8i databases in large multi - site production and development/testing environment of which 14+ years of total experience as APPS DBA.
• RAC Implementation Project: Migration of Oracle Application E-Biz 12.1.3 Single Database Instance to Oracle 2 NODE RAC with ASM with 32-bit to 64-bit application conversion, PCP Configuration, Gateway Installation for MS-SQL Server, RAC, E-Business Suite Administration, Oracle WebLogic, Oracle Applications Server, Oracle Enterprise Manager Grid Control 12c.
• Senior Lead, worked on R12.2.6 TOSHIBA - GLOBAL ONE implementation project. Demantra instance configuration, Installation, VM’s setup. Performance tuning for Demantra Analytic engine. EBS support, code migration(s) and setup RMAN Backup restore and recovery etc.
• Successfully upgrade from 11.5.10.2(CU2) to 12.1.3 (RPC3) and was part of the core cutover team. Upgrade done on X2-5 Half Rack Exadata servers and Exalogic server. Actively participated in cutover planning and execution.
• R12.2.4 requirement gathering, analysis and recommended Hardware/System Resource Configurations. One full Cycle of R12.2.4 Upgrade completed successfully from 11.5.10.2 (CU2) including Performance tuning of upgrade jobs.
• Upgraded E-biz instance from 11.5.8 to 12.1.3 in Confidential . Cross platform DB upgrade HP-UX to Linux.
• EBS SSL implementation
• Experience in Oracle Database, RAC, E-Business Suite Administration, Oracle WebLogic, Oracle Applications Server, Oracle Enterprise Manager Grid Control, Active Data Guard, DMZ and Oracle Demantra installation/Setup and configuration.
• Performed Oracle Application 11i/12 & RDBMS 8i/9i/10g/11g installation, upgrade, cloning & patching, OEM on Linux platforms.
• Good experience in handling EBS Implementations, Upgrades and Support & Maintenance projects.
• Experience in Vertex 6.0 Upgrade, MFS install and Implementation, User publish and sync issues
• Experienced in providing 24*7 production system DBA support in an on-call fashion.
• Experienced in working on various UNIX platforms and Real Application Cluster.
• Experienced in upgrade of the RDBMS and Oracle Applications 11i, R12.
• Experienced in creating custom top and performing customizations of Oracle Applications as per customer specific requirement.
• Experience in HA (High Availability) & DR (Disaster Recovery) Management
• Monitoring the instances using multiple tools like OEM 12c, OSwatcher.
• Analysing and fixing the db and application performance issues.
• Keen understanding of the Database Architecture.
• Expertise in Oracle apps one-off patches, mini packs, family packs and CPU application.
• Performed various Oracle Application system administration activities including setup of users/responsibilities, Printer, Custom Application setup, Concurrent managers, defining profile options, recompiling flexifields, and manual jserv load balancing.
• Performed Database backup & Recovery using rman/hotbackup, cold backup.
• Cloning using Rapid Clone and by using multiple automated scripts.
• Parallel Concurrent Processing and troubleshooting.
• Front-end activities including creating Conc. Programs, executables, value sets, request sets, Conc. Manager Administration, user management, responsibilities etc.
• Preparing technical knowledge documents and participating in technical discussions, email communications.
• Experience with ad utilities like adpatch, adctrl, adrelink, adadmin, aderelink.sh, License Mgr, adident, adautoconfig.
• Flexible and adaptable to new technologies and challenges, thrive on solving the most complex issues to deliver the Customer the right result.
• Efficient Team Player, hardworking, good in analytical and logical problem solving abilities with excellent communication skills.
• Migrating objects with Dellsat for Oracle e-Business suite 12i

COMPETENCIES:

Verticals: ERP - E-Business Suite 11.5.8 11.5.10.2 (CU2) and R12.1.3, 12.2.6, along with Oracle databases 8i, 9i, 10g, 11gR2 and 12c, ERP - E-Business Suite 11.5.5, 11.5.10.2

Domains / Programming Skills: ORACLE Apps DBA 11i / R12 (AD, FND), C, C++, SQL & PL/SQL, Unix Shell

Programming: Basic Java and Advanced Java

Monitoring Tools & Techniques: SQLPLUS, OAM, Appworx Scheduling tool, Oracle 12c/11g/10g OEM Grid Control R1/R2, Oracle 9i OEM, TOAD, CVS,SQL NAVIGATOR

Databases: Oracle 11g/10g/9i/8i DBA PL/SQL, MYSQL

Software Tools: Oracle SQL*Loader, Workflow, TOAD,SCRUM

Operating Systems: HP (HP-UX 11), IBM AIX 5.3, Sun Solaris 9, Win NT, OEL 7.3, Sun Solaris, Mandrake Linux

Web / Application Server: OAS 10g, 9iAS, Apache, Forms Server, Report Server.

SOA: Web logic server 12c/11g, SOA, OIM/OID, BAM

Code Migration: Kintana, Remedy, DellStat etc

EXPERIENCE SUMMARY:

Project Manager/Sr Lead/Senior Oracle APPS Engineer/ Team Lead/ Technical Specialist

Confidential

Environment: Oracle Applications R12.1.3, 11gr2 2 Node RAC on ASM, OEL 7.2 64 bit

Responsibilities:

• On-Prem instances evaluation, Prepare Infrastructure at OCI and configuring backup to Cloud.
• The EBS R12 migration to cloud uses simple data guard, where the goal is to migrate source database to the destination and keep the database release the same.
• Prepare Cloud and Instantiate Cloud standby: Creating physical standby database at OCI (DbaaS)
• Perform a Data Guard Switchover when ready for migration using DGMGRL.
• Configuring application services (hosted on IaaS) for using the new primary database
• Ensuring redo are shipped from the new environment back to the source environment, to keep it current.
• If issues arise, execute a Data Guard switchover to return to the original configuration
• Configure RMAN for Oracle cloud backups using Oracle Database backup module.
• Creating compartment/VCN and launching database VM’s under OCI

Confidential

Sr. Lead

Environment: Oracle Applications R12.1.3, 11gr2 2 Node RAC on ASM, Oracle Enterprise Manager (OEM) Grid Control, RMAN, OEL 7.2 64 bit

Responsibilities:

• Manage and support mission critical E-Business Suite. Responsible for 24x7 operation support, coordination of patches, administration of customer profile setups and concurrent manager issues.
• Critical production and non-production support in RAC.
• E-Business Suites cloning from RAC to RAC and RAC to non-RAC instances with ASM using BCV snap and RMAN duplication depends of storage support.
• Database and Applications cloning and production instances from ASM to NON-ASM file systems.
• Setting PCP, Fail over for concurrent manager in RAC R12
• Supporting and coordinating with unix team on quarterly cpu patches.
• Standardize customization in proper way and fixed shell scripts and custom program for RAC
• User and developers support as when required.
• Re-organizing tables and indexes as part of maintenance activity to reduce fragmentation.
• Maintain and applying patches in shared appltop environments including dmz set-up and maintenance.
• Handling alerts from EM and crons.
• RMAN backup and Monitoring Implementation
• Configuring workflow
• Applied critical grid, oracle home patches and payroll patches like hrglobal and data installer to keep them up to date.
• Troubleshooting the performance issues and preparing RCA reports.

Confidential

Sr. Lead

Environment: Oracle Applications R12 (12.2.6) database 12.1.0.2, OEL 7.2 (64-bit)

Responsibilities:

• Setup and configured Demantra VM's for DEV,INT and CRP
• Performance tuning for Demantra Analytic engine (Re-org tables and GSS).
• Well documented DBA runbook for Demantra setup and configuration
• POC(s) done for improving import timings for Demantra Schema DMTPD
• RMAN backup, Code Migrations, Patching, cloning, DB monitoring and support.
• DBA 24*5 support

Confidential

Sr. Lead

Environment: Oracle Applications R12 (12.2.5) database 12.1.0.2, OEL 7.2 (64-bit)

Responsibilities:

• Successfully installed 12.2.5 with 12.1.0.2 DB (Multi-node) on VMWare machine.
• Applied 2016 PSU and CPU DB/MT patches, along with ETCC.
• Oracle Gateway Configuration for IBM DB2 (Zos) server.
• Enable SSL for Oracle E-Biz 12.2.5
• Configure SSL based workflow notification mailer for Office365.
• R12.2.5 Cloning and Patching (adop), maintenance.
• Configured mutt (email client ) to support SSL/TLS
• Sysadmin setup for users security and printer setup

Confidential

Sr. Lead

Environment: Oracle Applications R12 (12.1.3) database 11.2.0.4, OEL 6.5 (64-bit)

Responsibilities:

• Upgraded successfully Prod instance (Six-node DB RAC and 12 APPS Node) with R12.1.3 (RPC3)
• Applied 250 + functional patches.
• Upgraded IE 11 and Latest Java Version (JDK Upgrade) to 1.7u79
• PCP configuration and load balancing.
• Performance Tuning Long running jobs includes other jobs affecting upgrade performance.
• Third party Tool integration with E-Biz suite.
• Applied Oracle recommended best practices from upgrade.
• Distributed AD feature for adpatch to complete faster. PCP and Shared APPL TOP
• Critical production and non-production support in RAC.
• E-Business Suites cloning from RAC to RAC and RAC to non-RAC instances with ASM using RMAN duplication depends of storage support.
• Setting PCP, Fail over for concurrent manager in RAC R12
• Supporting and coordinating with UNIX team on quarterly CPU patches.
• Standardize customization in proper way and fixed shell scripts and custom program for RAC
• User and developers support as when required.
• Re-organizing tables and indexes as part of maintenance activity to reduce fragmentation.
• Maintain and applying patches in shared appltop environments including DMZ set-up and maintenance. Handling alerts from EM and crons.
• RMAN backup and Monitoring Implementation
• Configuring workflow
• Applied critical grid, oracle home patches and payroll patches like hrglobal and data installer to keep them up to date.
• Troubleshooting the performance issues and preparing RCA reports.
• Upload and apply Vertex Quantum data update patches and keep them up to date.

Confidential

Team Lead

Environment: Oracle Applications R12 (12.1.3) database 11.2.0.3, RHEL 5

Responsibilities:

• Backup and Recovery
• Cloning and Patching
• Troubleshooting issues
• Monitoring.