PROFESSIONAL EXPERIENCE:

• Oracle Apps. DBA professional with around 7 years of experience, TEMPhas a solid noledge of E - Business Suite architecture, Oracle Database architecture, SQL and PL/SQL.
• Extensively worked with Oracle Applications right from R12 to 11i (11.5.5 to 11.5.10).
• Production Experience in administering Oracle Apps 11i/R12, databases and upgrade from 11.5.8, 11.5.9 to 11.5.10, R12.
• Extensive experience on new implementations and migration projects.
• Very strong in cloning using utilities like ADclone, ADconfig and Rapid clone.
• Used utilities like ADadmin, ADrelink etc. to maintain application and database tier.
• Installed and configured Oracle Application stack on both single node and multi node environments.
• Experience with installation and maintenance of Oracle Application Server (10g and 9i).
• Expert in monitoring applications and databases using OAM and OEM.
• Created Custom schema for teh custom module in Oracle Application.
• Database Recovery using Hot & Cold Backup, RMAN and 10g DataGuard.
• Experience in configuring and managing teh Concurrent Managers, Workflow Notification Mailers and monitoring their operation.
• Experienced in writing UNIX shell scripts and setting up CRON jobs for database needs.
• Backup and recovery of oracle database using RMAN.
• Experience in Data Center migration activities.
• Expertise in performance tuning using Statspack, TKprof, OEM (Oracle Expert, SQL Analyzer) and Quest TOAD as well as performance tuning of Oracle APPS.
• Installation and configuration of Application Desktop Integrator (ADI)
• Work independently to ensure that teh 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.
• Create and Maintaining teh Technical Notes and Documentation.
• Expertise in Fusion Middleware like SOA 11.1.2 and Discoverer.
• Supported most of teh modules like Oracle HRMS, Oracle Supply Chain Management and Value Chain Management.

TECHNICAL SKILLS:

Applications: Oracle EBS 11i/R12, Oracle Application Server 10g AS, Oracle Application Server 9iAS

Databases: Oracle 8i, 9i, 10g, 11g

Operating Systems: Linux, Sun Solaris, AIX, HP-UX, Windows NT/2000/2003/XP

Performance Tools: TKPROF, STATSPACK, Explain Plan, ORADEBUG

Scripting: Unix Shell Script

Others: SOA, Discoverer 11g, VCP,OID, APCC Modules, AD Utilities, SQL * Loader, TOAD, XML/BI Publisher, Workflow Builder

PROFESSIONAL EXPERIENCE

Confidential, WA

Sr. Oracle Apps DBA

Responsibilities:

• 24x7 Production Oracle Applications Administration with E-Business 11i and R12
• Responsible for cloning and patching teh E-Business environment by utilizing tools such as rapid clone, adadmin, adctrl and adpatch.
• Installation and configuration of discoverer11g on weblogic server.
• Supported OID11g on standalone database with failover dataguard .
• 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 teh post-upgrade issues.
• 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.
• Registering teh new Forms, Reports, pl/sql scripts as concurrent programs, analyzing teh performance and coordinating with application teams regarding teh same.
• Tuning teh database with AWR, Tkprof, TRACE, Execution plans, SQL profiles, SQL Plan Baselines, SQL HINTS
• Coordinating and working with offshore DBA team regarding various day to day tasks and following up through completion.
• Configuration of Workflow Notification Mailer, OAM, OEM10g. Coordinated with teh application team for teh migration of mail servers from 2003 to 2010.
• Administering and reviewing logs. Escalate issues to management as appropriate.
• Worked on teh user and data security issues. Worked closely with users group to ensure timely implementation of an ERP.
• Took active role in communication with various development and test teams.
• Preparation and maintenance of documentation of all teh activities according to teh team standard.

Environment: Unix/Linux, SUN Solaris 8, Oracle database 10g, 11g, Oracle Applications R12 (12.1.3), Discoverer 11g, OID 11g, cognos

Confidential,

