SUMMARY

• 9 years of professional experience in Oracle Database Administration, Oracle Apps Administration,, Oracle Fusion Middleware, Oracle RAC Administration.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Installed and configured Oracle Application stack on both single node and multi node environments.
• Upgraded Application from 11i (11.5.10) to R12 (12.1.1) and to 12.1.3. And From 12.1.3 to 12.2.4.
• Experience in Installation and configuration of WebLogic server, OEM12c.
• Expertise on installing, configuring and deploying SOA, OBIEE and OID on WebLogic.
• Proficient in analyzing and optimizing queries, Performance tuning and providing reports using SQL Tuning advisor, SQL Baseline, OEM and TKPROF.
• Extensive experience in implementing advanced topologies of the E - business suite like Shared applications tier, Split tier architecture, Parallel Concurrent Processing (PCP) and F5 load balanced web tiers
• Backup and recovery of oracle database using RMAN.
• Work independently to ensure that the databases are operating efficiently and ensure proper backup and disaster recovery methods are maintained.
• Expertise in configuring Workflow Mailer and applying security patches and troubleshooting Workflow related issues and OPP related issues.
• Supported most of the modules like Oracle AR, FIN/HRMS, Oracle Supply Chain Management and Value Chain Management.
• Implemented SSL on WebLogic, EBS and upgraded SSL from SHA 1 to SHA2.
• Upgraded Java from 1.6 to 1.7 and 1.7 to 1.8 and also renewed code signing certificate in all the environemnts.
• Installation, Configuration and Maintenance of Physical standby databases in Data guard.
• Experience in handling and administering Oracle 11i/R12 Instances using AD utilities such as adadmin, adctrl, admerge, adsplice, adpatch, adop etc.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modelling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in converting single instance database to Automatic Storage Management (ASM)
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Experience with installation and maintenance of Oracle Application Server (10g and 9i).
• Experienced in writing UNIX shell scripts and setting up CRON jobs for database needs.
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues.
• Good team player, self-motivated and a quick learner.

TECHNICAL SKILLS

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

Fusion Middleware: SOA 11g, OBIEE 11g, OEM 12c, WebLogic 12c, OHS

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

Tool: /Utilities: TKPROF, Explain Plan, ORACLE Bug DB,, AD Utilities, SQL * Loader, TOAD, XML/BI Publisher, Workflow Builder, SQL Developer.

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

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Oracle Apps DBA Consultant

Environment: Red Hat Linux 5, Oracle11g (11.2.0.3), 11g (11.2.0.4), Oracle Applications EBS R12.2.4, SOA 11g, OBIEE 11g.

Responsibilities:

• 24x7 Production on Oracle Retail business Applications Administration.
• Supported R12 E-business suite(12.2.4) in DMZ in test and production environments.
• Part of smooth transition between HCL and Infosys in the project and lead with the new team.
• Provide technical assistance to all internal/ external customers and team members for any issues related to application.
• Cloned non prod environments from Prod environments using clonetab.
• Hands on Using Delphix for creating database in vmware while cloning using clonetab.
• Experience in supporting RAC database with failover data guard.
• Worked on Performance tuning of long running and month end jobs.
• Hands on in monitoring the alerts using Nagios.
• Applied application patch’s in the OLTP prod and ODS prod environments.
• Supporting application team for the month end closure and troubleshooting any long running or form related issues.
• Part of daily support tasks like data fixes, code migration etc.
• Supporting Fusion middleware (OID, SOA, Discoverer and OBIEE) troubleshooting issues related the application.
• Hands on deployments on SOA and OBIEE environments.

Confidential, Orland, FL

Oracle Apps DBA Consultant

Environment: Red Hat Linux 5, Oracle 11g (11.2.0.2), 11g (11.2.0.3), 11g (11.2.0.4), (12c) Oracle Applications EBS R12.1.3. R12.2.4, SOA 11g, OBIEE 11g.

Responsibilities:

