Summary

• 9 years of work experience as oracle Applications DBA with expertise on Oracle Applications 11i, R12 and Databases 9i, 10g/11gRAC.
• Extensive experience in the areas of installation, configuration, implementation, patching, cloning, up gradation, troubleshooting and support of Oracle 11i R12 instances on major Operating Systems.
• Hands on experience in Application patching using ADPATCH on Single node, Multinode, Shared APPL TOP.
• Oracle EBS 11i/R12 Oracle Applications DBA Financials/Supply Chain/HRMS/CRM/Property Module with RAC and stand-alone Instance
• Managing database performance using AWR, ADDM, ASH, TKPROF, SQL Trace Configuration of Oracle 10gR2/11gR1/11gR2 OEM Grid control to monitor database.
• Two-upgrade Projects Experience from 11.5.9 to R12.1.3and 11.5.10.1 to 11.5.10.2 point upgrade.
• Experience on different kinds of EBS Application cloning using Rapid Clone which includes Multi Node to Single Node, Multi Node to Multi Node and Single Node to Multi Node.
• Experience in Installation of 11g Fusion Middleware components including installing/maintain, configuration, backup, patching of the Web logic Server and its components.
• Extensive experience in day-to-day administration capacities of Oracle Applications R12/11i instances.
• Strength includes strong analytical and problem solving skills and a very good team player.
• Performed Discoverer, ATG RUP 7, Module level I-Procurement, Purchasing Project Costing and Sun Java Upgrade to the Latest version on PRODUCTION.
• Being the face of the DBA service to the customer in terms of chalking out a plan for the major projects like Upgrades, Full Life Cycle Implementation Projects, etc., till the project goes LIVE.
• Handling Oracle Apps Performance related issues like Oracle 11i Slowness, High memory Consumption, High CPU Utilization, High TEMP usage Long Running Concurrent Requests.
• Providing on call DBA Support for Oracle's e-Business Studio Hosted environments to ensure 24x7 DBA support.
• Installation of RAC and Managing RAC Environment efficiently
• Installing configuring Oracle cluster ware Database Software Troubleshooting using cluvfy handling common issues that arise during integration of the whole bugs, network issues, configuration files issues
• Extensive expert in Installation and Configuration of OBIEE Applications using weblogic server 11g
• Good knowledge on Fusion Middleware technologies like Weblogic server, Oracle Discoverer Implementation and integration with EBS Database and Business Process Execution Language

Software

• Operating Systems : Window NT, AIX UNIX, Sun Solaris, HP UNIX Linux.
• RDBMS : Oracle 11g/10g/9i.
• Languages : SQL, PL/SQL, UNIX Shell Scripting.
• Tools/IDEs : Control-M, OEM, OAM Toad, Kintana, Remedy, WinSCP, SQL
• ERP : Oracle Applications 11i R12.1.3/R12.2.2
• Web Servers : Oracle Web logic Server

Experience:

Confidential

Oracle Apps DBA

Project description:

VMware ERP Systems are running on RHEL 5.6 with Multinode Oracle Applications 11i 11.5.10.2 and 5 node 11gR2 RAC Database with Load Balancer, PCP enabled and Integrated Fusion Middleware Components like OAM,SOA,BPEL and Portal accessed all over the world.

Confidential

Responsibilities

• Administration and support of EBS on Oracle 11GR2 5 Node RAC and 8 node application tier on Linux.
• Deployed Oracle technologies e.g. Active Data Guard, ASM, OEM/Grid, RMAN in mission critical highly available production environments.
• Supporting production database environment space projection and reclamation, SQL performance tuning of existing applications.
• Cloned various 11i instances from RAC to RAC and RAC to Non RAC TEST, UAT, DEV, STAGE, LT .
• Experience implementing and deploying Oracle Enterprise Management OEM grid control.
• Experience implementing and deploying SSL and GRC.
• Database Upgrades and Migration from Lower version to High Version at VMware
• R12 VISION Installation for demo purpose
• Providing On call Support for Prod and Non-Prod Issues
• Upgraded EBS 11i Database from 10g to 11gR2 and converted from Non- RAC to RAC Environment

