SUMMARY

• 8 years of professional experience in Oracle Database Administration, Oracle Apps Administration, Oracle Application EBS Administration, Oracle RAC Administration, Oracle Discover 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.
• Expert in monitoring applications and databases using 12c grid control.
• Extensive experience in implementing advanced topologies of the Ebusiness suite like Shared applications tier, Split tier architecture, Parallel Concurrent Processing (PCP) and F5 load balanced web tiers
• Experienced in writing UNIX shell scripts and setting up CRON jobs for database needs.
• 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.
• Excellent remote systems support and troubleshooting capabilities.
• Experience in Installation of weblogic server for 11g discoverer and OID.
• Expertise in managing application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration and printer setup.
• Expertise in configuring Workflow Mailer and applying security patches and troubleshooting Workflow related issues and OPP related issues.
• Expertise in Fusion Middleware like SOA 11.1.2 and Discoverer.
• Supported most of the modules like Oracle FIN/HRMS, Oracle Supply Chain Management and Value Chain Management.
• Expert in upgrading Oracle Applications to 11.5.10.2 to 12.1.1 and 12.1.1 to 12.1.3
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF, Explain Plan, SQLT and SQL plan management.
• Experience in handling and administering Oracle 11i/R12 Instances using AD utilities such as adadmin, adctrl, admerge, adsplice, adpatch etc.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, 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.
• Configured R12 E - business suite in DMZ environment.
• Experience with installation and maintenance of Oracle Application Server (10g and 9i).
• Expertise in installing Discoverer and integrating to ERP Applications.
• Expertise in RMAN for recovery and cloning.
• 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, 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, Oracle Demantra, OEM, 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, Sunnyvale, CA

Oracle Apps DBA

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

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) to R12 (12.1.3) in a multinode environment.
• Migrated Oracle E-Business suite application tier from Solaris 10 to RHEL.
• Applied patches using ADPATCH, ADCTRL utilities.
• 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
• Installation and configuration of Discoverer11g and integrated with EBS.
• Experience in Installation and configuration of OID11g on standalone database with failover dataguard.
• Experience in Installing and configuring AMP(Application Management Pack) for EBS on OEM 12c and 11g for monitoring and patching activities.
• Oracle database upgrade from 11.1.0.7 to 11.2.0.3 and Applications upgrade from Oracle Applications (E-Business Suite) 12.1.1 to 12.1.3
• Supported major projects like HR Portal migration and Open Enrollment.
• 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 datagaurd
• Worked on latest EBS / Fusion applications technology as well as Discoverer 11g, OID and Enterprise Manager.
• 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 oncall Production support for various production databases
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Experience in applying Oracle FIN/HRMS yearly RUP patches.
• Performance tuning of Oracle Database, applications and queries.

Confidential, Seattle, WA

Oracle Apps DBA Consultant

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

Responsibilities:

• Upgraded Oracle Applications from 12.0.4 to 12.1.3 preserving the customizations.
• Involved in Cloning and patching of oracle applications EBS sR12.
• Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments.
• Monitoring of the DBs and applications components, proactive provisions on the environment, restore the service in case of incidents, work with the SMEs (subject matter expert) on the level 3 issues in case of bug or specific technology stack issues
• Implemented Oracle 11g dataguard for Production database with autoconfig database trigger which ensures real time failover of the Oracle Database
• Built production databases for MODELN project as per company standard and technical specifications.
• Participate to the maintenance of global converging Oracle solutions architecture and standard procedures within the Global DBA team
• Implementation of SSL for forms.
• Migrated Single Instance to RAC 11gR2(11.2.0.3)
• Setup PCP across concurrent manager nodes.
• Cloning test environments from Production using RMAN.
• Expertise on Cold/Hot/Logical/RMAN backup and recovery strategies and implemented automation scripts for RMAN full/incremental backups.
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Support Oracle OID/SSO Integration..
• Knowledge of 11g new features such as Automatic Health Monitoring, security, SQL Performance Analyzer, Real Application Testing.
• Responsible for implementing Load Balancing in RAC Database.
• Created and Managed Services using DBCA.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability.

Confidential, Tampa FL

Oracle Apps DBA Consultant

Environment: Red hat 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.
• 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, night time, 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, 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.
• Experience in system architecture of 11i Applications implementation of various Financials modules like GL, AP, AR, and 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.
• Ran Sqltrace and explain plans to investigate potential problem with some queries.