Oracle Apps DBA

Shaik Raheem

adi3r9@r.postjobfree.com

Ph: +91-986*******

Experience Summary:

Having 5+ years of experience in Oracle APPS DBA and Oracle DBA with good hands on in administering of Oracle Databases, Tools and Oracle ERP Applications, and Oracle WebLogic Server.

Well Exposed to Oracle Consulting Procedures in Administration includes installation, configuration, Cloning, patching, remote administration and support of Oracle Databases on major Production and Operating Systems.

Fully conversant with Application DBA activities like Oracle Database and Oracle Applications Installation, configuration, upgrade, remote administration, cloning, patch application and Performance tuning.

Created and Managed Physical Standby databases using Data guard for PROD and QA Environments.

Hands on Experience in maintaining WebLogic Servers that includes installation and Upgradation, creation of Clusters, managed servers, node managers, data sources and Deployments.

Well Exposed on Oracle Enterprise Manger implementation of 10g, 12c and 13C. Tools & Technology

OS Red Hat Linux, Oracle Enterprise Linux and Windows Family ERP Oracle Applications Release 11.5.10.2, 12.1.X, 12.2.X Database Oracle 10g, 11g and 12c

Languages SQL

Tools TOAD, SQL Developer, WINSCP, Putty

GUI OMC, OEM 10g and 13c

Overview of Work Summary:

Extensive experience as Oracle Apps DBA on different versions of EBS applications like 12.2.X, 12.1.X, 11.5.10.2 and Database 10g, 11g.

Good knowledge in 12c database

Well familiar with architecture and file structure of Oracle Applications 11i & R12.

Experienced in System administration activities like – defining Concurrent programs, Request sets, Profile settings, concurrent managers, troubleshooting CM issues and User/Responsibility management.

Experienced in managing multiple environments like PROD, DEV, QA, FUNC, TRN, PTCH, SAND, TEST and CONV…

Experienced in cloning of Oracle Application 11.5.10.2 and 12.2.5 from Production to all Non-Prod ENV.

Experienced on all the Oracle Apps DBA related functions – Monitoring, Cloning, Patching, performance tuning, Troubleshooting Appl/DB issues.

Applied family packs, mini packs and database patches with adpatch, Opatch and ADOP utilities.

Experienced in Oracle Applications 11.5.10.2/R12 preferably Supporting, Performance Tuning, Trouble shooting, Maintenance etc.

Experienced in User and database security - Managing user accounts, roles, privileges, profiles, password security, resource usage and management.

Gathering table, schema and database level statistics to increase the performance.

Created and Managed Physical Standby databases using Data guard for PROD and QA Environments.

Experienced in taking Backups using Oracle backup and Recovery, RMAN, EXP/IMP, EXPDP/IMPDP methodologies.

Well Experienced in creating and managing tablespaces, data files.

Well Exposed in creating Users and Assigning Responsibilities to users and setting the profile options in EBS Applications.

Performed Shrink operation on schemas and tablespaces to reclaim unused space.

Knowledge in generating and analyzing AWR, ADDM and ASH reports and Performance tuning, explain plan, tkprof.

Knowledge in generating trace on form sessions, concurrent programs, Database sessions.

Involved and good knowledge in Installation & Upgrading databases from 10g to 11g and EBS Applications from 11.5.10.2 to 12.2.x

Well experienced in defining Concurrent programs, Request sets, concurrent managers, troubleshooting CM issues.

Knowledge in Custom Tops configuration.

Handled various Maintenance activities using AD Utilities.

Knowledge on Deploying customizations like java files, form files, concurrent programs to Oracle standard and Non-standard locations by using adcgnjar and FNDLOAD utilities.

Involved in running Data Installer and applying hrglobal.drv according to legislations in 12.2.5 Oracle Applications

Experienced in EBS R12.2.x. like File Structure, ADOP, Cloning, BSU Patches…

Experienced in Raising SR’s and participated of OWC sessions to clear the issues.

Good knowledge on installation of WebLogic Server

Experience in configuring of Clusters, managed servers, node managers and data sources of WebLogic Server.

Hands on experience in installing and redeploying applications in WebLogic Server through Console.

Working Experience:

I have been worked as Oracle Apps DBA in APPSTEK Information Services Pvt Ltd, Hyderabad from MAY 2015 to NOV 2018

Current employer:

Currently Working with Capgemini since 21st Feb 2019 to till date. Education:

B.Tech from JNTU, Kakinada in 2012.

M.Tech from JNTU, Kakinada in 2015

Oracle Certification: OCA

1Z0-061 Oracle Database 12c: SQL Fundamentals

1Z0-062 Oracle Database 12c Administration

1Z0-1085-20 Oracle Cloud Infrastructure Founddations 2020 Associate Professional Experience:

Responsibilities:

In this project, worked on Linux for Prod/UAT/Clone/Dev/Test/Patch environments.

Cloning the Oracle Applications using Rapid clone utility (11i and R12).

Handled various Maintenance activities using AD Utilities

Handled Applications configuration using Autoconfig

Handled patching, concurrent manager administration, Forms and Reports troubleshooting, cloning 12.2.6 instances and Oracle Apps SYSADMIN functions for Linux.

Created and Managed Physical Standby databases using Data guard for PROD and QA Environments.

Cloned Oracle Applications R12.2.6 from PROD to Non-Prod instances Using RMAN Backup.

Applied Oracle Applications patches (Family pack, one off patch, CPU patches etc.) on 11.5.10.2 & 12.2.6 instances using ADPATCH and ADOP utilities.

Applied Oracle Applications BSU patches on 12.2.6

Deploying customizations like java files, form files, concurrent programs to Oracle standard and Non-standard locations by using adcgnjar and FNDLOAD utilities.

Applied Oracle Applications Localization patches as per Clients requirement.

Taking Backups using RMAN, EXP/IMP, EXPDP/IMPDP methodologies.

Good experience with Tablespace issues like resizing and creating new Tablespaces.

Setup the metrics and notifications in OEM and OMC Oracle Management Cloud as per oracle recommendations and Database configuration.

Compiling Forms and Reports as per developer’s requirement.

Gathering table, schema and database level statistics to increase the performance.

System Administration activities like user creation setups, creation of function, menus, responsibilities etc.

Experienced in Custom Tops configuration.

Worked with Oracle Support on opening, managing, and resolving Oracle SR's.

Worked with oracle support on OWC session to resolve issues as per user request.

Expert in generating trace on form sessions, concurrent programs, Database sessions.

: Oracle Apps DBA/DBA Duration: 21/Feb/2019 – Till Date

: Oracle Applications R12.2.6 (Off Shore Support)

: TOLL

Project

Client

Role

Professional Experience:

Responsibilities:

In this project, worked on Linux for Prod/QA/Func/Dev/Test/Trn/Conv/Patch environments.

Cloning the Oracle Applications using Rapid clone utility (11i and R12).

Handled various Maintenance activities using AD Utilities

Handled Applications configuration using Autoconfig

Handled patching, concurrent manager administration, Forms and Reports troubleshooting, cloning 11.5.10.2 & 12.2.5 instances and Oracle Apps SYSADMIN functions for Linux.

Created and Managed Physical Standby databases using Data guard for PROD and QA Environments.

Cloned Oracle Applications 11.5.10.2 and R12.2.5 from PROD to Non-Prod instances Using RMAN Backup.

Applied Oracle Applications patches (Family pack, one off patch, CPU patches etc.) on 11.5.10.2 & 12.2.5 instances using ADPATCH and ADOP utilities.

Applied Oracle Applications BSU patches on 12.2.5

Deploying customizations like java files, form files, concurrent programs to Oracle standard and Non-standard locations by using adcgnjar and FNDLOAD utilities.

Applied Oracle Applications Localization patches as per Clients requirement.

Taking Backups using RMAN, EXP/IMP, EXPDP/IMPDP methodologies.

Good experience with Tablespace issues like resizing and creating new Tablespaces.

Setup the metrics and notifications in OEM as per oracle recommendations and Database configuration.

Compiling Forms and Reports as per developer’s requirement.

Gathering table, schema and database level statistics to increase the performance.

System Administration activities like user creation setups, creation of function, menus, responsibilities etc.

Experienced in Custom Tops configuration.

Worked with Oracle Support on opening, managing, and resolving Oracle SR's.

Worked with oracle support on OWC session to resolve issues as per user request.

Expert in generating trace on form sessions, concurrent programs, Database sessions.

Shaik Raheem

: Oracle Apps DBA/DBA Duration: 11/May/2015 – 30/Nov/2018

: Oracle Applications 11i & R12 (Off Shore Support)

: LAITRAM L.L.C.,

Project

Client

Role

Contact this candidate