Environment

Oracle Applications 11.510.2 on Linux RHEL 5.6 with 11g R2 11.2.0.3 RAC Database configured with ASM

Confidential

Oracle Apps DBA

Project description:

Confidential systems are running on RHEL 5.9 with Multi node Oracle Application R12 12.1.3 environment accessed by many users of the E Y Company all over the world. There are OGRC, OACCG and TCG Production Instances have been integrated into different Instances with Oracle 11gR1, Oracle10gAS Application.

Confidential

Responsibilities

• Installed R12.1.1 EBS on RHEL Server release 5.9 Tikanga on Multi Node with 2 Node 11.1.0.7 RAC with ASM
• Upgraded R12.1.1 Applications to R12.1.3
• Installed R12.2.2 on Training server to explain EBS Fusion roadmap to Client
• Supporting and Administrating both R12.1.3 and R12.2.2 environments
• Installed and maintained OBIEE 11.1.1.5.0 RCU 11.1.1.5,Weblogic 10.3.5
• Startup and shutdown of OBIEE Application services and backup
• Implemented PCP for the Concurrent manager Node
• Preparing existing R12.1.3 environment for R12.2.3 Upgrade for UAT as well as Database upgrade from 11.1.0.7 to 11.2.0.3.
• Oracle Fusion Administration Exp which includes weblogic server, OBIEE Administration
• Working on weekend maintenance Activities that involve service bounce, Table space report gathering, clearing logs on middle tier and database. Also involves other planned maintenance and unplanned issues handling
• Performing daily checks and health checks on Apps instances.
• Code Migration from Dev to prod instance using Lotus Notes
• SSL Implementation for EBS Applications
• SSO Implementation for the EBS R12 Applications
• Monitoring EBS Applications through Oracle Application Manager
• Configured workflow Notification Mailer for R121.3 Applications
• Configured Cisco http Load balancer for EBS R12 Applications
• Addressing Apps performance issues like Oracle R12 Slowness, Long running Concurrent Programs.
• User Creation and assigning responsibilities to the users based on the request from Application Team.
• Escalation point for Level 2 Operations and Application Technical Support
• Clone, Patch, Autoconfig, Node movement etc. Apps administrative tasks
• Performance tuning of database and SQL to improve application performance
• Responsible for Backup and recovery of Production Database and Applications
• Created custom top, Custom EBS menus and Personalization's
• Responsible for code migration using stat change management solutions for Live Production Instance
• Enabling and Disabling profile options to troubleshoot the Issues related to EBS Applications
• 24 x 7 problem troubleshooting and support to R12 and GRC,OACCG and TCG application environment - manage Remedy tickets and Oracle SRs
• Collect more detailed information on problems for analysis
• Currently helping team to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.
• Configured Implemented RMAN hot / archive log backups for Oracle Applications / Core PRODUCTION servers on tape Disk.
• Configured Physical standby database with the Data guard technology
• Collect better metrics on frequency and duration of problems
• Document current state of EBS monitoring, understand existing tools, etc.
• Trouble shooting performance issues related to system application performance
• Implemented scripts for space, database and concurrent managers alerts.
• Implemented SSL for EBS R12 Applications and troubleshooting end user SSL login Issues.
• Responsible for setting and managing user accounts, defining grants, setting up roles.
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN
• Well command on all AD utilities ex: ADADMIN, ADRELINK, Autoconfig etc.
• Supporting Technical team/ or development team in code migration
• Concurrent Managers administration and Troubleshooting CM related issues.
• Shell scripting for cron jobs some customization in already created scripts.
• Integrated GRC and OACCG with R12 Applications
• Cloning R12 EBS Applications from PROD to DEV,TEST and UAT Environments
• Monitored the production Oracle alert logs for database errors
• OEM Configured for the EBS 11g Database
• Installed Oracle Application Desktop Integrator on End Client Desktops
• Workflow Notification mailer Configuration for Inbound and Outbound Notifications
• Tuning SQL Queries for technical team

Environment

Oracle Applications R12.1.3 on Linux RHEL 5.9 with 11g R1 11.1.0.7 RAC Database configured with ASM

