Summary:Oracle Applications DBA with 7+ years of experience in software industry and oracle applications administration in production, development and test environments. Good experience in Oracle E-Business patching, upgrading and Load balancing.

• 7+ years of Oracle Application and Database Administration experience on variety of Database versions 7,8i, 9i,10g,11g on UNIX, Solaris, HP-UX, AIX, Linux, Windows NT 4.0/2000 with HRMS, (HR, Payroll), Financials(AP,AR,GL,FA), Order Management, Compensation, modules using Apps (11.5.8, 11.5.9, 11.5.10), Oracle Application Server 9iAS, Developer 2000 6i (Forms 6i and Reports 6i, Net8, Sql*Plus, PL/SQL, Stored Procedures, DB Triggers etc).
• 7+ years’ experience in OracleDatabase Administration, Oracle Applications, Analysis, Design, Server Optimization Techniques, Production environment and Applications support
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Experienced and proficient with Oracle E-Business suite application (R12 12.1.3/12.0.x, 11.5.7, 11.5.8, 11.5.9 and 11.5.10) and Oracle Applications Server (9i/10g) in Sun Solaris, Red Hat Linux, AIX and Windows environment.
• Performed Application installation and upgrades.
• Expert in upgrading Oracle Applications to 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.3.
• Performed database installation and upgrades. Experience in setting up HTTP Load Balancing.
• Expert in upgrading Oracle Applications Technology stack (Developer patch sets, JDK, J initiator etc).
• Expert in Cloning using ADCLONE, Rapid clone and ADCONFIG.
• Expertise in implementing Shared APPL_TOP and PCP.
• Expertise in troubleshooting Workflow and Notification Issues.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues.
• Proficient in Oracle tools and utilities (Net8, Svrmgr, WebDB, OAS 4.0.8, Data Browser, Developer Suite, Export, Import, SQL*Loader, PL/SQL, OEM, IA, SQL Navigator, DB Artisan, ER Studio, Glance, SQL Expert) in UNIX (Sun Solaris, AIX, HP-UX) & Windows environment.
• Designed and implemented user security application that assigned Oracle Label Security (OLS) policy permissions to individual Oracle accounts to provide row level data security.
• Experience in general troubleshooting, fire fighting, and development of scripts, documentation, issue resolution, and TAR support.
• Well versed in implementing System Management and Monitoring procedures.
• Strengths include skills in SQL and PL/SQL.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Experience in Security Management and Database Auditing.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Experience in Installing, configuring and maintain Oracle RAC, data warehousing andData guard.
• Database Upgrading from one server to another using Export and Import utility.
• Used INFORMATICA (Power Center) tool as ETL tool for constantly moving the data from sources into staging area
• Development of the Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. (on ETL side) as per the design documents/communication
• Expertise in installing Discoverer and integrating to ERP Applications.
• Expertise in RMAN for recovery and cloning.
• Expert in Configuring Workflow Mail.

TECHNICAL SKILLS

ERP : Oracle E-Business Suite  R12: 12.1.3/12.0.6  11i: Ver 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.2. RDBMS:Oracle Server 8i/9i/10g/11g for Sun Solaris, Linux, AIX,HP-UXOperating Systems :Sun Solaris 2.6/2.5.1(SUN OS 5.5.1), AIX, HP-UX, Windows 95/98/NT, Windows NT 4.0 ServerLanguages :SQL/ PL/SQL, UNIX Shell Programming (Bornshell, Csh, Ksh) CrontabSoftware Tools/ GUI :Oracle Developer2000, Oracle Enterprise Manager (OEM), SQL Navigator, SQL*Plus and TOAD.Application Servers:Oracle 10g/9ias R2.

PROFESSIONAL EXPERIENCE

Client: Confidential, Denver, CO August 10 – Present
Sr.Oracle Apps DBA
As an Oracle Apps DBA, Successfully upgraded 11i version 11.5.10 to 11.5.10.2 to 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.3R12 and also performed database from Oracle 8.1.7 to Oracle 10g.
Responsibilities:

• 24x7 Production Oracle Applications Administration.
• Maintaining production, development & test databases and applications.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Upgraded Oracle Applications 11i (11.5.10) Database Version 8.1.7.4 to 10g (10.2.0.4) on Solaris.
• Involved in creating, editing, scheduling and deleting of sessions and batch of session using Workflow manager in Informatica.
• Designed and implemented OLS label cache to enable use of Hibernate with OLS and to improve performance by eliminating repeated use of Oracle conversion functions.
• Resolved session locking issues using Informatica repository manager
• Upgraded Oracle Applications 11.5.10 to 11.5.10.2, 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.3 and database 9.2.0.8 to 10g
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle Database which is on RAC.
• Successfully upgraded Oracle Applications 11.5.10.2 to R12 (12.0.4) in multinode configuration
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed installation and configuration of oracle SOA suite 10g/11g for the integration of Application and Database.
• Created test environment through cloning production environment for developers to test on live data
• Adapted persistence framework to make WebLogic Server container managed transactions operable with Oracle Label security using JMX MBeans to dynamically mange connection pools
• Administration of Oracle ERP applications version 11.5.10.2
• Good knowledge in Data Modeling tools like Ervin.
• Implemented AUTOCONFIG in the apps environment and used ADCONFIG, ADBLDXML commands
• Implementation, customization and personalization of Oracle iProcurement.
• Experience on various modules such as Financials, ASCP, MFG, CRM, AR, AP, GL, and PO.
• Involved in developing a disaster recovery (DR) plan.
• Implemented and support of both physical, logical standby databases and Oracle Data Guard.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, and Family pack).

Client: Confidential, San Antonio, TX October 08 – July 10
Sr.Oracle Apps DBA/DBA
Responsibilities:

• Upgraded 9i database to 10g (10.2.0.3) database.
• Upgraded Oracle Applications from 11.5.10.2 to R12.
• Post go-live support of Oracle Applications R12.
• Maintenance of 10g databases and other non-ERP Databases.
• Implemented parallel concurrent processing in R12.
• Cloning DEV and UAT instances from Production for testing.
• Configured custom Output Post Processor.
• Migrated the production database from Old servers to new servers.
• Successfully implemented 3-node RAC setup and made the environment stable.
• Have good knowledge on 10gAS OID, SSO and complete infrastructure and middle tier components of 10g.
• Configured load balancing on Apache and Forms Servers.
• Designed ETL process using Informatica tool to load form sources to targets through data Transformations.
• Applied the patch sets, one off patches, Opatch to the Development and production servers.
• Monitored databases using 10g OEM grid control.
• Implemented the Oracle E-business suite Application Management Pack on OEM.
• Implemented Shared APPL_TOP.
• Responsible for troubleshooting the issues raised by oracle ERP from both user community and development.
• Worked on the performance issues both at the database level and applications level.
• Worked with Oracle Support on resolution of SRs
• Created and monitored the concurrent managers
• Provided valuable suggestions for allocating system storage and planning future storage requirements.
• Responsible for Cloning of Database and Applications as per functional requirements.
• Implemented Oracle Applications upgrades, patches using various AD utilities.
• Prepared analysis for resolving system errors, disk space problems, and huge file sizes errors.
• Monitored Oracle Applications users using Oracle E-Business Suite.
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches etc.
• Developing UNIX and SQL scripts for the smooth functioning of database and application related issues.
• Gathered database/Objects statistics using DBMS_UTILITY, DBMS_STATS, and FND_STATS packages and ANALYZE command.
• Responsible for setting up the printers in Application environment.
• Upgraded JDK 1.1 to 1.3.1 as a part of the Oracle Applications Upgrade from11.5.10.2 to R12
• Troubleshooting throughout the project phases and TAR Management.
• Effective use of Oracle Web cache with multiple applications.
• Capacity Planning/Management (space/machine load/network).
• Moved the objects from one instance to other using FNDLOAD.
• Performed Application admin tasks using ADADMIN utility.
• Prepare and implement system management and maintenance procedures.

Environment:Oracle Applications 11i(11.5.9), Oracle 8i/9i, HP UNIX TRU-64, Precise, OEM, SQL* plus, SQL Loader, Toad, Oracle Discoverer, JDK 1.1/1.3.1

Client: Confidential, Salem, NH Aug 07 – Sep 08
Oracle Apps DBA/DBA
As an Oracle Apps DBA, responsible for installation, implementations, upgrades and smooth functioning of Oracle ERP applications on UNIX system and Oracle databases. 
Responsibilities:

