SUMMARY

• 9 years of experience in Oracle DBA and Oracle E - Business Suite DBA Roles.
• Extensive experience on Oracle E-Business Suite 11.5.8, 11.5.9, 11.5.10.2, 12.0.6, 12.1.1, 12.1.3 and 12.2.4 with EBS upgrade to 12.2.4 version.
• Area of Expertise includes Database support and maintenance, installation, configuration, administration, security management, memory management, backup, recovery, cloning and upgrade of 10g and 11g databases.
• Have good technical skills, strong grasping power and keen learning skills.
• Flexible towards work environment and have good client interaction skill.
• Proactive and result-oriented leader adept in mentoring and motivating the dynamic team to exemplary performance.
• Received many appreciations from clients and senior management from organization.
• Awarded with Customer Champion Award for my work in Confidential Technologies.

TECHNICAL SKILLS

• Database Upgrade
• RMAN
• OEM
• Disaster Recovery
• ASM ( Automatic Storage Management)
• SSO ( Single Sign On)
• GRCC - Governance, Risk and Compliance control
• APEX
• Cloning - Using RMAN, Cold and Hot backup
• Patching - Using OPatch
• Performance Tuning - SQL Trace, TKPROF, AWR, ASSH, ADDM
• Expdp/Impdp process
• 11i and R12 version
• Upgrade
• Cloning and patching
• Using AD utilities
• Managing concurrent managers
• Shared application file system
• Red Hat Linux
• Sun Solaris
• HP UX PA RISC
• Windows Server
• Hummingbird Exceed
• Terminal Server
• VNC/SSH/ SCP/ FTP/Telnet
• Smarterm
• Applimation
• Vantives
• JIRA
• Service Now/ Assure Service Desk

PROFESSIONAL EXPERIENCE

Confidential, Long Island, NY

Sr. Oracle DBA/Oracle Apps DBA

Responsibilities:

• Working on upgrade project.
• Done database upgrade from 9.2.0.7 to 12.1.0.2 version
• Done EBS upgrade from 11.5.9 version to 12.2.4.
• Involved in management call and project kickstart.

Confidential, Wood Dale, IL

Sr. Oracle DBA/Oracle Apps DBA

Responsibilities:

• Supporting 24*7 critical production databases with Oracle E-Business Suite and BI and Apex services.
• Ensuring the availability and performance of databases and application services.
• Successfully performed complete cycle of Oracle EBS 12.1.3 upgrade from 11.5.10.2 release along with Brazil Localization and major HRMS family packs and Patch Wizard Patches application.
• Performance tuning of 12.1.3 EBS to ensure high availability of applications for end users.
• Upgraded Oracle AS 10.1.3 to 10.1.3.5 in R12.1.3 EBS.
• Successfully done complete cycle of Oracle database upgrade from version 10.2.0.4 to 11.2.0.2.
• Proficient on several AD admin tools like ADPatch, ADSPLICE, Rapid Clone, ADMerge, Distributed AD, ADadmin, ADsplice, Autoconfig etc.
• Applied critical CPU bundle patches, Patch wizard Patches and other family packs to make system up to date.
• Java upgrade from Java 6 to Java 7 version for R12.
• Troubleshooting and managing concurrent manager processes and workshifts related issues.
• Expert in application cloning using Rapid Clone, Auto Clone, Autoconfig Clone and Manual Clone.
• Performance Tuning of database and SQL optimization using ASH, AWR, ADDM and Statspack, SQL Trace and TKPROF.
• Re-org of tables via OEM along with Re-building bad indexes for performance issue and regular maintenance of database,
• Data Guard implementation on 11.2.0.2 database with failover/switchover process.
• Maintenance and support of Applimation (History) database along with version upgrade.
• Worked on Oracle Internet Directory integration with R12.1.3
• Refreshing/Cloning of development and test databases using RMAN, Export, Cold and Hot backup.
• Copying schema, tables etc. via export import.
• Apply database patches mostly CPU, bug fixes, one offs using OPatch.
• Troubleshooting Database errors like ORA-600, ORA-7445, Memory Issue etc.
• Created scripts for sanity checks of databases.
• Creation of database and E-Business user as per the requests and assigning required roles and responsibility. Installation of Oracle
• Worked on Apex, BI and Warehouse database.
• Apex installation to version 4.1 and Apex Upgrade from Version 4.1 to 4.2.
• Maintained a high customer satisfaction index for technical consultancy on different Integration Projects.
• Co-ordinated daily conference calls with Client (Video/Audio) and various stakeholders to review activities/tasks and plan for resolution of critical issues.
• Closely worked with Functional and Development team for database design and construction.
• Made sure all SLAs were met. Set-up and maintain documentations and standards.
• Worked with Oracle on SR and OWC for fixing the issues during the complete tenure.
• Supported off-hours on-call support.

