SUMMARY:

• 10+ years of Oracle EBS / Oracle databases and associated technologies.
• Oracle EBS R12 / 11i, Oracle database server 12c/ 11g R2 / R1 /10g/ 9i / 8i
• New Implementation of EBS R12.2.4. Installed and Configured Endeca 12.2 V5.
• Implemented SSL & SSO on R12.2.4
• Expertise experience on installing, configuring and troubleshooting Golden Gate.
• Created physical and logical standby databases using Data Guard.
• Installed & Configured Oracle Internet Directory & Oracle Access Manager.
• Installation / configuration of Weblogic server, Fusion Middleware - SOA / BPEL
• Oracle Apps cloning, Apps instance upgrades, database / CRS / ASM upgrades.
• Oracle database 12c/ 11g R2, 11g R1, 10g / 9i on 11g / 10g CRS / ASM.
• Oracle database 11g R2 infrastructure configuration, 11g R2 ASM / CRS upgrade.
• Configuration of Workflow Notification Mailer, OAM, OEM 10g and tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Worked on Fusion applications 11.1.1.6/11.1.1.7 for POC setup.
• Worked on ZFS Storage for POC setup. Implemented DMZ setup on Oracle EBS R12.2.4.
• Handled POC setup for 12c upgrade and Installation methods.
• Trainings handled on Oracle EBS / Oracle databases and associated technologies.
• Oracle Apps cloning, patch analysis, instance propagation planning of Apps instances.
• Apps Instance Planning, capacity planning, monitoring, instance tuning, best practices.
• Platform migration of Oracle database, database storage analysis, ASM / File systems
• Oracle on Demand implementation experience on EBS, OBIEE, Fusion apps etc.
• Expertise on various architectures of Oracle Apps and database configurations.
• Oracle Apps database performance tuning, troubleshooting issues.
• Oracle application server, Oracle discoverer 10g / 4i, Oracle workflow.
• Oracle Grid control / OEM, RMAN, SQL *PLUS, PL/SQL, Forms, Reports
• Oracle Standby database / Data guard configuration in Oracle Apps environment.
• Control-M scheduler, BMC Site scope, big brother monitoring systems.
• Hands on experience on Appworx for scheduling jobs.

TECHNICAL SKILLS:

Operating Systems: Linux (RH, OEL), UNIX (Sun Solaris, HP-UX, NEC UX, SCO, AIX), Windows 95, Windows 98, 2000, Windows NT 4.0 and XP

Oracle RDBMS: 12c/ 11g R2 / R1, 10g 9i RAC, 8i

Oracle EBS: Oracle Applications R12 (R12.2.4, R12.2.0, R12.1.3& R12.0.1),11i (11.5.2 through 11.5.10.2), 11.0.3, Fusion Apps 11.1.6,11.1.7

LANGUAGES: SQL, PL/SQL, UNIX Confidential, C, C++ and JAVA

PROFESSIONAL EXPERIENCE:

Confidential, WI

Sr. Oracle Apps DBA

Responsibilities:

• Implementation of Oracle Apps R12, Release 12.2.4.
• Implemented DMZ setup on Oracle EBS R12.2.4.
• SSL configuration with external and internal certs.
• Implemented SSO for EBS R12.2.4
• Installed OID 11.1.1.9 and OAM 11.1.2.3.3.
• Upgraded AD and TXK from Delta.C.5 to Delta.C.7
• Worked on Weblogic and other Fusion Middleware products.
• Installed Endeca and configured to EBS for online reporting.
• Implemented planning(APCC/SPP) Instance R12.2.4.1.
• I Supplier node setup in R12.2.4.
• Hands on experience with OBIEE, BI publisher & APCC environments.
• Configured Workflow Notification Mailer.
• Adop patching activity on R12.2.4.
• Having hands on experience on online patching.
• Stabilized clone process for EBS R12.2.4 with SSL and external node configuration by Rapid clone.
• Stabilized clone process for Endeca.
• Worked on tight schedules to reach GO-LIVE on time.
• Worked on multiple SR’s and many user related issues.
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring
• Stabilized Installation, Cloning & patching documentation.

Confidential, TX, USA

Sr. Oracle Apps DBA

Responsibilities:

