SUMMARY:

Over 9 years of experience as an Oracle Application DBA, in Implementations/Installations, Configurations, Maintenance and troubleshooting of Applications 11i and R12(12.2.4, 12.2.3, 12.1.3) and Oracle database (9i, 10g, 11g, 12c). Extensively worked on Oracle 11i and R12 - Database migrations, Upgrade of Database and Applications. Good experience in implementing advanced configurations ie. RAC/PCP, DMZ, Shared appltop, Shared application Tier, Discoverer, Workflow.. etc.

EXPERIENCE SUMMARY:

• Oracle E-Business Suit administration EBS R12.2, 12.1, 11i involving Oracle E-biz cloning, patching, user administration, application upgrades, DMZ configurations and troubleshooting developer, functional and business user issues.
• Upgraded Oracle Application to 11.5.10.2, R12.1 & R12.2 from prior version
• Oracle Database administration (installation, backup configuration using RMAN, applying security updates and bug fixes, upgrades, cloning and user administration) of 9i/10g/11g/12c
• Experienced in Space Management, Query Tuning and Application Tuning Cloned Oracle applications R12 and Databases.
• Leading and Managing the offshore / On site model with 24 X 7 Production support.
• Good implementation knowledge of Shared Appl Top and Shared application tier
• Oracle Application Cloning using Rapid clone. Multi node to single node, Multi node to Multi node
• Experience in working with RAC/PCP and DMZ setups
• Installation & Configuration of Oracle GRID (CRS) Infrastructure
• Good Experience in managing and configuring Weblogic Server.
• Strong database, application and development tool troubleshooting expertise. Experienced in logical and physical database design, modeling. Hands on database performance and instance tuning for both RAC and NON-RAC environments. Managing Grid Control.
• Install the Oracle Business Accelerators for Oracle E-Business Suite environments on the client's hardware for training and implementation purposes
• Complies with all ETS security and audit standards. Ensures security of company information by ensuring database is secure and monitors environment to identify improper access
• Monitoring and ticketing tools like OEM, HPOV and BMC Remedy and other third part tools like KINTANA (HPPPMC), PVCS and Microsoft VSS.

TECHNICAL PROFILE

ERP: E-Business Suite R12.2.4, R12.2.3, R12.1.3, 11.5.10.2, 11.5.9. DATABASE 9i, 10g, 11g

DB Management: TOAD, OEM 11gR2/ 12c, OAM

Operating Systems: RHEL, Solaris 5.9/5.10, AIX 6.1/7.1, HP-UX, Windows

BI/Reporting tools: OBIEE 11.1.1.5

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH, ADDM, SQLT

Programming: UNIX shell Programming (Bourne, corn), SQL, PL/SQL, HTML

PROFESSIONAL EXPERIENCE:

Confidential, Provo, UT

Lead Oracle Apps DBA -Consultant

Version: Oracle Apps 11.5.10.2 to 12.2.4 and Oracle database 11.2.0.2 to 11.2.0.4

Responsibilities:

• Migrated database from HP UIX to RHEL6 64 Bit, Upgraded the database from 11.2.0.2 to 11.2.0.4
• Upgraded the Applications from 11.5.10.2 to R12.2.4
• Configuring shared application tier with load balancer Using Hardware Load Balancers with Single Web Entry Point
• Installed and configured 11g web discoverer and integrated with E-Business suite
• Fixed several issues while in UAT related to several modules (GL, AP, AR, HR)
• Installation and upgrade of BI Publisher and integrated with E-Business suite R12.2.4
• Advanced cloning of R12.2.4 application file system to non prod instances
• Maintaining production, development & test databases and applications.
• Demantra/ASCP installation and integration with Oracle E-Business Suite R12.2.4
• Oncall support on 24/7 in current month for stabilizing the latest R12.2.4 applications
• Configured and developed monitoring shell scripts to trigger an alert if services are down.
• Advanced cloning methods of R12.2.4 from multimode to single node
• Applied patches using ADOP with different adop options.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views (replication).
• Installed and configured Single-Sign On and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users
• Architect for and the implementation of Oracle Identity Manager, Oracle Access Manager (OAM)

Environment: RHEL6, Oracle Apps 12.2.4 and Oracle database 11.2.0.4, Discoverer 11g, Demantra 7.3.1.5, BI Publisher 11g

Confidential, Houston, TX

Senior Oracle Apps DBA -Consultant

Version: Oracle Apps 11.5.10.2 to R1213 and Oracle Database 11.1.0.7 to 11.2.0.2

Responsibilities:

• Install & Upgrade of Oracle EBS from 11.5.10 to 12.1.3. DB 11.1.0.7 to 11gR2.
• Applied Delta.3 patches one by one (Product By Product) to avoid several errors/complaints from end users for the products Oracle Procurement, Financials, Oracle Projects & HRMS 12.1.3 for large production systems.
• 24x7 Production support of Oracle Applications Administration
• Configured and setup DMZ Public URL Successfully with customer defined responsibilities
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Monitoring Enterprise Manager during load testing and presenting back the performance related metrics pages to the customer.
• Configuring SSL IMAP workflow mailer
• Discoverer upgrade to 11g
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10g & 11g database.