Confidential, West Palm Beach, FL

Sr. Oracle DBA/Oracle Apps DBA

Responsibilities:

• Worked on R12.1 implementation project at customer site.
• Installation, configuration and upgrade of Oracle server software and related product.
• Was involved in all technical discussion with rest of the team and management team during the complete tenure and gave the best for the project.
• Cloning, patching and code migration on regular basis was done for bug fixing.
• Applied many critical patches like HRMS, CPU patch and family packs as well using adpatch and admerge utilities..
• Applied OPatch on development and production database.
• Worked on RICEW (code) object migrations.
• Strategized and planned backup and recovery of the database through RMAN.
• Managing and maintaining Load Balancer system for high availability of production application services.
• Disaster Recovery setup of version 10.2.0.4 database with failover/switchover process.
• Preparing pre patch analysis and applying CPU patches to maintenance instances up to date.
• Monitoring Concurrent service and troubleshooting Concurrent manager issues on daily basis
• Upgraded GL WAND to version 4.2.
• Worked continuously with functional and technical team till completion of the project.
• Taken care of Discoverer EUL creation for R12 EBS.
• Taking care of GRC control application and worked on GRCC upgrade from 8.5.1 to 8.5.5.28
• Received many appreciations from higher management and Clients for my work

Confidential

Oracle Apps Engineer/Admin

Responsibilities:

• Proactively monitoring the PROD/Test/Development Instances via OEM and OAM.
• Maintaining the 24X7 mission critical production database.
• Installation and configuration of 11i and R12 E-Business Suite.
• Worked on Multi-node and shared file system environment
• Strong experience in Patching and Patch analysis for Mini packs, Family packs, XML publisher, CPU patches etc.
• Apply RDBMS patches using Opatch and EBS patches using adpatch.
• Preparing pre patch analysis and applying CPU patches to maintenance instances up to date.
• Cloning the Rapid clone enabled/Autoconfig enabled instance.
• Hands on experience on ASM and RAC.
• Backup and recovery through RMAN. It includes Cold backup and incremental backups.
• OEM installation and OEM template addition.
• Strong experience in Creating Users, Responsibilities, Menus and Form Functions.
• Worked on CVS, a version control tool and also on SQL Developer and toad.
• Worked on Share point ticketing system like Vantives, JIRA, Mantis etc.
• Single handedly managed major customer like DreamWorks Animation and was involved in conference call on weekly basis.
• Code migrations and data fixes on Production and development environment without any failure.
• Troubleshooting Applications and DB issues which include ORA- errors etc.
• Monitoring Concurrent service and troubleshooting Concurrent manager issues.
• Interacting with Oracle support for technical service requests.
• Preparing useful scripts for alerts on client’s environment.

Confidential

DBA Activities Coordinator

Responsibilities:

• Handling Mail Requisition without any slippages in the mails of all the clients.
• Preparing weekly and monthly reports.
• Handling internal site with all documents up-to-date.
• Handling CD Repository.
• Supporting Minor DBA related task for internal clients.
• Monitoring the internal servers and database services.