• Maintained Oracle Applications Release 11i (11.5.10.2)
• Successfully completed 3 Test upgrades from 11.5.7 to 11.5.10.2
• Upgraded Oracle Application databases from 8i to 9i (9.2.0.7)
• Upgraded Oracle Application databases from 9i to 10gR2
• Implemented Parallel Concurrent Processing
• Installed, upgraded and maintained Oracle ERP applications version 11.5.9
• Upgraded application from 11.0.3 to 11i using Auto Upgrade.
• Administration of Oracle ERP applications version 11.5.10.2.
• Setup and implementation of Oracle Financial Analyzer.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purpose.
• Setup system profiles in Apps.
• Setup of test 9i RAC Cluster using Linux.
• Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
• Worked with Orchestration Team to simplify the integration Architecture and Transition to ESB.
• Implemented Oracle 9i RAC on Windows.
• Registered customized applications, Apps Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Installed, Configured and Integrated OID with Single Sign On against 9i Database.
• Registered printer in Applications.
• Enabled Auditing feature. Worked on Workflow, Oracle Application manager.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Created new application messages and then generated message file for application.
• Monitoring of database for growth and performance.
• Created new concurrent managers, Purged concurrent requests table.
• Wrote custom PL/SQL packages for DBA related jobs such as purging custom tables, loading datainto custom tables etc.

Environment:Unix/Linux, Oracle 9i&10g, Oracle Applications 11i

Client: Confidential November 06 - July 07
Oracle Apps DBA
As an Oracle Apps DBA, I was responsible for production, development and test instances of Oracle Applications 11.5.2, 11.0.3. Installed Oracle Applications 11i and up gradation from 11.5.5 to 11.5.6, up gradation from Oracle RDBMS 7.3.4 to Oracle RDBMS 8.1.7.4, developing PL/SQL Procedures, DB Triggers, Backups and Recovery.
Responsibilities:

• Responsible for both manage and support all Production, Development and Test instances of Oracle Applications 11.5.2, 11.0.3.
• Configured and Installed Oracle Application 11i using Rapid Install
• Upgrading the Base install 11.5.5 to 11.5.6 and maintaining Oracle Applications.
• Monitored the Applications and Database using OEM and OAM
• Setting up of printers in the Apps.
• Maintenance of concurrent processing requests and concurrent managers.
• Tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, and ADCTRL.
• Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.
• Creating the database, tables, and table spaces, data objects, setting privileges, indexes, user logins and passwords.
• Reorganization of the Database using export import.
• Database upgrade from Oracle Release 7.3.4 to Oracle Release 8.1.7.4.
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Design and development of major processing at the back-end through DB-Triggers, Stored Package and Procedures using SQL and PL/SQL and SQL.
• Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.
• Query optimization and tuning using tools like TOAD and SQL Loader.
• Provide technical assistance to developers in all matters concerning performance, application related issues.
• Debugged Oracle Reports and Oracle Forms programs.
• Created new Oracle Reports and Oracle Forms programs based on user specifications.
• Assists in design tasks such as debugging, specifications development and system integration testing.

Environment:Linux 2.4, Oracle database 7i&8i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader

Confidential August 04 – October 06
Jr. Oracle Apps/DBA
Responsibilities:

• Installation of Oracle Application 11.5.2.
• Cloning of Application Instance -- Single node to two node Using AD Clone. Applied the patches using ADPATCH.
• Performed Application admin tasks using ADADMIN utility. Applied India Localization patches & resolving with Oracle.
• Registered Forms, created Form Functions and Menus. Registered Executables, created Concurrent Programs and Request Groups.
• Created Responsibilities and Application Users System Administration of 11i Setting up of printers in applications.
• Maintenance of concurrent processing requests and concurrent managers. Created and resized the new Data files. Pinning of Packages, Procedures and functions in SGA Run preparatory scripts -- admin server.
• Reset ORACLE schema passwords update configuration-related profiles apply product customizations to environment and files.
• Set rollback segments for normal use validate and compile APPS schema Creation of Schema objects and Space Management. To take backups as per the corporate policy and perform recovery as and when required.
• Developed Data Loading Scripts designed the database structures for the custom module Performed the maintenance of Database and Production support.
• Management. To take backups as per the corporate policy and perform recovery as and when required.
• Developed Data Loading Scripts designed the database structures for the custom module Performed the maintenance of Database and Production support.

Environment:Oracle applications E-Business suite 11.5.2, 11.0.3, Oracle 8i, SunSolaris 2.2, EMC TimeFinder, SRDF, PL/SQL, Forms 4.5, Reports 4.5.

Education:

• Bachelor of Science (Computers) .