Profile Summary:

11 years of professional experience in information technology industry that experience in Oracle application Database Administration like Oracle Database Administration, Oracle Application Administration DBA Technical on all the platforms.

DBA Technical Skills

Operating Systems: Hp-UX RA-RISC, HP-UX Intanium, Linux OEL4, 5, 6, Linux Redhat, Windows, Solaris 2.X, AIX

Rdbms: 11gR2/10g/9i, Datagaurd StandBy DB , 11g Grid

Applications: ORACLE APPLICATIONS 11.5.9/11.5.10, 12.1.3, 9iAS, 10gAS, OC4J, BPEL, OTM, FTI, 12.2 Fusion Application Fusion middleware, Fusion Application, SOA Backup: Veritas, RMAN and XBP Backup tools

Data Modeling: Oracle Discover, Oracle express, Oracle VM, Oracle OBIEE,

Tools/Others: Data pump, OEM, TOAD, Apache Server, Shell Scripting, Express Instance Manager, OEM, and Express Server Administration. Backup and recovery using RMAN, Pasta printer setup, HP-Printer setup, Label printer setup.

Other Technical Skills

Technical Proficiency

Oracle Skills:

• Installed, configured and administered Oracle Application 11i/12i database in a Multi-tier architecture
• Application upgrade from 11.5.10.2 to 12.1.3.8 EBS suite.
• Application upgrade from 12.1.3 to 12.2.4 EBS
• Implementation of Demantra 7.3.1 with EBS suite.
• Very good in performance tuning in application and database of EBS in OLTP/DSS systems.
• Applying RPC recommended patch collections on R12 applications
• Version upgrade and component upgrade on databases of 10g and 11gR2
• Managing planning EBS with Integrated ERP application.
• EBS upgrade and Plant form migration of 11.5.10.2 to R12 from HP-UX to Linux.
• Database clone with upgrade processes on 10g/11gR2 very tricky
• BPEL Manager Administration and support on 10.1.3.5 on message queues.
• OTM upgrade from 5.5 to 6.2.4
• OTM Administration and Integration with PCmailer, EBS R12, BPEL, Jboss, Fedex.
• Conjugating DMZ setup with EBS 11.5.10.2
• Printer configuration on EBS. i.e., HP, Label, Xerox Pasta printers
• Cloning using ad clone utility and adcfgclone.
• Manual cloning using own scripts as per requirement
• Very well versed in Rapid Install, DataInstaller, AdPatch, Adadmin and Adctrl utilities for Oracle Applications.
• Installation of 10g/11g/11gR2 database and Application server and 10g/11g/12c OEM Configuration.
• Configure PCP Parallel Concurrent Processing for multi node environments.
• Well experienced in administering Oracle Applications and Internet Databases on UNIX platforms, which includes creating, designing and maintaining production databases.
• Highly skilled in logical and physical database design, performance tuning.
• Very proficient in Oracle on-line/off-line backup and recovery principles.
• 11g OEM Oracle Enterprise Manager Implementation with Email and Pager Alert for 11i Application environments.
• Installed and used RMAN for taking the backup of Oracle 11gR2 Databases.
• Posse's Good skills in managing the Oracle resources for logical structures.
• Very well experienced in using Oracle Server Utilities like Datapump, dbca, netca, dgmgrl, srvctl, crsctl.
• Stats Pack installation for Performance Tuning and have experience on performance tuning advisers using OEM 12c
• Proficient in configuring Concurrent Managers and Apache Web Server for Applications.
• Data Warehousing and Users Administration Roles and Profiles
• Strong Trouble Shooting Skills.

Projects Summary

Confidential

Environment: OEL 4/5/6, Linux Redhat, HP-UX RA RISC, HP-UX Itanium 11.11/23/31, Linux VM Ware.

Role: Oracle Apps DBA

Responsible for:

• Support for EBS Production and development environments of 11.5.10.2/12.1.3
• Support for Planning EBS on Application integrated with ERP EBS 11.5.10.2/12.1.3
• Upgrade and platform migration from 11.5.10.2 to 12.1.3
• Upgrade application version from 12.1.3 to 12.2.4
• Enhancing security by PSU patches monthly.
• Upgrading BPEL from 10g to 11g SOA.
• Implementation of DWMS with 11g ODI application.
• Support for OTM 5.5/6.2 and BPEL deployment on 10.1.3.3/10.1.3.5
• Upgrade of OTM 5.5 to 6.2.4
• HP Printer, label printers and Pasta printers configurations
• Character set conversion of databases in 10g and 11gR2
• Upgrade, Migration activities of databases
• Backup and restore of all Productions and point in-time recovery when needed.
• Implementation of India localizations IN60107
• BPEL administrations and upgrade from 10.1.3.3 to 10.1.3.5
• RAC to non-RAC migrations/cloning
• Resolving all test/development/Production issues.
• Datagaurd / standby maintenance from 10.2.0.2 , 11.1.0.7 and 11gR2
• Strong UNIX/Linux and EBS troubleshooting skills.

