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