SUMMARY:

• 7+ years of professional experience in Software Development Life Cycle experience involving Requirements, Analysis, Specification, Design, Conversions, Installations, Maintenance, Upgrades etc.
• Oracle Apps DBA(E - Business Suite 11i and R12)
• Oracle DBA (Oracle RDBMS 9i /10g/11g)
• 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.1.1/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.1.1 and 12.1.1 to 12.1.3.
• Experienced inOracle E-Business Suiteimplementations and Upgrades from CRP, Development, and UAT to production as an Oracle Application DBA.
• 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).
• Good knowledge of Oracle XML Publisher, developing the XML Reports in Microsoft word and integrate to the Oracle Applications 11i E-Business Suite.
• 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 tuning issues.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF and Explain Plan.
• 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.
• Experience in installation and configuration of Oracle SOA suite 10g/11g.
• proficient in handling Oracle Applications Manager which provides a powerful set of features to manage Oracle Workflow, Patching, Configuration Utilities and Concurrent Processing
• Great experience in handling and administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, admerge, adsplice, adpatch etc.
• Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM)
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases
• Experience in general troubleshooting, firefighting, and development of scripts, documentation, issue resolution, and TAR support.
• Well versed in implementing System Management and Monitoring procedures.
• Strengths include skills in Shell Programming, 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.
• Database Upgrading from one server to another using Export and Import utility.
• Expertise in installing Discoverer and integrating to ERP Applications.
• Expertise in RMAN for recovery and cloning.
• Expert in Configuring Workflow Mailer.
• Expertise in applying security patches.
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX).
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues.
• Experienced in writing UNIX shell scripts and setting up cron jobs for database needs.
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC.
• Maintaining Hot Backups, Cold Backup.
• Strong Analytical skills and ability to interact with end-users, managers, and technical personnel.
• Good team player, self-motivated and a quick learner.

TECHNICAL SKILLS

Applications: Oracle EBS 11i/R12, Oracle Application Server 10g AS, Oracle Application Server 9iAS.

Databases: Installation, Implementation, Administration, Upgrading and Troubleshooting of Oracle 8i, 9i, 10g RAC, 11g RAC.

Tool/Utilities: TKPROF, STATSPACK, Explain Plan, ORACLE Bug DB, OEM.

Operating Systems: Windows NT/2000/2003/XP, RHEL, Sun Solaris, AIX, HP-UX.

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

PROFESSIONAL EXPERIENCE

Confidential, Redwood Shores,CA

Sr. Oracle Apps DBA

Environment:Red Hat Linux 5, OEL 5.4,Windows 2003,11g R1, Oracle Applications EBS 11i,R12 11g RAC,TOAD, Developer 6i.

Responsibilities:

• Worked on EBS R12 environments. Provisioning of R12 environments and apply latest patches using ADPATCH utility on environments as suggested by development and Quality people.
• Creation of Custom Applications, menus and responsibilities.
• Maintenance of Oracle Databases and Oracle Applications.
• Working on System Administrator Activities.
• Installation of Oracle Database and Oracle Applications.
• Responsible for supporting multiple instances, activities include installation, maintenance and upgrade of Oracle E-business Suite / Fusion databases.
• Supported cross-product support across entire EBiz suite and solved database/middle-tier issues with the development and release of Application products.
• Worked on latest EBS / Fusion applications technology as well as Portal, IAS, Enterprise Manager.
• Install, configure and troubleshoot all components of Oracle Applications techstack and maintained multiple Oracle databases.
• Perform day-to-day database administration and ensure integrity, security and availability of applications environments.
• Worked on setup and configuration of Fusion Middleware components Oracle SOA, Weblogic 12c and EM 12c.
• Manage storage and host resources for all the development and QA teams.
• Regular database activities, backups monitoring, issue resolving through EMS(Environment Management System Tool)
• Conduct training and mentor new hires on the core environment management platform.
• Upgraded EBS Database to 11g (11.2.0.3) RAC in both TEST and PRODUCTION environment.
• EBS upgrade from 11.5.10.2 to 12.1.3 and 11i to R12.1.3
• Jinitiator to JRE upgrade
• Applied patches using ADPATCH, ADCTRL utilities.
• Auto configure Customization
• Maintaining and patching Shared APPL TOP
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Configured RMAN backups.
• Performed NON-RAC to RAC and RAC to NON-RAC cloning.
• Performance tuning of Oracle Database, applications and queries
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Configured Workflow Notification Mailer for inbound and outbound processing.
• Maintenance and support of Development, Test and Production environments.
• Converted single instance e-business database to Oracle 11g RAC
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Installed and configured Single-Sign-On (SSO) and Implemented SSL Security.
• Daily Working on Bugs assigned to me via bug db template.