• Upgraded Oracle Apps R12, Release 12.0.4 to 12.1.3 and database upgrade 10g to 11g.
• Copy/Clone of Oracle application environment using Rapid clone
• Worked on Fusion applications 11.1.6/11.1.7 for POC setup.
• Worked on ZFS storage for POC setup.
• Conducted Performance Review of Oracle Database for business critical applications with Senior Leadership team
• Generated AWR/Statspack reports from Oracle 11g/10g/9i database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Created SQL profiles to force the optimizer with the best execution plan.
• Completed minimized the space related errors in Oracle Databases by conducting month review with Senior Management and addresses the space issues proactively
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table re-org, add enough spaces to database
• Created a purge script to remove more than one year old data
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.

Confidential, Columbus, IN

Sr. Oracle Apps DBA

Responsibilities:

• Upgraded the E-Business Suite from R11i (11.5.10.2) to R12 (12.0.4).
• Installed and configured Oracle Single Sign-On Solution, Oracle Access Manager (OAM).
• Cloning and patching in EBS R12 environment for the implementation across Financials, Oracle HRMS, Manufacturing and Supply Chain modules.
• Migrated the Database and Applications from RHEL 4.0 32 bit to RHEL 5.0 64 bit.
• Installed and Configured Oracle 11gR2 Grid Infrastructure Software (Clusterware and ASM) and RDBMS on Oracle Enterprise Linux
• Supporting the Production environment of R12 environment with Financials, HRMS
• Configured Automatic Storage Management (ASM) with RDBMS10g for R12 environment.
• Installation and configuration of User Productivity Kit(UPK)
• Applied the major patches like HRMS family pack K RUP 3, CPU patches and Financials Family Pack G
• Cloning/Refreshes of database and application using Rapid clone.
• Evaluation of the Archive & Purge Solutions available for 11i in particular Outerbay and Applimation.
• Design & Implementation of Transportable Tablespaces for the Custom Archive/Purge Solution.
• Implemented the backup strategy for the backup of the custom schemas using Transportable Tablespace for purging.
• Familiar with Oracle Applications AD utilities like AD Administration, AD Controller, AD Merge Patch, AD Splice, AD Relink, Auto Patch etc.,
• Monitor system performance, identify bottlenecks and ensure problem resolution.
• Designed, Tested and implemented the hot backups for the production Database using RMAN.
• Creation of Responsibilities, data groups, and custom menus, users.
• Tuning of the Concurrent manager and all sysadmin issues.

Confidential

Apps DBA

Responsibilities:

• Oracle Application EBS upgrade from 11.5.9 to 11.5.10.2
• Configured Oracle Business Intelligence Enterprise Edition (OBIEE) with Oracle EBS with the Fusion Intelligence Applications and supporting the Implementation of OBIEE.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.
• Designed, Tested and implemented the hot backups for the production Database using RMAN.
• Enabling Shared APPL TOPs for various middle tiers
• Implementation of DR site for Oracle applications using Oracle Data guard
• Configuring and Implementing the Oracle Applications Manager (OAM) with 11.5.8
• Applying the Forms and Reports 6i patch sets to the Application instance
• Applying the application patches, and RDBMS patches and lot of troubleshooting on AD Utilities.
• Managing Concurrent Requests and Concurrent Managers
• Managed the Multi Language Supported installations with language patches and UTF8 conversions.
• Troubleshooting all kind of problems for all the customers in production life cycle of the project.
• Good experience in Oracle Exchange Server
• Solid knowledge of Apache configuration in Oracle Applications Environment
• Full understanding of all the Application DBA (ad) tools (adadmin, adpatch, admerge, adsplice, adlicmgr, adrelink.sh etc)
• Basic understanding of Functional modules like GL, FA, AR, PO, AP etc
• Installation and administration of RDBMS in Real Application Cluster (RAC) environment

Confidential

Jr. Apps DBA

Responsibilities:

• Cloning/Refreshes of database and application using Rapid clone.
• Designed, Tested and implemented the hot backups for the production Database using RMAN.
• Creation of Responsibilities, data groups, and custom menus, users.
• Tuning of the Concurrent manager and all sysadmin issues.
• Installed OBIEE 11g along with SPP Planning Instance
• Applying the application patches, and RDBMS patches and lot of troubleshooting on AD Utilities.
• Creating, Registering the Custom Schemas, Custom Apps, Forms with the AOL
• Supported Oracle Financials, Manufacturing, CRM and HRMS modules as an Oracle APPS DBA
• Running the Statspack on the databases to find the potential areas to tune
• Designing and Implementing the hot and Cold backups for the Oracle Instances
• Solid knowledge of Apache configuration in Oracle Applications Environment
• Full understanding of all the Application DBA (ad) tools(adadmin, adpatch, admerge, adsplice, adlicmgr, adrelink.sh etc)