SUMMARY:

• Total 9Yrs of experience in IT Industry as an Oracle Apps DBA in Administration, Testing,Maintenance and support.
• Oracle Certified Professional ( DBA - 11g)
• Oracle Certified Professional ( DBA - 10g)
• Oracle Certified Associate ( DBA - 9i)
• Extensive experience as an ORACLE Applications DBA in a variety of different environments like AIXSUN SOLARIS, Linux, HPUX
• Oracle Applications Release R12, 11i installation & Configuration Good problem-solving capabilities.
• Responsible for installation, upgrades, patches, TAR support, concurrent manager administration,
• Duties included database creation, database tuning, Web Server, backup/recoveryGeneral, troubleshooting, script development, and documentation.
• Installed and patched R12.1.1, 11.5.8, 11.5.9, 11.5.10.2 instances and Discoverer 4.1.48.06.
• Worked on AD utilities like adpatch, adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig
• Cloning R12, 11i databases using through oracle applications and rapid clone technique.
• Appling the OS patches for Linux R12,11i and Oracle Application patches and upgrade the Applicationdatabases from 9.2.0.4 to 9.2.0.5/10g/11g.
• Very strong in Auto Patch, Upgrade, cloning.
• Performed backups and tested crash recoveries using conventional Hot & Cold backups and RMAN
• Expertise in installing, maintaining and administering Oracle Applications 11i (11.0.3, 11.5.9,11.5.10, R12) instances.
• Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of OracleApplications e-Business Suite.
• Upgraded the RUP version from 3 to 7 in Oracle Applications 11.5.10.2.
• Upgraded the Oracle Applications from 11.5.8 to 11.5.10.2.
• Upgraded the database from 9.2.0.8 to 10g to 11g.
• Export and Import of Database, DB link creation
• Expertise in handling Many Oracle Applications Databases with sizes varying from 300 GB to 9 TB.
• Providing application support and backend database support.
• Experienced in Oracle Apps Administration and Sysadmin tasks
• DMZ implementation at IDEA client with isupplier and isourcing module implementation
• Experience in supporting Oracle Application modules like Oracle Financials - Financials AccountingHub(Subledger Accounting),AP, AR, GL, FA, FCG, CM, HRMS, LM, SCM, Iprocurement, Iexpense
• Performed Sysadmin activities on Oracle Financials - Financials Accounting Hub(Subledger Accounting)module by creating module users, responsibilities, menus,submenus,request groups,profile options.
• Interacted with Oracle Financials - Financials Accounting Hub (Subledger Accounting) users and fixedthe users issues on the technical side as well as on Oracle application side.
• Interacting with the developers of Oracle Financials - Financials Accounting Hub (SubledgerAccounting) team fix the development issues related to the Financials Accounting Hub module andmigrate the Codes from dev to uat and Prod environments.
• Tune and applied patches on the Oracle Financials - Financials Accounting Hub (Subledger Accounting)module.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical Standby
• Databases (Data Guard). Thorough Experience with supporting the Production Database withComplete lifecycle including Installations, Upgrade, Patching,Cloning,Backup/Recovery,HighAvailability including Oracle Real Application Cluster (RAC) and Data Guard
• System Administration of Oracle Application using Application Object Library and Systemadministration module, using listed tasks: Registering New Application, Registering New schemaRegistering Customized Tables using Application Standards, Creating new customized responsibilitiesMenus, Request group, Functions, Concurrent programs. Administering Concurrent Processes andManagers and Automating the Request
• Good presentation and communication skills to provide support to the Customer.
• Ability to work flexibly as a team member.
• Worked on 24/7 high availability environment
• Dedication with an inner drive to succeed and accomplish goals.
• Ability to perfectly plan and execute the given job to perfection.

TECHNICAL SKILLS:

RDBMS & ERP: Oracle 9i, Oracle 10g, Oracle 11g, Oracle Applications11i (11.5.8,11.5.9, 11.5.10.2), Release R12 (R12.1.1,R12.1.3)

Tools: SQL*PLUS, SQL Server 2005 Reporting Services, ETLTool, Toad,Vmware, Datastage, VSS (Configuration Tool), Appworx,Tivoli,Remedy,Lotus Notes, RMAN, Tkprof, Statspack, Forms and Reports6i, Discoverer,Cronjob (UNIX), Oracle Enterprise Manager

Languages: C,C++,SQL, PL/SQL(Basics)