Confidential, Pleasanton, CA

Oracle Applications DBA

Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 (B.11.11), Windows XP, Oracle 8i (8.1.7), 9i (9.2.0) & 10g (10.2.0), Oracle Applications EBS 11i/R12, Oracle 9i & 10g RAC, TOAD, Developer 6i.

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.
• Upgraded Oracle E-Business Suite 11.5.10 to 11.5.10.2, 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.1 and database 9.2.0.8 to 10g
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle Database which is on RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Handled database migrations of Oracle Applications E-Business suite (11.5.8, 11.5.5, 11.5.2) production (3 Tier), test and development instances.
• Successfully upgraded Oracle Applications 11.5.10.2 to R12 (12.0.4) in multinode configuration.
• Performed installation and configuration of oracle SOA suite 10g/11g for the integration of Application and Database.
• Oracle Applications Upgrade from Oracle Applications(E-Business Suite) 11i (11.5.8¸11.5.9, 11.5.10) to R12/12i(12.0.4)
• Created test environment through cloning production environment for developers to test on live data
• Administration of Oracle ERP applications version 11.5.10.2.
• 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, PO, and INV.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• 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.
• Installed and configured Single-Sign-On (SSO) and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigned to users.
• Planning and Administration of backup and recovery strategies.
• Oracle 10g Database Implementation/Upgrade/Support.
• Oracle 10g Application Server Implementation/Upgrade/Support.
• Oracle Data Guard Implementation for High Availability and remote Disaster Recovery (DR) site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.

Confidential, O’Fallon, MO

Oracle Apps DBA

Environment: Unix/Linux, SUN Solaris 8, Oracle Database 10g (10.2.0.4), Oracle Applications 11i (11.5.10.2), TOAD, SQL Loader, AD Utilities.

Responsibilities:

• Successfully upgraded Oracle Applications Database from 10.2.0.2 to 10.2.0.4
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data.
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Implemented and supported AP, GL, AR, PO, HRMS modules.
• System Administration responsibilities include application security, scheduling work shifts, registering new concurrent programs / request Sets.
• Participated in a team to maintain and support Oracle Applications in 24 X 7 environments.
• Researched and resolved JInitiator performance issues and suggested migration to Sun JDK.
• Critical patch update/oracle support (TAR)/ application patching activity/Application bug fix as suggested by oracle support.
• Upgraded JInitiator and other technology stack components in development environment.
• Cloning of database and application environments using Rapid Clone and other cloning options to create an in house instance for internal research and development.
• Performance Monitoring, Space Monitoring / Capacity planning, concurrent manager tuning.
• Configured Workflow Notification Mailer for inbound and outbound processing
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Responding to different types of alerts automation using oracle alerts.
• Troubleshooting / resolving issues with concurrent managers
• Applied Oracle Projects Maintenance pack to Development environments.
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Performing pre and post health checkups of oracle 11i applications.
• Researched and documented available options to create a DB Link between oracle and SQL Development databases to rewrite the existing interface.

Confidential

Junior Oracle Apps DBA

Environment: Unix/Linux, SUN Solaris 8, Oracle database 8i (8.1.7) & 9i (9.2.0), Oracle Applications 11i (11.5.2, 11.5.5, 11.5.7), HRMS, TOAD, SQL Loader, AD Utilities

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, Auto config 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 knowledge and experience with oracle application utilities such as Rapid Installer, Rapid Clone, adpatch, adadmin, adsplice andadctrl.
• Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps.
• Extensive experience in system architecture of 11i Applications implementation of various Financials modules like GL, AP, AR, FA.
• 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).
• 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.
• Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• 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.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Assisted DBA in writing statements in Oracle SQL & PL/SQL.