SUMMARY

• Around 15 years’ experience in Oracle DBA, Applications DBA on Solaris, HP and Linux platforms.
• Extensive Experience in Oracle DBA and Oracle Applications DBA.
• Experienced in SQL Server Database Administration.
• Experienced in Peoplesoft Database Administration.
• Experience in upgrade from 10.7 to 11i & 11.5.4, 11.5.7, 11.5.8 and 11.5.9 and 11.5.10 to Release 12.1.1, 12.1.3 and 12.2.3
• Working experience in SQL server .
• Experienced in database upgrade from 10g to 11g.
• Experienced in Database upgrade on 9.2.0.6 to 10.2.0.4
• Exposure to Oracle 12c.
• Experienced in Cloning and Rapid Clone of oracle applications.
• Experienced in Oracle Database, Oracle Ebusiness Suite Patch application and TAR process.
• Experienced in Oracle Ebusiness Suite implementation for various modules.
• Experience in E - Business Suite installation (single & multi-node), upgrade and maintenance on Solaris and Linux platforms.
• Experienced in Tuning Applications forms, reports database and concurrent managers.
• Experience in implementing advanced configurations like installing external web tier in DMZ, SSL.
• Extensive experience in SSO setup, integration and configuration.
• Experienced in Datawarehouse applications.
• Oracle Applications Project Lead and Global Lead Experience.
• Experienced in SOX compliance activities in Oracle EBS.
• Extensive experience in RMAN procedure.
• Extensive On-call 24x7 production support.
• Experience in RAC, Shared APPL TOP, Single Node, MultiNode Systems.
• Experienced in 11i and Release 12 Patch application and TAR process.
• Experienced in Oracle E Business Suite implementation.
• Extensive experience in Installation, Migration, Upgrade and Administration of Oracle Applications.
• Experienced in Performance Tuning of Oracle Applications.
• Experienced in OID, OAM, TDE, ASO and Encryption methods for Security.
• Experienced in Database and Oracle Applications and PeopleSoft Security Planning and Implementation procedures.
• Experienced in SQL Server Database management.
• Extensive On-call 24x7 production support.
• Friendly, cooperative attitude, detail-oriented, analytical and self-driven.

TECHNICAL SKILLS

Modules: INV, OM, AR, PO, AP, GL, HRMS, Payroll, OAB, Projects, Treasury, Sales and Service Contracts, iPayment, iProcurement, iRecruitment, iExpenses, Oracle Time and Labor, Workflow, Oracle Alert and System Administration.

Operating System: Sun Solaris, HP, Linux, Windows, Citrix.

Database: Oracle 7.x, 8.x., 8i, 9i, 10g, 11g and 12c

Advanced DB Technology: RAC, Dataguard, ASM, Exadata, Endecca

Security Technology: ASO, TDE, SSO, OID, OAM

Middleware: IAS, OWB, WebLogic, Oracle Fusion technologies.

Front End Tools: Forms, Reports, Discoverer 4.0, 10g

Related Software: ADI, Noetix, Vertex,170 systems/Markview

BI Technology: Hyperion, OBIEE

Software Languages: SQL, SQL*PLUS, PL/SQL.

Others: SQL*Loader, Enterprise Manager, TOAD, Xpert tuning, TOAD DBA toolPrecise, DB Artisan, SSH, Visio, MS Project and MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential, AZ

Senior Lead DBA

Environment: Oracle Database 9i, 10g, 11g and 11.5.10.2 and Release 12.2.3 on Sun Solaris - Linux Enterprise, Peoplesoft 9.2 - SQL Server

Responsibilities:

• Proactive monitoring of DBA/APPS DBA and SQL server instances/database.
• 24/7 production support.
• Managed around 50 Oracle Instances/Database including, Oracle Applications and PeopleSoft Database and 30 SQL Server Databases.
• Oracle Ebusiness Suite upgrade from Release 11.5.10 to Release 12.2.3
• Implemented Oracle Transparent Data Encryption for Peoplesoft Database.
• Managed Global team with On-Site and Off-Shore support.
• Analyzed, Designed and Integrated Database of acquired companies.
• Regular review of SOX compliance systems and generate reports for audit.
• Managed 15 Terabytes of data for transaction database of all stores.
• Created, Maintained and Managed partitions of large database.
• Managed Database on RAC, DataGuard environment.
• Managed Interfaces to outside vendors and services providers.
• Regular cloning of applications and database using Rapid Clone process.
• Coordinate closely with functional team and Oracle for issue resolution.
• Managed DB backup and recovery using RMAN procedure.
• Oracle ASO implementation in Oracle Applications and Peoplesoft Database.
• TDE encryption implementation on Oracle Database.
• Implemented encryption over sensitive data areas.
• Regular review of performance and analyzing AWR reports.
• Fix applications issues raised by users on a day-to-day basis.

Confidential, AZ

Oracle DBA Consultant

Environment: Oracle Financials Release 12.1.3, 12.1.1, 11.5.10.2 on Sun Solaris.

Responsibilities:

