PROFESSIONAL SUMMARY:

• Having 11 years of Solid Experience in Oracle 11i, R12 Applications (R12.1.3 upgrade to R12.2.5, R12,Oracle EBS 12.2.5) and Oracle Applications Server (9i/10g) in UNIX Sun Solaris, Red Hat Linux, AIX and Windows environment.
• Experienced asOracle Applications 11i/R12 DBA&Oracle DBA, providing 24x7 support of both Production & Development on Various Platforms.
• Experienced in Oracle Apps Administration andSysadmin tasks
• Installation, Configuration & Deployment ofOracle E - Business Suite 11i/R12.
• Implemented Oracle Apps 11.5.10.2 withOracle RAC.
• Implementation of High Availability solutions withOracle 11g/10g RAC,Physical and Logical Standby Databases (Data Guard).
• Trouble shootingFormsserver,Reportsserver,Apacheserver,Jserv,Jinitiatorand Workflow.
• Expert in 11i AppsCloning, Implemented new techniques for Apps Refreshes.
• AppliedPatching,Upgrades, framework, SSL For 11i Apps.
• Application andConcurrent Managerload-balancing andFailover,Shared APPL TOPconfiguration.
• Excellent experience in Installation ofOracle 8i, 9i, 10g in UNIX/LINUX and Windows environment.
• Proficient in Database and Applications Administration activities such asUpgrades,Patches,TAR support,Backup and Recovery, Performance tuning, script development.
• Effective troubleshooting of Database and Performance problems.
• Worked with development teams and data administration staff to enhance Database and application performance.
• Extensive performance tuning of Concurrent programs, Concurrent Mangers andSSWA
• Very strong in Auto Patch, Upgrade, cloning.
• Expertise in usingADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG,ADMRGPCH, ADLICMGR&PTS tools.
• Experience on Multi Org
• Production DBA Experience on Oracle releases11g/10g/9i/8i
• Excellent knowledge in installation and maintenance of Oracle Application Server
• Expertise in configuring various oracle application modules likeDiscoverer, Workflow
• Management of schemas, objects &Partitioningthe tables & indexes.
• Experience in Confidential variety of different environments likeHP-UX,SUN SOLARIS,Linuxand Windows.
• Experience in managing very large databases (Multiple TB of size).
• Experience in administration of large Oracle database running inSANenvironment, setting up databases for bank environment.
• Write Korn shell scripts to monitor and maintain the Oracle Applications database.
• Performed backups and tested crash recoveries using conventionalHot&Coldbackups andRMAN.
• Proficient in performance tuning usingExplain Plan,STATSPACK,TKPROF, AWR, ADDM
• Expertise in installing, maintaining and administering Oracle Applications11i (11.5.8, 11.5.9, 11.5.10, R12)instances.
• Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
• Confidential very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS:

Operating Systems: Confidential -UX, Sun Solaris, Windows, Red Hat Linux, Oracle Enterprise Linux.

RDBMS: Oracle8i, Oracle 9i, Oracle 10g RAC, Oracle 11g RAC.

ERP: Oracle E-Business Suite 11.5.7, 11.5.8, 11.5.9, 11.5.10.2, R12.

Languages: Sql, C, UNIX Shell Scripting.

Tools: RMAN, OEM, OAM, SQL*PLUS, SQL*Loader, External Tables, TOAD.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

PROFESSIONAL EXPERIENCE:

Confidential, Irving TX

Sr.Oracle Apps DBA

Responsibilities:

• Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, firefighting, developer/integrator relations, script development, and documentation.
• Design and Implementing Business Continuity Plan for Oracle ERP Application with Active Data Guard.
• Performed R12.1.0 to R12.2.5 upgrade on RHL 7.3.29 and Solaris version 10
• Oracle Database 11g upgrade to 12c
• Performed 11.5.8 to 11.5.9 upgrade with migration from Windows NT to Sun Solaris 9.
• Applied patches for R12.1.0 and R12.2.4 on • Oracle 11i experience includes, 11.5.8 install and upgrade to
• 11.5.10 with the Forms, Web Server, Reports and Concurrent Mangers on Sun Solaris node.
• Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems.
• Monitoring the Application System with OAM.
• Involved in Web Logic 10.3, Oracle SOA suite and configuration in development to production environments
• Experience in weblogic troubleshooting, creating managed server and deployment process
• Installed and configured an Oracle Applications Release 11i (11.5.10) environment with Oracle database 9i Release 1 (9.2.0.5).
• Installing and maintenance of Oracle Applications 11i on Windows NT, Windows 2000 and Sun Solaris
• Cloning of application and the database by using autoconfig and creating multiple instances in Order to support the Application developers to test various scenarios.
• Coordinating with Oracle Technical assistance Team to resolve any issue relating to ERP
• Using AD utilities to maintain applications by compiling Apps Schema, Maintain Application Object menu, maintaining snapshots of the application using adamin and adpatch utilities for application of patches.
• Web Related Oracle webdb, Oracle web application server, SOA
• Configuring and setting printer setting and printer style for check Printing and other application Program
• Application System administration tasks such as Defining Responsibilities, User session Limits, Managing Concurrent programs and requests Purge Obsolete workflow data, Organizing Programs into request groups, defining data groups, Managing concurrent Programs by defining managers, scheduling requests to run at regular intervals, Cost based Optimization in applications, gather schema statistics, gather table statistics, administration of workflow to administer the workflow enabled processes.
• Frequent Monitoring of alert log, system log, for information or errors and resolve the same based on the logs
• Monitoring database for fragmentation and de-fragmenting of tables. Reorganization of the tables, table space Refreshing development database from production for testing
• Online / Offline backup of database using the archive logs and the sun operating system backup using at command.
• Planning the Disaster recovery in the event of database crash to recover without any loss of any data.
• Analyze, drop and recreate indexes to improve performance both with enterprise Manager and manually through command Prompt.

Environment: Oracle Applications EBS 11i/R12, Oracle 10g RAC, TOAD, RedHat Linux 4/5, SUN Solaris 10, 10g (10.2.0), AIX

ATT, Bothell WA

Sr. Oracle Apps DBA

Responsibilities:

• Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.
• Setup system and user profiles for Oracle Applications, administer concurrent managers and reports.
• Developed suite of utilities for maintenance of multiple Oracle Applications environments: environment configuration, initialize environment, automated databases, Webserver, Form servers and concurrent managers startup/shutdown process.
• Installed and configured Oracle Recovery Manager (RMAN), Oracle Management Server, Data Gatherer, Oracle Enterprise Manager with Diagnostic Pack and Tuning Pack.
• Performed databases performance tuning and monitoring using shell scripts, Oracle Enterprise Manager Tuning Pack, and Diagnostic Pack.
• Created and tested shell scripts for automated cold and hot backup. Installed and configured Veritas NetBackup with Oracle RMAN for all backups.
• Recovered/restored multiple databases from physical disk failure. These failures include lost of datafiles/system tablespace/control files/on-line redo logs.
• Administered Discoverer Business Area, End-User-Layer (EUL) and designed business critical reports using Oracle Discoverer and Oracle Reports
• Created and managed the project plan for upgrading EBS to 11.5.10.2/10 gR2-multi-node RAC/ASM/SSL and integration with OAS 10g/Portals and compatibility/upgrade of several third-party products into Confidential single integrated solution for global operations.
• Created and managed strategies for multi-vendor product mix and hardware/software cost matrix: procurement procedure, multi-instance development, and implementation process. Implemented oracle best practice standards and methodologies.
• Implement Oracle Advance Collections implementations project and provided all infrastructure support for Oracle Apps 11i.
• Perform performance tuning for database and upgrade Oracle Applications from 11.5.9 to 11.5.10.2. Responsible for customizations in 11.5.9 and the test plan for regression testing by respective functional users. Executed post-upgrade product-specific task and included business users for regression testing. Completed capacity planning and working on upgrade issues.

