SUMMARY

• Over 7 plus years of IT experience in Design and Development of Client/Server, Web server applications using Oracle 11g/10g/9i/8i databases at Production and Development environments in various domains like finance, healthcare and manufacturing on UNIX & Windows NT/2000/2003 Platforms. Expertise in SQL, PL/SQL, and Oracle forms 10g/6i, Reports10g/ 9i/6i and UNIX shell scripting.
• Experience in working with different environments/versions and server administration including LINUX, Windows, SOLARIS, AIX and HP - UX.
• As an Oracle Apps DBA key responsibilities include Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers.
• Expert in Installs of Release R12 12.0.4 & 12.1 with ASCP, WIP, BOM, INV and Demantra Integrations.
• Experience as Oracle Applications DBA providing support to many Production, Development, Test, CRP instances (Large and VLDB databases) comprising some of the more complex and challenging environments from versions 11.5.2 through R12 with modules being GL, Financials, AP, AR, BOM, HR/Payroll, OM, INV, OE/ONT, OID, OWB, PA, PO, FA, MRP, MFG, ASCP, MSCA,MMS,OTC,OPS.
• Expert in Installs of ASCP supply chain environment with Demantra 7.2 and E-business environments.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System Administration & Hyperion Financial Management (HFM).
• 3 years of working experience on oracle products like Financial Accounting Hub for accounts validation, Financial Data Quality Management with Oracle Essbase and DRM/MDM.
• Expert in packages Oracle Enterprise Manager, TOAD, SQL Navigator, RMAN, Apache, HTML, RMAN, Schema Manager. Working in environments constituting iAS, Oracle Self Service Web Applications, XML, Discoverer (3.x, 4i).
• Experience in Implementation and Customizations, Custom Application, Code Migrations.
• Strong Experience in Cloning & Patching 11i, R12 Instance using Rapid and manual cloning.
• Proficient in installation and upgrading Oracle Applications 11i E-business suite to R12.
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Applied patches to update and security fixes to Oracle E-Business Suite 11.5.5, 11.5.9, 11.5.10.2.
• Multiple upgrades of Oracle Apps 11i, which includes database upgrade from 9i to 10g as well as application tier upgrade from 11i to R12, Upgraded Oracle 11i Applications Database 9i (9.2.0.6) to 10.2.0.3 on Linux, Performed Oracle EBS 11i migration from HP-UX to LINUX.
• Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM).
• 5+ years of strong working experience on Oracle forms and reports 6i & 10g and 11g.
• Implementation, troubleshooting forms server, report server, Discoverer server, Web Server.
• Installed and Configured 10gRAC with PCP for E-business 11.5.10.2 and 12.1.1
• Extensive experience in working with Oracle Developer Suite 10g, Developer 6i, Discoverer 4i, Workflow 2.6 and Application Express 2.2/3.0.
• Installation, configuration and maintenance of Oracle 10g RAC, 9iAS/10gAS, E-business 11i, R12 with ASM, FLASHBACK and Standby (DATAGUARD).
• Oracle 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Installed and Integrated Oracle Internet Directory with 9i database with Single Sign On.
• Installing, configuring and maintaining Oracle Grid Control (10g grid).
• Extensive experience in working with the utilities like OEM, TOAD, Export/ Import, SQL* Loader, SQL Analyze and Oracle Supplied DBMS PACKAGE.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF and Explain Plan.
• Expertise in configuring backup software like VERITAS Netback up, Legato Networker for oracle using RMAN tool for backup and recovery.

TECHNICAL SKILLS

Applications: Oracle EBS 11i/R12, Oracle Application Server 10gAs and 9iAS

Databases: Oracle 8i,9i and 10g RAC, 11g R1, 11g R2

Platforms: Windows NT/2000/2003/XP, RHEL, Sun Solaris, AIX, HP-UX

Languages: C, C++, Java, J2EE, SQL, PLSQL, Perl, Shell Scripting, Pro*C

Performance Tools: TKPROF, STATSPACK, Explain Plan, ORADEBUG

Others: AD Utilities, SQL * Loader, TOAD, XML/BI Publisher, Workflow Builder, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, TX

Oracle DBA

Responsibilities:

• 24x7 Production Oracle Applications Maintenance, Support and Administration.
• Administration of Oracle ERP applications 12.1.3, 12.1.1 and 12.0.4
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Implementation, customization and personalization of Oracle iProcurement.
• Setup and tested monitoring of applications, databases and servers using DBSPI/HP-Openveiw.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Created a Real Application Clusters (RAC) environment for E-Business Suite.
• Performing backups and recoveries using RMAN/ conventional hot backups/Export dumps.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN and Netapps.
• Monitored performance and availability of Oracle Applications through Grid Control & OAM.
• Development & Test Environment Support includes cloning, project support, patching and bug-fixing.
• Upgraded Oracle Applications from 11.5.10.2 to Release 12.1.1 on Solaris 10.
• Creating and dropping of users, granting and revoking rights as and when required.
• Cloning databases, applications and Disaster Recovery Database.
• Tuning heavy data loads, Monitoring and Performance tuning.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Partitioning strategies for very large tables.
• Diagnose and troubleshoot Database problems and failures
• Implementing range, list partitions, hash sub partitions.
• Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.

