PROFESSIONAL SUMMARY:

• An Oracle R12/11i/10g/9i/8i Certified Database Administrator having 12 years of experience as Oracle Applications Database Administrator on Oracle Applications 12.1.3/12.1.1/12.0.6/12.0.3/11.5.10.2/11.5.10/11.5.9/11.0.3 on Sun Solaris, IBM AIX, HP - UX, Linux-x86
• Have around 6yrs of Oracle Applications 11i/R12 (ebiz) implementation and Production support experience
• Extensively worked on Sysadmin (user creation, responsibility assignment, patching, cloning etc.) activities of Oracle Applications 11i and R12
• Solid experience in Oracle Applications (R 12/11.5.10.2 ) Installations, Cloning and Upgrade to highest Patch Set Levels, Oracle 10g Application server setup and installation of Discoverer 10g, Oracle Enterprise Manager 10G/11G.
• Very good experience in supporting Oracle Applications 11i/R12 Prd servers having manufacturing (Order management, SCM, OE, PO, Inventory) and finance modules (GL, AR, AP, FA, PA) implemented
• Extensive experience in supporting multiple Oracle Applications, Oracle Application Server, Databases running 24x7 mission-critical / OLTP applications under multi-tier architecture demanding high availability and increased performance. Worked in environment where uptime SLA is 99.99%
• Experience in implementing RAC 11g RAC-to-RAC cloning, RAC-to-non-RAC cloning. Adding node, removing node and supporting day today performance and environment issue.
• Experience and expertise in Oracle Applications System Administration, Oracle Workflow, Oracle Self Service Web Applications including iStore and iSupplier. Strong experience in Parallel Concurrent Processing, Multi Node/Single Node Cloning of Oracle Applications, Application Tuning, Patching, Security Administration, Integration of Oracle Internet Directory and Oracle Single Sign On with Oracle E-Business Suite 11i/R12. DMZ configuration for External iStore and iSupplier Nodes. Implementing Reverse Proxy for Oracle SSO and Oracle Applications.
• Proficient in Space Management, Capacity Planning, Change Management, Backups and Recovery, RMAN, Disaster Recovery, Database and Applications Performance Tuning, Oracle Physical standby databases.
• Implemented DR site for 11.5.10 Oracle Applications and Oracle Application Server 10g (SSO/OID) using IP Change Approach. Integrating OID and Microsoft AD for various Single Sign-on Requirements and architecture. Customizing SSO Authentication Plug-in and Integrating Oracle SSO with CA Siteminder. Windows Native Authentication configuration with Microsoft AD and Oracle Single Sign-on.
• Extensive uses of utilities like Rapid Install, Rapid Clone, autoconfig, adpatch, adctrl, adrelink, adadmin, adident, adautoconfig for maintenance of Oracle application. Also conversant with SYSADMIN tasks.
• Extensively worked on responsibilities creation/migration, users/schema creaion and privilege assignment
• Worked on Database 8i, 9i 10g and 11g and used all advanced features of 10g like AWR, ASH, ADDM, Transportable Tablespace and Data Pump.
• Strong UNIX - Solaris, Linux, HP-UX and AIX experience
• Troubleshooting Oracle Concurrent Managers, Forms, Reports, Apache and OC4J oacore, oafm components.
• Experience in performing backup and recovery using backup tools like Veritas Backup Exec, Netbackup with RMAN integration.
• Understanding and Implementing High Availability and Disaster Recovery requirements and solutions. New IP Change Approach for DR Sites.
• Allocating system storage and planning future storage requirements for the Database System.
• Have strong experience on tuning database memory, application, I/O and operating systems
• Make recommendations regarding hardware needed to enhance the usefulness and speed of current or anticipated databases.
• Worked on several XML publisher configuration issues like changing .env file
• Strong technical background, communication and presentation skills, excellent analytical and problem solving skills, quality focused team player and highly result oriented, positive attitude with a commitment towards excellence.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Sun Solaris 7.0/8.0/9.0/10 Red Hat Linux 2.1/3.0/4.0/5.0 AS & ES IBM - AIX 5.1 Windows NT/2000/2003/XP

DATABASES: Oracle 8.0, 8i, 9i,10g & 11g Informix 9.3/9.4 DB2 8.0

ORACLE APPLICATIONS: Oracle Applications R12(12.0.1 to 12.1.3) Oracle Applications 11i(11.5.9,11.5.10,11.5.10.2) Oracle Applications 11(11.0.3)