Confidential

Role: Oracle Apps DBA

Responsible for:

• Trouble-shooting of all oracle application problems of 11i/R12.
• Providing DBA Support to ensure 24x7 DBA support.
• Copy/Clone of oracle application environment. RAC to RAC
• DB/Application Backup.
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl, adaimgr, adrelink, adsplice etc.
• As active team member of RAC Upgrade from 11.5.9 to R12.
• Cluster Management and verifying cluster process to ensure smooth operations.
• Monitoring the all-running Instance to ensure everything working.
• Quantum upgrade and licensing the New Products.
• Tablespace Maintenance like adding the increase the size of the data files.
• Interacting with oracle support to resolve application issues.

Confidential

Role: Oracle Apps DBA

Responsible are:

• Upgrade application from 11.5.9 to R12 version
• Refreshes from the Production system to Dev Test environment.
• Workflow, printer, discoverer configuration and troubleshooting.
• Upgradation of 8.1.7 to 9.2.0.5 using DBUA.
• Upgradation to 9i to 10g
• Cloning from RAC to Non RAC environment.
• Multi tier installation of Oracle 11i Applications.
• Applying types of patch application using adpatch and Opatch.
• PCP configuration and Application tuning.
• RMAN backup of all development systems.
• Refresh of 9iAS
• Strong trouble-shooting of all oracle application problems.

Confidential

Role: Oracle Apps DBA

Responsible for:

• Migration from different platforms to Linux of Production, Development, Test Instances.
• Upgrading the Instance from 11.5.5/11.5.6/11.5.7/11.5.8 to 11.5.10.
• Applying major Patches.
• DB/Application Backup.
• Import / Export of 8i/9i databases.
• Trouble-shooting of all oracle application problems.
• Providing 24x7 support to the Production, test environment.
• Interacting with oracle support to resolve application issues.

Confidential

Role: Oracle Apps DBA

Responsible for:

• Refresh from Production to Development Instances.
• Using Kinta EAP tool to apply patches.
• Performance tuning of all Development databases.
• Finding the suitable recommendations based the data analysis.
• Writing scripts to minimize the time required.
• Trouble-shooting of all oracle application problems
• Worked on 24/7 high availability environment.

Confidential

Environment: Linux Unix RAC , Windows NT Dell Machines , Oracle 9I, Oracle Application 11I ERP CRM

Role: Oracle Apps DBA

Responsible for:

• Trouble-shooting of all oracle application problems.
• Providing DBA Support to ensure 24x7 DBA support.
• Copy/Clone of oracle application environment.
• DB/Application Backup.
• DB refresh from RAC Environment to Non-RAC environment.
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl, adaimgr, adrelink, adsplice etc.
• As active team member of RAC Upgrade from 11.5.9 to11.5.10.
• Cluster Management and verifying cluster process to ensure smooth operations.
• Monitoring the all-running Instance to ensure everything working.
• Quantum upgrade and licensing the New Products.
• Tablespace Maintenance like adding the increase the size of the data files.
• Interacting with oracle support to resolve application issues.

Confidential

Environment: Sun Sparc 2.6 and 2.8, Windows NT Dell Machines , Oracle 9I, Oracle Application 11I ERP CRM

Role: Oracle Apps DBA

Responsible for:

• Creating Custom Top for the client Requirements.
• Upgrade Oracle Application to current releases and current product-level with applying maintenance packs and Minipacks.
• Installing/Configuring of two-node oracle application
• Providing DBA Support for Oracle's eBusiness Studio Hosted environments to ensure 24x7 DBA support.
• Daily Monitoring all the application Systems.
• Trouble-shooting of all oracle application problems.
• Copy/Clone of oracle application environment.
• Custom Top Creations and DB upgrade.
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl, adaimgr, adrelink, adsplice etc.
• Interacting with oracle support to resolve application issues.

Confidential

Environment: Linux, Oracle 9I, Oracle Application 11I ERP CRM

Role: Oracle Apps DBA

Responsible for:

• Upgrade Oracle Application to current releases and current product-level with applying maintenance packs and Minipacks.
• Providing DBA Support for Oracle's eBusiness Studio Hosted environments to ensure 24x7 DBA support.
• Creating Custom Top for the client Requirements.
• Trouble-shooting of all oracle application problems.
• Copy/Clone of oracle application environment.
• Custom Top Creations and DB upgrade.
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl, adaimgr, adrelink, adsplice etc.