Environment: Database 9i/10g/11g RAC, SQL, PL/SQL, SQL*Loader, Solaris 9/10, Linux 4, 5.

Confidential, OH

Sr.Oracle Apps DBA

Environment: RedHat Linux 4/5, SUN Solaris 10, 10g (10.2.0), Oracle Applications EBS 11i/R12, Oracle 10g/11g RAC, TOAD

Responsibilities:

• Upgraded database from Oracle 10g to Oracle 11g RAC.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Upgraded Oracle Applications 11i (11.5.5.10) Database Version 8.1.6.4 to 10g (10.2.0.4) on Solaris.
• Applied mini-packs, CPU patches, family packs using ADPATCH, ADCTRL utilities.
• Configured Vertex for TAX integration, Outerbay Archive for Archiving Financials Data.
• Oracle Application R11i Upgrade (Apps11.0.3 to 11.5.3/11.5.5/9 iAS; Database8.1.6to 8.1.7/9i/10g)
• Created test environment through cloning production environment for developers to test on live data using rapidclone and adconfig utilities.
• Installed and Configured Discoverer 11.1.1.2 and Oracle OID 11.1.1.2 with E-business R12
• Implemented STAGED APPL TOP to reduce patching downtime.
• Automated database cloning using rapidclone to create the daily refresh environment through scripting.
• Implementation, Troubleshooting forms server, report server, Discoverer server, Web Server and Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Generated several reports using Oracle iExpense (OIE) module in two projects. Advised and made recommendations to improve the overall database design.
• Involved in developing a disaster recovery (DR) plan for Oracle Applications R12.
• InstalledOracleApplication Server 10AS 10.2.0.2,OracleDemantra 7.2 and configured. Setup war file for configuration betweenDemantraserver and Application server.
• Perform SQL tuning and assist developers with coding PL/SQL and code review of customizations.
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9iAS.
• Configuration of Workflow Notification Mailer, OAM, 10g Grid Control
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack).
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10g database.
• Expertise inmigratingformsfrom 6i to 10g.
• Skills in Oracle E-Business Application single & multi node Shared Installation with Dematerialize Zone DMZ security firewall.
• Installed and configured Single-Sign On with OID and Implemented SSL Security.
• Utilized VERITAS DBAC software to manage raw partitions and clustering on the HP-UX systems.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Applied NLS patches for Canadian French and Japanese Languages.
• Providing assistance with DBA related activities on Demantra 7.3 project, including but not limited to installation of Demantra 7.3, and applying patches.
• Securely implemented iRecruitment in the DMZ using a reverse proxy and SSL
• Designed and generatedformsfor data validation and processing in OracleForms10g/11g/6i and also in generating reports in Oracle Reports 10g/11g.
• Applied several Localization patches for country specific functionality.
• Converted the database into Automatic Storage Management (ASM) enabled database.
• Expertise inmigratingfrom Oracle10g to 11g
• Planning and Administration of backup and recovery strategies.
• Upgrades of J-initiator, Forms, and OJSP as part of the Applications Upgrade.
• Migrated existing RAC databases from VERITAS cluster server 5.2 to ASM.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new application messages and then generated message file for application.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Worked closely with users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Oracle 10g and 11g Database Implementation/Upgrade/Support.
• Oracle 10g Application Server Implementation/Upgrade/Support.
• Oracle OID Implementation and Support.

Confidential, PA

Oracle Apps DBA

Responsibilities:

