SUMMARY

• Specialized in Oracle Applications R12/11i Database and System Administration with over 10 years’ experience under UNIX environment.
• 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 OAM and OEM.
• 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.
• Experienced and proficient with Oracle E - Business suite application (R12 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 and SUSE Enterprise Linux.
• Expertise in upgrading Oracle Applications from 11.5.10.2 to 12.0.4/12.1.1/12.1.3.
• Experience in database installation and upgrades.
• 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 Implementing SSL for Oracle E-Business Suite Applications
• Experience in handling and administering Oracle 11i/R12 Instances using AD utilities such as adadmin, adctrl, admerge, adsplice, adpatch etc.
• Cloning R12,11i Applications and databases using rapid clone technique.
• Experience in upgrading Oracle Applications EBS databases from 9.2.0.4 to 9.2.0.6/10g/11g.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Expertise in RMAN for recovery and cloning the databases.
• Experience in general troubleshooting, fire fighting, development of scripts, documentation, issue resolution, based on Oracle TAR/SR support.
• Expertise in implementing Shared APPL TOP and PCP.
• Expertise in troubleshooting Workflow and Notification Issues.
• Performed backups, recoveries using conventional Hot & Cold backups and RMAN.
• Experienced in Oracle Apps Administration and Sysadmin tasks
• Experience in setting up the Physical Standby database and configuring Datagaurd and test the disaster recovery scenarios.
• Good Knowledge on DMZ server configuration and Setups.
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues.
• Expertise in handling Many Oracle Applications Databases with sizes varying from 300 GB to 5 Tera Bytes.
• Lead/supervisory experience, responsible for leading the technical team, making assignments and being the point of contact for technical questions in regards to the project.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Strengths include skills in Shell Programming, SQL, SQL*Loader, Import/Export Data Pump and PL/SQL.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF, Explain Plan, SQLT and SQL plan management.
• Experienced in Space Management, Memory Tuning and Application Tuning.
• Excellent remote systems support and troubleshooting capabilities.
• Create and Maintaining the Technical Notes and Documentation.
• Excellent Team Player, hard working, good in analytical and logical problem solving abilities with good presentation and communication skills to provide support to the Customer.
• Ability to work flexibly as a team member and ability to perfectly plan and execute the given job to perfection.

TECHNICAL SKILLS

ERP (Incl. Versions): Oracle Apps EBS R12 (12.0.4, 12.0.6, 12.1.1, 12.1.3) Oracle Apps EBS 11i (11.5.10.2)

Database: Oracle 9i, 10g, 11g

Operating Systems: Sun Solaris 9 & 10, HP-UX, OEL, RHEL, SUSE 10&11

Languages: SQL, PL/SQL, Shell Scripting, PHP

Tools: FNDLOAD, SQL Loader, SQL*Plus, TOAD, SQL Developer, OEMHP-PPM/Kintana, OAM, FNDCPASS, RMAN, Data Guard, DataPump

Modules: System Administrator, AOL, FND, OM, HRMS

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Oracle Applications DBA

Responsibilities:

• EBS upgrade from 11.5.10.2 to 12.1.3.
• 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.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user
• 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.
• Customizing autoconfig templates according to the environment requirements.
• Installed, Configured and Administered Application Server 10.1.3.4.
• Closely worked with SQL loader, Export/Import, Data pump for data transfer.
• Analyzed AWR reports, ASH reports to tune to databases instances.
• Install, configure and troubleshoot all components of Oracle Applications tech-stack 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.
• Implemented PCP on 12.1.3 multinode with failover.
• 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, Pennsylvania

Oracle Applications DBA

Responsibilities:

• Upgraded Oracle EBS database 10g 32bit to 11g 64 bit and moved the same from Solaris 8 32 bit RHE 5.4 64 bit Server
• Extensively used export-import and Data Pump -- Expdp/ Impdp to take logical backup and migrate databases from 32-bit server to 64-bit servers in different environment.
• Upgraded Oracle E-Business suite from 11.5.10.2 to 12.0.6.
• Scheduling meeting with the Application Team in different location to gather the information for migration.
• Applied the localization patches and used adsplice to register the product.
• Providing on-calls Production Support on application side.
• Cloning Development, Test, QA instances periodically from the Production Instance.
• Interaction with oracle support and management of SRs for issue resolution.
• Applied the diagnostic patches which help in getting the diagnostic information, which can be provided to Oracle Support SRs.
• Adding space to the data files to accommodate growth of tablespaces.
• Scheduling the purge programs to remove the old files which can save a lot of Space on server.
• Production application and database patching coordination between PROD, TEST,DEV Instances.
• Created custom tops.
• Bouncing the Apache and Workflow Notification Mailer services based on requirement.
• Reset ORACLE schema passwords by using FNDCPASS.
• Tracking analyzing the invalid objects, compiling and validating the invalid objects.
• Creating Database Objects for Custom Applications.
• Troubleshoot problems with web server, forms server and concurrent managers.
• Experienced in handling regular maintenance tasks like Purging Concurrent manager log files.
• Worked on resolving connectivity issues related to TNS entries and SQLNET.
• Experience in the creation of Oracle Applications Database Links.
• Worked on Materialized views in synchronizing the database tables.
• Install, upgrade and configure Oracle RDBMS Software (10g& 11g) and applying CPU patches from Oracle.

Confidential, Ohio

Oracle Applications DBA

Responsibilities:

• Upgrded EBS from 12.0.6 to 12.1.1 on RHEL Server release 5.9 (Tikanga) on Multi Node.
• Upgraded R12.1.1 Applications to R12.1.3
• Upgraded EBS database form 10.2.0.6 to 11.2.0.4
• Implemented PCP for the Concurrent manager Node
• Working on weekend maintenance Activities that involve service bounce, Table space report gathering, clearing logs on middle tier and database. Also involves other planned maintenance and unplanned issues handling
• Performing daily checks and health checks on Apps instances.
• Configured Cisco http Load balancer for EBS R12 Applications
• Addressing Apps performance issues like Oracle R12 Slowness, Long running Concurrent Programs.
• Clone, Patch, Autoconfig, Node movement etc. Apps administrative tasks
• Performance tuning of database and SQL to improve application performance
• Responsible for Backup and recovery of Production Database and Applications
• Created custom top, Custom EBS menus and Personalization’s
• Responsible for code migration using stat change management solutions for Live Production Instance
• Enabling and Disabling profile options to troubleshoot the Issues related to EBS Applications
• Currently helping team to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.
• Configured Physical standby database with the Data guard technology
• Good Knowledge on DMZ server configuration and Setups.
• Document current state of EBS monitoring, understand existing tools, etc.
• Trouble shooting performance issues related to system & application performance
• Responsible for setting and managing user accounts, defining grants, setting up roles.
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN
• Supporting Technical team/ or development team in code migration using HP/PPM
• Concurrent Managers administration and Troubleshooting CM related issues.
• Shell scripting for cron jobs & some customization in already created scripts.
• Cloning R12 EBS Applications from PROD to DEV,TEST and UAT Environments.

Confidential

Oracle Applications DBA

Responsibilities:

• Maintaining production, development & test databases and applications.
• Upgraded Oracle Applications 11i (11.5.10) to R12 (12.1.1) 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 Installing and configuring AMP(Application Management Pack) for EBS on 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.
• 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
• 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.

Confidential

Oracle Applications DBA

Responsibilities:

• Involved in oracle ERP database upgrades from 9.2.0 to 10.2.0.2. Planned, tested database.
• Performing the daily health check of Application and Database server on Prod/Dev/Test environments. Database space management at tablespace level and maintain archive log space.
• Patch analyzing and patching the different application tiers.
• Move all custom programs and reports to production; this involves enforcing naming standards, maintain the custom application top, and setting up concurrent requests.
• Configuring and supporting the oracle workflow components for oracle applications.
• Involved in Cloning of application instance and refreshes from production to non-production instances.
• Setting up the printers in Application environment.
• Migrating the custom code form development instances to Production instances using Kintana tool.
• Trouble shooting concurrent manager issues and its operations.
• Administering Oracle Applications instances using Utilities like AD Administration, AD Controller, Auto Config, AD Relink and Auto Patch, f60gen and managed passwords by using FNDCPASS.
• Performed Tracing of various User sessions, Forms sessions and Concurrent program.
• Performing password management of Oracle Applications instances and users.
• Monitoring, identifying and resolving user issues.
• Performing tracing through tkprof, explain plan and analyze the files for identifying issues.
• Running Gathere schema Statistics programs for different schema's for performance improvement.
• Implemented the use of oracle recovery manage RMAN to perform cold and hot backup of the databases.

Confidential

Oracle Applications DBA

Responsibilities:

• Responsible for both managing and supporting all Production, Development and Test instances of oracle Version 9.2.0.6 and Oracle Applications 11.5.10.2 .
• Upgraded QA instance database from 9.2.0.6 to 10.2.0.4.
• Cloning Oracle Applications 11.5.10.2 from production system, for testing and development purpose.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch, Security patches etc on.
• Performed day-to-day database and oracle apps tasks like code movements, package and form compilations.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity
• Tracing the alert.log file for “ORA” messages, Monitoring database to ensure smooth functioning of database
• Compiling forms/pll's, DB invalids.
• Worked on AD utilities (example: ADADMIN, ADRELINK, AUTOCONFIG etc)
• Experience with Installing and managing & maintaining databases in 24x7 Production environments on Multiple Applications tiers.
• Performed Shared Appl-top installation.
• Familiar in Multi node installation and as well as cloning (Rapid and Manual also)
• Performing Patch analysis, downloading patches and applying patches
• Applied oneoff, minipack and maintenance patches
• Reduced the patch time using features like defaults file and merge patch.
• Managing apps password, application user passwords and schema passwords.
• Responsible for backup & Recovery by using predefined RMAN & HOT BACKUP scripts.
• 24/7 customer support in monitoring production and development environments Tablespace monitoring.
• Month end Closing support and Supporting Technical team/ or development team in code migrations.

Confidential

Engineer - Applications DBA

Responsibilities:

• Installation of Oracle EBS software and Creation of Oracle Databases on Various platforms.
• Cloning, Patching, and Administering the Concurrent Mangers.
• Interacting with development team, carrying out the jobs as and when required/as per schedule.
• Monitoring and supporting non-Production server issues.
• Refreshing the database.
• Troubleshooting the user issues, interacting with the end users/ coordinating between development team / Users to carry out the Patching/ implementing new changes to the system.
• Applying application patches different server as per oracle suggestions and patches requested by users/developers.
• Familiar with Oracle Applications AD-Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, Auto Patch and Rapid Install, FNDCPASS, f60gen, CONCSUB etc.
• Good Understanding in Setting up the RMAN backup and recovery Scenarios.
• Performing the patch analysis and estimating the downtime requirments.
• Performing the code migrations quarterly basis on to the respective instances.
• Periodically cloning the production server on to Development Server.
• Developing Hot, cold and logical backup scripts to automate the backup procedures. Planning for storage spaces requirements and placing them for optimum I/O performance.
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.

Confidential

Oracle Apps DBA

Responsibilities:

• Responsible for Installation of Oracle Applications on Linux Platform.
• Monitoring and optimize the performance of the Standard Manager Pending Jobs and CPU usage.
• Cloning and maintenance of application system and database on Linux platform.
• Performing Patch analysis, downloading patches and applying patches
• Managing apps password, application user passwords and schema passwords.
• Handled weekend outages for maintenance activities
• Backing up the apps database and file system.
• Created Data Groups, Responsibilities and Users as part of system administration.
• Troubleshooting issues related to Concurrent Managers.
• Maintaining Oracle Applications by using administration utilities like AD Admin, AD Patch, AD Controller etc
• Applying RDBMS and Application patches
• Altered several components configurations like port numbers and made them Functional.
• Regular database activities, backups monitoring and issues resolving.