SUMMARY

• More than 9 years experience in administering ORACLE E - Business suite 11i (11.5.10 CU2, 11.5.9) (Financials, Manufacturing, HRMS, Public sector Modules) Applications, and administering ORACLE Databases (11g, 10g, 9i, 8i).
• Expertise in leading the teams for maintenance of 24X7 high-availability applications.
• Very good understanding of the Architecture, Features and Facilities offered by Oracle EBS 11i, Oracle Databases 10g,9i,8i with objectives of saving costs and time.
• Exposure to Oracle EBS R12.
• Strong experience in supporting development, unit test, system test, Integration test, certification test, production databases under almost all flavors of UNIX (Sun Solaris, IBM AIX, HP UX Red Hat).
• Fully conversant with Oracle Application DBA activities such as ORACLE 11i Applications Administration, Cloning, and Patching, Database Administration, Refreshing databases, maintenance of RAC databases etc.
• Proficiency with several AD admin tools like Rapid clone, ADpatch, Auto upgrade, ADadmin, ADcontroller, etc.
• Expertise in Concurrent Manager Queue redesign. Implemented parallel concurrent processing (PCP), and managed failover mechanism for Concurrent Managers.
• Expertise in cloning using Rapid Clone utility to create Test, QA and Development Instances.
• Expertise in applying Oracle Applications (EBS) patches using Adpatch, Adadmin, Adctrl.
• Expertise in applying Oracle Database patches using Opatch Utility
• Experience in upgrading the ORACLE 11i Applications (11.5.9 to 11.5.10 and 11. .5.10.2 ).
• Experience in Upgrading databases. (10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1)
• Experience in configuring external EBS 11i Apps tier on DMZ server for iRecruitment..
• Experience in configuring Oracle BI Discoverer 10.1.2 in Oracle EBS 11i environments.
• Exposure in configuring FAH (Oracle Financials Accounting HUB).
• Experience in Integration of Oracle Applications 11i with OID/SSO
• Experience in Managing/working/converting RAC databases.
• Expertise in Database Space Management, Memory Tuning and Application Tuning
• Expertise in EBS Middle tier troubleshooting and performance tuning.
• Experience in implementing ERP monitoring application to monitor the ORACLE Applications and Database.
• Experience in creating and managing Standby database using Data guard.
• Expertise in Backup and Recovery activities using RMAN utilities.
• Worked with several Multi node and multi tier environments.
• Experience in implementing security policies to meet SOX Compliances.
• Printer registration with Oracle EBS.
• Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming, and PRO*C.
• Experience with various Change Management tools like Kintana, Mercury, MKS, PVCS, Continuus.
• Sound experience in different phases of a project life cycle including design, architecture, programming, testing, end user support, and preparing customer specifications as a part of software requirements.
• Involved in supporting the SOX teams by providing the necessary data and execute task for SOX compliance.

TECHNICAL SKILLS

ERP Administration: Oracle 11i E-Business suite (11.5.10.2, 11.5.9), AD Utilities, Patching, Configuration, Cloning, System Administration, Oracle 10g AS, Oracle BI Discoverer 10.1.2, OID/SSO integration, Oracle EBS R12.

Database Administration: Oracle 11g, Oracle 10g, Oracle 10 RAC, Oracle 9i, 9iRAC, Oracle 8i, Performance Tuning, Backup and Recovery using Cold, Hot, and RMAN and Other Utilities

Programming: PL/SQL, Pro*C, SQL*Plus, C, C++, Shell Scripting. Exposure to J2EE

Hardware: Digital DEC Alpha Server 8400, HP UX 10.2, SunOS 10, 9, DYNIX 4.0,Linux RHEL ES/AS 3, AIX5L Windows 9x/NT, UNIX, DOS

Tools: REMEDY, CLARIFY, iHUB, Kewill, Clearorbit, Optio Print Utilities, TOAD, PL/SQL Developer., Veritas Netbackup

Domain Experience: Financial Services, Telecom, Healthcare, Public Sector

PROFESSIONAL EXPERIENCE

Confidential, NV

Senior Oracle Apps DBA

Responsibilities:

• Managing Oracle E Business suite 11i (11.5.10.2) having multi node environment
• Managing multiple production, testing, QA and development Utility database instances.
• Administering ORACLE Applications E-Business Suite 11i with AD Utilities (Adadmin, Adpatch, Adctrl etc.), OAM.
• Administering ORACLE Databases 10g (10.2.0.2), 11g (11.1.0.7)
• Applied standalone, minipacks rollups, family pack patches to EBS 11i using ADpatch utility.
• Analyzed and applied quarterly Payroll patches, Legislative data using Datainstaller, hrglobal driver. .
• Upgraded Oracle Applications 11. .5.10.2
• Upgrade database 10.1 to 10.2 and applied patchset 10.2.0.2 to multiple databases.
• Experience in managing databases on high availability environment using Sun Cluster.
• Upgraded Dev and Test instances to 11g (11.1.0.7)
• Applied database patches using Opatch utility.
• Building Clone instances for Development and Test teams.
• Configured External Apps Tier on DMZ server for iRecruitment
• Configured Oracle BI Discoverer 10.1.2 with EBS 11i for reports.
• Working with Financials functional team for configuring Oracle Financials Accounting Hub
• Upgrading JDK versions from 1.4.2 to 1.6 and configured native SUN JRE Plug-in
• Proactively tuning JVM for performance issues, adding new JVMs
• Application and Database Monitoring: Concurrent Manager throughput, Long Running Jobs, Application Locks, Application File Systems, and General Operating System Monitoring.
• Created shell scripts and scheduled them for monitoring Oracle Applications and Databases.
• Performance Tuning of Applications and Databases.
• Performance tuning and Monitoring using Grid Control database.
• Managing instances using OEM.
• ORACLE Printer Configuration.
• ORACLE TAR Management: Raised and monitored TAR s with Confidential for issue resolutions.
• Weekends on call support and Payroll support.
• Database backups using RMAN on tape and Disk.
• Users and responsibilities Maintenance
• Custom code migrations to Test and PROD environments using PVCS.
• Working with Development, QA and other teams to support the related issues.

Environment: Solaris 10, Oracle Applications11i E-Business suite 11.5.10.2, Oracle10g (10.2.0.2), Oracle 11g (11.1.0.7), Oracle BI Discoverer 10.1.2, AD Utilities, PL/SQL, SQL Scripts, Shell Programming, TOAD., Veritas Netbackup

Confidential, Denver, CO

Oracle Apps DBA

Responsibilities:

• Managing multiple production, testing, QA and development instances.
• Managing Oracle E Business suite 11i (11.5.10.2) having multi node environment
• Administering ORACLE Applications E-Business Suite 11i with AD Utilities (Adadmin, Adpatch, Adctrl etc.), OAM.
• Administering ORACLE Databases 10g, 10g RAC.
• Applied standalone, minipack and maintenance packs.
• Upgraded Oracle Applications 11. .5.10.2
• Upgrade database 10.1 to 10.2 and applied patchset 10.2.0.3 to multiple databases.
• Applied database patches using Opatch utility.
• Worked on conversion from single node to 2 Node RAC database for SIT and UAT systems.
• Worked on conversion from Single node to 2 Node Apps Tier for Oracle Application by implementing shared APPL TOP.
• Worked on integrating OID/SSO with 11i EBS
• Working on implementing Parallel Concurrent Processing ( PCP)
• Building Clone instances for SIT and UAT environments.
• Application and Database Monitoring: Concurrent Manager throughput, Long Running Jobs, Application Locks, Application File Systems, and General Operating System Monitoring.
• ORACLE Printer Configuration.
• ORACLE TAR Management: Raised and monitored TAR s with Confidential for issue resolutions.
• Performance tuning and Monitoring using Grid Control database.
• Created shell scripts and scheduled them for monitoring Oracle Applications and Databases.
• Weekends on call support.
• Weekly hot back backup activities production, cold backup on Test/dev databases.
• Users and responsibilities Maintenance
• Custom code migrations to Test and Prod are done using MKS tool based on development requests.
• Problem resolution repository is built in custom DBA ticketing tool.
• Working with Development, QA and other teams to support the related issues.

Environment: AIX 5.3, Linux RHEL ES/AS 3, Oracle Applications11i E-Business suite 11.5.10.2, Oracle10g (10.2.03), Oracle 10g RAC Database, Oracle 10gAS, OID/SSO, AD Utilities, PL/SQL, SQL Scripts, Shell Programming, MKS, TOAD.

Confidential, Milwaukee, WI

Lead Oracle Apps DBA

Responsibilities:

• Managing more than more 30 production, test and development instances.
• Managing Oracle E Business suite 11i having multi node environment with RAC Database and various middle tier tools
• Administering ORACLE Applications E-Business Suite 11i with AD Utilities (Adadmin, Adpatch, Adctrl etc.), OAM.
• Administering ORACLE Databases 10g, 9i.
• Applications Patch management: Patch impact analysis, patch application and trouble shooting.
• Applied standalone, minipack and maintenance packs.
• Applied database patches using Opatch utility.
• Involved in a project, which analyzes and applies quarterly Security patches (CPU).
• Implemented Concurrent manager profiling across the 4 Node RAC to minimize the Interconnect traffic.
• 4th node has been added to existing 3 node RAC
• Concurrent queue Management based on run time and pending time SLA. Implemented Parallel Concurrent Processing ( PCP)
• Managed the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Cloning of Applications using RAPID CLONE from multi node to similar or lesser node Test, QA and Development .
• Application and Database Monitoring: Concurrent Manager throughput, Long Running Jobs, Application Locks, Application File Systems, and General Operating System Monitoring.
• Involved in implementing Dashboard-based ERP Monitoring solution by developing shell scripts and SQL scripts.
• Involved in upgradations from 11.5.9 to 11.5.10.
• ORACLE Printer Configuration and managed printer configuration on Optio Print software.
• ORACLE TAR Management: Raised and monitored TAR s with Confidential for issue resolutions.
• 24 x 5 technical support, 24 x 7 during quarter and month close and weekends on call support.
• Performance Tuning of Applications and Databases using precise tool, tkprof, explain plan.
• Generating trace files for problem resolution.
• Responsible for backup/recovery using RMAN utilities.
• Responsible for setting-up and managing Standby database using Data guard for DR sites.
• Worked on managing and configuring Single Sign-on (SSO/OID) environment.
• Ad-Hoc Technical Requests: Ad-Hoc Queries - SOX/Audit/Security.
• Monitoring and supporting tools such as OPTIO, IHUB, CLEARORBIT, KEWILL, and MSCA.
• User Maintenance (Creation, modification and deletions).
• Custom code migrations using Kintana tool to test and Prod environments.
• Worked on user documentation like Instance strategy, Instance management, Problem manager, Setup document and Change management docs.
• Security policies for accessing Oracle Applications implemented and Audit trail enabled.
• Problem resolution repository, using Clarify solution linking utility has been created to reduce issue resolution timings.
• Forms Load balance is implemented so that load is shared across all Form nodes.
• Apache Load balance is implemented to share the Application connectivity sessions.
• Configured Workflow Notification Mailer for PO approvals.
• Purge strategies developed for APPS tables related to Concurrent requests, Workflow, Audit and Interface tables.
• Working with Development, QA and other teams to support the related issues.

Environment: SUN Solaris 5.9, Linux RHEL ES/AS 3,Oracle Applications11i E-Business suite 11.5.10, 11.5.9 Oracle10g, Oracle 9i RAC Database, AD Utilities, PL/SQL, SQL Scripts, Shell Programming, Clarify, Mercury Test Director, Kintana

Confidential, Denver, CO

Responsibilities:

• Managed IPNMS Fault - Performance Application, consisting of various tools (Netcool, Nerve Center Trap Exploder).
• Performed day-to-day database administration and ensured integrity, security, and availability of the database.
• Managed Instance and Schema objects
• User Maintenance (Creation, modification and deletions).
• Storage management, sizing the database objects, monitoring file systems, and table space growth.
• Performance tuning of the queries using Explain Plan, tkprof.
• Purge strategy was defined and implemented.
• Standby Database has been setup and monitoring using Data Guard.
• Provided On Call DBA support.
• Alerts setup for Database monitoring.
• Planned and implemented Backup and Recovery strategies.
• Taking physical backups such as Hot backups regularly using RMAN Utilities.
• Provided Ad-Hoc reports from the Data Warehouse for management.
• Worked with Unix Core and storage teams for any issues related to OS level or storage issues.
• Developed user documentation for supporting tools and database and created problem resolution repository.

Environment: Solaris 5.9, Linux RHEL ES/AS 2.1, Shell Programming, Oracle 9i, PL/SQL, NetCool Reporter, Remedy, Toad

Confidential, Denver, CO

Responsibilities:

• Actively involved in gathering requirements, system design, development, and application support.
• Worked as a Developer to implement the Customer Data mart creation of Qwest residential customers for Marketing Supporting systems.
• Scripts (PL/SQL, SQL, PRO*C, Shell) were developed to extract the customer data from Corporate Data Warehouse and loaded into the Customer Data Mart for MDSS.
• Developed Procedures and Campaign Management Forms.
• Involved in the design activities of system enhancement requests for existing frame work, viz bringing additional data for residential customers, accommodating external purchased data into master tables, creating customer requested monthly reports, and modifications of Customer Data..
• Performance tuning was done to improve the performance of the queries using EXPLAINPLAN. Queries performance was improved by creating new Indexes, forcing indexes, parallel processing, and modifying Where Clauses, etc.

Environment: UNIX, SunOS 2.6, DYNIX4.0, Oracle 8.1.6, SQL*Plus, PL/SQL, PRO*C, C, C++, Shell Programming Developer 2000 SQL*Forms 6.0, Continuus, Control - M