Oracle Apps DBA

Responsibilities:

• Worked on new implementation projects migration activities. Supporting teh development and testing of various modules in oracle applications.
• Performed complete refresh of teh development environment from teh production using Rapid Clone. Configured shared application tier on teh development environments.
• Based on teh requirement from teh development teams, created teh custom top and configured them on EBS.
• Worked on patching activities like patch analysis, merging and applying patches using teh utilities like admrgpch and adpatch and troubleshooting teh issues faced during teh process.
• Used AD utilities like adctrl and adadmin to resolve teh issues while applying teh patches.
• Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities, experienced in developing exhaustive documentation for all activities performed.
• Responsible for daily hot backups and weekly cold backups when required.
• Scheduled & automated back-end jobs and monitoring scripts.
• Registered Forms, created Form Functions and Menus. Registered Executables, created Concurrent Programs and Request Groups
• Identified teh programs causing performance issues and worked with development team to resolve them.
• Set and document standards for use of databases with objectives of data integrity, data security, and efficient operation and audit requirements.
• Configured Workflow notification mailer and troubleshoot teh issues regarding teh same.
• Deploy teh application custom developed code following teh corporate code deployment and data migration processes like Kintana, FNDLOADER, and ACMP.
• Involved in personalization and customization of various Oracle products and migrating them from one environment to teh other.
• Worked on various modules like VCP, Demantra and Rapid Planning. Actively participated in teh discussions with various teams and shared ideas to resolve various issues.
• Worked on Oracle Rapid Planning and ISTORE.
• Continuous exposure to teh issues related to various modules like HRMS, OM, Finance, etc.,
• Worked on teh configuration of istore on teh DMZ servers. Supported teh team in issues related to teh roles and responsibilities.
• Active role in configuring SSO and OIM. Worked with teh setup team regarding teh configuration of SSO and OIM and teh issues faced during teh process.
• Configured periodic and event alerts on teh application level. Monitored teh performance of scheduled jobs by creating value sets.
• Keeping track of teh issues encountered and teh steps taken to resolve them

Environment: Unix/Linux, SUN Solaris 8, Windows, Oracle database 10g, 11g, Oracle Applications R12 (12.1.0,12.1.1, 12.1.3), AD Utilities, Exp/Imp, RMAN, TKPROF etc.

Confidential, PA

Oracle Apps DBA

Responsibilities:

• 24x7 Production Oracle Applications Administration with E-Business 11i and R12 and 10g and 11g database.
• Worked on new implementation projects migration activities.
• Responsible for upgrading EBS 12.1.1 to 12.1.3.
• Coordinated and communicated with all teh teams during teh new implementation. Created a plan on teh consensus of all teh UNIX, development and testing teams, and executed it to perfection.
• Participated actively in teh datacenter migration activities and coordinated with UNIX teams and clients.
• Responsible to ensure that teh environments are stable and at acceptable performance.
• Responsible for daily hot backups and weekly cold backups.
• Ensure that products used are Certified and Supported by Oracle
• Implementing various monitoring scripts and coordinating various alerts within teh team.
• Worked on 10g and 11g Discoverer
• Responsible for regular discussions with UNIX teams
• Monitoring Oracle Applications users ensuring maximum performance.
• Identifying and developing UNIX and sql scripts for teh smooth functioning of database and applications
• Scheduled & automated back-end jobs.
• Involved in Performance Tuning of Informatica ETL mappings and database.
• Oracle Database and Oracle Applications cloning/refresh single-node to multi- node and vice versa.
• Worked on teh servers hosted by Amazon Web Services.
• Worked on teh installation of OBIEE, Informatica and DAC client tools.
• Involved in teh installation and of 11.1.2 SOA and 11gDiscoverer.
• Worked on teh implementation of SSL.
• Analysis and application of Patches, Documentation of pre-and post patch installation steps.
• Creating and maintaining documentation for teh various existing processes.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Documentation and noledge transfer of various activities performed.

