SUMMARY

• Over 12 years Hand - On experience in Oracle Application Database Administration.
• Expert in leadership skills, team management, efficient in individual contribution and also a good team player.
• Expert in Upgrades, migrations, applying patches Cloning/refreshes and Troubleshooting, End user support of applications powered by Oracle systems.
• Expert in performance running on Oracle application and database.
• Expert in Support & Management of Oracle e-Business Suite R11 & R12.
• Experience in Installation and Configuration of Oracle Enterprise Manager Grid Control (OEM) system for monitoring and management.
• Expert in Backup & Recovery using RMAN.
• Experience in 10g/11g Real application cluster (RAC), ASM
• Experience in Oracle WebLogic, SOA10g/11g.
• Experience in handling DR environment.
• Experience in DMZ, SSL, and Oracle Web Cache server.
• Have good knowledge of Oracle Internet Directory (OID), Single Sign On (SSO).
• Have good knowledge on OBIEE 11g administration.
• Expert in troubleshooting Issues and Performance problems.
• Experience in supporting small size (120 GB) to very large size databases (8 TB) in a 24x7 support environment.
• Hands on experience in writing shell script and documentation.
• Strong interpersonal skills, ability to interact with people at all levels good communication and presentation skills

TECHNICAL SKILLS

Applications: Oracle E-Business Suite 11i, R12(12.0, 12.1, 12.2), Oracle AS 10g, Fusion Apps 11.1.1.5, ASCP, VCP, Demantra, Oracle Application Server10g/9i, Oracle Portals, Discoverer, Data Reports, OAM, OBIEE, SOA, AIA

Database RDBMS: Oracle 9i, 10g, 11g, 12c, RAC, ASM, Mongo database

Platforms/Operating Systems: RHEL, Solaris, AIX, Windows, HP-Unix, Oracle Exadata/Exalogic

Tools: RMAN, Toad, OEM, Autopilot, Informatica Smart Partition (6.2,6.3,6.4)

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

Lead DBA

Responsibilities:

• Planed and coordinated all DBA aspects of project from initiation through delivery.
• Created R12.2 upgrade/migration steps from Solaris to Exalogic/Exadata hardware.
• Created workbook for upgradation of each phase right from CRP, UAT, mock production build and production build.
• Characterset conversion from solaris to Linux.
• Setup external node and responsibility access setup.
• Worked on external f5 url setup with ops.interned and ops.web teams.
• Worked with technical on implementation of environmental changes on ERP system as per Exa standards.
• Build DR environment and performed a fail over scenario with proper documentation.
• Worked on strategy to reduce upgradation time.
• Resolved performance issues during migration.
• Performed migrations as per new Exa standards.
• Scheduled backup strategy.
• Performed cloning steps and documented the steps.
• Knowledge transfer to production support group.

Environment: Oracle Exadata/Exalogic, Sun Sparc 64 Bit, EBS R12

Confidential

Project Manager and Lead DBA

Responsibilities:

• Planed and coordinated all aspects of project from initiation through delivery.
• Developed project plans, protocols, and/or informed consents.
• Supervised and facilitated the development of high impact training/presentation materials and content, meetings and conferences with program/project participants, scheduled and target audience communication.
• Communicated project status and timelines.
• Created installation/segmentation steps for ILM setup.
• Worked on strategy to reduce implementation time.
• Created setup documentation for ILM 6.4 version.
• Resolved performance issues during implementation.
• Trained DBA team for ILM implementation.
• Working on ILM upgrade from 6.3 to 6.4 version with through impact analysis.

Environment: Sun Sparc 64 Bit, EBS Multinode and single node with 11i and R12, ILM 6.4

Confidential

Lead DBA

Responsibilities:

• Planed and coordinated all DBA aspects of project from initiation through delivery.
• Created migration steps from Solaris to Exalogic/Exadata hardware.
• Created workbook for migration of each phase right from CRP, UAT, mock production build and production build.
• Setup external node and responsibility access setup.
• Worked on external f5 url setup with ops.interned and ops.web teams.
• Worked with technical on implementation of environmental changes on ERP system as per Exa standards.
• Build DR environment and performed a fail over scenario with proper documentation.
• Worked on strategy to reduce migration time.
• Resolved performance issues during migration.
• Performed migrations as per new Exa standards.
• Scheduled backup strategy.
• Performed cloning steps and documented the steps.
• Knowledge transfer to production support group.