Confidential

Oracle Apps DBA

Project Description

Confidential Servers running on Solaris float form with Multi node Oracle Application 11.5.10.2 environment accessed by many users of the MASTERCARD Company all over the world.

Responsibilities

• Supporting EBS 11i production Applications including All Financial Modules like AP, AR,OIC,FA,GL etc
• Maintain the Multi-Node installation of Oracle ERP 11.5.10.2 with Database ASM Storage enabled
• Upgraded DB from 9.2.0.8 to 10.2.0.3 in 3 iterations and Applications from 11.5.10.1 to 11.5.10.2
• Installed Hyperion Financial Module and reporting tools on cent OS and Provided Hyperion Administration support for the Client
• Implemented ASM Storage for Database File system
• Escalation point for Level 2 Operations and Application Technical Support
• Clone, Patch, Autoconfig and Apps administrative tasks
• Support implement changes in technology E.g.: database upgrades/application upgrades
• Production application and database patching coordination between PROD, TEST,DEV Instances
• Develop standards, procedures and process documentation
• Addressing Apps performance issues like Oracle R12 Slowness, Long running Concurrent Programs.
• Create and maintain operational scripts
• Managing physical standby Database
• Supporting Technical team/ or development team in code migration
• Concurrent Managers administration and Troubleshooting CM related issues.
• Shell scripting for cron jobs some customization in already created scripts.
• SSL Implementation for EBS 11i Application systems.

Environment

Oracle ERP 11.5.10.2 DB 10.2.0.3 with ASM on Solaris platform

Confidential

Oracle Apps DBA

Project Description

Confidential provides the essential financial infrastructure for delivering effective investment servicing solutions globally. The investment research and trading arm of State Street, provides with access to specialized research, trading, securities lending and innovative portfolio strategies to help enhance and preserve the value of your portfolio. Providing Maintenance and DB Upgrade support for Confidential. They have Oracle Applications with Multi-node configuration running on v11.5.10.2 accessed by many users of the Client. An application has GL, AP, AR and FA modules have been integrated into one single Instance Powered by RHEL 4.3 Oracle Database 9.2.0.6.

Confidential

Responsibilities

• Supporting 8 production databases including All Financial Modules like AP, AR, FA, GL, BOM, Inventory, Order Management, XML Publisher etc
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN.
• Well command on all AD utilities ex: ADADMIN, ADRELINK, Autoconfig etc
• Reorganization Rebuild tables, indexes basing on Planed Outage work
• Supporting Technical/development team in code migration
• Upgraded successfully the Application Technology Products to latest base level by applying the ATG PF.H Rollup 4.
• Upgraded successfully Database from 9.2.0.6 to 10.2.0.3
• Monitoring the Alerts and taking action if required.
• Notifying sessions consuming High Temp usage / High Memory Consumption / High CPU Utilization to Application Team.
• Concurrent Managers administration and Troubleshooting CM related issues.
• Performing end to end patch analysis and patching the Oracle Apps servers using adpatch opatch.
• Shell scripting for cron jobs some customization in already created scripts.

Environment

Oracle ERP 11.5.10.2 DB 10.2.0.3 on RHEL 4.3

Confidential

Oracle Apps DBA

Confidential Equipment Service is our Client for which we are supporting all Production, Development, Test core databases. Apart from this we are also supporting the Oracle Application R12.1.1 Production and UAT instance. There are around 21 databases which we are supporting.

Responsibilities