• Worked on maintaining 23 TB 6 node RAC production, development & test databases and applications.
• Part of transition KT between 2 vendors (Wipro - HCL) in the project.
• Worked on 4 corporate loads which includes applying DB+GI PSU, OJVM patch‘s and code migrations.
• Part of upgrading and configuration of E business suite from 12.1.3 to 12.2.4.
• Hands on stage creation, enabling the ADOP and synchronizing the file systems.
• Applying application patches using ADOP utility.
• Involved in trouble shooting the performance related issue by tuning SQL using OEM and SQL tuning advisor.
• Analysed AWR reports, ASH reports, SQL profile to tune to databases instances.
• Performance tuning of Oracle Database, applications and queries.
• Worked on Concurrent manger tuning (PCP) for slow and fast running requests.
• Installation and configuration of OEM 12c and integrated with EBS and Database.
• Installed, configured and deployed OBIEE, SOA on WebLogic 12c (Fusion Middleware).
• Worked on configuring SSL in OHS and WebLogic.
• Implemented SSL in EBS and upgraded it from SHA1 to SHA2 for security and applied code signing certificates in the all the environments.
• Worked on workflow setups while cloning the lower environments from Production
• Oracle database upgrade from 11.2.0.2 to 11.2.0.4, 11.2.0.3 to 11.2.0.4 and 11.2.0.4 to 12c.
• Installed and configured golden gate 11.2.1.0.15 on Lower and prod environment.
• Upgraded golden gate for few test environments from 11.2.1.0.0 to 11.2.1.0.15.
• Upgraded GRC controls from 7.3.2 to 7.3.3.
• Worked on trouble shooting apache and forms related issues,
• Worked on FLASHBACK to restore on point in time recovery.
• Worked on the automated code migration in all the test environments.
• Worked on creating automated RMAN scripts for backups of Oracle Databases.
• Have been involved in cloning the lower environments from Production to keep all the environments on sync.
• Upgraded Java from 1.7 to 1.8 and supported application team in resolving the post-upgrade issues.
• Adding new space in the ASM based on the requirement to make sure the business runs smooth.
• Worked on export and import of few table for critical testing on the lower environments.
• Applied patches using ADOP, adpatch, and opatch auto utilities.

Confidential, Seattle, WA

Oracle Apps DBA Consultant

Environment: Red Hat Linux 5,Windows, SUN Solaris 9/10, Oracle 10g (10.2.0.5), 11g (11.1.0.7), Oracle Applications EBS 11i/R12.

Responsibilities:

• 24x7 Production on Oracle Retail business Applications Administration and oracle and SQL database.
• Maintaining production, development & test databases and applications.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Upgraded Oracle Applications 11i (11.5.10) to R12 (12.1.1) and to 12.1.3.
• Migrated Oracle E-Business suite application tier from Solaris 10 to RHEL.
• Experience in applying Oracle HRMS yearly RUP patches.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
• Created index and table partition for improving the performance.
• Installation and configuration of Discoverer11g and integrated with EBS.
• Enabled and disabled auditing at Site and application level for security.
• Worked on latest EBS / Fusion applications technology as well as Discoverer 11g, OID and Enterprise Manager.
• Experience in Installation and configuration of OID11g on standalone database with failover dataguard.
• Experience in Installing and configuring EBS on OEM 12c and 11g for monitoring activities.
• Oracle database upgrade from 11.1.0.7 to 11.2.0.3.
• Supported major projects like HR Portal migration and Open Enrolment.
• Cloned Oracle home to all non-prod instances and made sure everything is in sync with production.
• Upgraded Java from 1.6.0.17 to 1.6.0.35 and supported application team in resolving the post-upgrade issues.
• Upgraded oracle database 11.2.0.2 to oracle 11.2.0.4 with data guard
• Configured Oracle Data guard for Oracle Disaster recovery.
• Provide technical assistance to all internal/ external customers and team members during system problems and implementation.
• Applied patches using adpatch, adctrl and opatch utilities. Applying Oracle security patches within 30days of their release.
• Providing on call Production support for various production databases
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.

Confidential, Tampa FL

Oracle Apps DBA Consultant

Environment: Redhat Linux 5, Solaris 10, Oracle 11g, Oracle Applications 11i (11.5.10.2), R12 (12.1.3).

Responsibilities:

• Applied all the latest techstack and product based patches.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration
• Installation, creation of 11g databases for Testing, Development and Production.
• Worked on Oracle backup and recovery strategy, designing and implementation using cold backup, hot backup and RMAN methodologies.
• 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.
• Tuned the slow running concurrent requests and defined concurrent managers.
• Registering the new Forms, Reports, PL/SQL scripts as concurrent programs.
• Performed Oracle E-Business environment administration and management using ad tools such as adadmin, adautocfg, adpatch, adctrl, adsplice, adlicmgr, adaimgr.
• Customizing autoconfig templates according to the environment requirements.
• Installed, Configured and Administered Application Server 10.1.3.4 with SOA Suite (Fusion Middleware).
• Closely worked with SQL loader, Export/Import, Data pump for data transfer.
• Analysed AWR reports, ASH reports to tune to databases instances.
• Worked on semi - yearly disaster recovery test for Ebiz, markview, discoverer.
• 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.
• Responsible to improve the performance by using the hints 10046 trace, Indexes, Explain Plan, SQL plan baselines and SQL profiles.
• EBS upgrade from 11.5.10.2 to 12.1.3.
• Configured R12 E-business suite in DMZ in test and production environments.
• Implemented PCP on oracle RAC environment
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• 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.
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.

Confidential, O’Fallon, MO

Oracle Apps DBA Consultant

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.
• 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.
• Implemented High Availability replication and OC4J clustering for Infrastructure tier services.
• Implemented shared appl top in 11.5.10 environments
• 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
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.

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:

• 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 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.
• 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 ADAdministration and other AD Utilities. Experience with Oracle Applications DesktopIntegrator (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.
• Ran Sqltrace and explain plans to investigate potential problem with some queries.
• 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.