Environment: Oracle Exadata/Exalogic, Sun Sparc 64 Bit, EBS R12

Confidential

Project Manager and Lead DBA

Responsibilities:

• Planed and coordinated all aspects of project from initiation through delivery.
• Developed project plans, protocols, and/or informed consents.
• Planed and negotiated project budgets and timelines.
• Trained project staff on methods and protocols.
• Supervised and facilitated the development of high impact training/presentation materials and content, meetings and conferences with program/project participants, scheduled and target audience communication.
• Communicated project status and timelines.
• Created installation/segmentation steps for ILM setup.
• Build custom accelerators for Confidential environment.
• Worked on strategy to reduce implementation time.
• Created setup documentation for ILM 6.3 version.
• Reduced the overall implementation of CTT site from 45hrs to 25hrs using Oracle features rather than relying on tool.
• Coordinated with Informatica to resolve implementation and performance issues.
• Resolved performance issues during implementation.
• Discussed with Informatica to get latest bugfix’s related to the tool.
• Trained DBA team for ILM implementation.

Environment: Sun Sparc 64 Bit, EBS Multinode and single node with 11i and R12, ILM 6.3

Confidential

Sr. DBA - Oracle Apps

Responsibilities:

• Performance Tuning of Oracle Applications and Database
• Implemented Monthend proactive monitoring for Finance system to capture locking, Concurrent Manager Health, Pending Jobs, Business Critical Job runtime, etc.
• Executed Finance and HR Database re-org to enhance performance along with results on improved programs behaviour.
• Coordination with Support groups.
• Customer connect.
• Finance Warroom DBA.
• HR Legislative Patching.
• Troubleshoot problems related to Oracle database and Oracle Applications.
• Clone Oracle Applications environments & cloned Oracle Apps subset quarter wise using Auto pilot.
• Supporting users with issues they come across during test/development work.
• Code review and migration following GIEA standards.
• System Administration responsibilities.
• Database maintenance activity.
• Supported discoverer plus and discoverer web desk reports.

Environment: Sun Sparc 64 Bit, EBS Multinode and single node with 11i and R12, Appworx

Confidential, Minneapolis, MN

Sr. DBA - Oracle Apps

Responsibilities:

• Experience in Performance Tuning of Oracle Applications and Database
• Administering Concurrent Manager and Concurrent Requests.
• Database tables re-org to enhance performance.
• Troubleshoot problems related to Oracle database and Oracle Applications.
• Clone Oracle Applications 11i environments & cloned Oracle Apps subset quarter wise using Auto pilot.
• Recovered table on Production using partial database recovery.
• Resolved ASCP Planning Data Collection performance issue on Production.
• Supporting users with issues they come across during test/development work.
• Code review and migration following GIEA standards.
• Analyze and Applied patches using adpatch utility on different instances (Production, development and test).
• System Administration responsibilities.
• Database maintenance activity.
• Applied database patches.
• Cloning of database & RDBMS software.
• Worked on both Cold/Hot Backup strategies
• Supported discoverer plus and discoverer web desk reports.
• Detecting block corruption using DBVERIFY, alert log and resolved using RMAN.

Environment: Sun Sparc 64 Bit, EBS Multinode and single node with 11i and R12, Demantra, Appworx

Confidential

Sr. DBA - Oracle Apps

Responsibilities:

• Upgraded Production Database from 10g (10.2.0.4) to 11g (11.2.0.3).
• Upgraded Database from 10g to 11g for UAT, CRP and DEV.
• Worked on Performance Tuning of Oracle Applications and Database
• Coordinated with multiple teams as part of planning and execution of Confidential .
• Documented and maintained workbook for the upgrades performed.
• Worked on Oracle Minimum Base Line patching activity and security patches with the help of PUMA oracle dedicated support.
• Worked on clone of Oracle application 11i.
• Upgraded Demantra application from 7.2 to 7.3.
• Monitor databases and application through OEM Grid Control.

Environment: Sun Sparc 64 Bit, EBS Single node with 11i, Golden Gate, Auto Pilot, Oracle Governance, Discoverer, Audit Vault, Logical Apps, Webdesk, Demantra, Appworx

Confidential

Sr. DBA - Oracle Apps

Responsibilities:

• Worked on Performance Tuning of Oracle Applications and Database.
• SQL level tuning with the help of Performance Engineering team
• Worked on code review and migration as per GIEA standard.
• Troubleshoot incidents/problems related to Oracle database and Oracle Applications.

