SUMMARY:

• Total 11+ Years of experience as Oracle Applications DBA and Oracle DBA on creating strategic solutions, Implementation, Rollout, Upgrade, Support, Service delivery projects on Managing Oracle Databases both on ERP and Non - ERP platforms.
• Installation, Configuration & Deployment of Oracle E- Business Suite 11i and R12.
• Installation and Configuration of Oracle 10g/ 11g databases on Solaris and Linux.
• Implemented Oracle Apps 11.5.10.2 with 3-node Oracle RAC & Data Guard.
• Experience in migration of Oracle 11g Databases from Solaris to Linux.
• Expertise in performing Database Upgrades.
• Experience in Patching with various utilities using AD patch, Database patching and Application patching.
• Experience in working on a 24X7 On-Call Schedule to support multiple Production Databases and applications.
• Oracle Applications System Administration security functions and AD Utilities.
• Expertise in Backup and Recovery using RMAN and troubleshooting backup related issues.
• Expertisre in Standby Databases, Data Guard configurations and trouble shooting and Replication using Golden Gate.
• Expertise in Cloning Oracle Database and Application with DB size of more than 35TB using Shadow Image technology.
• Implemented and configured Single Sign on (SSO) for Oracle R12 Application.
• Installation, Configuration and Maintenance of Oracle 10g RAC, 11g RAC, Oracle 11i and R12 applications.
• Experience in troubleshooting the long running Concurrent Requests to identify the root cause to fix the issue.
• Implementation, Troubleshooting forms server, report server, Discoverer server, Web Server and Maintenance of Concurrent managers and Parallel Concurrent Processing (PCP).
• Experience in troubleshooting Concurrent Manager issues and resolve them.
• In depth experience of identifying, analyzing and tuning SQLs during upgradation phases in ERP implementation cycles.
• SQL tuning based on identification from TKPROF, explain plan, RAW Trace file and Trace file with bind variables, AWR, ADDM reports.
• Led high-availability of a 4 node Oracle RAC database, 4 App-Tiers, and two disaster recovery sites.
• Experience in migrating 3 node Oracle RAC database to new servers.
• Experience with database performance and tuning techniques to enhance database optimization plans.
• Installing, configuring and maintaining Oracle Grid Control.
• Experience in Database Security and Auditing.
• Result oriented, self-motivated, team player, ability to work independently.
• Creative thinker and analytical problem-solver with demonstrated ability to manage projects from planning through execution/completion under the pressure of fast-paced, time-sensitive environments
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Operating Systems: HP-UX, Sun Solaris, Red Hat Linux.

RDBMS: Oracle8i, Oracle 9i, Oracle 10g, Oracle 11g, Oracle12c, SQL Server 2003

ERP: Oracle E-Business Suite 11.5.7, 11.5.8, 11.5.9 & 11.5.10.2, R12.

BI Tools: OBIEE, Informatica

Languages: SQL, PL/SQL, UNIX, Shell Scripting.

Tools: RMAN, OEM, OAM, SQL*PLUS, SQL*Loader, Kintana, Erwin, TOAD.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWRMiddleware: Oracle 9iAS, Oracle 10gAS.Weblogic

Other: Discoverer 10g, EMC, Confidential, VCS, Applimation

PROFESSIONAL EXPERIENCE:

Confidential . Richardson, TX

Sr. Oracle Apps DBA / Oracle DBA

RESPONSIBILITIES:

• 24x7 Oracle Production Database and Application Administration and maintenance.
• Installation, Maintenance and Administration of Oracle Applications 11i and R12.
• Expertise in Oracle applications 11i and R12 Rapid Installations and management.
• Worked on the project to upgrade Oracle application 11.5.10.2 to R 12.1.3 on Solaris Platform.
• Worked as a lead DBA to manage, assist, train and support our Off Shore DBA team and be available to assist them 24X7 as and when needed.
• Worked on a Huge Environment supporting More than 300 + database Instances.
• Worked on Solaris to Linux Migration for Aspen, JDA, EPL and other Databases and EBS Applications.
• Working on regular Saturday DBA weekend maintenance tasks for the database Applications R12 PROD, SOA, OTM, Mercury, DLC, YODA, OBIEE, WMS and other databases.
• Working on annual DR exercise for databases R12 PROD, EPL, SOA, OTM, Mercury, DLC, YODA.
• Worked on Cloning and Patching the ERP environments utilizing tools such as rapid clone, adadmin, adctrl and adpatch.
• Provide DBA support for Monthly and Quarterly Release activities and implement the SIS plan execution steps.
• Working on Stats import process to R12 PROD every month.
• Working on iPayment Setup and iPayment project upgrades periodically.
• Worked and implemented the JDK 1.7 Upgrade project in R12 PROD environment successfully after implementing in Development/Test instances.
• Work on Connect:Direct Configuration setup and troubleshoot the issues encountered.
• Worked and implemented the Voltage (Encryption) setup in ERP R12 Prod and Non-Prod databases.
• Actively implemented financial modules on an existing Oracle e-Business Supply Chain infrastructure.
• Built new Dataguard instances for YODA, LENS databases.
• Worked on syncing back the Confidential Dataguard instance which was more than 160 hours behind the Primary Database.
• Designed security framework and implemented SOX on all Supply Chain applications and databases.
• Implementing and Configuring Load balancer for Oracle apache and forms connections on R 12.1.3.
• Implemented a Disaster Recovery strategy for Oracle e-Business and OBIEE application to support infrastructure.
• Worked on setting up the Golden Gate Configuration for Revenue Requisition Project and for YODA Solaris to Linux migration.
• Worked on applying the PSU Patches and Application patches periodically to all the Databases and ERP Applications.
• Implemented security strategy using Oracle Identity Manager for assigning responsibilities to Application and DB users.
• Implemented the Single Sign On (SSO) for R12 using OAM/OID and perform the SSO post-clone steps in all the cloned/refreshed instances.
• Involved in Upgrading Databases from 9.2.0.4 to 9.2.0.8, 9.2.04 to 10g and 10.2.0.4 to 11g.
• Troubleshoot multiple Issues in Production related to Applications & Database on a daily basis.
• Cloning production database and applications for development, testing and Projects on a regular basis.
• Expert in Using AD Utilities.
• Good Knowledge of Basic Architecture of PPM and experience in Migrating Kintana package lines.
• Have a thorough Understanding of workflow setup steps.
• Involved in debugging PL/SQL programs for data processing and management.
• Involved in the maintenance and trouble shooting of RAC Databases and Enterprise Manager Grid Control.
• Worked on performance issues on Oracle 11g RAC (4 node) production database of size around 35TB.
• Wrote Shell scripts for Alerts for ORA- errors, backup and recovery, Performance Tuning, Unix Shell scripting to be controlled from Crontab.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Involved in Database design & Database Architecture.
• Implemented the Security Policy for Billing Data Centers of for AT&T Services, Inc.
• Refreshed Test / Stage / UAT databases from the production environment of size 35TB using Shadow image Technology and applying Archives logs to the cloned database thereafter.
• Setting Up new environments for our Telecom Billing projects at application and Database level.

Environment: Sun Solaris, Linux, Oracle 11g/10g/9i, Oracle 12c, Oracle Applications 11.5.8, 11.5.10.2, R12, Applimation, Kintana, Oracle Discoverer 10g.

Confidential - Sunnyvale, CA

Sr. Oracle Apps DBA/ Oracle DBA

RESPONSIBILITIES:

• Worked on moving 8 of the Sub Prod databases from Sunnyvale location to RTP location so far and working on the remaining ones as per the Sub Prod Migration schedule.
• Performed the numerous Post-Clone steps on all the RTP Sub Prod Instances and scheduled the needed Manual Requests/Request Sets.
• Worked on 10g databases.
• Worked on Modifying the Hot Backup Scripts and Scheduled Hot Backups to run successfully for all the RTP Sub Prod Instances.
• Create tablespaces, tables, and users for custom applications and maintained security.
• Written/Modified shell scripts to monitor as needed and maintain the Oracle database.
• Supporting the development and testing team during implementation of the Project and on all DBA related issues.
• Helped the Development team in quickly resolving the issues that they encountered during their testing.
• Identified the long running jobs on existing Sub Prod Instances and ran them in RTP Sub Prod Instances and made sure that Performance is good on the RTP Instances.
• Worked on Performance Testing of the RTP Sub Prod Instances.
• Analyzing the objects and gathering the statistics periodically for the effective query optimization.
• Performed all the Pre-requisite steps, Installed 10.2.0.1 Database and upgraded the software and database to 10.2.0.3 for SSO Installation on RTP STG Server duressodb01-stg.
• Installed MRCA and loaded MR using MRCA on RTP STG Server duressodb01-stg.
• Performed OID Installation on the db node of RTG STG Server (duressodb01-stg).
• Performed SSO Installation on both the Application nodes duressoapp01-stg and duressoapp02-stg.
• Worked with SA’s effectively in resolving the issues encountered during SSO Installation.
• Copied all the users from SAC STG OID to RTP STG OID.
• Worked on Applying the Jan 2011 CPU Patches for databases ANAPPI and XNAPPI initially and document the steps, so that those patches can be applied later to DNAPPI and then to PNAPPI.
• Worked on Applying the Jan 2011 CPU Patches for Discoverer.
• Worked on Discoverer Installation on RTP Sub Prod Instances.