TOOLS: Oracle11g GRID Control, DBASTUDIO, Erwin, TOAD, SQL Navigator, OBIEE, Perforce, Kintana (PPM),Vertex (ECM), Sabrix, SQL Developer RMAN, RAC, EXPDP/IMPDP, SQLLoader, Tkprof, Statspack, ADDM, AWR ISA (Informix Server Administrator)

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Responsibilities:

• Manage, maintain and Administer Oracle E-Business suite R12 which is 24X7 with Oracle Financials and ChRM modules on R12 release.
• Supported Implementing Oracle application new modules.
• Clone the Production system to create Test / Dev environment
• Working closely with the application development team for Bug Fixes and with Oracle Support for TAR.
• Performance Tuning of Oracle Application and Database
• Managing user accounts and their security privileges
• Database space management to optimize I/O, SQL Tuning.
• Defined Concurrent Programs and Manage Work sift for Concurrent Managers.
• Oracle AD: R12, in Shared APPL TOP, with all of the AD tools maintain apps/ database. Patch, clone, refresh, RAC, Dataguard (clod/hot standby), and PCP/load balance database and application configuration. Maintaining Work Flow.
• Shared Application Tier File System, NAS, OCFS2, node maintain.
• Oracle Database: RMAN create database technical stack for APPS/DB clone
• EMC power SAN disk RAID portioning and CRS, ASM install.
• RDBMS, Dataguard, RAC, clone database, ASM, RMAN
• OLTP/OLAP database administration, upgrade, patches, installation, RAC-Standby, rolling upgrade, RMAN, ASM, instance-SQL tuning, physical-logical standby.
• Grid Control/OEM management, installation and configuration.
• Oracle Server upgrading, installation, migration, configuration, patching, cloning.
• RMAN, Data Pump, SQL Loader, FLASHBACK
• OLTP database administration, upgrade, patches, installation, RAC-Standby, rolling upgrade,
• RMAN, ASM, instance-SQL tuning, physical-logical standby.
• Grid Control/OEM management, installation and configuration.
• Oracle server upgrading, installation, migration, configuration, patching, cloning.
• RMAN, Data Pump, SQL Loader, FLASHBACK online backup/restore, performance monitoring and tuning.
• 3- Tier architecture Oracle application server implementation management, standby database.
• Management on the use access control, SSL enable on application.
• Analyzing and applying CPU patches and tech stack upgrades (10.1.3.3 to 10.1.3.5)

Confidential, San Diego, CA

Responsibilities:

• Worked in 24x7 Production Oracle Applications Administration.
• Support for Production, Development, Test, Staging and UAT Instances.
• Performed database upgrade from 10g to 11g.
• Working closely with Functional/Developers and helping them in issues.
• Implemented Parallel Concurrent Processing (PCP).
• Periodic cleaning of Log/Output files.
• Compiling invalid objects in the database.
• Registering users, responsibilities and Organization ID’s.
• Organizing table spaces, data files and other database objects as per OFA standards.
• Managing schemas, tables, tablespaces, datafiles, and dblinks.
• Scheduling and Administration of backups and recoveries strategies.
• Creation of menus, request groups and responsibilities.
• Taking care of performance issues, created indexes and rebuilding the table structure whenever necessary.
• Setup RSA and DSA key authentication for Test and Production instances.
• Patching, cloning, using AD utilities like adpatch, adadmin, admrgpch, adclone.
• Database and Application cloning from production to test instances.
• Monitoring and handling Concurrent Managers related issues.
• Monitoring and administrating Oracle Workflow.
• Registration of New Oracle Apps users and System Printers.
• Administering and configuring Oracle HTTP web server
• Single-node Install & Multi-node Install of R12 Oracle Applications on test instances as part of future enhancements.
• Support functional and development teams for customization or development requirements.
• Good hands on experience in using tools TOAD, SQL* Plus, PL/SQL
• Deploying Code and testing on development instances once the developers provide code builds migrating the deployment to production.
• Auditing the Database at the user, object, session and privilege levels.
• Monitoring the instance statistics and tuning the database to improve performance.
• Good knowledge in system architecture of 11i Applications implementation of various Financials and CRM modules like GL, AP, AR, FA, OR and SCM etc.
• Compiling or registering forms using f60gen utility.
• Cloning of Oracle Application Production Instance for various ongoing development, enhancement, testing and support activities
• Patching Oracle Apps Instance for various bug fixes, enhancements and security issues
• Supporting various clients’ third party applications Markview, Sabrix, Logical Apps etc.
• Performing Production Server outage activities
• Custom code migration using Project & Portfolio Management (Kintana) tool
• 24x7 Production and non Prod Servers monitor for various alerts - like Space usage, locks, workflow issues, high load and high CPU usage.
• Supporting various Disco reports migrations and good experience in Disco Administrator and Desktop
• Configuring and troubleshooting XML publisher related issues.
• Supporting BPEL server for various issues
• Installed and configured OBIEE Servers
• Supported OBIEE reports development and migration
• Supported reports conversion from Discoverer to OBIEE
• ERP DB Upgrade/Minimum Baseline Patches Application
• Applied prerequisite database pathces
• Ran adpreclone on the DB node
• Upgraded Oracle Database from 10.2.0.4 to 11gR2(11.2.0.2)
• Applied Minimum Baseline patches for Oracle Apps 11i Instance
• Applied custom code to Oracle Applications Instance
• Cloned Support Instance from Prod instance
• Supported post upgrade and patch issues
• Logged TARs for post upgrade issues
• Applied all the India Localization Patches
• Cloned Development, Test and Pre Prod instances
• Migrated all the custom code using PPM (Kintana)
• Performed all the setups for multiple Set of Books (MSOB)
• Upgraded Discoverer EUL Schema (Noetix)
• Migrated all standard code and custom code related to Finance and Mfg modules
• Involved in Corporate Pilot Testing1,2 & 3 of the India Localization Implementation Project
• Supported Post-go live support of India Implementation.

