SUMMARY

• Certified Oracle Professional with Over 11 years of experience in Oracle Database 9i,10g,11g,12c RAC, E - Business Suite 11i,R12 Administration, Oracle Web Logic, Oracle Applications Server, Oracle Enterprise Manager Grid Control, SQL server. 8 Years of Experience in on-site off-shore model.
• Performed Oracle Application 11i/12 & RDBMS 9i/10 g/11g/12c installation, upgrade, cloning & patching, OEM, Data guard on various platforms. Experienced in providing 24*7 production system DBA support in an on-call fashion. Experienced in working on various UNIX platforms and Real Application Cluster. Experienced in upgrade of the RDBMS and Oracle Applications 11i, R12.
• Experienced in adding Application Middle Tiers to the existing architecture. Experienced in creating custom top and performing customizations of Oracle Applications as per customer specific requirement. Experience in HA (High Availability) & DR (Disaster Recovery) Management Monitoring large scale databases and its instances using multiple tools like OEM, OSwatcher,Crons. Troubleshooting various critical issues to make sure them got fixed.
• Working with Oracle support on bug fixes until issue resolve. Working on user/database/instance performance issues on various kinds. Analysing and fixing the db and application performance issues.
• Keen understanding of the Database Architecture. Expertise in Oracle apps one-off patches, mini packs, family packs and CU2 application. Worked as a Functional DBA for ORACLE Advanced Planning and Scheduling & Value Chain Planning (MRP 11i/R12 ) & DEMAND planning
• Performed various Oracle Application system administration activities including setup of users/responsibilities, Printer, Custom Application setup, Concurrent managers, defining profile options, recompiling flexi fields, and manual jserv load balancing.
• Performed Database backup & Recovery using rman/hot backup, cold backup. Cloning using Rapid Clone and by using multiple automated scripts. Parallel Concurrent Processing and troubleshooting.
• Front-end activities including creating Conc. Programs, executables, value sets, request sets, Conc. Manager Administration, user management, responsibilities etc. Conducting internal brown bag sessions, preparing technical knowledge documents and participating in technical discussions, email communications.
• Flexible and adaptable to new technologies and challenges, thrive on solving the most complex issues to deliver the Customer the right result. Efficient Team Player, hardworking, good in analytical and logical problem solving abilities with excellent communication skills.
• Closely working with data warehouse team on various activities. Worked on demantra environments. Working on weblogic. Knowledge in Exadata machine, Working knowledge on hyperion environments
• Knowledge in Service Oriented Architecture and Oracle suite of Fusion (OSB/SOA), Knowledge on SSO, Knowledge on OID, Knowledge of Golden Gate Director, Monitor
• Working knowledge on with Oracle Managed cloud services and Oracle On Demand. Knowledge on latest application release on version R12.2.4 and DB-12c.

TECHNICAL SKILLS

Primary Skills: Oracle e-Business suite 11.5.X, R12.1.X & R12.2.X, Oracle 9i/10g/11gR1,R2 DB on RAC + 10g AS, Fusion Applications 11.1.8,SQL server, Golden gate

Tools: /Utilities: RMAN, OEM 10g,12c, TOAD, VPN, Secure CRT, PUTTY, VNC VIEWER, WINSCP3, SSH,SQL loader

Languages: SQL, PL/SQL,C

Database: Oracle 9i, 10g, 11g, 12c in RAC, SQL server, IBM DB2,Exadata

Operating Systems: Sun Solaris, RHEL Linux 3.0/4.0, AIX, Win NT/2000/XP

Web / Application Server: Web logic, OAS, 9iAS, Apache, Forms Server, Report Server

PROFESSIONAL EXPERIENCE

Confidential, Leawood, KS

Principal Oracle Apps DBA Consultant

Responsibilities:

• Critical production and non-production support in RAC. Working on E-Business suite upgradation from R12.1.3 to R12.2.3
• As part of the upgrade plan working on latest release 12.2 and 12c. E-Business Suites cloning from RAC to RAC and RAC to non-RAC instances with ASM using BCV snap and RMAN duplication depends of storage support.
• Database and Applications cloning and production instances from ASM to NON-ASM file systems. Setting PCP, Fail over for concurrent manager in RAC R12
• Supporting and coordinating with unix team on quarterly cpu patches. Standardize customization in proper way and fixed shell scripts and custom program for RAC
• User and developers support as when required. Re-organizing tables and indexes as part of maintenance activity to reduce fragmentation.
• Maintain and applying patches in shared appltop environments including dmz set-up and maintenance. Handling alerts from EM and crons. RMAN backup and Monitoring Implementation
• Configuring workflow. Applied critical grid, oracle home patches and payroll patches like hrglobal and data installer to keep them up to date. Troubleshooting the performance issues and preparing RCA reports. Monitoring business critical large RAC databases and working on performance issues.
• Troubleshooting critical/non critical issues in daily basis. Upload and apply Vertex Quantum data update patches and keep them up to date.

Environment: Oracle Applications R12.1.3, 11gr2 3 Node RAC on ASM, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES5.

Confidential, Miramar, FL

Principal Oracle Apps DBA Consultant

Responsibilities:

• Maintaining production and non-production databases resides on 11g and R12.
• Solitarily upgraded the database from 11.1.0.7 to 11.2.0.4 until go live.
• Installed and configured the golden gate.
• Cloning the database and applications.
• Implemented new instances for critical business use.
• Provided go-live support for upgraded oracle database with applications.
• Re-organizing tables and indexes as part of maintenance activity to reduce fragmentation.
• Build new instances for development user testing.
• Installed 12c OEM and deployed agents and targets.
• Experience in replication using golden gate, materialized views.
• Replication and Extracting data and applying on production using Golden Gate.
• Utilize SQL Developer and toad for develop management and performance matrix reports.

Environment: Oracle Applications R12.1.3, 11g, SQL Developer, Toad, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES5.

Confidential, Boca Raton, FL

Principal Consultant

Responsibilities:

• Part of the migration team and migrated current production instances from linux to sun solaries.
• Cloning the instances and creating replica of production to user for developing.
• Applied critical CPU bundle patches to system up to date.
• Performed table re-organization and gained space in critical database.
• Performing code promotions and helping developers to complete their setup.
• Preparing pre patch analysis and applying CPU patches to maintenance instances up to date.
• Installed weblogic server and configured discoverer server on it.
• Maintain demantra Instances and agile applications on windows.
• Implemented oracle discoverer 11g in production, test and training environments and integrated.
• Collaborate with other team members for Escalation Management and EBS Performance issues.

Environment: Oracle Applications R12.1.3, 11g, ASCP, Demantra, Agile, Weblogic, SQL Developer, Toad, RMAN, Sun Solaris.

Confidential, Summit, NJ

Project Lead Consultant

Responsibilities:

• The above project includes the 24*7 implementation support for Confidential Corporation. It in turn includes all the change, release and incident Management activities. Monitoring the table spaces, file system and miscellaneous alerts from alert log, OEM metrics.
• Trouble shooting the client and server side issues via ticketing services. Effective participation in crisis calls, escalation calls and technical calls to resolve any issues related to Applications Database. Extensive database and RAC patches application.
• Interacting and working effectively with product support to escalate the TAR and troubleshooting the issues. Supported GRC, ACG, CCG databases.
• Acted as Offshore lead for the contractors and provided several technical trainings and created high volume of technical knowledge documents.
• Familiar in using Change management control tool like quest stat. Received appreciations on various occasions in handling the user issues, working out maximum number of user tickets and proactively solving the issues and working RCA.

Confidential

Oracle Applications DBA

Responsibilities:

• Refresh the Development databases with Production data as per the customer’s requests. Monitor the health of the database servers on various parameters and resolve the issues as and when they arise as per their criticality.
• To meet the specified SLA s for the database servers maintenance tasks. To meet the increasing no of customers and the workload, identify the regular maintenance tasks automate them as and when feasible.
• To ensure the key deliverables are met and ensure to contribute to the peers knowledge base and share the key learning’s through trainings and presentations across the sites.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions. Supported SAP applications on Oracle Database

Environment: Oracle Applications 11.5.x, R12.1.3 RHEL 3.x

Confidential

Oracle Applications DBA

Responsibilities:

• Actively taken initiative in planning the Migration with the Client. Involved in migrating any 11i applications to 11.5.10.2, 9.2.0.6 Oracle Applications on single node and multi.
• Performed Export and Import activities with using DMA tool (or) Traditional Method. Applied Maintenance Packs, Database related Patches and Critical CPU patches.
• Configured Workflow, DMZ, Discoverer. Provide more details what have u configured & by configuring what has been achieved. Spliced some of non-installed products.
• Ensure user’s maintenance is as per the organization standards and security policies are complied with.
• Checking and compiling invalid objects, clearing cache and bouncing the Apache.
• Administrating and responding to Oracle TAR’s. Trouble shooting various issues during day-to-day activities. Administering and maintaining 3 databases (Production, Test and Development)
• Trouble shooting Concurrent Managers and services, performed clean ups. Actively take part in key development road maps for the next generation product design’s implementations at the database level. To maintain the specified SLA s for the database servers maintenance.
• Develop test and implement the up-gradation plans as per the schedule for the new product releases with minimum down time. To ensure the key deliverables are met and ensure to contribute to the peers knowledge base and share the key learning’s through trainings and presentations across the sites.

Environment: Oracle Applications 11.5.x, RHEL 3.x

Confidential

Oracle DBA

Responsibilities:

• The above Project included the fresh implementation of the basic required products. This project involved setup and testing of the instance. Cloning of the Oracle Application System for the testing purpose using the Rapidclone. Pre-patch analysis, patching, Configuration changes to the file system and cloning for the future requirements.
• Tablespace management, user management and concurrent processing management. Checking the concurrent processing manager status and verifying its frequency of refreshment through Dashboard. Backup and recovery planning as per the customer requirements. Prepared the documentation of the changes made for future analysis.

Environment: Oracle Applications 11.5.9, Oracle 9.2.0.3, RHEL 3.0

Confidential

Oracle DBA

Responsibilities:

• Administration of Oracle 9i database including installation, creation and monitoring Database. Allocating system storage and planning future storage requirements for the database system. Planning the backup and recovery of database and maintaining.
• Troubleshooting various issues during installation and day-to-day activities. Experienced in Patchset and RDBMS patch application. Creating new users, assigning roles and profiles as per customer specifications. Managing the space issues and performance of the instance from time to time.
• Upgrade of database from 9i to 10g by following Upgrade Guide for 10g Release1.Followed the Patchset application document strictly. Created Technical notes and documentation. Interacting with product support and follow up for any outstanding issues.

Environment: Oracle 9i, Red-Hat Enterprise Linux 3.0