• Supporting 21 databases including All Prod, Test, Dev, UAT having Financial Modules like AP, AR, GL, BOM, IProcurement, Iexpenses,VCP ASCP etc
• Installed R12.1.1 EBS on RHEL Server release 5.5 Tikanga with 3 node 11gR1 RAC with multi-languages US English Dutch
• Upgraded R12.1.1 Applications to R12.1.3
• Applied Oracle Value Chain Planning Release 12.1.3.6 patch including pre-requisite patches on EBS R12.1.3
• Demantra 7.3.1 Installation and Integration with EBS 12.1.3
• Providing DBA support to Demantra Technical and functional Users
• Provided Administration support while Import Integration Workflow from EBS/VCP using Stored Procedure
• Installing Oracle 10g,11g Database Software on Linux and Windows float forms
• Providing 24/7 Support for the remedy Ticketing system after Go live
• Create and maintain operational scripts
• Secure Socket Layer Implementation for Oracle E-Business Suite
• New FSG Report's Development based on User Requirement
• Implemented Data guard across physical locations as a DR solution
• Installing Latest Application Desktop Integrator Tool
• Responsible for setting and managing user accounts, defining grants, setting up roles
• Faster problem detection resulting in faster issue resolution automation
• Be able to provide user feedback as to cause/resolution of problems
• Document current state of EBS monitoring, understand existing tools, etc.
• Trouble shooting performance issues related to system application performance.
• Liaison with Oracle Service Request Support to resolve various application and database issues.
• Implemented scripts for space, database and concurrent managers, Period Opening alerts for GL,AR and AP Modules
• Performing Health checkups to the Oracle Applications Databases.
• OBIEE Installation with Web logic server
• Configured Implemented RMAN hot / archive log backups for Oracle Applications / Core PRODUCTION servers on tape Disk.
• Creation customer interface documents like AR, AP, Order Acknowledgment using BI publisher and designed layout templates using RTF templates

Environment

Oracle ERP R12.1.3/VCP DB 11.1.0.7 3-Node RAC on RHEL 5.5 and Demantra7.3.1 Installation Administration.

Offshore Projects

Confidential

Oracle Apps DBA

Responsibilities

• Upgraded Oracle apps database 9i 9.2.0.3 32bit to 10gr2 10.2.0.3 32 bit and moved the same from RHEL 2-32 bit box to RHE 4-32 bit box
• Upgraded Oracle applications from 11i to R12 11.5.9 to R12
• Merged Two node application service to single node application Node
• Upgraded Discoverer 4i to 10g
• Monitor archived logs generation, archived log disk partition, archived log backup and successful transfer / application of archive logs to standby / DR locations
• Giving trainings to new team members to kop-up to the project level.
• Interacting with client's business teams during new releases and other vital activities
• Publishing the shift schedules and tracking the resource tasks
• Performing Continuity of Business exercise by interacting with various teams at the client's site.
• Outage Management, Instance Management and Release coordination
• Developed Mobile Browser Application using Trinidad components of ADF Mobile framework with the help of Jdeveloper 11.1.1.3.
• developed Mobile Browser Application using Oracle ADF Mobile framework and Jdeveloper 11g tool
• Analyzing the concurrent request loads and defining new concurrent managers if required
• Resolving User issues related to E-Business suite
• Handling tickets raised by the users through various ticketing systems like Team Track, Virtual Tech and others
• Monitoring and administering standalone discoverer services
• Create and maintain operational scripts to improve productivity and capturing the exceptions
• Trouble shooting performance issues related to system application performance.
• Concurrent Managers administration and Troubleshooting CM related issues.

Environment

Oracle ERP R12.1.3 DB 11.1.0.7on RHEL 5.5

Confidential

Oracle Applications DBA

Project Description

Confidential is a leading global supply chain manager and processor of agricultural products and food ingredients. It consists of various modules like procurement, accounts payable, fixed assets, general ledger and project accounting and receivables.

Responsibilities

• Supporting 2 production databases including All Financial Modules like GL, AR, AK, Procurement, and Expanses.
• Upgraded Oracle DB from 10.2.0.3 to 10.2.0.4 on OEL
• Migrated EBS 11i Environment from Solaris to RHEL 4.5
• Upgraded EBS Applications from 11.5.10.2 to 12.0.4 on TEST Instance
• Backed up the databases through RMAN.
• SSO integration with EBS 11.5.10.2
• Oracle 10G Forms Reports server installation, support and maintenance
• Applying Database and Application Patches
• 24 x 7 problem troubleshooting and managing E Tracker Issue tickets and Oracle Service Requests
• Proven effective and efficient troubleshooting skills and methods
• Moved all custom programs and reports to production. This involved enforcing naming standards, maintaining the CUSTOM TOP, and setting up concurrent requests.
• Escalation point for Level 2 Operations and Application Technical Support
• Cloning, Autoconfig, etc. Apps administrative tasks
• Create custom concurrent requests to perform Database performance
• Creating Database Objects for Custom Applications
• Support implement changes in technology E.g.: database upgrades/application upgrades
• Production application and database patching coordination between PROD, TEST,DEV Instances
• Upgraded ERP Applications jinitiator to Sun Java JRE 1.6 Family