Environment: -Oracle 11g, EBS 11i / R12 on Unix (Red Hat Linux)

Confidential, San jose, California

Senior Oracle Apps DBA

Version: Oracle Apps 12.1.3 and Oracle database 11.2.0.2

Environment: IBM Aix 5.1, OEL4 - 32 Bit & OEL6 -64 Bit

Responsibilities:

• Migrating 11.5.10.2 Middle Tier from HP-UX to Linux
• Installation of demantra spectrum and creating demantra schema
• Upgrade from Demantra 7.1.1 to 7.3
• Configured and installed IBM Web sphere applications on OEL4
• Created customized scripts for deploying demantra war file to web-sphere applications & Created the workbench dashboard
• Installed Analytical Engine managers on web-sphere applications
• Migrate from MRP to ASCP
• Map Existing Supply Planning Processes from MRP to ASCP
• Enhance the Integration of Forecasting and Supply Planning
• Migrate Existing Processes to the Upgraded Software in Demantra 7.3
• Build Enhancements for the following functionality
• Collect Customer Based Price Lists into Demantra
• Collect Inventory into Demantra
• Collect Open Sales orders into Demantra
• Publish Forecast at a weekly level in Demantra
• Solving Technical Issues that arise from the Upgrade
• Architect for the implementation of Oracle Identity Manager, Oracle Access Manager (OAM), Oracle Internet Directory, and Oracle Virtual Directory

Environment: RHEL5, Oracle Apps 12.1.3 and Oracle database 11.2.0.2, Demantra 7.3.1

Confidential, Columbus -IN

Lead Oracle Apps DBA -Consultant

Version: Oracle Apps 11.5.8 to R1213 and Oracle Database 9.2.0.4 to 11.2.0.2

Responsibilities:

• Migration of oracle database 9i from AIX to RHEL5
• Upgrade database from 9.2.0.4 to 11.2.0.3 in RHEL5, OATM migration of the database
• Upgraded Oracle Applications from 11.5.8 to R12.1.3
• 24x7 Production support of Oracle Applications Administration
• Maintaining production, development & test databases and applications.
• Configuring SSL IMAP workflow mailer
• Discoverer upgrade to 11g and integrating with EBS R12.1.3
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Created new application messages and then generated message file for application.
• Cloning the oracle applications Production to Non Production
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10g & 11g database.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new application messages and then generated message file for application.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Worked closely with users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems with solutions for future reference.

Environment: RHEL5, Oracle Applications 12.1.3 and Oracle database 11.2.0.2

Confidential, Englewood, CO

Senior Oracle Apps DBA -Consultant

Version: Oracle Apps R1213 and Oracle Database 11.1.0.7

Responsibilities:

• Maintaining production, development & test databases and applications.
• 24x7 Production Oracle Applications Administration.
• Applied patches using ADPATCH, ADCTRL utilities.
• Created test environment through cloning production environment for developers to test on live data.
• Implementation, customization and personalization of Oracle iProcurement.
• Generated reports and financial consolidations with Oracle Hyperion Financial Management.
• Installed other supporting products for financial module like Oracle Essbase for modeling complex business scenarios and DRM/MDM.
• Generated several reports using Oracle iExpense (OIE) module in two projects.
• Advised and made recommendations to improve the overall database design.
• Monitored performance and availability of the VIS application (a high-availability web-based application running Oracle10g RAC on HP-UX cluster with EMC SAN).
• Involved in developing a disaster recovery (DR) plan.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Installation & Configuration of Oracle GRID (CRS) Infrastructure
• Cluster and Oracle RAC Diagnosability Tools Enhancements

Environment: RHEL4, Oracle Apps 12.1.3 and Oracle database 11.1.0.7

Confidential, Laurel, MD

Lead Oracle Apps DBA -Consultant

Version: Oracle Apps R1206 and Oracle Database 10.2.0.3

Responsibilities:

• Upgrade Applications from 11.5.9 to R12.0.4 & R12.0.6
• Cloning for application and database from 11.5.9 to R12 in Linux X86-64
• Installed ADF libraries, Runtime Support libraries, JDBC libraries, JDeveloper libraries prior to the installation of Oracle Application Server 9iAS/10gAS on test and development environments.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• EBS integration of UPK to Prod and have deployed it in UPK server
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Installed Vertex and Quantum
• Automated financial processes to ensure consistent, efficient, cost-effective, and timely processing of all transactions through MarkView Financial Suite (formerly 170 MarkView from 170 Systems).
• Installed and Configured active modules being GL, Financials, AP, PAY, PER

Environment: Linux, Oracle Apps 12.0.6 and Oracle database 10.2.0.3

Confidential, Cupertino, CA

Senior Oracle Apps DBA

Version: Oracle Apps R1206 and Oracle Database 10.2.0.4

Responsibilities:

• 24x7 Production support of Oracle Applications Administration
• Good experience on Oracle 9iAS, 10g Discoverer Configuration, discoverer, Punchout, ADI
• Upgraded database from Oracle 9i to Oracle 10g RAC
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Created new application messages and then generated message file for application.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.

Environment: Linux, Solaris, Oracle Apps 12.0.6 and Oracle database 10.2.0.4