SUMMARY

• Over 8+ years of extensive experience as a Oracle Applications DBA as well Oracle DBA in Production, Test and Development environments.
• Installed Oracle 11i Applications E - Business suite (11.5.7/11.5.9/11.5.10/ R12) Sun Solaris, Red Hat Linux environments and AIX.
• Installation, configuration and upgrade of Oracle 10g RAC, Application Server 9i/10g.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Experience as Oracle Applications DBA providing support to many Production, Development, Test
• CRP instances comprising of some of the more complex and challenging environments from versions 11.0.3 through 11i releases.
• Experience in Installing and Configuring active modules being GL, AP, OM, INV, PO, AR, HRMS, FA, MRP, and ONT.
• Cloning Oracle 11i Instance using Rapid and manual cloning.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Installing and Upgrading Oracle Applications 11i e-business suite to R12.
• Administering Oracle 11i Instances using AD utilities
• Applying patches to 11.5.5, 11.5.9, 11.5.10.2, R12 versions of e-business suite.
• Experience in Installing and Configuring Oracle EDI Gateway product.
• Good working experience with EDI product to enable modules MFG, FIN, AP & PO.
• Implementation, Troubleshooting and Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Having good knowledge on Oracle Transportation Management (OTM) and Demantra .
• Oracle 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups
• Implementing High Availability solutions with Oracle 10g RAC, Standby (Datagaurd)
• Installing, configuring and maintaining Oracle Grid Monitoring.
• Extensive knowledge in working with the tools like OEM, TOAD, Export/ Import, Stats pack, SQL* Loader, SQL Analyze, TKPROF, Explain Plan, and Oracle Supplied DBMS PACKAGE.
• Hot and cold Backup and recovery of Oracle 10g database using tools like RMAN
• Scripting and scheduling of oracle database backup using RMAN.
• Good experience of Oracle PL/SQL, Procedures, Triggers, Cursors and Functions.
• Cloning of database for development teams, import and export of data.
• Installation and Maintained SOA/BPEL
• Good working Experience on Sun Solaris, Linux, HP-UX and AIX.
• Experience in Installation and Configuration of MS SQL Server 2000 & 2005
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases.
• This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Proven ability to adapt to demanding schedules and changing priorities
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Involved and implemented with analysts, developers, programmers and project managers in a project system development life cycle (SDLC) phases.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• Extensively worked in Oracle back-end programming and Front-end development using tools like workflow, PL/SQL, SQL*Plus, Oracle*Forms, Oracle*Reports, SQL*Loader, Toad and modified the formats using XML publisher.
• Experience working on Oracle work flow builder 2.6.3.5 and developed several custom work flows.
• Excellent interpersonal and communication skills. Ability to interact with people at all levels and good presentation skills.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R12, 11.5.10, 11.5.9, 11.5.8, 11.5.7

Databases: Oracle 9i/10g/11g RAC

Operating Systems: Oracle Enterprise Linux 3/4/5, Red hat Linux 2.1/3.0/4.0/5.0 , Sun Solaris 5.6/5.9/10, UNIX IBM AIX, SQL Server 2000 & 2005

Tools: PL/SQL Developer, TOAD, OEM, OAM, SQL*Plus, SQL*Net, SQL*Loader, RMAN, ADDR,Export/Import, Kintana

Middleware: Fusion Middleware -10g AS (OC4J clustering, EM, web cache, OID/SSO,Discoverer) 9iAS (Jserv)

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Oracle Apps DBA/Oracle DBA

Responsibilities:

