SUMMARY

• 7+ years of practical experience as an Oracle DBA and Applications DBA.
• 6+ years of experience in Oracle 11i Applications (Oracle EBS) DBA and R12 applications.
• 4+ years of strong working experience on Oracle forms and reports 6i & 9i.
• 3+ years of experience in supporting Oracle technical and functional areas.
• Experience in working with different environments/versions and server administration including LINUX, Windows, SOLARIS, AIX and HP-UX,HP -TRU 64 OS
• Installation, configuration and maintenance of Oracle 10g RAC, 9iAS/10gAS, 11i, R12 applications.
• Implemented High Availability solutions with Oracle 10g RAC, ASM, FLASHBACK and Standby (DATAGUARD),OATM from 11.5.10
• As an Oracle Apps DBA key responsibilities include Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers.
• Experience as Oracle Applications DBA providing support to many Production, Development, Test, CRP instances comprising some of the more complex and challenging environments from versions 11.0.3 through 11.5.10,R12(12.1.x) with most affective modules being GL, Financials, AP, AR, BOM, HR/Payroll, OM, INV, OWB, PA, PO, FA, MRP, MFG.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System Administration.
• Complete understanding in customization and workflow procedure for Oracle Apps Order to Cash (OTC) and Procure to Pay (P2P) life cycles.
• Experience in Implementation and Customization of Oracle Receivables.
• Experience in using Spreadsheet for the storage of financial data for remote computing and perform corporate consolidations with instant access to real-time data.
• Expertise in Importing Account Receivables data into Oracle Receivables.
• Strong Experience in Cloning & Patching Oracle 11i& R12 Instance using Rapid and manual cloning.
• Proficient in installation and upgrading Oracle Applications 11i e-business suite to R12 (12.0.4)
• Expertise in administering Oracle 11i to R12 Instances using AD utilities such as adadmin, adcntrl, adsplice, admerge, adpatch etc.
• Applied patches to update and security fixes to Oracle E-Business Suite 11.5.5, 11.5.9, 11.5.10.2,12.0.4.
• Multiple upgrades of Oracle Apps 11i, which includes database upgrade from 9i to 10g as well as application tier upgrade from 11i (11.5.5) to R12 (12.0.4).
• Upgraded Oracle 11i Applications Database 9i (9.2.0.6) to 10.2.0.3 on Linux.
• Performed Oracle EBS 11i migration from HP-UX to LINUX.

• Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM).
• Provided support for developer in building forms and reports.
• Implementation, troubleshooting Forms server, Report server, Discoverer server, Web Server.
• Superior support and maintenance of Concurrent managers (ICM) and Parallel concurrent Process (PCP).
• Practical Knowledge on configuring and installing Oracle Application Server (9iAS/10gAS), Discoverer, IDiscoverer, Punchout, ADI.
• Extensive experience in working with Oracle Developer Suite 10g, Developer 6i, Discoverer 4i, Workflow 2.6 and Application Express 2.2/3.0.
• Oracle 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Installed and Integrated Oracle Internet Directory with 9i database with Single Sign On

And OID 10g.

• Integrated with third party identity managers such as Third party LDAP and Third party

SSO

• Integrated Microsoft active directory to OID and MS kerberos with SSO 10g
• Designed and Developed OAS 10g Portal Application for users.
• Oracle 10g Application Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories.
• Installing, configuring and maintaining Oracle Grid Control (10g grid).
• Extensive knowledge in working with the utilities like OEM, TOAD, Export/ Import, SQL* Loader, SQL Analyze and Oracle Supplied DBMS_PACKAGE.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF and Explain Plan.
• Expertise in configuring backup software like VERITAS Netback up, Legato Networker for Oracle using RMAN tool for backup and recovery.
• Written efficient scripting for scheduling Oracle database backups using hot backup and RMAN.
• Good Knowledge of Oracle SQL & PL/SQL programming and query tuning.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR.
• Upgrading database from one server to another using Export and Import utility.
• Hands on experience in using Oracle DATAPUMP feature for bulk metadata and data movement.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes database health check, active listeners, automatic backup (HOT backup or COLD backup), disk space availability, alert log errors etc.
• Setup a crontab jobs for production environment to receive automatic alerts related to TS issues, OS level space issues, locking issues etc.
• Installed and Configured Oracle Application Server 10g (10.1.2.x & 10.1.3.x SOA) with Portal and Discoverer as an active application.
• In depth understanding in UNIX administration, Project Management, Perl Scripting and Technical documentation.

TECHNICAL SKILLS

