SUMMARY

• Over 9+ years of Extensive experience in wide range of Oracle Technologies including Oracle E Business Suite 11i and R12 on LINUX and Solaris environments as a Database administrator.
• 8+ years of solid experience in Oracle 11i, R12 Applications (R 12 12.1.3/ 12.0. x, 11.5.10, 11.5.9, 11.5.8, 11.5.7) and Oracle Application Server (9i/10g) in UNIX, Sun Solaris, Red Hat Linux, AIX and Windows environment.
• Experienced in Linux and Windows System Administration
• Architecture, Installation, Cloning and Patching (version R12,11.5.8 to 11.5.10.2
• Oracle Apps Server 10gAS (Forms/reports
• Upgraded EBS 11i AIX 5.3 to R12 Exalogic Linux
• Expert in Cloning of databases from RAC to RAC and RAC to non - RAC
• Converted Single Node Non-ASM Database to 2 Node RAC ASM Database.
• Oracle Database Infrastructure experience on Single node, multi-node and RAC.
• Creating maintaining, Tuning Standby databases, Disaster recovery using Datagaurd Broker.
• Concurrent Manager Setup and trouble shooting
• Installed and configured the Oracle Fusion Middleware for Oracle Forms, Reports Discoverer 11GR1 and Oracle SOA Suite 11gR1.
• Strong Experience in Cloning & Patching 11i, R12 Instance using Rapid and manual cloning.
• Proficient in installation and upgrading Oracle Applications 11i e-business suite to R12.
• 5 years solid experience in Solaris (versions 2.6,7,8,9,10)
• Familiar with pl/sql programming.
• Has good experience in SQL Server Clustering and MSSQL Server 2000/2005/2008/2012 Log Shipping, Database Mirroring.
• Worked on AIX operating system.
• Applied patches to update and security fixes to Oracle E-Business Suite 111.5.5, 11.5.9, 11.5.10.2.
• Experienced in Oracle Financials HRMS and AP, AR modules etc.
• Worked on dedicated storage networks like SAN.
• Multiple upgrades of Oracle Apps 11i, which includes database upgrade from 10g to 11g as well as application tier upgrade from 11i to R12, Upgraded Oracle 11i Applications Database 10.2.0.5 to 11.2.0.3 on Linux, UNIX and Solaris
• Administrating the oracle database and applications with the AD utilities. Adautocfg, adaimgr, adadmin, adpatch, adrelink
• Administrate the forms and reports using with AU utilities
• Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM).
• 5+ years of strong working experience on Oracle forms and reports 6i & 10g and 11g
• Experienced working in OLTP and Data Warehouse environment
• Administrating the AOL/FND for setup the new user set user and system privileges
• Configuring the client connect to the applications through the Browser
• Apply the patches like patch, mini pack, maintains pack to fix the bug.
• Application’s sysadmin tasks like creating and managing users and their responsibilities, Menus, Functions, Profiles, Alerts.
• AD Utilities adadmin, adpatch, admrgpch, adctrl etc.
• Troubleshooting Login, Self Service Application, Concurrent Processing, Jinitiator and Network related issues.
• Backup and Recovery of the Oracle Databases using VERITAS Netback up, RMAN, Oracle Data-Guard or by designing own shell Unix Script.
• Provided sr. level technical expertise in system administration, application administration and automation using UNIX shell scripting.
• Installation and configuration of Single or multi node APPS Middle Architecture with Load Balancing.
• High End Server from SUN, DELL administration.
• VERITAS Storage Foundation for high availability.
• LAN and WAN Infrastructure implementation with redundancy and security.
• ITIL Process Implementation and audit.
• Major role in IT Budget preparing.
• Disaster Recovery Policy Implementation for mission critical Application.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, and ADDM to collect and maintain performance statistics and improves the database performance.
• Expert in SQL* Loader, export/import and data pump import to load data in to tables.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
• A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications 11i (11.5.10)/R12, Oracle Application Server 10g As and 9iAS

Databases: Oracle 8i, 9i and 10g RAC, 11g R1, 11g R2

Tools: & Utilities: Oracle Applications Manager, AD Utilities, SQL * Loader, OEM, TOADExp/Imp, DataPump, RMAN, Sql*Loader, Data Modeling - ERWin

Performance tools: TKPROF, STATSPACK, Explain Plan, ORADEBUG

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

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

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.1.2 and R12.1.2 to R12.1.3 upgrade on RHL 7.3.29 and Solaris version 10
• 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.1.2 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.
• 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.
• Worked on XML publisher to generate reports.
• Configuring notification mails from application to send it across to the user Inbox in Microsoft exchange for users for Purchase Orders and Quotation approvals as per the hierarchy set in the application.
• 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

Confidential, Carlsbad, CA

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.
• 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.
• Monitoring and resolving Database & Apps listener and tns issues.
• Relining the executables, generating forms, jar files, validating apps schema and compiling the invalids etc by using adadmin.
• 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, Oracle Applications 11i (11.5.9 & 11.5.10), Oracle 9i RAC, Release 12.0.4

Confidential, St. Louis, MO

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.
• Monitoring the Application services and bouncing the Application services as per requirement.
• 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 a 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 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.
• 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 Support

Responsibilities:

• Maintain Oracle server incomplex environments such as Linux Servers.
• Monitoring tablespaces 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 for routine administration alert and trace monitoring.

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