• Installed, Configured, Upgraded and Supported Oracle Applications 11i e-business suite
• Monitored production, development & test databases and applications.
• Setting Up and Configuring Single Sign-On Using Oracle Access Manager and Open SSO Enterprise
• Installed Oracle Applications11i e-business suite 2 node with using Rapid Installation and performed cloning and patching.
• Upgraded Oracle Applications 11i e-business suite to R12 for test, development environments.
• Installed, Configured and Maintained modules AR, HRMS, AP, GL, PO, INV, OM.
• Troubleshooting concurrent manager, discoverer, forms, reports servers and workflow mailer problems.
• Performed Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Applied patches using ADPATCH, ADCTRL utilities
• Upgraded database from Oracle 9i to Oracle 10g and Implemented RAC with Data Guard on Solaris.
• Upgraded Oracle Database 9i (9.2.0.4) to Oracle Database 10g (10.2.0.3) on Linux.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc).
• Deployed SUN JRE 1.6 for windows clients recently from JInitiator 1.31 on Oracle 11i E-Business suite.
• Worked on supporting migration team that migrating from HP to AIX.
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Worked on Oracle Transportation Management (OTM).
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Worked on Applications Identity Management module.
• 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 user groups to ensure timely implementation of an ERP.
• Installation and Maintained SOA/BPEL.
• Manage and Monitor a BPEL Process.
• Configuring Oracle ESB Services.
• Very good experience in creating SR’s through Metalink.
• 24x7 Production support of Oracle Applications Administration
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Involved and Implemented Oracle 10g Application Server Implementation/Upgrade/Support.
• Installation and configuration of Oracle Application Server 10g (10.1.2.0.2 & 10.1.3.3) with portal as a partner application.
• Implemented cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.

Environment: Oracle Applications R12, 11.5.10.2, Oracle Database 11g/10g/9i, Unix/Linux, SQL, PL/SQL.

Confidential, Salt Lake city, Utah

Oracle Apps DBA/Oracle DBA

Responsibilities:

• Responsible for both managing and supporting Production, Development, Test databases (9.2.07, 9.2.05, 8.1.7.4) and Oracle Applications (11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2).
• Experience with Installing and managing R12 in single and multi node.
• Upgraded QA instance from 11.5.9 to 11.5.10. Experience with Applications 11i Rapid Install.
• Handled database migrations of Oracle Applications (11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2) Production (3-tier), Test and Development instances.
• Upgrading Oracle Applications 11i e-business suite to R12 on Test Database.
• Configured and maintained Linux Virtual Server and High-Availability Linux cluster for Course management system software
• Experience in Installation of 11i e-business on Linux, Solaris, AIX and Windows box in single and multi node.
• Setting Up and Configuring Single Sign-On Using Oracle Access Manager and Open SSO Enterprise.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Implemented Oracle Financials 11i Inventory, Project Accounting, Accounts Receivable and General Ledger for a major semi-conductor manufacturer
• Cloning Oracle Applications (11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2) from production system, for testing and development purpose.
• Upgraded Oracle Applications (11.5.8, 11.5.9, 11.5.10) to R12.
• Installed SOA/BPEL on Single node and on RAC.
• Troubleshooting application issues at various levels operating system/cluster database/instance/listener/concurrent manager/forms tier/webserver/BPEL.
• Designing backup strategy for SOA/BPEL.
• Good working experience on various modules such as Financials, Oracle Spreadsheet Server, HRMS, CRM, AR, OWB, AP, GL, PO, INV, FA, OM etc.
• Experience in configuring and customization financial accounting, general ledger ERP package using Oracle Spreadsheet Server.
• Experience in Migrating from HP to AIX.
• Experience in Installing and Configuring Oracle EDI Gateway product.
• Good working experience with Oracle EDI product to enable modules MFG, FIN, AP & PO.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch, Security patches etc on 11.5.2 through 11.5.10 instances.
• Experience with Installation, configuration, upgrade and performance tuning of Oracle RAC.
• Using shell scripting. The script is designed to perform preclone, database removal, restoration (datafiles and application binaries restoration), db recover, adconfig (on both DT and AT), and postclone, generating validation report in HTML format.
• Performed day-to-day database and oracle apps tasks like code movements, package and form compilations.
• Experience with maintaining, monitoring and administration of physical database on windows.
• Experience in creating SR’s, downloading patches from Metalink.
• Installed, Configured and Maintained MS SQL servers 2000 & 2005 databases.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases.
• This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.