Confidential . Plano, TX

Oracle Apps DBA/ Oracle DBA

RESPONSIBILITIES:

• 24x7 Oracle Production Database Administration.
• Worked on a Huge Environment supporting More than 200 + Instances.
• Supported Business User & Developers to customize some of Supply chain & Financial Modules.
• Involved in Upgrading Database from 9.2.0.4 to 9.2.0.8, 9.2.04 to 10g.
• Troubleshooting Issues in Production related to Applications & Database.
• Cloning production database and applications for development and testing.
• Expert in Using AD Utilities.
• Wrote Scripts to collect stats for Production & Reporting Instance.
• Troubleshoot and worked with Oracle support on issues related to Environments.
• Support user with Sysadmin Activities.
• Good Knowledge of Basic Architecture of PPM and experience in Migrating Kintana package lines.
• Basic troubleshooting for Kintana Migration and User management.
• Worked on Startup /Shut down Kintana, ERP services and Database when needed, Generated and Scheduled reports in Kintana.
• Have a thorough Understanding of basic workflow steps.
• Basic shell scripting to understand the Kintana log file error message code in case when it is required.
• Worked with developers on debugging and modifying code to write effective interfaces.
• Experience in implementing Hot, cold and RMAN backups and performance tuning of SQL statements.
• Re-writing SQL statements, creating/modifying indexes for slow running SQL statements in order to improve performance.
• Responsible for cloning, patching and standard maintenance activities of oracle databases and EBS applications.
• Identify performance bottleneck on high volume transaction systems. Analyze SQL statements by using explain plan and tkprof.
• Design/Reorganize database objects and design indexes to improve response of queries.
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Automated the process of analyzing tables every night.
• Evaluate and adjust Oracle database initialized parameters in init.ora file. Monitor and optimize database performance. Resolve all performance issues caused by historical Oracle architecture and application design.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration·
• Wrote SQL scripts to monitor tablespace and extent growth.

Environment: Sun Solaris, Oracle 11g/10g/9i, Oracle Applications 11.5.8, 11.5.10.2, Applimation, Kintana, Oracle Discoverer 10g

Confidential - McLean, VA

Oracle Database Administrator

RESPONSIBILITIES:

• Involved in 24x7 support for 800GB 2 Node production RAC database with on-call pager
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Installation of Oracle version 10g Release 2 64 Bit on Solaris 10 and HP-UX11.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Developed and Implemented Disaster Recovery (DR) Plan.
• Setup of Standby Database using Data guard for faster Disaster Recovery.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Upgradation and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Daily Health Check Up of the Database using statspack, AWR, ADDM.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Monitoring and Troubleshooting of Database Replication issues.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Scripts for Cold Backups.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Automated the process of analyzing tables every night.
• Evaluate and adjust Oracle database initialized parameters in init.ora file. Monitor and optimize database performance. Resolve all performance issues caused by historical Oracle architecture and application design.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration·
• Hands on experience in java database connectivity(JDBC) with oracle thin driver.
• Highly proficient in designing enterprise application with J2EE design patterns like singleton and session sacade.
• Expertise in J2EE technologies such as servlets and jsps.
• Scheduling jobs through Oracle Job Scheduler.
• SQL Tunings for Performance of Objects.
• Provide Solutions to the Problems Faced by end Users Or Programmers.
• OS level activities like space monitoring of Mount point.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
• Space Management which includes table space creation, adding new datafiles.