SUMMARY:

• An astute Oracle Apps DBA wif 8 plus years of IT experience in Oracle technologies.
• Worked as Technical Lead, Team Lead, Onsite / Offshore co - coordinator and as per teh client need.
• Strong expertise in end to end Oracle E-Business Suite upgrades, and Database upgrades
• Involved in a wide array of activities in implementation, up gradation and support of multi-tier production and development environment like Oracle Applications 11i, R12.1 and R12.2 along wif Oracle RDBMS versions 9i, 10gand 11g on UNIX/Linux/Windows platforms.
• Sound knowledge on cloning of oracle applications using Rapid clone & manual clone.
• Exposure on Weblogic installation and administration.
• Involved in various integration like OID, OAM and OEM.
• Experience in PCP, workflow configurations
• Strong knowledge and OATM
• Configured Secure Socket Layer for Oracle Applications
• Exposure in working at Client/Customer locations, high level of confidence in customer management and can handle pressure situations.
• Having a good exposure to UNIX environment, AIX and Solaris
• Confident at troubleshooting and problem solving.
• Capable of preparing and understanding shell scripts.

TECHNICAL SKILLS:

• E-biz Upgrade from 11i to R12.1.3
• E-Biz patch set upgrade R12.2.2 to R12.2.3
• Apps R12.2 OID, OAM integrations
• JDK,JRE & Dev 6i upgrade from 1.4 to 1.6
• Apps 11i & R12 point release upgrades
• Applications Cloning
• R12 forms upgrade
• R12 RUPs and 11i RUPs
• ATG patching
• Apps CPU patching
• Shared Tech stack implementation
• DMZ setup
• SSL Configuration
• Forms Socket to Servlet conversion
• PCP Setup and CM troubleshooting
• MWA Configuration
• Apps Custom code migration
• Apps Configuration
• OATM Implementation
• Workflow Configurations
• Discoverer 10g installation and upgrade
• Printer Setups
• Apps Migrations
• Web logic administration
• Web logic Domain Integration
• Web logic Clustering and load balancing
• OEM Integration & administration
• Database upgrade 8i to 11G
• Database Migrations
• Rman Backups
• RAC Implementation
• ASM Administration
• Database Performance tuning

PROFESSIONAL EXPERIENCE:

Confidential

Lead DBA

Responsibilities:

• Upgrading Database from 10g to 11gR2.
• Upgrading E-Business suite application instances from 11.5.10.2 to 12.1
• Upgrade Oracle Applications R12.1.3 to R12.2
• Cloning of Oracle Application through Rapid Clone and manual cloning.
• PCP Configuration and Administration
• SSL Implementation on R12 Applications
• JDK, JRE upgrade
• Shared Techstack implementation
• Adding Web tier and configuring
• Integrating and administering discoverer server.
• Workflow administration and maintenance.
• Mark view Integration and web logic administration.
• Applied RDBMS patches, maintenance packs, mini packs.
• Implementing OATM.
• Platform Migration from IBM AIX 5.3 to 7.1.
• Evolved in Organizational units merging in R12
• 11g OEM Configuration and integration
• Agent Installation and Configuration in OEM
• OMS Patches and OEM patches
• Trouble shooting various issues during migration.
• Web page designing using oracle APEX
• Implementation and integration of UPK wif EBS
• Provided 24/7 support to various phases SIT, UAT and go live.
• Maintaining Application Security and Database Security
• Managing Users, Responsibilities and Profile options Oracle Database 10g & 11g
• Monitoring Health Check of servers by background process and by using OAM
• Create and Follow up Service Requests wif Oracle Support for Technical Support
• Creating and Maintaining database links for different domains.

Environment: RDBMS 10g and 11G, Oracle Applications 11i, R12.1& R12.2

Confidential

Responsibilities

• Actively involved in planning and preparation of teh UK go live project. Played a Key role in UK go - live and made a successfully deployment.
• Involved in customer meetings and responsible for taking decisions required for teh project.
• Transitioned offshore team on teh upgrade activities and helped them to understand teh internal and external dependencies.
• Conducted weekly meetings wif both internal and external clients and provided teh status updates
• Played a key role in post go live support and worked as a single point of contact for client and third party vendors for resolving teh post go live issues.Responsibilities as Offshore Team Member:
• Installing and Administrating E-Business Suite 11i and R12.X
• Upgrading E-Business suite application instances from 11.0.3 to 11.5.10.2
• Upgraded E-Business suite application instances from 11.5.10.2 to R12
• Involved in application upgrade point level from R12.1.2 to R12.1.3
• Upgrading Database from 8i to 11gR2.
• Applied RDBMS patches, maintenance packs, mini packs.
• Hands on experience in Cloning of Oracle Application through Rapid Clone and manual cloning.
• Oracle Applications table spaces are migrated from old architecture to OATM
• JDK upgrade from 1.4 to 1.6
• Starting and stopping of weblogic admin and managed servers.
• Administering weblogic managed servers.
• Has worked on OID integration wif 11g databases
• Implemented SSO Integration wif R12.1.3
• Upgraded JRE from J-initiator.
• Changing and adding database parameters according to upgrade requirement.
• Configured secured socket layer (SSL) in oracle applications 11i.
• Applying CPU patches to fix teh security issues.
• Managing Redo log and Archive log files.
• Oracle Database space management.
• User security management & administration.
• Implementing custom tops as for customer business perspective.
• Troubleshooting issues during teh up gradation.
• Involved in applications performance tuning and database performance tuning.
• Golden Gate Installation

Environment: RDBMS 8i, 9i and 11G, Oracle Applications 11i, R12

Confidential

Apps Database Administration

Responsibilities

• Administrating E-Business Suite 11i and R12,
• Experience in Application Patching using ad patch and strong analytical and problem solving skills in Patch Management.
• Applied RDBMS patches, maintenance packs, mini packs.
• Proficient in using auto config for Oracle application system maintenance.
• Knowledge on AD Utilities like ad admin, adrelink, adctrl etc
• Knowledge on Cloning of Oracle Application through Rapid Clone.
• Managing teh tablespaces and reorganized teh Fragmented Tables.
• Added redolog files and maintained redolog groups.
• Purging unwanted request output and log files using purge concurrent programs.
• Managing teh Concurrent Managers and its operations like starting, stopping teh concurrent managers.
• User account management - creating users, disabling users, responsibility management.
• Sysadmin tasks like creating user, assigning responsibilities, registering forms, Concurrent programs, creating responsibilities and menus.
• Managing Redo log and Archive log files. Conversion of Database in Archive Log / No Archive Log Modes.
• Ability to handle more TEMPthan 30 service requests for a day.
• Interact wif end users to understand their technical queries related to database
• And provide assistance in resolving them.
• Performing health checks periodically and maintaining consistency.
• Starting and stopping teh web logic services
• Troubleshooting startup issue of concurrent manager server and other servers.
• Troubleshooting discoverer server issues.
• Performing Patch Analysis, preparing final action plan for execution.
• Performing Pre Config Analysis(Application and database changes)
• Performing Pre State Analysis(data fixes)
• Changing parameter values in application configuration file
• Patch Application in Single and Multi node servers.
• Applying RDBMS patch using Opatch
• Trouble shooting issues after patch application.

Environment: RDBMS 8i, 9i and 11G, Oracle Applications 11i, R12.