Environment: Sun Sparc 64 Bit, EBS Single node R12.1.3

Confidential

Project Lead Engineer

Responsibilities:

• Database administration, Space Management, User Management, Housekeeping.
• Managing primary database structures, resolving space and basic performance issues.
• System administration tasks like administering concurrent program, creating users, creating responsibilities and menus.
• Cloning the production system to the target test system.
• Applied patches and resolved patch related issues.
• Workflow notification mailer setup and maintenance.
• Installed AIA 2.2.1 along with Oracle service Registry 10.1.3.1, Service Oriented Architecture on 10g Database.
• Worked on Fusion Middleware Installation 11g Release 1
• Configured RDBA tool on Database.
• Done Helthcheck on database by using scripts.
• Installed 10g RAC on test.
• Maintained Applications file system like re-link applications programs, copy files to destinations, generate message files using adadmin utility, create applications environment file.

Environment: RHEL 4.0, Windows XP/2000, Oracle 10g, Oracle 10gAS

Confidential

Lead DBA

Responsibilities:

• Migrated Oracle database from Linux to Solaris.
• Upgraded EBS 11.5.10.2 to 12.1.3 CRP1,CRP2 and Production.
• Provided support to Client upgrade for CRP2.
• Providing DBA support to Technical and Functional team.
• Cloned CRP1 to development and test.
• Cloned EBS with RAC/ASM database to single node on regular file system.
• Enabled SSL for EBS.
• Enabled Latin American English(ESA) NLS.
• Applied patches
• Concurrent administration.
• Recreated custom soft links.

Environment: RHEL, Solaris, EBS R12, ASM, RAC

Confidential

Sr. DBA

Responsibilities:

• Providing regular Applications DBA support in 24 x7 mode
• Cloned production to development and test (Multi to single/Multi to Multi node).
• Enabled SSL for EBS.
• Renewed the SSL certificate on EBS Production.
• Worked on EBS DR setup.
• Worked on CR’s.
• Prepared SOP on cloning
• Applied patches
• Provided support on Hyperion Installation and DR setup.
• Upgraded Oracle database.
• Created physical standby database for production.
• Concurrent administration.
• SYSADMIN tasks.
• Working on Weekly/Monthly monitoring reports.

Environment: AIX, RHEL, EBS R12, ASM, RAC

Confidential

Oracle Applications DBA

Responsibilities:

• Maintained Applications Database Objects like Validating and compiling objects, recreating grants and synonyms to Apps schema using adadmin utility.
• Maintained Applications file system like re-link applications programs, copy files to destinations, generate message files using adadmin utility, create applications environment file.
• Clone Oracle Applications 11i environments.
• Involved in Upgrading Oracle Applications from 11.5.9 to 11.5.10.2
• Troubleshoot & resolving issues in upgrading/user support.
• Analyze and Apply patches using adpatch utility on different instances (Production, development and test).
• Creating users and assigning the Responsibilities using System Administration module of Oracle Applications.
• Administering Concurrent Manager and Concurrent Requests.
• Troubleshoot problems related to Oracle database and Oracle Applications.
• Single and multi-node installations on test.
• Configuring changes in Oracle Applications environment.
• Supporting users with issues they come across during test/development work.
• Storage management including adding datafiles to the tablespaces and distributing them among different disks to reduce I/O contention.
• Coordinating with Oracle support for logging tar and knowledge based search to find solution to the problems that are occurring in the live server and while applying patches (tar, Bug search).
• Installation of oracle 9i &10g RDBMS servers.
• Point version upgrade database from 9.2.04 to 9.2.07.
• Applied database patches.
• Cloning of database & RDBMS software.
• Worked on both Cold/Hot Backup strategies

Environment: RHEL, Sun Solaris, Windows, Oracle 9i, 10g.

Confidential

Support Engineer

Responsibilities:

• Cloning the production system to the target test system.
• Nightly therapeutic reboot of the production system.
• Enrolling users, assigning roles and profiles, maintaining system by monitoring user access to the database.
• Troubleshooting ORA errors.
• Managing primary database structures, resolving space and basic performance issues.
• Listener, tns entries configuration.
• Interaction with oracle support for technical assistance requests in troubleshooting Issues.
• Maintaining and resolving operating system level space issues.

Environment: Windows, Oracle 9i.