OS: UNIX (Linux), AIX 5.3, 6.1, SUN Solaris 8.0,9.0, HPUX & Flavors of Linux

Specialization: Oracle Application 11i, Release R12 DBA, Oracle 9i DBA, Oracle 10g, 11g DBA, 12C, RAC,ASM, Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Senior Oracle Apps DBA

Responsibilities:

• Providing Support to Oracle R12 (12.1.1) & 11i (11.5.10.2) Application.
• Providing 24*7 support to COCC by Monitoring Performance of production instance
• Resolving Remedy tickets raised by users and performing approved production change requests
• Upgraded the Oracle Databases from 10.2.0.5 to 11.2.0.4
• Worked on 10g, 11g databases, and R12.1.1 applications.
• Maintaining, Monitoring and Administering for Oracle applications environment on RAC architecture
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Setup the RAC one node.
• Set up Printers and Workflow mailer in Oracle Applications R12.1.1 & 11i Prod, UAT,QA,DEV Environments
• Worked closely with Functional/Developers and helping them in fixing issues
• Applying latest CPU,PSU patches from Oracle Support to the Test and Production Instances for resolving issues or Enhancing features.
• Cloning 11i & R12 ERP Instances from Production to Test, Development Instances and coordinate with Testing and Development Teams.
• Backups- Logical and Physical for Multiple Instances.
• Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Tablespace Quotas.
• Raising the Service Request and working with Oracle Team.
• Installed and configured 10g Discoverer on a Oracle Application environment.
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.
• Scheduled the Rman Backup scripts in a cron job.
• Applied Patches for Developers Bug fixes and Scheduled Maintenance on Oracle Applications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed the Oracle 10g, Oracle 11g databases and Created Tablespaces on ASM environment.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Performed the Restore of Oracle 10g/11g databases on a one node RAC environment.
• Install, configure and write shell scripts
• Daily DBA activities as Performance Monitoring, Instance Health Check etc
• Working with FNDCPASS to change Passwords of APPLSYS,APPLSYSPUB and SYSADMIN
• Provided 24*7 Production support in Oracle Production Databases as well as Oracle Applications environments.
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)
• Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.

Environment: Oracle Applications R12 & 11.5.10.2 Oracle 11.2.0.3 Dual node AIX 6.1, ASM, RAC

Confidential

Oracle Apps DBA

Responsibilities:

• Providing Support to 11.5.10.2 Application users through ticketing system.
• Providing end to end support for all the instances of Oracle Apps 11.5.10.2 at Cummins
• Migration of Forms/Reports/procedures/queries of developers for production migration
• Worked on 9i, 10g, 11g databases & 11i applications.
• Maintaining, Monitoring and Administering for 11ii Instaces
• Performed Multi Node installation of Oracle EBS 11.5.10.2
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Set up Printers and Workflow mailer setup in Oracle Applications 11i Prod, UAT,QA,DEV Environments
• Working closely with Functional/Developers and helping them in fixing issues
• Raising the Service Request and working with Oracle Team.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD in Oracle Applications Environment.
• Applied Patches for Developers Bug fixes and Scheduling Maintanence on Oracle Applications
• Implemented DR setup on the Oracle Applications 11i environment as per Client Standards.
• Migrated the Oracle forms and reports from One sever to another, compiled them through f60gen in Oracle Applications Environment.
• Oracle Applications Concurrent Manager Administration & tuning for 11i applications.
• Installed the Oracle 10g databases and Created Tablespaces.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Approving code approval through TKprof of Database for the Developers
• Configuring Printers, creating db links, creating updating SR’s, checking locks on the system
• Provided 24*7 and On Call support in Oracle Databases and Oracle Applications (11i).
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)

Environment: Oracle Applications 11.5.10.2, Oracle 9.2.0.8, Multinode Solaris 5.9

Confidential

Oracle Apps DBA

Responsibilities:

• Performing OATM Migration for oracle apps 11.5.9
• Getting Business Knowledge for the systems involved in OATM Migration
• Preparing the execution plan for the upgrade and migration in collaboration with the client DBA’s
• Responsible for the analysis, testing of the system before conducting OATM Migration
• Testing the plans on Test Environment
• To Check the pre - requisites before performing OATM Migration
• Troubleshooting OATM Issues and maintaining an Error Log Repository
• Supervising the team during the actual OATM migration on the production system
• Solely responsible for communication with the Client
• Handling Tars
• Done Full Exports and Imports of the database at schema as well as tablespace level.
• Solely responsible for communication with the Client.

