PROFILE SUMMARY

Around11 years of professional experience in Information Technology industry which includesOracle ApplicationsDBA with hands on in administering Oracle Databases, Tools and ERP Applications.

JOB OBJECTIVE

To take up a challenging role as an Oracle Applications DBA in a world class I.T Organization.Consistently meeting the Organizational goals in tandem with personal growth. In my job, I look for opportunities to learn, grow, practice and deliver while working with a team of highly motivated individuals.

ORACLE APPS DBA

• Extensive experience in managing shared service model containing more than 100 OracleE-business suite instances which includes Production, Stage, Development Test instanceswith 99 uptime as SLA.
• Extensive experience in administering maintaining Oracle Applications E-Business Suite 11i:11.5.10,11.5.10.2 and R12:12.0.4,12.1.1,12.1.2,12.1.3,12.2.0,12.2.2,12.2.3 and Oracle Databases 9i,10g 11gR1/R2 .
• Good hands on experience in executing Patching, Refreshes Upgrades.
• Expertise in Installation of Oracle Databases onASM/Non-ASM file systems.
• Expertisein Dataguard/Standby setup.
• Expertise in 10g/11g Grid Infrastructure implementation CRS ASM , RAC databases installation, Upgradation of CRS and RAC Databases.Hands on Experience in working withNon-RAC, RAC environments.
• Good knowledge on using Datapump and Physical Backup's like COLD and HOT Backup, Restore and Recovery at different scenarios. Expertise in migration of tablespaces, schemas and huge data across the environments using datapump.
• Expertise in RMAN Backup and Recovery, Developed weekly strategy for RMAN Incremental backups and weekly Tape backups.Extensive experience in refreshing core DB instance using RMAN backups.
• Expertise in Oracle E-Business Suite, Administering Shared APPL TOP Parallel Concurrent Processing.
• Familiar with Discoverer, Workflow configurations, Forms and Reports.Troubleshooting Concurrent manager, Apache and Discoverer issues.
• Expertise in Oracle Weblogic Installation and Administration. Expertise in WeblogicClustering. Expertise in Oracle BI Installation and Administration.
• Experience on Implementation, Maintenance of Oracle Apps R12.2. Expertise in Cloning, Patching using ADOP in 12.2
• Experience on working with Oracle Exadata, Exalogic environments.
• Good hands on experience with Oracle Utility Products like, Oracle Customer Care and Billing Oracle CC B , Oracle Work and Asset Management System Oracle WAMS , Oracle Meter Data Management Oracle MDM .
• Knowledge in other domains likeOracle Fusion Middleware Concepts, Oracle Utility Products, OBIEE.
• Ability to work with and listen to customers/users. Capable of self-learning to explore technically. Ability to interact with end users, self-motivated, quick learner and team player with Good communication skills.

TECHNICAL SKILLS

ASSIGNMENTS

Confidential

Oracle Apps DBA

Exalogic environments.DBA Lead.Implementation and Support of Oracle UtilityProducts Oracle Customer Care Billing,Oracle Work and Asset Management, Oracle Meter DataManagement. , Support of Oracle Apps 11i and R12.

Environment: Oracle Database 11gR2 11.2.0.1, 11.2.0.3, 11.2.0.4 , Oracle Apps R12 12.1.3

• Crompton Greaves CG Impleme
• acle Apps DBA Support.
• ActivisionBlizzard, Inc. - Implementation of Oracle Apps 12.2 on Exadata and Exalogic environments.
• 12.1.4, 12.2.0, 12.2.3 .Oracle Weblogic 10.3.3, 10.3.4, Oracle BI 10.1.3.4. Oracle Utility Products - CC B 2.3.1, Oracle WAMS 1.9.0.3, Oracle MDM 2.0.

Responsibilities

• Worked with Oracle Utility products implementation project as a DBA lead. Responsible for the complete Architecture setup for CG client.
• Worked on Maintenance, Support, Patching and Cloning using Rapid Clone.
• Involving in Database and Application performance issues including Weblogic issues.
• Configuring DB alerts using Crontab.
• Database restoration and recovery using RMAN.
• Configuring RMAN backups.
• Oracle 11gR2 RAC installation.
• Oracle Database installation, Maintenance and support.
• Hands on working experience on 12.2environments.
• Experience in Cloning from Single node to Multi Node and Multi Node to Multi Node. RAC to Non RAC and RAC to RAC using Rapid Clone.
• Expertise in Oracle Apps 12.2 Patching using ADOP.
• Working in an Oracle AppsR12.2 Implementation project with Exadata and Exalogic architecture.
• Citi Group Or
• ntation Support of Oracle Utility Products DBA Support.
• Installed and Configured Oracle Databases 11gR2 and Oracle Utility Applications CC B, WAMS, MDM .
• Installed and Configured ASM, Migrated Non-ASM Databases to ASM. Implemented Oracle RAC.
• Installed and Configured Oracle Dataguard Physical Standby .
• Installed and Configured Oracle Weblogic for Oracle Utility Applications. Experience in Oracle Weblogic Clustering.
• Did a complete setup of the servers at Data Center.
• Performing Database/Schema level Refreshes using expdp/impdp and RMAN. Automated the process of Daily Schema Level Refresh from Production DB to Replica DB.
• Involved in Configuring OEM. Monitoring the Databases. Automated the Daily Health check report. Configured SQL Plan Management.
• CompletedOracle Advanced Compression POC and SPM SQL Plan Management POC.
• Worked on R12.2 POC.
• Completed Oracle Exadata Database Machine 2014 On-Demand Implementation Boot Camp.
• Completed Oracle Exadata 2014 Certified Implementation Specialist Practice Assessment.