Environment: Oracle Applications EBS 11i/R12, Oracle 10g RAC, TOAD, RedHat Linux 4/5, SUN Solaris 10, 10g (10.2.0), AIX

Confidential

Sr.Oracle Apps DBA

Responsibilities:

• Involved in Installation of Oracle E-Business Suite R12 and Upgradation from 11.5.10.2 to R12 on Linux Platform Code migrations
• Cloning the Oracle Apps instances from prod to test by using Rapid Clone process
• Resolving issues related to Concurrent manager and login problems.
• Performing Patch analysis, downloading patches and applying patches by using Auto Patch (adpatch).
• Monitoring the Application System with OAM.
• Reducing the patch time using features like defaults file, merge patch.
• Applied the patches like one-off patches, mini patches, family patches, CPU patches.
• Converted forms socket to servlet forms mode.
• Adding new off cycle Products by using adsplice utility.
• Generated AWR reports and used TKPROF utility.
• Proactively monitoring the Application health checks and taking preventive action as required.
• Applied RDBMS patches by using Opatch.
• Installation of Oracle Weblogic 10.3.5 and deploying application
• Debugging the Apache issues by using Apache configuration & log files.
• Monitoring and resolving Database & Apps listener and tns issues.
• Tracing the User session, Concurrent program and Form session as per requirement or request mail.
• Troubleshooting all level issues, by working with oracle all levels.
• Cluster and Data guard issues.
• Have configured Data guard.
• Troubleshooting and Performance tuning of oracle Application / DB.

Environment: LINUX 2.6.9-67.ELsmp, Regular (non-ERP) Database Oracle 9i&10g, Weblogic10.3.5, Oracle Applications 11i (11.5.9 & 11.5.10), Oracle 9i RAC, Release 12.0.4

Confidential

Sr.Oracle Apps DBA

Responsibilities:

• Involved in Installation of Oracle E-Business Suite R12 and Upgradation from 11.5.10.2 to R12 on Linux Platform
• Cloned the Application instance from production to Test and Development using Rapid Clone and Manual Process.
• Relining the executables, generating forms, jar files, validating apps schema and compiling the invalids etc by using adadmin
• Worked with various Oracle Applications Utilities like AD Administration, AD Controller, Auto config, AD Merge Patch, AD Relink, AD Splice, AutoPatch, f60gen, CONCSUB etc.
• Done patch analysis, applied patches and checked the patch impact.
• Applied the patches like one - off, mini, family patches.
• Converted forms SOCKET to SERVLET forms mode.
• Used AD Controller to see the status of workers and restarted failed worker after resolving the problem.
• Assigned the specific Concurrent requests to concurrent managers and resolving issues.
• Debugging the Apache issues by using Apache configuration & log files.
• Resolving issues related to Concurrent manager and login problems.
• Reducing the patch time using features like defaults file, merge patch and using Adpatch options.
• Trouble shooted several worker issues while patching.
• Applied RDBMS patches by using OPatch.
• Changing the apps password and application user password by using FNDCPASS.
• Oracle Applications Troubleshooting on Apache (http Server) and Concurrent Manager.
• Responsible for creating Application and managing user accounts and assigning responsibilities.
• Monitoring the alert logs & Trace files.
• Taking the backup of the databases using RMAN, Logical, cold and Hot Backup procedures.
• Monitoring and resolving Database & Apps listener and tns issues.
• Tracing the User session, Concurrent program and Form session as per requirement or request mail.
• Performing routine checks of space utilization and Extended Table spaces by resizing/adding data files when needed.

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

Confidential

Sr.Oracle Apps DBA

Responsibilities:

• Responsible for the support and maintenance of the applications & databases
• Participate in Confidential team to maintain & support for multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.
• Install and maintain Oracle Applications in complex environments such as Single-node and multi-node installations.
• Cloning the instances from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.
• Work closely with teams including Applications development, database development, Oracle Support, and business community.
• Applying latest releases of the RDBMS patches from Oracle to the Production and test instance to resolve few technical challenges & issues.
• Concurrent Manager Creation, monitoring, tuning and troubleshooting.
• Applied and documented patches that included mini-packs, family packs and standalone patches.
• Applied the Application patches like one-off, mini, maintenance and family pack.
• Assigned specific concurrent requests to concurrent managers.
• Performing FNDLOAD/WFLOAD and FNDCPASS.
• Monitoring Tablespace for space usage and adding required space whenever it reaches threshold value.
• Worked with various Oracle Application Utilities like AD Administration, AD Controller, Autoconfg, AD Merge Patch, AD Relink, and AD Splice.
• Changing Apps Password and Application User Password by using FNDCPASS Utility.
• Performing operations like Creation of Users, Session Management, and Granting Privileges to users from Applications.
• Performed routine checks of space utilization and adding space to database when its needed.
• Extended Table spaces by resizing/adding data files when needed.
• Created new user accounts, profiles, and roles and assigned them to different users and enabled auditing to monitor the system privileges and roles granted.
• Carrying out migrations of code to UAT and production environments.
• Performed manual online backups & offline backups.
• Worked with DBA tools like SQL Loader, Import/Export and datagurd.
• Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
• Interact with Oracle Support for technical assistance requests.

Environment: Linux 2.4, Oracle database 9i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader

Confidential

Oracle Apps DBA

Responsibilities:

• Involved in Installation of Oracle E-Business Suite R12 & 11.5.10.2 on Linux PlatformCode migrations
• Cloning the Oracle Apps instances from prod to test by using Rapid Clone process
• Resolving issues related to Concurrent manager and login problems.
• Worked with various Oracle Applications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, AutoPatch, f60gen, CONCSUB etc.
• Performing Patch analysis, downloading patches and applying patches by using Auto Patch (adpatch).
• Monitoring the Application System with OAM.
• Reducing the patch time using features like defaults file, merge patch.
• Applied the patches like one-off patches, mini patches, family patches, CPU patches.
• Converted forms socket to servlet forms mode.
• Adding new off cycle Products by using adsplice utility.
• Good experience on Database recoveries.
• Generated AWR reports and used TKPROF utility.
• Resolving the Errors by analyzing the log files and error descriptions.
• Proactively monitoring the Application health checks and taking preventive action as required.
• Applied RDBMS patches by using Opatch.
• Debugging the Apache issues by using Apache configuration & log files
• Performed Database cloning from Production database to test database.
• Monitoring and resolving Database & Apps listener and tns issues.
• Knowledge in creating the Users, Responsibilities & registering the forms and Concurrent programs.
• Tracing the User session, Concurrent program and Form session as per requirement or request mail.

Environment: Oracle database 9i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader

Confidential

Oracle DBA

Responsibilities:

• Maintain Oracle server in complex environments such as Linux Servers.
• Monitoring table spaces size and resizing datafiles.
• Checking whether all the Database and applications are up and running or not.
• Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
• Monitoring the table space periodically for growth.
• Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export and Import utilities.
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Transferring the bulk data from text file into Oracle Database using SQL * Loader and export & Import utility for backup purpose and distributing the tables in multiple environments.
• An active member in the team of migrations.
• Giving Instance support to Development team for any Database Object modifications and Optimization
• Configuration of TCP/IP protocol, listeners, SQLNET and tnsnames.
• Maintaining Archive logs and their spaces.

Environment: Oracle 8i/9i OEM, Linux, Confidential -UX, TOAD, RMAN, Database Tools/Utilities, STATSPACK, TKPROF, UTL SMTP, SQL*LOADER