SUMMARY:

• Over 9+ years of extensive experience as an 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) Sun Solaris, Red Hat Linux environments and AIX.
• Installed Oracle R12 Applications version 12.2 and upgraded to 12.2.4 version.
• Installed Oracle WebLogic Server 11gR1 (10.3.4) version.
• Installation, configuration and upgrade of Oracle 10g RAC, Application Serve r 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 R12 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, 12.0.4, 12.1.3 versions of e-business suite.
• Experience in Installing and Configuring Oracle EDI Gateway product.
• Hands-on experience on Oracle Database upgrades from 10.2.0.4 to 10.2.0.5 and 11.2.0.3 and higher versions.
• 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).
• Oracle 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database(Data Guard), Materialized views, VCS, Streams Replication, Golden Gate.
• 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.
• Good working Experience on Sun Solaris, Linux, HP-UX and AIX.
• 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.1.3, 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

Tools: PL/SQL Developer, TOAD, OEM, OAM, SQL*Plus, SQL*Net, SQL*Loader, RMAN, ADDR, Export/Import, Dataguard, Oracle Golden Gate 11g.

Middleware: Fusion Middleware -10g AS (OC4J clustering, EM, web cache, OID/SSO,Discoverer) 9iAS (Jserv), Oracle SOA 11g, Oracle WebLogic Server 10.3.4

PROFESSIONAL EXPERIENCE:

Confidential, Hightstown, NJ

Oracle Apps DBA/Oracle DBA

Responsibilities:

• 24x7 Production support of Oracle Applications Administration
• Maintaining production, development & test databases and applications.
• Applied patches using ADPATCH, ADCTRL utilities.
• Upgraded database from Oracle 10g to Oracle 11g and Implemented RAC.
• 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.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Installed Oracle Applications 12.2 version and upgraded to 12.2.4 this is a fresh installation as the client moving from Lawson ERP to Oracle ERP.
• Migrated Day to Day code deployments into DEV, QA, UAT and PROD using HP-PPM tool.
• Bi weekly cloning from PROD to TEST environments includes SSO and Non SSO environments.
• Installed Oracle SOA 11g version from Scratch and integrated with E-business Suite.
• Installed Oracle WebLogic Server 11gR1 (10.3.4) version and integrated with R12 applications.
• Deployed applications (WAR, JAR, EAR) on multiple WebLogic Servers and maintained Load balancing, high availability and Fail over functionality.
• Configuration of JDBC connections and data sources with Oracle database server11g troubleshooting and fixing up problems.
• Performed Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Configured Workflow notification mailer, OAM, OEM10g and 11g.
• Worked on Dataguard setup and enabled the crons in Dataguard for archive logs shipping from Production database.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc).
• Responsible for both managing and supporting Production, Development, QA and UAT environments.

Environment: Oracle Applications R12.2, R12.2.4, 11.5.10.2, Oracle Database 11g/10g/9i, Dataguard 11g, Oracle SOA 11g, Oracle WebLogic Server 11gR1 (10.3.4), Unix/Linux, SQL, PL/SQL

Confidential, San Jose, CA

Oracle Apps DBA/Oracle DBA.

Responsibilities:

• Installed, Configured, and Supported Oracle Applications R12 e-business suite
• Monitored production, development & test databases and applications.
• 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 10g to Oracle 11g and Implemented RAC with Data Guard on UCS Linux (Cisco Hardware).
• Experience in replication using golden gate, materialized views.
• Replication and Extracting data and applying on production using Golden Gate.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Worked on troubleshooting the issues raised by users while running the OIC concurrent programs.
• 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 Cross Platform migration from HP to UCS Linux (Cisco Hardware) using Data Pump
• 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.
• 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.
• Worked on Dataguard setup and enabled the crons in Dataguard for archive logs shipping from Production database.
• Installed and Configured Clusters in WebLogic 7.x/8.x/9.x/10.x /11g environment.
• Managed Memory Leaks, adjusted JVM heap size, Perm size by tuning WLS heap size using Optimize IT, Jprobe and monitored error log files & messages for optimized performance of Weblogic Server.
• Deployed the applications in formats of WAR, JAR, and EAR in Weblogic 10.3.4
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Worked on Oracle Access Manager Configuration and access policy data from designated source directory.
• Worked on implementing Access Manager Components like Identity System and Access System.
• Worked on Apache webserver and involved in troubleshooting the issues in Apache.
• 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.
• Used OATM utility for tablespace migration.
• 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.
• Performance tuning of Oracle Database, applications and queries.

Environment: Oracle Applications R12, 11.5.10.2, Oracle Database 11g/10g/9i, Dataguard 11g, SOA 11g, WebLogic 8.1/9.2/10.3.4, Unix/Linux, SQL, PL/SQL.

Confidential, Irvine, CA

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.
• 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 RAC.
• 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.
• Worked on bouncing the Apache webserver upon user request to clear the cache.
• 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.
• Worked closely with Application Team for long running OIC Concurrent Jobs.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• 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), 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.
• 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.

Confidential, Torrance, CA

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.
• Installed Siebel Analytics (OBIEE) and integrated with CRM applications
• 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.
• Tuning the databases for optimal performance and monitoring CPU performance.
• 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.
• Worked on Oracle Demantra 7.3 installation.
• Integrate Oracle Demanta with Front end Applications.
• 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
• 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 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, Demantra 7.3

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.
• Responsible for installing Siebel, Informatica tool and create & restore repositories.
• 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