SUMMARY

• To work in a challenging environment where I can enhance and deliver my skills to the best of my capabilities and talent.
• Oracle Apps. DBA professional with over 8 years of experience, has a solid knowledge of E - Business Suite architecture, Oracle Database architecture, SQL and PL/SQL.
• Extensively worked with Oracle Applications right from R12 to 11i (11.5.5 to 11.5.10).
• Supported most of the modules like Oracle Financials, Oracle Manufacturing, Oracle HRMS, and Oracle Supply Chain Management.
• Production Experience in administering Oracle Apps 11i/R12, databases and upgrade from 11.5.8, 11.5.9 to 11.5.10, R12.
• Very strong in cloning using utilities like ADclone, ADconfig and Rapid clone.
• Used utilities like ADadmin, ADrelink etc. to maintain application and database tier.
• Expertise in managing application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration and printer setup.
• Installed and configured Oracle Application stack on both single node and multi node environments.
• Expert with configuring Workflow Mailer and applying security patches.
• Experience with installation and maintenance of Oracle Application Server (10g and 9i).
• Expert in monitoring applications and databases using OAM and OEM.
• Created Custom schema for the custom module in Oracle Application.
• Database Recovery using Hot & Cold Backup, RMAN and 10g DataGuard.
• Experience in managing the Concurrent Managers, Internal Concurrent Managers, Standard Concurrent Manager and Conflict Resolution Manager & monitoring their operation.
• Experienced in writing UNIX shell scripts and setting up CRON jobs for database needs.
• Scripting and scheduling of oracle database backup using RMAN.
• Configured the Form server Load Balancing
• Expertise in performance tuning using Statspack, TKprof, OEM (Oracle Expert, SQL Analyzer) and Quest TOAD as well as performance tuning of Oracle APPS.
• Installation and configuration of Application Desktop Integrator (ADI)
• Experience in Oracle 10g/11g RAC installation on Raw devices
• Experience in Managing/working/converting RAC databases

TECHNICAL SKILLS

ERP: Oracle E-Business Suite 11.5.9, 11.5.10.2, R12.1.1

Database: Oracle Database 9.2.0.5, 9.2.0.8,11.2.0.1Oracle Real Application Cluster 11g

Middleware: Oracle Weblogic 11g, Oracle SOA Suite 11g, OEM Grid Control, OID, SSO

Operating Systems: Linux, SunSolaris, AIX, Oracle VirtualBox

Languages: Unix Shell Scripting, SQL, C++

Software, Application & Tools: Oracle VM(OVM), Oracle HTTP Server(OHS), Oracle Maintenance Wizard, DBCA, DBUA, Oracle Data Guard, OEM, OAM, RMAN, ASM, Clusterware, VCS, SQL*Plus, SQL*Loader, Exp, Imp, Expdp, Impdp, TOAD, Sub Version, SQL Developer, Nagios, Foglight, Netbackup, Venyu, Solaris Zones, Platespin.

PROFESSIONAL EXPERIENCE

Confidential

Onsite Apps DBA Lead

Responsibility: -

• 24x7 Production Oracle Applications Maintenance, Support and Administration.
• Manage resource availability.
• Period review of the onsite and offshore team performance with Customer Managers.
• Documentation of the work assigned in the environment and stored for the future use.
• Planning and Administration of backup and recovery strategies.
• Day to Day DBA activities.

Confidential

Onsite Apps DBA Lead

Responsibility: -

• Understanding the current Infrastructure w.r.t Performance, Load, Usage and future growth.
• Involved in Architectural Layout of the Infrastructure in New DataCenter.
• Planning the Application migration waves.
• Identify candidates for consolidation.
• Consolidation of Oracle databases on Solaris Zones
• Making Low level project plan for migration of Applications and Databases.
• Make sure that the capacity of the hardware is sufficient enough for the Load.
• Making sure database structure is as per standard.
• Implement RMAN backup for all databases using Netbackup Agent.

Confidential

Onsite Apps DBA

Responsibility: -