Confidential

Designation: Senior Technical Analyst

Projects Handled: Oracle Apps Maintenance Support, Refreshes Upgrades

Environment: 11i/R12 Applications, 9i/10g/11g Database

Description: Workedin a Dedicated Services Team, Providing an end to end supportto the above mentioned Clients.

Responsibilities

• Support and maintenance of 11i and R12 Applications with PCP configured.
• Involved in supporting and maintaining all types of instances which includes 11i/R12 Apps, 9i/10g/11g Databases, 10g AS, iLearning instances, HR instances, Discoverer servers etc.
• Installation and Support of Non-RAC, Single Node RAC and Multi Node RAC environments.
• Regular maintenance worksand Configuration tasks Such as Cemli's/Code Promotions, Patching, Performance Tasks etc .
• Install, Configure and maintain third party software Such as Appworx, Sabrix,SuperTrump .
• Involved in performance issues related to DB MT.
• Involved in Weekly based Refreshes Sometimes as requested by Customer .Refreshes which includes Multi Node to Single Node, Multi Node to Multi Node, Single Node to Single Node, Single Node to Multi Node, RAC to Non-RAC, Non-RAC to RAC
• Involved in Database related activities like Refreshes,Patching,DB Performance issues .
• Successfully completed Oracle Applications upgrade from 11.5.10 to 11.5.10.2.
• Involved in R12 upgrades 12.0.4 to 12.1.1, 12.1.2 to 12.1.3
• Performed complete Patch Analysis and application of Apps and DB Patches.
• Involved in CPU Patching, DST Patching and Mass patching.
• Involved in Discoverer installation and Configuration.
• Effectively involving in managing Post refresh documentation as per Customer requirements.
• Involved in 10gAS administration.
• Involving with the Support/Development Teams for getting any workarounds on issues.
• Managing in creating the SR's and Efficiently involved in transferring the SR's across other teams and getting the work done.
• Effectively managing the Standard process flow and maintaining Customer satisfaction.
• Managing OWC sessions across Customers and Other team members.
• Communicating with the Team members very frequently, Effectively involving in the work and making sure to complete within the requested time.
• Effectively sharing the work across Team members. Taking responsibility of allotting work and making sure of all the SR's in the queues were addressed.

WITH iNET FRAME TECHNOLOGIES. April '06 to Jan '08

Designation: Oracle Apps DBA

Confidential

Environment: 11i Applications, 9i 10g Database

Description: Worked in a Dedicated team supporting the above Clients.Having a Complex Apps architecture including RAC environments.

• Responsibilities

• Support and maintenance of 11i Applications with PCP configured. 9i RAC and 10g Databases.
• Support for Non-RAC, Single Node RAC and Multi Node RAC environments.
• Refreshes includes Multi Node to Single Node, Multi Node to Multi Node, Single Node to Single Node, Single Node to Multi Node, RAC to Non-RAC, Non-RAC to RAC etc
• Involved in Weekly based Refreshes Sometimes as requested by Customer .
• Involved in performance issues related to DB MT.
• Regular maintenance works and Configuration tasks Such as Cemli's/Code Promotions, Patching, Performance Tasks etc .
• Daily 24/7 active support for Prod and Non-Prod environments.
• Involved in all kinds of DB activities. Refreshes,Patching,DB Performance issues etc .
• Analysis and application of Apps and DB Patches and adadmin activities.
• Performing SYSADMIN tasks.
• Performing Pre-Patch Analysis for multiple patches.
• Merging the patches using admrgpch.
• Involved in CPU Patching, DST Patching and even in Mass patching.
• Clones/Refreshes of 11i instances.
• Effectively Following the Post Refresh Documentations.
• Effectively managing all the Front end tasks.
• Involved in 10gAS administration.
• Managing OWC sessions across Customers and Other team members.
• Involving with the Support/Development Teams for getting any work arounds on the issues.
• Managing in creating the TAR's.
• Effectively managing the Standard process flow and maintaining Customer satisfaction.

WITH REDWOODS CONSULTING. Jan'04 to April'06

Responsibilities

• 24x7 DBA support
• Tablespace maintenance like adding and resizing datafiles.
• Maintaining, Administering of Oracle Databases and Applications.
• Schema backups using export and import utilities.
• RMAN backups. Incremental and Full.
• Monitoring DB alert log errors, Tablespace usage, Locks in a Database.
• Patch Analysis and Patching.
• AD utilities adpatch, adadmin, adctrl etc.
• Involved in System Administration tasks.
• Cloning of the Applications using Rapid Clone.
• Created/Maintained Technical Notes and Documentation.