SUMMARY:

• 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 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.1 Oracle 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, Dallas Tx

Onsite Apps DBA Lead

Responsibilities:

• 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, Dallas Tx

Onsite Apps DBA Lead

Responsibilities:

• 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.
• Handling large databases on SAN storages.
• Identify candidates for consolidation.
• Providing temporary solutions for backup and recovery on NAS during the migration.
• 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, Dallas Tx

Onsite Apps DBA

Responsibilities:

• 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.
• Installed Oracle Database 11gR2 with ASM and configured Enterprise Manager to manage ASM & Database

Confidential - RexelDallas Tx

Onsite Apps DBA

Responsibilities:

• 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.

Confidential - RexelDallas Tx

Onsite Apps DBA

Responsibilities:

• 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 - RexelDallas Tx

Onsite Apps DBA

Responsibilities:

• 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.

Confidential

Offshore Oracle Apps DBA Team Lead

Responsibilities:

• Planning of the complete activity and also performing the activity in DEV/UAT and then 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

Responsibilities:

• 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 an 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

Responsibilities:

• 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

Responsibilities:

• 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)