• Proactive monitoring of instances/database.
• 24/7 production support.
• Issue analysis, review and resolution.
• Regular cloning of applications and database using Rapid Clone process.
• Coordinate closely with functional team for issue resolution.
• Lead Oracle Release 12.1.3 upgrade project.
• Successfully Upgraded Release 12.1.3 from 11.5.10.2 Member of core team for iRecruitment implementation Review HR feed from CYBORG applications.
• Managed DB backup and recovery using RMAN procedure.
• Worked with technical consultants in deploying custom forms, reports.
• Worked with Oracle Support in resolving various issues faced by functional consultants.
• Worked with Oracle support in resolving various upgrade and patching issues.
• Fixed applications issues raised by users on a day-to-day basis.
• Extensively used AD utilities for administration purposes.
• Upgraded E-Business Suite test, development, and production instances from 11.5.3(multi-node) to 11.5.10.CU2 (multi-node).
• Performed release 12.1.1 and 12.1.3 upgrade from 11.5.10.2 in multimode setup.
• Upgraded E-Business Application technology stack components from iAS1.0 to iAS 1.0.2.2.2 (Rollup 4), Jinitiator 1.1.8.25 to 1.3.1.24, JDK 1.3.1 to 1.4.1, and Developer 6i patch set 9 to patch set 15.
• Upgraded Discoverer 4i to Discoverer 10g.
• Upgraded E-Business Suite database from 8.1.7.4 to 9.2.0.7. Upgraded E-Business Suite database from 9.2.0.7 to 10.2.0.4, 10.2.0.5 Extensively worked on Apache/Jserv.
• Configured and enabled multiple JVMs in iAS 1.0 and also iAS 1.0.2.2.2.
• Cloned production instance to test and development instances using Rapid Clone.
• Installed Discoverer 10g, configured it with E-Business Suite 11.5.10.CU2 test & development instances, and upgraded EUL to 10g.
• Installed external web tier in DMZ for iReceivables and iRecruitment modules implementation and configured SSL for external web tier.
• Developed SQL queries to pull user data for SOX audit purposes.
• Coordinated the Change Control process for maintenance activities like cloning, patching.
• Applied database patches using oPatch utility.
• Managed tablespaces and other database objects.
• Installed Stats pack in the database to monitor the database and identify the bottlenecks in 9i databases.
• Performed System administrator responsibilities like creating users, adding responsibilities, adding concurrent manager reports to a responsibility etc.
• Extensively worked on concurrent managers to improve performance.
• Upgraded ATG RUP 4, HR.K and IRC.E
• Supported Learning Management System
• Documented Cloning Process
• Generate and Review SOX Audit reports regularly and coordinates with internal and external auditors.
• SR logging, review and support for Applications and Database.
• Analyze, Review, Test and apply patches.
• Involved in implementation of Contracts modules. Involved in implementation of HR suite.

Confidential, MO

Oracle Applications DBA Consultant

Environment: Oracle Financials Rel. Ver11.0.3, 11.5.7, 11.5.9 and 11.5.10 on Sun Solaris 2.8

Responsibilities:

• Handled day-to-day Apps DBA activities using Oracle Application utilities and tools.
• Installation, configuration and maintenance of Development, Test and Production instances of Oracle Applications. Worked closely with functional and development team while implementation.
• Upgraded Oracle Apps 11.5.7 to 11.5.9
• Upgraded Oracle Apps 11.5.7 to 11.5.10
• Database upgrades from 8.1.7.4 to 9.2.0.4, 9.2.0.4 to 9.2.0.6 and 9.2.0.6 to 10.2.0
• Migrated SAP instance into Oracle Applications 11.5.7
• Implemented Belgian Banking Solutions as part of SAP migration to Oracle Apps project
• Worked closely with functional and development team during Migration.
• Involved in Dataguard setup and configuration.
• Involved in Contingency Exercise of Oracle Applications failover.
• Managed Oracle Applications Performance by various methods.
• Assist developers in Application Tuning and Performance improvement.
• Managed backup using RMAN and SQL Backtrack.
• Administered patches for bug fixing and upgrade.
• Bug fixing and timely issue resolution using Oracle Support Services.
• Archiving and purging old data from Oracle Applications 11i Provide 24x7 support.
• Supported various modules like AR, PO, AP, GL, FA, Cash Management, Treasury Management, and iProcurement - Self Service applications.
• Timely communication to business stake holders.
• Regular tracking of Patch applications in the Test, Dev, GOLD and Production environments
• Experienced in Cloning oracle applications.
• Security control measures taken as per the guidelines of Sarbanes and Oxley.
• Coordination with datacenter, development team and operations team.

Confidential, Mountain View, C.A.

Applications Administrator

Environment: Oracle Financials Rel. Ver. 10.7, 11.5.4, 11.5.7, 11.5.8, 11.5.9 on Sun Solaris and HP Unix systems.

Responsibilities:

• Day to Day Oracle Applications Administration activities.
• Managing Concurrent process and fine tuning Concurrent Managers.
• Change Control implementation and follow-up.
• Worked closely with functional and development team during Migration.
• Month-End close support for functional users.
• Monitoring system activity and fine tuning problem areas.
• Involved in Contingency setup and configuration. Exercise of Oracle Applications failover.
• Managed Oracle Applications Performance by various methods.
• Ensure SOX compliance of the systems and generate audit reports
• Cloning Oracle Applications.