• 24x7 Production Oracle Applications Administration & Development & Test Environment Support.
• Created copies of production environment include PTCH, TEST, DEV, UAT, CRP, PROJ, SUPP using RAPIDCLONE.
• Installed and configured JRE 1.6.0 10 sun native plugin with E-business Release 11.5.10.2
• Installed Release 12.0.4 using rapidinstall staged software method.
• Installed and Integrated Discoverer 10.1.2.2 with E-business Suite.
• Developement Support including cloning, patching, sql tuning of customizations, project support.
• Oracle DataGuard Implementation for HA and remote DR site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.
• Installed, upgraded and maintained Oracle ERP applications version 11.5.10.2
• Installed and Configured Oracle Single Sign-On and Oracle Internet Directory 10g 10.1.4.3 E-business R12.
• Upgraded application from 11.5.9 to 11.5.10.2 using maintenance pack.
• Oracle DataGuard Implementation for HA and remote DR site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.
• Generated impact analysis and added patches.
• Administration of Oracle ERP applications version 11.5.10.2.
• Performed database and application cloning of Production database to TEST environment to provide users the live data for testing purpose.
• Migrated databases from Solaris to Linux using export/import of E-business Applications.
• Implemented SHARED APPL TOP to reduce patching downtime
• Applied patches using merged patches and non-interactive patches methods.
• Setup system profiles in Apps.
• Managed all aspects of the Company Tier 2+ global data center centers.
• Configured VERITAS Cluster server 5.2.
• Applied HRMS patches, quarterly tax updates for HRMS & Financials Data through quantum and vertex updates.
• Setup a test 9i RAC Cluster using Linux and produced detailed analysis of system performance.
• Installed Oracle Applications server 10g and integrated this with Oracle OID.
• Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
• Troubleshoot Concurrent service, Concurrent manager issues and Implementing Parallel Concurrent Processing (PCP) in both normal and RAC environment.
• Worked with Orchestration Team to simplify the integration Architecture and Transition to ESB.
• Involved in a project implementation of Installation and Configuration of SOA suite Version 10.1.3.3 including Application Server with OC4J, ESB, BPEL, OWSM (Oracle Web services manager) & UDDI Registry.
• Implemented Oracle 9i RAC on Windows.
• Registered customized applications, created and assigned responsibilities to users, customized menus, attached menus to responsibilities and finally this to users.
• Installed, Configured and Integrated OID with Single Sign On against 9i Database and VERITAS Cluster.
• Registered printer in Applications, custom printer drivers and custom print styles in Oracle Applications
• Created Pasta drivers for Multi-Language printer support in E-business Applications.
• Enabled Auditing feature. Worked on Workflow, Oracle Application manager (OAM).
• Created new application messages and then generated message file for application.
• Used TOAD, ADDM, AWR, ORADEBUG TKPROF, EXPLAIN PLAN and STATSPACK.
• 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.
• Provided application support to users and created a log of all the problems with solutions for futurereference.

Environment: Regular (non-ERP) Database Oracle 9i&10g, Oracle Applications 11i (11.5.9 & 11.5.10), Oracle 9i RAC, Release 12.0.4, HP UNIX TRU-64, Precise, SQL Loader, Toad, oracle Discoverer.

Confidential, NJ

Oracle Apps DBA

Environment: Unix/Linux, SUN Solaris 8, HP-UX 11.0, Windows, Oracle database 9i (9.2.0), Oracle Applications 11i (11.5.2, 11.5.5, 11.5.7), HRMS, TOAD, SQL Loader, AD Utilities, Exp/Imp, RMAN, TKPROF etc.

Responsibilities:

• Responsible for managing production, development & test databases and applications.
• Maintaining the Oracle Applications Systems including Oracle databases, Middle tier iAS Applications.
• Involved in Upgrading of Oracle Version 9.2.0.4 & Oracle Applications 11.5.5, 11.5.2 and supporting the production team.
• Cloning using Rapid clone, Autoconfig and adclone utility.
• Involved in database migrations cloning Oracle Applications (11.5.5, 11.5.2) production system, for testing and development purpose using rapid clone.
• In depth experience with oracle application utilities such as RapidInstaller, Rapid Clone, adpatch, adadmin, adsplice andadctrl.
• Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps.
• Experience in web development using HTML, JavaScript, and XML.
• Extensive experience in system architecture of 11i Applications implementation of various Financials modules like GL, AP, AR, FA, ASCP, MSCA, MMS, OTC, OPS etc.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent managers.
• Using AD Administration and other AD Utilities. Experience with Oracle Applications Desktop Integrator (ADI).
• Tuning the databases for optimal performance.
• Experience in installing, configuring, administering, and performance tuning Microsoft SQL Server 2000/2005 and MySQL
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Enabled Auditing feature for tables such as FND USER etc.
• Created new application messages and then generated message file for application.
• Created new concurrent managers, Purged concurrent requests table.
• Wrote custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Worked closely with users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Expert in Oracle SQL & PL/SQL.
• Good experience and knowledge on Discoverer, Idiscoverer. Performed Patch Management.

Confidential

Oracle Apps DBA

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

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, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
• Reorganization of the Database using export import.
• Developed Perl scripts with SQL Server 2000 to provide automated auditing of enterprise environment.
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• DB2 stored procedure (SP), user defined function (UDF), and user defined table function experience with DB2 SQL/PL.
• Database and SQL statement access plan optimization experience with DB2’s Explain, Visual Explain, and Design Advisor tools.
• 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 Packages and Procedures using SQL and PL/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.
• Provides technical assistance and user support functions.
• Participated in action planning and implementation.