T.Raja Shekar Mobile :+201-***-****

Oracle Apps DBA E-Mail : ac441l@r.postjobfree.com

Aim to be placed in a challenging organization that gives me scope, update my knowledge and skills in accordance with the latest trends and be a part of team that dynamically works towards growth of organization.

A competitive professional having total around 8+years of experience in Oracle Apps DBA and as well as core DBA.

Lead Team from onsite, will be assigning work to offshore and will be talking

To application team for the down time and will be planning for the outage at non business hours

Experience on Oracle Applications 11i, R12 Installations and Oracle databases 9i, 10g and 11g

Worked on EXA data and Exalogic machine

Experience on Sys Admin Activities like creating users and assigning responsibilities including Security Maintenance

Worked on 12.2.3,12.2.4,12.2.6 with latest Cloning step Dual in 12.2

Worked on 12c database

Good knowledge on SQL and PLSQL

managers and processes, Patching, User management issues and space management issues related to Oracle Applications.

Very good in communicating to the clients and end users from offshore.

Good knowledge in AD utilities and handling different kind of activities in Oracle Applications.

Excellent remote systems support and troubleshooting capabilities.

Worked 12.2 patching adop utlity and 12.2 Cloning

Hands-on operational expertise as an Oracle DBA, with technology including RAC, SSO, DataGuard, High Availability and Backup/Recovery

Portal password change and Backup activity in Portal

Trained in Oracle Fusion Administration

Appalied the p-relay(HRMS) patches

Knowledge on 12.2.4 and weblogics

Participated in the DR and JRE upgrade

Have Converted Non- ASM Database to ASM Database

Have troubleshooted and fixed the Concurren issues

Upgrading Oracle Apps from R12 (12.1.3) to latest R12 (12.2.3)

Analyzed and applied various CPU patches, PSU patches etc.

User management and assigning responsibilities to the users in Oracle Applications

Created new instances using Rapid clone (DEV/QA/PATCH Instances).

Expertise working on oracle 11gR2 RAC,12C environment

Experience in Real Application Cluster environment (RAC) with ASM and file systems

Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose

Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Dataguard. Also proficient with new 11g features such as Active Dataguard and Snapshot standby database

Expertise in troubleshooting Cluster issues in 11g RAC and 10g RAC databases

Involved in 12.2.3 upgrade

Done Delta 7, Delta 8,Delta 9 patches on 12.2

Extensive knowledge of Oracle OEM 12c Architecture, Framework, and Infrastructure Strong Experience in Database Performance Tuning.

Expertise Database administration, maintenance, and schema design for PostgreSQL.

Operating Systems

RHEL 5/4,OEL 5,HP-UX,Windows XP,2003,2000

Database

Oracle 10g

Languages&Packages

C,C++,HTML,VB,SAP-ABAP,Sql,PL/Sql

Web Related

Apache, Portal,P-relay, weblogic, FMW

ERP Applications

Oracle Applications (11.5.9, 11.5.10.2,R12)

Tools & Utilities

Putty,RMAN,SQL* Loader,OEM,OAM,X-Manager

GUI Tools

Oracle Enterprise manager11g&12c, TOAD, Data Loader, SQL Developer

Completed Graduation (Computers) from Osmaniya University,Hydrabad.

Working as an Oracle Apps DBA for Genpact LLC, NewYork Jan 2016 to till date

Working as an Oracle Apps DBA for Genpact, Hyderabad Jan 2013 to Dec 31 2016

Working as an Oracle Apps DBA in Hexaware Technlogies, Bangalore upto Jan 2013

Project #2 :

Client

Genral Electricals ( GE) -GRC, TRN, OHR, OLM

Role

Oracle Apps DBA

Team Size

12

Organization

Genpact

Environment

Oracle Apps 11.5.10.2, $ R12, 12.2.3,12.2.4,12.2.5

Duration

Jan 2013 to Tilldate

.

Responsibilities :

Applied all the CPU patches using ADOP online patching tool

Upgraded EBS version from 12.2.3 to 12.2.6 using ADOP

Monitoring Concurrent Managers & its operations like starting, stopping the concurrent managers & Troubleshooting problems, resolved the view log/out files issues of concurrent requests.

Applying patch on Applications using Adpatch utility on Patch instance .

Oracle Applications Utilities like AD Administration, AD controller, Autoconfig, AD Relink, Auto Patch, f60gen and managed passwords using FNDCPASS.

Monitoring, identifying and resolving user issues...

Maintenance of File System and taking appropriate backups for security and consistency.

Validating and creating grants & synonyms on Apps schema, performed Jar file/forms generation as a post patch step, Relinking the Oracle Apps programs.

Performed research for patches for specific problems and downloaded Patches. Done Patch analysis, applied Patches (one-off,mini-packs) and checked the Patch impact, Managing Patch history till go-live.

Performed tracing for various user sessions and for various conc. Programs.

Reduced the timelines of patching using features like defaults file and merge patch.

Troubleshooting several worker issues while patching.

Managed and troubleshooted apps components like apache/forms etc.

Monitoring alert log and trace files for errors.

Monitoring the cpu,memory usages on the server.

Installed off-cycled products using adspilce utility.

Helping users while initial setup of application launch and resolved db Connectivity issues,

Monitoring tablespaces for space usage and adding required space whenever it reaches threshold.

Project #1:

Client

Unisys

Role

Oracle Apps DBA

Team Size

13

Organization

Hexaware,

Environment

Oracle Apps 11.5.10.2, Oracle 9i,

Duration

Dec’09 to Jan 2013

Client Description :

Unisys is a Fortune 500 company, a leader in worldwide information technology

services and solutions. In more than 100 countries we deliver the precision thinking

and relentless execution that drives our clients' business transformation.

The centre will provide software development, maintenance,

business process outsourcing and technical help desk services

Responsibilities :

Controlling and monitoring the user access to the database.

Monitoring alert log and trace files for errors.

Managing Import/Export depending upon requirement.

Hot/Cold Backups of database.

Resolving user issues and performance issues due to high CPU usage.

Applied RDBMS patch by using Opatch..

User management involving creating users,assigning roles and priviliges

Configuring listeners and tnsnames.ora files.

Tracing Sql Session and used TKProf to analyze the traced file.

Applied patches on Applications using Adpatch utility on patch instance

Cloning the Oracle Apps instances from prod to test using rapid cloning process .

Monitoring Concurrent Manager & Troubleshooting problems, resolved the view log/out files issues of concurrent requests.

Used admerge patch, default files to reduce the time while applying patches.

Performed research for patches for specific problems and downloaded patches. Done patch analysis, applied patches and checked the patch impact.

Participate in a team to maintain & support for multiple oracle databases and high availability (24 X 7) environment.

Transferring the bulk data from text file into Oracle Database using SQL * Loader and export & Import utility for backup purpose and distributing the tables in multiple environments.

Raja Shekar

Contact this candidate