Applications: Oracle EBS 11i/R12, Oracle Application Server 10g AS, Oracle Application Server 9iAS
Databases: Oracle 8i, 9i, 10g RAC, MySQL 5.1
Operating Systems: Windows NT/2000/2003/XP, RHEL, Sun Solaris, AIX, HP-UX ,TRU 64OS
Languages: C, C++, PHP, PERL, SQL.
Performance Tools: TKPROF, STATSPACK, Explain Plan.
Others: AD Utilities, SQL * Loader, TOAD, XML/BI Publisher, Workflow Builder, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential,Longview, TX, USA Nov2009-Tilldate
Oracle Apps DBA
As an Oracle Apps DBA, I was responsible for upgrading and smooth functioning of Oracle 11i and R12 applications, successfully upgraded 11i version 11.5.5 to 11.5.10.2 to R12 (12.0.4 12.1.1) and also performed database from Oracle 8.1.7 to Oracle 10g.
Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 (B.11.11), Windows XP, Oracle 8i (8.1.7), 9i (9.2.0) & 10g (10.2.0), Oracle Applications EBS 11i/R12(12.0.4), Oracle 9i & 10g RAC, TOAD, Developer 6i
Responsibilities:

• 24x7 Production Oracle Applications Administration.
• Maintaining production, development & test databases and applications.
• Good knowledge on Oracle applications 11i and R12 Rapid Installation.
• Upgraded Oracle Applications R12 (12.0.4) Database Version 8.1.7.4 to 10g (10.2.0.4) on Solaris.
• Migrated Oracle Database to Oracle Database Gateway for Teradata to have full business enterprise features.
• Upgraded to 11.5.10 from prior which has OATM via TMU
• Upgraded Oracle Applications 11.5.5.10 to 11.5.5.2 to 12.0.4 and Database 9.2.0.8 to 10g.
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities for upgrading versions prior to 11.5.10 with OATM .
• Created test environment through cloning production environment for developers to test on live data.
• Administration of Oracle ERP applications version 11.5.10.2 and R 12.0.4.
• Good Knowledge in Data Modeling tools like Erwin.
• Setup and implementation of Oracle Financial Analyzer.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Implementation, customization and personalization of Oracle iProcurement.
• Experience on various modules such as Financials, MFG, CRM, AR, AP, GL, PO, and INV.
• Validated different accounts and performed transformations in financial module using Financial Accounting Hub.
• Generated reports and financial consolidations with Oracle Hyperion Financial Management.
• Integrated Microsoft active directory to OID and MS kerberos with SSO 10g
• Installed other supporting products for financial module like Oracle Essbase for modeling complex business scenarios and DRM/MDM.
• Experience in Implementation and Customization of Oracle Receivables.
• Generated several reports using Oracle iExpense (OIE) module in two projects.
• Advised and made recommendations to improve the overall database design.
• Monitored performance and availability of the VIS application (a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN).
• Involved in developing a disaster recovery (DR) plan.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views (replication).
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9iAS.
• Automation of tasks like backup/refresh and other jobs using.
• Installed and Integrated Oracle Internet Directory with 9i database with Single Sign On
• and OID
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack).
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10G database.
• Installed and configured Single-Sign On and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Planning and Administration of backup and recovery strategies.
• 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.
• Worked closely with users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Oracle 10g Database Implementation/Upgrade/Support.
• Oracle 10g Application Server Implementation/Upgrade/Support.
• Oracle OID Implementation and Support.
• Oracle DataGuard Implementation for HA and remote DR site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.

Confidential,Phoenix AZ, USA September 2007-October 2009
Oracle Apps DBA
As an Oracle Applications DBA, I managed several project implementations of Oracle Applications. Managed production, test and development Oracle 11i Application instances hosted by Oracle On-Demand, Performance tuning and java error resolution. I was responsible for coordinating with other business functional groups affected by applications and changes. Reported on the need for adding new instances to the client environment and worked on installing local instances independent from OOD. Created and maintained reports of roles and user accounts, database tablespaces, tables, and indexes.
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:

• 24x7 Production Oracle Applications Administration
• Maintaining production, development & test databases and applications.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Good experience on Oracle 9iAS, Discoverer, Idiscoverer, Punchout, ADI
• Upgraded Oracle 11i applications version from 11.5.5 to 11.5.10.2
• Upgraded Oracle Applications 11i(11.5.5.10) Database Version 8.1.7.4 to 10g(10.2.0.4) on Solaris
• Migrated Oracle Database to Oracle Database Gateway for Teradata to have full business enterprise features.
• Upgraded Oracle Applications 11.5.5.10 to 11.5.5.2 and Database 9.2.0.8 to 10g.
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Administration of Oracle ERP applications version 11.5.10.2.
• Good Knowledge in Data Modeling tools like Erwin.
• Setup and implementation of Oracle Financial Analyzer.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Worked with Oracle On-Demand to successfully upgrade 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
• Handled weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Implemented and supported AP, GL, AR, PO, HRMS modules.
• Worked with Oracle On-Demand to apply HR RUP3 patch to development and production environments.
• System Administration responsible for application security, scheduling work shifts, registering new concurrent programs / request Sets.
• Participated in a team to maintain and support Oracle Applications in 24 X 7 environments.
• Researched and resolved JInitiator performance issues and suggested migration to Sun JDK.
• Supported and administered oracle discoverer 10g to resolve performance and other user issues.
• Critical patch update/oracle support (TAR)/ application patching activity/Application bug fix as suggested by oracle support.
• Upgraded JInitiator and other technology stack components in development environment.
• Researched various options for 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.
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Responding to different types of alerts related to Database and Applications.
• Troubleshooting / resolving issues with concurrent managers.
• Troubleshooting of Oracle Self Service Web Applications.
• Applied Oracle Projects Maintenance pack to Development environments.
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Performing pre and post health checkups of oracle 11i applications.
• Researched and documented available options to create a DB Link between oracle and SQL Development databases to rewrite the existing interface.

Confidential,
Dearborn MI,USA August 2006 - September2007
Oracle Apps DBA
As an Oracle Apps DBA I was responsible for installation, upgrades, maintenance, security and implementation of Oracle ERP applications and Oracle databases.
Environment: Unix/Linux, SUN Solaris 8, Oracle database 8i (8.1.7) & 9i (9.2.0)&10g, Oracle applications 11i, HRMS, TOAD, SQL Loader, AD Utilities,

Responsibilities:

• Responsible for managing production, development & test databases and applications.
• Maintaining the Oracle Applications Systems including Oracle databases, Middle tier iAS Applications.
• Involved in Upgrading of Oracle Version 8.1.7.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 web development using HTML, JavaScript, and XML.
• Extensive 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 AD Administration and other AD Utilities. Experience with Oracle Applications Desktop Integrator (ADI).Tuning the databases for optimal performance.
• 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.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Enabled Auditing feature for tables such as FND_USER etc.
• Created new application messages and then generated message file for application.
• 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.
• Worked closely with users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Good Knowledge of Oracle SQL & PL/SQL.
• Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.
• Good experience and knowledge on Discoverer, Idiscoverer.
• Performed Patch Management.

Confidential,Oct2004-April2006
Oracle Apps DBA
As an Oracle Apps DBA, responsible for production, development and test instances of Oracle Applications 11.5.2, 11.0.3. Installed Oracle Applications 11i and up gradation from 11.5.5 to 11.5.6, up gradation from Oracle RDBMS 7.3.4 to Oracle RDBMS 8.1.7.4, developing PL/SQL Procedures, DB Triggers, Backups and Recovery.
Environment: Linux 2.4, Oracle database 7i&8i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader
Responsibilities:

• Responsible for, both manage and support all Production, Development and Test instances of Oracle Applications 11.5.2, 11.0.3.
• Configured and Installed Oracle Application 11i using RapidInstall.
• Upgrading the Base install 11.5.5 to 11.5.6 and maintaining Oracle Applications.
• Monitored the Applications and Database using OEM and OAM.
• Setting up of printers In the Apps.
• Maintenance of concurrent processing requests and concurrent managers.
• Tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, ADCTRL.
• Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
• Reorganization of the Database using export import.
• Database upgrade from Oracle Release 7.3.4 to Oracle Release 8.1.7.4
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Design and development of major processing at the back-end through DB-Triggers, Stored Packages and Procedures using SQL and PL/SQL and SQL.
• Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.
• Query optimization and tuning using tools like TOAD and SQL Loader.
• Provide technical assistance to developers in all matters concerning performance, application related issues.
• Debugged Oracle Reports and Oracle Forms programs.
• Created new Oracle Reports and Oracle Forms programs based on user specifications.
• Assists in design tasks such as debugging, specifications development and system integration testing.
• Provides technical assistance and user support functions.
• Participated in action planning and implementation.

Confidential, July 2003 –Sep2004
Oracle DBA

• Upgrading and migrating database from oracle 9i to 10g version.
• Design and support complex distributed and replicated database architecture.
• Creating table spaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating table spaces taking into account I/O load distribution.
• Locally managed table spaces were used which track all extent information in the table spaces itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.
• Performed SQL tuning by using Explain Plan and TKProf
• Making structural changes to the databases when database design changes are to be implemented.
• Creating and Managing stored procedures and triggers, distributed data, database replication, server tuning, automation of administrative tasks, database
• Implementation and maintenance of read only snapshots and snapshot logs

EDUCATION
Bachelor of Technology