Senior Oracle Apps DBA

Confidential

Responsibilities:

• Installed of Oracle Applications R12 prod and test instances on Red Hat Linux EE 4.0
• Created of Applications users and assigned responsibilities.
• Applied RUP1, RUP2 and RUP3 Patches
• Applied Financial product specific patches
• Interacting with users/developers and resolving their regular service requests
• Changed profile options for various financial functional setups
• Have resolved various issues related to setups
• Various TAR’s has been raised at the time of setups being done
• Trained Junior Apps DBA on Oracle Apps R12 and 11i (11.5.10.2)

Oracle Apps 11i PRD Support

Confidential

Responsibilities:

• Upgraded AD from AD.H to AD.I.2 by applying patch
• Taken back up of configuration files of both apps tier and db tier
• Applied database interoperability patches
• Created tablespaces as per tablespace mode
• Updated AutoConfig technology stack templates
• Installed the Release 11.5.10 Technology Stack Validation Utility
• Applied maintenance pack (MP)
• Applied security patches
• Applied latest consolidated help patch
• Dropped the MRC schema as it is no longer required

Confidential

Responsibilities:

• Maintaining accounts of both e-Business suite and Database on GSI (Global Single Instance) & SRV (Tele Service) Prod & Test instances
• Migrating the databases from Sun box to Linux Box using Exp/imp method
• Upgrading the databases of various GSI & SRV databases
• Adding of responsibilities after verifying appropriate approvals.
• Approving and troubleshooting various Database/Applications login issues
• Troubleshooting of various SSO (Single Sign On) issues.
• Interacting with users/developers and resolving their regular service requests
• Implementing scripts for various mass load/revoke of responsibilities on GSI & SRV instances
• Maintenance of HELPDESK package, which is used by APS (Access Provisioning System)
• Automation of Various Accounts/Responsibilities/Privileges
• Supporting implementation of APS (Access Provisioning System) in SRV (Tele Service) Instances.
• Creation new responsibilities for various E-Business Suite and Tele Service applications
• Supported CRM to GSI merge (C2G) and migration to 11.5.10(11i10) of Oracle E-Business Suite.
• Supported RDBMS migration from Oracle 9.2 to 10.1 on GSI & SRV Prod and Test Instances
• Validating, approving and auditing various db links in various GSI, SRV, CAPP, EDW environments
• Auditing of GSIAP for various secured responsibilities like System Administrator, SI ACCT, Application Developer etc.
• Worked as a SME (Subject Matter Expert) and prepared various SOX processes doc related to Security and System Access Management
• Working as a POC for APAC region for Security and System Access Management
• Monitoring the database performance using the stats pack reports
• Working on the RDBMS patching, Application Patching & database refreshes
• Setup the standby databases with manage recovery mode
• Weekend & weekly on call support.

Oracle 1St level Support.

Confidential

Responsibilities:

• Supporting users of large databases on Windows and UNIX platforms.
• Mentoring other Oracle DBAs
• Preparation of Technical information Notes on
• Performance tuning of oracle databases
• Backup and recovery
• Installation & configuration of Database on different platforms.
• Implementation of Standby databases (DR) and Dataguard