SUMMARY:

• Have around 10 years of experience in core DBA / Oracle Apps DBA & Oracle fusion middleware DBA.
• Designed, Implemented and Configured the complex ERP architecture with two Node RAC, Shared APPL TOP, PCP.
• Proven expertise in communicating across organizational levels and with cross - functional teams to drive shared vision and foster culture of excellence.
• Extensive experience in Oracle Apps DBA Activities like RDBMS and Apps patching, maintenance through AD tool, ADOP utilities, resolving ERP issue like concurrent manager, AD utilities and workflow configuration, profile and custom module deployment and installation, cloning, software releases and database tuning. Administrative and monitoring activities on RAC.
• Expertise in RMAN for recovery and cloning
• Extensive experience with Installation, Maintenance, Monitoring, Troubleshooting, Performance tuning, Cloning & Patching of Oracle Applications & Databases.
• Oracle Database upgrade from 11.1.0.7 to 11.2.0.3 and 11.2.0.3 to 12.1.0.2
• Perform Troubleshooting on Oracle Application, Hyperion Planning, Essbase, OID and OAM issues.
• Application node addition and deletion in 12.2.5 and integrate Access gate with EBS 12.2.5.
• Knowledge on OBIEE, WebLogic, Informatica and DAC Administration.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 10, Windows 2000 Server Family

Languages: SQL, PL / SQL, Ant,WLST

Database Tools: Toad, DBA, Golden 32 OEM Grid, SQL developer

RDBMS: Oracle 9i,10g,11g,12c

Other Technologies: RAC,ASM,WebLogic, OID/SSO, OAM, OEM,Informatica,DAC

ERP: Oracle Applications 11i,R12(12.1.3, 12.2.3, 12.2.5)

Middleware: SOA11g,OBIEE 11g,12c

PROFESSIONAL EXPERIENCE:

Application Architect

Confidential

Tools: Oracle 11g release 2 Database, Oracle 12c database, Putty, Oracle ERP, Oracle OBIEE, Informatica, DAC, Oracle apps R12.1.3, OID, OAM, RAC, SOA, Hyperion, Essbase, Service Now

Responsibilities:

• Created team strategies and establish project scopes of work; communicate project deliverable timeframes and benchmarks to clients.
• Production support the oracle Application R12 instance, including the boundary applications like WebLogic, OBIEE, Hyperion product, informatica, SOA, DAC.
• Good Experience in Database performance Tuning using (Statspack, AWR, ADDM, tkprof)
• Day to Day troubleshooting of the environment which include fixing all issues coming in them and supporting the various component of oracle Application Form, Apache, Concurrent manager, DB, OBIEE, Informatica component, DAC and Hyperion product
• Troubleshooting problems with All Oracle applications, Database, OBIEE, OID and OAM 11g.
• Maintaining Oracle Application File System and Database using AD Utilities like adadmin, adctrl, adpatch, admgrpch, ad relink, adident, adsplice.
• Apply the Patches using AD Patch Utility and adop utility on Application File System and Technology Stack.
• Performed database cloning using RMAN backups and third-party backups.
• Recover databases and clone applications Using RMAN.
• Installation and Administration of Oracle WebLogic 11g, and 12c
• JDBC Connection Pool and Multiple pool configurations with Oracle, MySql, DB2 and MS SQL Server, etc.
• JMS Configurations- JMS Server, Connection Factory, Foreign JMS server, Message Bridge, Topic/Queue, Distributed destinations
• Creating security roles, group policy, user authentication, auditing and authorization
• Sizing and Tuning JVM Heaps for OC4J and WebLogic
• Sizing the Database connection pools and tuning the database
• Troubleshooting problems with Essbase and Hyperion Planning.
• Taking daily backups for Essbase and Hyperion Planning servers.
• Involved in developing a disaster recovery (DR) plan.

Oracle DBA and WebLogic Administrator

Confidential, TX

Tools: Oracle 11g release2 Database, Oracle Database 12.0.2, Oracle WebLogic 11g Remedy Tool(ITSM), TOAD, Putty

Responsibilities:

• Sound knowledge of both database and program code performance tuning.
• Installation and Administration of Oracle WebLogic 11g, and 12c
• Creating security roles, group policy, user authentication, auditing and authorization
• Sizing and Tuning JVM Heaps for OC4J and WebLogic
• Sizing the Database connection pools and tuning the database
• Having Experience on EXPDP/IMPDP, SQLLDR and refresh activity based on requirement
• Capable of performing database change management, performance tuning, and most of the other roles of the DBA.
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches etc..
• Provided technical assistance for trending analysis to achieve capacity and performance planning initiatives.
• Monitored databases using 10g OEM grid control and Developing UNIX and SQL scripts for the smooth functioning of database and application related issues.
• Successfully implemented 3-node RAC setup and made the environment stable..
• Troubleshooting, Load Balancing, Clustering, Deploying Applications, Performance Tuning and Maintenance. Create, configure and tune WebLogic domains/applications for performance.
• Work with vendors and developers for application related issues
• WebLogic Administration, Monitoring and Troubleshooting using Admin Console
• Cluster Configuration - Single Cluster, Multiple Clusters and Deployment over clusters.
• JMS Configurations - JMS Server, Connection Factory, Foreign JMS server, Message Bridge, Topic/Queue, Distributed destinations
• Tuning JVM heap size to maximize the number of clients accessing the applications.
• WebLogic Administration, Monitoring and Troubleshooting using Admin Console.
• Managing and Monitoring the JVM Performance by adjusting WebLogic heap size and garbage collection parameters
• Deploying different applications like WAR files, EJB jars files and enterprise application archives (EAR) on WebLogic using various deployment tools (Console and WLST tool)