Environment: Unix/Linux, SUN Solaris 8, HP-UX 11.0, Windows, Oracle database 9i (9.2.0),10g, 11g, Oracle Applications 11i (11.5.9, 11.5.10), Oracle Applications R12 (12.1.0, 12.1.1, 12.1.3) HRMS, TOAD, SQL Loader, AD Utilities, Exp/Imp, RMAN, TKPROF etc.

Confidential, CA

Oracle Apps DBA

Environment: Linux, SUN Solaris, Windows, Oracle database 9i (9.2.0), Oracle Applications 11i (11.5.2, 11.5.5, 11.5.7), AD Utilities, Exp/Imp, RMAN, TKPROF etc.

Responsibilities:

• Responsible for managing production, development & test databases and applications.
• Maintaining teh 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 teh 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 experience with oracle application utilities such as RapidInstaller, Rapid Clone, adpatch, adadmin, adsplice andadctrl.
• Pre-patch or Impact analysis for teh 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, ASCP, MSCA, MMS, OTC, OPS etc.
• Managing teh Concurrent Managers and its operations like starting, stopping teh concurrent managers and monitoring of teh concurrent managers.
• Using AD Administration and other AD Utilities. Experience with Oracle Applications Desktop Integrator (ADI).
• Tuning teh databases for optimal performance.
• Experience in installing, configuring, administering, and performance tuning Microsoft SQL Server 2000/2005 and MySQL
• Planning for storage spaces requirements and placing them for optimum me/O performance.
• Partitioning tables by determining teh suitable methodology to improve performance and manageability.
• Enabled Auditing feature for tables such as FND USER etc.
• Created new application messages and tan 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 teh problems with solutions for future reference.
• Good experience and noledge on Discoverer, Idiscoverer. Performed Patch Management.

Confidential

Oracle Apps. DBA

Environment: Red Hat Linux 4, Oracle Applications EBS 11i, Oracle 9i & 10gDescription: As an Oracle Apps DBA, me was responsible for production support of release 11.5.10.2.

Responsibilities:

• 24x7 Production Oracle Applications Administration with E-Business 11i and R12
• Successfully upgraded 11.5.10.2 to R12 with 9.2.04 to Oracle 10g. Maintaining production, development & test databases and applications.
• Upgraded Oracle Applications database 9.2.0.4 to 10g (10.2.0.4) on Solaris.
• Upgraded Oracle Applications 11.5.10.2 to R12
• Applied patches using ADPATCH, ADCTRL utilities.
• Applications/Database Cloning & Refresh using RAPIDCLONE
• Administration of Oracle ERP applications version 11.5.10.2 and R12
• Applied teh HRMS RUP 3 patch and OracleHRMSQ1-2009 SQWLpatches to development and production environments.
• 24*7 on-call production support for high-availability web-based application running Oracle9i 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.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Planning and Administration of backup and recovery strategies & configuring backups using RMAN & hot and cold backups.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for teh user.

Confidential

Oracle Apps. DBA

Environment: Oracle 8i, OEM, SQL * plus, imp/exp, rman, SQL, pl/sql, SQL* loader, tkprof.

Responsibilities:

• Cloning of Oracle APPS 11.5.7 Instance on HP-UX 11.0 platform
• Upgraded Oracle Applications 11.5.7 to Oracle Applications 11.5.8 on HP-UX 11.0 platform
• To tune and configure Oracle 8i Database for optimum performance.
• Provided production support.
• System Administration of 11i
• Applied teh patches using ADPATCH and working on teh issues if any.
• Developed backup scripts for Application 11.5.7
• Created Responsibilities and Application Users
• Performed Application admin tasks using ADADMIN utility
• Maintenance of Concurrent Managers
• Verified all instances are up and running
• Verified that all Application Services are on-line
• Resolved Jinitiator issues
• Tuning teh databases for optimal performance.
• Planning for storage spaces requirements and placing them for optimum me/O performance.