EXPERIENCE SUMMARY:

• 10+ years of experience as an Oracle database and EBS administrator, providing 24X7 production and development support for 11g/10g/9i databases on various platforms, which include HP - UX, SUN SOLARIS, Windows and Linux.
• Expert in Administration of Oracle Applications E-Business Suite (11i, R12.1 and R12.2).
• Worked on Data Guard setup along with Data guard Broker
• Experience in E-biz Database upgrade from 10.2.0.4 to 11.1.0.7 and 11.2.0.2/11.2.0.3.
• Expertise monitoring the production databases using the OEM and toad.
• Expertise the start and stop scripts for block out database in OEM.
• Expertise the AWR and ASH reports from OEM and oracle level.
• Experience on understanding the performance issues like database side and application side.
• Setting up Standby Database/Data Guard to protect against failures. Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.
• Recovery of database in case of database crash, disk/media failure, etc.
• Proactive monitoring and performance tuning of production databases using Oracle Enterprise Manager (OEM) and scripts.
• Expertise in performance tuning of large databases and SQL/PLSQL programs.
• Installed and configured of Oracle 10g Application Server.
• Worked as a team member to provide 24x7 on-call production database support.
• Platform Migration from Solaris to AIX.
• Monitor and optimize the database performance.
• Allocate system storage and plan for future storage requirements for the database system.
• Implementation of Shared Application Tier file system.
• Implemented Golden Gate to replicate tables daily for reporting purpose
• Reduced hardware cost by implementing external webtier without investing in physical external webtier . Configured “Reverse proxy with external Webtier” for such customers.
• Worked on Noetix Installation (6.0.1) and Implemented the Security with Noetix Admin.
• Expert in Administration of Oracle Applications E-Business Suite (11i & R12).
• Worked on Cross Platform Migration Project from Solaris to IBM AIX.
• Implemented DMZ with iSupplier Portal.
• Extensive Experience on Oracle Minimum Base Line patching activity and upgraded Database from 9i to 10g, upgraded 10 production instances to get extended support from oracle.
• Implementation experience on ASCP (Advance Supply Chain Planning) and Demantra.
• Worked on PCP (Parallel Concurrent Processing) configuration.
• Hands-on Experience in Noetix Views installation, upgrade and support activities.
• Worked with Functional team for implementing Role Based User Access.
• Created Daily/Monthly Health check reports from OEM.
• Configured MWA with two dispatchers and scheduled MWA bounce twice a daily.
• Cloning from Standby Database.
• Reduced Patch downtime using Staged Appltop.
• Configured Active Dataguard for reporting purpose.
• Configured UPK.
• Implemented SSL
• Implemented several concurrent programs to automate tkprof generation,jspfile compile, form generation, Bulk user creation, WA bounce,Compile Custom.pll, Assign Responsibility automatically.
• Integrated Mercury Object Migrator with EBS instance to migrate AOl’s.
• Created Custom User defined metrics in OEM to monitor Planning/Cost/Interface Managers & MWA status etc.
• Automated Clone of ebs instance daily.
• Experience in Demantra And SSO integration with ASCP setup.
• Experience in setting up iStore and iSupplier in DMZ.
• Implemented SSO between ASCP 11i Instance and Demantra application for easy way of logging into both applications.

SKILL SET:

Database Administration: Oracle Installation, Upgrade and Troubleshooting.

Applications: Oracle Applications 11i (11.5.10, 11.5.10 CU2),R12 System Administration, Installation, Patching, cloning, DB refresh, DB Upgrade and Applications Upgrade.

Oracle Utilities and tools: Expdp/Impdp, OAM, Oracle Enterprise Manager, Noetix Appworx, DMU and CCSCAN.

Operating Systems: Solaris, IBM AIX and RedHat Linux

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

Sr DBA Consultant

Environment: Prod, UAT, Test, Dev

Responsibilities:

• Working as L3 level support in Production environment and maintain the shift lead our team.
• Good understand the performance issues and database slowness issues.
• Managing 90 databases and 25 Oracle Applications (R11i, R12.1.3, and R12.2.4).
• Coordinating the offshore and onsite
• Migrating the existing Oracle Application 11i to R12.1.3 new servers.
• OEM implementation and monitoring.
• Good knowledge on exports and imports and schema level and database level using data pump.
• Knowledge on connecting between the databases using DB links using public and private DB links.
• Supporting the finance related databases as part of Hyperion databases and month end activates.
• Supporting the Vertex application.
• Supporting the decommission databases
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary
• Handling Escalations, Sev1 Cases and other Critical cases.
• Upgrade the databases from 11i to R12
• RMAN Backup and cloning Database using RMAN Active Duplicate
• Implemented SOX guidelines from technical perspective and followed change management to deploy codes.
• Setting up profiles for users.
• Gather stats using DBMS stats and FND stats to improve performance.
• Tracing Concurrent requests, forms, and database session.
• DB Refreshes(Created Shell script and automated)
• Providing support (24*7) and troubleshooting user (remedy) tickets.
• Acts as Escalation Point for Database issues and Conduct Root-Cause Analysis.

Confidential, Austin, TX

DBA

Environment: Prod, UAT, Test, Dev, ASCP instance and 10g Discoverer

Responsibilities:

• Provide Technical Help to DBA’s, wherever necessary, for the execution of work.
• Perform reviews, analyze defects and take appropriate measures for their elimination prior to submission to Client
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary
• Cloning of Oracle application environment using rapid cloning.
• Configured AUTOCONFIG for handling customizations and Security issues.
• Highly experienced in Investigating performance issues for Oracle Applications(Concurrent Program/Reports)
• Implemented SOX guidelines from technical perspective and followed change management to deploy codes.
• Database Refresh/clone doing complete/incomplete recovery using cold and hot backups.
• Upgraded some of our databases from 11gR1 to 11gR2. Worked with Oracle support to resolve the bugs related to 11gR2.
• Attends Status meeting with Client on periodic basis for the Projects.
• Delivery Weekly status report of DBA team to Client.
• Handling Escalations, Sev1 Cases and other Critical cases.
• Acts as Escalation Point for Database issues and Conduct Root-Cause Analysis.

Confidential

DBA

Environment: Prod, UAT, Test and Dev

Responsibilities:

• Upgrade of Database from 10g to 11gr2
• Installation and configuration web cache 10G
• High availability DR BUILD CONFIGURATION
• Convert NON-ASM to ASM
• Configured oracle applications Release 11i with 11g RAC.
• Database DB refresh, Performance Tuning
• RMAN backups and restores, cold and hot backups to tapes and file system.
• PCP configuration.
• Application user creation / responsibilities assignment, applying maintenance pack, family pack and one-off patches.
• Highly experienced in Investigating performance issues for Oracle Applications(Concurrent Program/Reports)
• Experience in installation and using Oracle Enterprise Manager (OEM) 10g GRID for some of the maintenance tasks.
• Patching security vulnerabilities as part of every quarterly release.
• Interaction with Oracle Support Services to resolve mission critical issues.

Confidential

DBA

Environment: Prod, UAT and Dev

Responsibilities:

• Database Upgrade
• Database DB refresh (created Shell Scripting and automated)
• Experience in Oracle RDBMS software installations.
• Security CPU Patching, Performance Tuning
• Upgrade of Applications from 11i to R12
• Platform migration from Sun Solaris 5.8 to Oracle Enterprise Linux 5.2.
• Applied day light saving patches.
• Solve Locking issues at Database/ Apps level.
• Troubleshooting Workflow notifications issues.
• Interaction with Oracle Support Services to resolve mission critical issues.

Confidential

DBA

Environment: Dev and Prod

Platform: Linux

Responsibilities:

• Performing Daily Health check to ensure the proper functioning of the production database and the Application server, ad-hoc support.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Patching Quarterly released security vulnerabilities released by oracle support.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of multi-terabyte database issues.
• Installation of Oracle Application 11i
• Setup and configure Standby databases for high availability.
• Installation and using Oracle Enterprise Manager for some of the maintenance tasks.
• Using autoconfigure Oracle Applications, Implementing Change requests.
• Designed, documented, implemented and maintained all Disaster Recovery procedures
• Providing ad-hoc support to the development team, maintenance of the Database. Monitoring database growth and managing space.
• Oracle Application Maintenance.
• Helped performance teams by providing TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADD).M reports for database tuning.
• Backup and Recovery using RMAN, Oracle Database cloning/refresh and Troubleshooting Refresh related issues.