Environment: Oracle Applications 11.5.9, Oracle 9i, LINUX

Confidential

Oracle Apps DBA

Responsibilities:

• Upgraded the Oracle applications from 11.5.8 to 11.5.10.2
• Getting Business Knowledge for the systems involved in Oracle Applications Upgrade
• Responsible for the analysis, testing of the system before conducting Upgrades
• It includes Communication with the Onsite Client & solving Technical problems
• To Check the pre - requisites before performing Upgrade
• Troubleshooting Upgrade Issues and maintaining an Error Log Repository
• Responsible for upgrading Oracle Applications version 11.5.8 to version 11.5.10.2
• Includes checking of upgrade logs etc. to ensure successful upgrade of the Installation
• Working closely with Functional/Developers and helping them in issues
• Handling Tars
• Done Full Exports and Imports of the database at schema as well as tablespace level. and loaded data into database.
• Created users, Profiles, Assign Grants, Granted Roles and Quota to users
• Solely responsible for communication with the Client

Environnent: Oracle Applications 11.5.8/11.5.10.2, Oracle 8i,9i, LINUX

Confidential

Oracle Apps DBA

Responsibilities:

• Upgraded the Oracle Databases from 8.1.7.0 to 9.2.0.7
• Getting Business Knowledge for the systems involved in DB upgrade & migration on Oracle Apps 11.5.9
• Responsible for the analysis, testing of the system before conducting Upgrades
• Done Full Exports and Imports of the database at schema as well as tablespace level.
• Installed Oracle software 9.2.0.5, Upgraded it to 9.2.0.7 database.
• It includes Communication with the Onsite Client & solving Technical problems
• To Check the pre - requisites before performing Upgrade
• Troubleshooting Upgrade Issues and maintaining an Error Log Repository
• Responsible for upgrading Oracle DB 8i to 9i with migration on Applications version 11.5.9
• Includes checking of upgrade logs etc. to ensure successful upgrade of the Installation
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations
• Prepared the documentation for day to day activates as apps dba for post production, architecture details, pre plan for Production Assessment

Environment: Oracle Applications 11.5.9, Oracle 8i, 9i, LINUX,AIX

Confidential

Oracle Apps DBA

Responsibilities:

• Oracle Apps 11.5.9 support for HILTON Group of Hotels
• Cloning 11.5.9 Production Instance to Test, Dev Instances.
• Applying patches through adpatch utility for all the Financials and Procurement team.
• Responsible for providing end to end support to Technical and Functional Teams of HILTON.
• Performing Migration of Forms/Reports/procedures/queries of developers on production and UAT
• Worked on Ad utilities like adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig etc.
• Writing scripts for backup and recovery process and implementation of RMAN in a catalog mode.
• Creating Users, Granting roles, creating tablespaces, alter tablespace.
• Able to create and review explain plans and develop optimized code from the development and review there of.
• Installation and Upgradation experience on 9i and 10g Application Servers
• Scheduling and Maintenance of interface processes and concurrent manager process in production.
• Experience in providing technical Support to functional people and if needed used to raise a Tar with oracle for resolution of issues.
• Scheduling of concurrent programs as per the client requirements for all financials, procurement team.
• Creating Users, assigned responsibilities to users for all the financials and procurement team .
• Creating Custom responsibilities, Request Groups, Menus and submenus through
• System administrator responsibility for all the AP, AR,GL,FA,CM, I Procurement,
• Performing Network Infrastructure analysis like tnsnames.ora, listener.ora, sql*net.
• Migration of Users, responsibilities, Request Groups, Menus through FNDLOAD Command.
• Experience to Perform database transaction and security audits
• Migration of form and Self Service personizations for all modules.
• Monitoring the table spaces of DEV/UAT and Production instance
• Applying Patches and Doing Clones of instance as and when required
• Ensuring backup of Production instance on day to day basis
• Troubleshooting the users day to day issues with seniors
• Perform assigned tasks on the basis of assigned Tickets and approved change request of Production
• Migration of users and their roles at the database level through export and import Command.
• Interacting with users and resolving all the issues.
• Developed and executed Unix Shell Scripts for frequent cloning.
• Taking Care of WorkFlow administration Activities.
• Migration of Users, responsibilities, Request Groups, Menus through FNDLOAD Command.
• Experience to Perform database transaction and security audits

Environment: Oracle Application 11.5.9 Oracle 9.2.0.8 Dual Node AIX 5.3