Environment: Oracle Applications R12, 11.5.10, Oracle Database 11g/10g/9i, Unix/Linux, SQL, PL/SQL, SQL Server 2000 & 2005

Confidential, Bethlehem, PA

Oracle Apps DBA/Oracle DBA

Responsibilities:

• 24x7 Production support of Oracle Applications Administration
• Maintaining production, development & test databases and applications.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Good experience on Oracle 9iAS, 10g Discoverer Configuration, Idiscoverer, Punchout, ADI
• Installed ADF libraries, Runtime Support libraries, JDBC libraries, JDeveloper libraries prior to the installation of Oracle Application Server 9iAS/10gAS on test and development environments.
• Upgraded Oracle 11i applications version from 11.5.5 to 11.5.10.2
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Administration of Oracle ERP applications version 11.5.10.2.
• Good Knowledge in Data Modeling tools like Erwin.
• Setup and implementation of Oracle Financial Analyzer.
• Implemented a fully integrated solution utilizing Oracle Financials 11.03 for Financial Reporting, General Ledger, Accounts Payable and Project Accounting.
• 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, AR, AP, GL, PO, INV, HRMS, and OM etc.
• Experience in Implementation and Customization of Oracle Receivables.
• Generated several reports using Oracle iExpense (OIE) module in two projects
• Advised and made recommendations to improve the overall database design
• Monitored performance and availability of the VIS application (a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN.
• Oracle Applications Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Worked on Application Centric Identity Management and SOA-based Web Services.
• 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 Database Implementation/Upgrade/Support.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.

Environment: Oracle Applications 11.5.10, Oracle Database 10g/9i, Unix/Linux, SQL, PL/SQL

Confidential

Oracle Apps DBA/Oracle DBA

Responsibilities:

• Upgraded application from 11.0.3 to 11i using Auto Upgrade.
• Good Experience in installing and configuring modules such as Financials, AR, AP, FA, PO and GL.
• Administration of Oracle ERP applications version 11.5.10.2.
• Good Knowledge in Data Modeling tools like Erwin.
• Setup and implementation of Oracle Financial Analyzer.
• Performed Finance and Accounting functions for several departments.
• Prepared budgets, reports and financial statement.
• 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.
• Oracle Applications server including OID.
• 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. .
• Enabled Auditing feature. Worked on Workflow, Oracle Application manager.
• Created new application messages and then generated message file for application.
• Using TKPROF, EXPLAIN PLAN and STATSPACK for the Better performance.
• 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. Worked on PunchOut, Bulk Loader.

Environment: Oracle Applications11i, Oracle Database 10g/9i, Unix/Linux, SQL, PL/SQL

Confidential

Oracle Apps DBA/Oracle DBA

Responsibilities:

• As a DBA involved in maintenance of database and refreshing databases using methods static Backup, IMPORT and EXPORT
• Create users, granting privileges, roles and defining quota
• Involved in backup of the database
• Monitoring the database growth, fragmentation, rollback segments maintenance
• Creation of Table spaces, Schemas, Database triggers and Stored Procedures.
• Contributed in physical layout planning for the redo logs, control files and archive logs to minimize I/O contention
• Optimized database performance by analyzing tables and indexes
• Generation of complex procedures, functions & triggers for business logic.
• Maintenance database security.
• Evaluate Oracle features and Oracle Related Products

Environment: Oracle Applications 11i, Oracle Database 8i/9i Unix/Linux, shell script, SQL, PL/SQL.

Confidential

Jr.Oracle DBA

Responsibilities:

• Creating and sizing of database objects (table spaces, tables, and indexes).
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures.
• Management of Users, Roles and Privileges
• Database performance tuning, table sizing and administration
• Scripts to monitor online Database objects and SGA.
• Diagnose the bottlenecks and problems causing poor performance
• Database reorganization to minimize fragmentation.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Clone the database for debugging application bugs.
• Data extraction and Loading using Export/Import and SQL*Loader.

Environment: Oracle 8i, SQL, PL/ SQL, Rman, HP-UNIX