• Created Architecture Design and Requirement document for Implementation.
• Created High Level Project plan and Communication plan within Different teams.
• Installed Grid Infrastructure, Configured ASM and Oracle Restart.
• Upgrade Oracle Application 11.5.10.2 RUP4 to RUP7.
• Database upgrade from 9.2.0.8 to 11.2.0.1.
• Used 11gR2 features for Load and Performance management of Database (Real Application Testing, SQL Performance Analyzer and Enterprise Manager other features).
• Also implemented Compression and Encryption (Oracle Advanced Security) for the RMAN Backup.
• Capturing baseline performance information from Form server, Application server, Web server and Concurrent Managers to compare in the new environment.
• Performing the completed activity from client side with proper documentation.
• Understanding current Architecture and Monitoring Mechanism of the Environment.
• Understanding the current client licensing and ones which are required.
• Implementing OEM to Monitor/Manage Oracle and non-Oracle Environment

Confidential

Onsite Apps DBA

Responsibility: -

• Analysis of Server requirement (OS, Patch level, Disk space, CPU and RAM)
• Installation of Oracle Applications and Upgrade from 12.1.1 to 12.1.2.
• Creating customizations, Cloning, Patching and other Sysadmin activities.
• Documentation of all the activity for further iterations.
• Analyzing database growth and identifying data for purging and deploying strategy for purging.
• Planning of the complete activity and also performing the activity in DEV/UAT and tan PRODUCTION.
• Creating documents for the activity, which included High and Low level plan, FEMA, Risk & Risk Mitigation, Communication Plan documents.
• Production implementation within committed timelines.
• Communicate with the Business (External) users and the Internal Stakeholders.

Confidential

Oracle Apps DBA Team member

Responsibility: -

• Getting insight knowledge about the Schemas of Oracle Application.
• Migration of the Production database from one hardware location to another.
• Performed the activity with a downtime of a hour.
• Data separation from one database to create two new databases.
• Coordinating with other teams (UNIX, Network, Application and Business community)
• Applied Database Patches.
• Load Test Support Activity for the database..
• Interacting with Oracle Corp. and users for TAR related Activities.
• Handling GE Kintana Tickets for the DBA tasks.
• Assisting Team members in all possible ways in DEV.
• Code Migration using FNDLOAD from DEV to UAT during Train Cycle.
• Documentation of the Task Performed and uploading it in Support Central.

Confidential

Oracle Apps DBA Team member

Responsibility: -

• Applied Database Patches.
• Load Test Support Activity for the database..
• Interacting with Oracle Corp. and users for TAR related Activities.
• Handling GE Kintana Tickets for the DBA tasks.
• Assisting Team members in all possible ways in DEV.
• Code Migration using FNDLOAD from DEV to UAT during Train Cycle.
• Documentation of the Task Performed and uploading it in Support Central.
• Applied Database Patches.
• Server maintenance activities
• User Tickets handled for the Internal Projects
• User requests handling database health checking, ensuring the database availability and monitoring the database.
• Coordinating with other teams (UNIX, Network, Application and Business community)

Confidential

Oracle Apps DBA Team member

Responsibility: -

• Oracle Apps Production, development and Test database Support and Maintenance.
• Database cloning.
• Cloning from Production database to Development database and Testing
• Cloning of Oracle Applications R11i using RAPID CLONE, AUTOCONFIG and ADCLONE utilities.
• Involved in Installation of Oracle 9i (9.2.0.4) on Red Hat Linux AS3 and Upgrading of oracle database from 9.2.0.4 to 9.2.0.6
• Extensively worked on Oracle Applications AD Utilities.
• Very well versed in RAPID INSTALL, ADpatch, ADadmin, ADctrl utilities for oracle.
• Database Administration tasks like managing database backups
• Starting and stopping apps services, Concurrent Manager Setup.
• Monitored concurrent processes so that performance of the system is maintained.
• Applied RDBMS patches using OPatch and application patches using Adpatch.
• Involved in troubleshooting using ADadmin, ADctrl while applying patches
• Patch analysis for database and applications patches.
• Performed patch analysis for patches involving lot of pre-requisites.
• Trouble-shooting of Oracle Application problems.