Oracle Apps and Fusion Middleware DBA

Confidential

Tools: Oracle Applications 11.5.10, Oracle 11g release 2 Database, Putty, Remedy Tool(ITSM), Fusion Middleware (SOA 11g)

Responsibilities:

• Multi node Oracle application with Load balancer and SHARED APPL TOP technology.
• Cloning of development and Test instances from production in RAC environment.
• Applying patches requested for DEV and PROD instances.
• Setting/writing of Monitoring/cronjob for automated alerts for monitoring instance
• Worked on implementing RFC’s.
• Supporting day-today maintenance activities like startup/shutdown, changing passwords of USERS, compilation of forms, adadmin and working on various Oracle application related issues.
• Logging TAR and coordination with oracle support for bugs and patches.
• Capacity Planning/Management (space/machine load/network).
• Supporting Oracle applications 11i (24*7) whose size is more than 4 TB.
• Application system administration - user accounts, user passwords, responsibilities, setting profiles.
• Oracle Application patches installation.
• Application and concurrent manager troubleshooting and Moved the objects from one instance to other using FNDLOAD
• Hot and Cold Backup and Recovery of the database under media and instance crash
• Database and APPL TOP refreshes of Test and Development environments
• Troubleshooting various Application user issues.
• Starting, shutdown and monitoring of Oracle Web Server, form servers, concurrent managers.
• Database restoration and testing.
• Index rebuilding and re-org of tables for defragmentation.
• Preparation of various audit reports to the SOX audit team
• Cloning and Refresh Applications and the database.
• Resolved various Problems that occurred while re-linking the application executables
• Generating report files Troubleshoot and resolved issues related to various user login issues, requests related to code migrations, concurrent manager issues, sysadmin jobs, instance performance issues and different components of Oracle EBS technology stack.

Oracle Apps and Fusion Middleware DBA

Confidential

Tools:: Oracle Applications R12, Oracle 11g release 2 Database, Putty, Remedy Tool(ITSM), Fusion Middleware (SOA 11g),3 Node RAC, ASM

Responsibilities:

• Installation and configuration of Oracle applications 11i, R12 on AIX.
• Maintaining Oracle Application File System and Database using AD Utilities Like adadmin, adctrl, adpatch etc.
• Applying patches to resolve bugs or to get new functional changes in Oracle Application.
• Cloning Oracle Applications multiple nodes to multiple node and single node including RAC instances and simulate technical challenges, coordinate with development and Functional teams.
• Experience in Rapid cloning of database and application.
• Involved in activities like creating users and responsibilities, Assigning responsibilities to the users.
• Managing Concurrent Process, Concurrent Programs/Managers, Registering New Concurrent Programs, Concurrent Types, Defining Work Shifts, and Specialization Rules and Combined Specialization rules, Defining New Concurrent Managers.
• Monitoring alerts for all ERP systems using OEM Grid Control.
• Regular code moves following customer’s internal ticketing system.Monitoring and diagnosing database performance through monitoring of alerts.
• Reorganization of the Database using export import.
• Monitored the Applications and Database using OEM and OAM
• Setting up of printers in the Apps.
• Installation of new Oracle R12 Application (12.1.1) on TEST server for Functional teams
• Helping users in case of any connectivity issues while using apps.
• Troubleshooting the SOA related Issues
• Involved in Deployment process in Fusion middleware.
• Working on Oracle Service Requests for Application, database and patch related issues towards resolving the same
• Patch Impact Analysis and Review, Code Migration, Code Promotions and Code Review
• Involve in OBIEE 11g instance administration and maintenance.
• Experience in Informatica and DAC administration and maintenance.

Oracle Application DBA

Confidential

Tools: Oracle Applications 11i (E-Business Suite 11i), Oracle 11g databases, PL/SQL Developer, TOAD, Putty, VNC, BMC Tracker

Responsibilities:

• Develop automated RMAN scripts for both backups and cloning of Oracle Databases.
• Implemented parallel concurrent processing in R12.
• Cloning DEV and UAT instances from Production for testing. Registered printer in Applications, custom printer drivers and custom print styles in Oracle Applications
• Used TOAD, ADDM, AWR, ORADEBUG, TKPROF, EXPLAIN PLAN and STATSPACK.
• Upgrade Oracle Applications R12.1.1 to 12.1.3 and EBS Database from 11.1.0.7 to 12.1.0.4
• Created the database and configured it according the requirement.
• Performance Tuning and Optimization of queries for development team.
• Deciding the Backup and Recovery strategy for the System, End User Support.
• Daily Alert Monitoring, Performance Tuning and Optimization of queries for better performance
• Developed Data Loading Scripts designed the database structures for the custom module Performed the maintenance of Database and Production support.
• Space Management Activity on quarterly basis, Backup & Recovery Audits of databases