Environment:

Oracle ERP 11.5.10.2 DB 10.2.0.4 on RHEL 4.5

Confidential

Oracle Apps DBA

Project Description

Confidential is an end-to-end freight-forwarding company. Project Scope is Implementation of ERP 11i that Includes INV, GL, AP and AR modules for the Order Processing, Order Support, Distribution Maintenance, Warehouse, Finance and the Quick Response Centers in City Financial services. Involved in Implementation and Post Go-Live Support and Major enhancements and Upgrades.

Responsibilities

• Installed 11.5.10 EBS on RHEL Server release 3.5 with single node
• Providing 24/7 Support for the remedy Ticketing system after Go live
• Scheduled shell scripts for Table space used space, Hot backup scripts using crontab
• Handling various troubleshooting calls for critical production databases
• Disaster recovery
• Document current state of EBS monitoring, understand existing tools, etc.
• Trouble shooting performance issues related to system application performance.
• Liaison with Oracle TAR Support to resolve various application and database issues.
• Responsible for setting and managing user accounts, defining grants, setting up roles, enforcing row-level and column-level security.
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN.
• Well command on all AD utilities ex: ADADMIN, ADRELINK, Autoconfig etc
• Reorganization Rebuild tables, indexes basing on Planed Outage work
• Supporting Technical team/ or development team in code migration
• Concurrent Managers administration and Troubleshooting CM related issues.

Environment:

Oracle ERP 11.5.10.2 DB 9.2.0.6 on RHEL 3.5

Confidential

Oracle Apps DBA

Responsibilities

• Upgraded Oracle apps database 9i 32bit to 10gR1 64 bit and moved the same from RHEL 2-32 bit box to RHE3-32 bit box
• Upgraded Oracle E-Business suite from 11.5.10.1 to 11.5.10.2
• Merged Two node application service to single node
• Applied RDA Patches and BOM Patches
• Upgraded Discoverer From 4i to 10g
• Exported Objects from Standard EUL to Application EUL using Export/Import Utilities
• Installation Of Discover Administrator And Desktop on Windows 32 bit OS
• Assigned Business Areas and Workbooks to Application Users using Discoverer Administrator And Discoverer Desktop 10g
• Applied Extended Support Patches to maintain the 11.5.10.2 Applications under minimum base level versions
• Oracle 10G Forms Reports server installation, support and maintenance
• Applying Database and Application Patches

Environment

Oracle ERP 11.5.10.2 DB 10g on RHEL 3.5

Confidential

ORACLE CORE DBA

Confidential

Responsibilities

• Install and maintain Oracle database 9i in complex environments
• Applying latest releases of the RDBMS patches from Oracle to the instance to resolve few technical issues.
• Cloning/Refresh the Databases from production to Test, Development instance to test simulate few technical challenges, coordinate with testing and development teams.
• Participate in a team to maintain support for multiple oracle databases in high availability 24 X 7 heterogeneous environment.
• Assist in developing, documenting, implementing, and sustaining Standard Operation Procedures.
• Managing Stand by Database and recovery of Stand by Database.
• Liaison with Oracle Support to resolve various application and database issues.
• Daily Activities
• Checking the number of connecting Users.
• CPU utilization for Oracle Users
• Checking Invalid Objects
• Checking the Growth of databases
• Checking the free space.
• Automation of daily export. Script written in UNIX for Cron Job .
• Taking Database statistics using STATSPACK.
• Checking long running Query.
• Checking for Jobs running, if failed executing it.
• Providing Solutions to user requests.
• Security issues related to logins, database users, and application roles and linked Servers.
• Monthly Replication of 2 Databases of Production using Export and Import Utility.

Environment

Oracle DB 9i on UNIX/Windows