OBJECTIVE

To work in a challenging environment where I can enhance and

deliver my technical skills to the best of my capabilities and talent.

EXPERIENCE SUMMARY

. Professional with around 3+ years of experience as Oracle APPS DBA

(11.5.x, 12.0.X), Oracle DBA (9.2.0.x,10.2.0.x) Administration and

Maintenance.

. Evaluating, Installing, monitoring and managing the Single and

MultiNode Oracle Apps

. Had a good working knowledge on shared Application Tier File system,

Shared Tech Stack

. Administrating E-Business Suite 11i,R12

. Cloning of Applications R11i from Production database to Development

database and Test DB.

. Monitoring and Troubleshooting of Apache, Forms, Conc. Manager,

Servers, and Database related issues.

. Experienced on AD utilities. (Ad patch, Admrgpch, Adctrl, Autoconfig,

Adadmin, Adrelink)

. Pre Patch analysis for application patches including patch set and one-

off patches.

. Sysadmin tasks like creating user, assigning responsibilities,

registering forms, concurrent programs, creating responsibilities and

menus.

. Experienced on database concept, architecture, installation, patching,

backup and recovery.

. Knowledge about Oracle 10gRAC on Linux Platform and R12.

. Self-motivated team player with an interest in working in a team

environment and ability to learn things quickly.

. Highly motivated, energetic, and professional team player with

excellent skills

PROFFESSIONAL SUMMARY

Currently working With Nest TechNet private

Limited

Oracle Apps DBA May

2010 - Till Date

EDUCATIONAL

SUMMARY

B TECH (Information Technology) from JNTU

Hyderabad in the Year 2010.

ADDITIONAL INFORMATION

. In house training of ORACLE 10g DBA at Nest TechNet Pvt Ltd.

. In house training of ORACLE 11i Apps DBA at Nest TechNet Pvt Ltd.

TECHNICAL

SUMMARY

ERP (11i / R12) Database

Patching in multiple testing / Database installation

development and production Maintenance of Components for

environment having multiple different applications

application tiers. Database Cloning/Refresh

Maintaining application using AD Rebuilding indexes as and when

utilities (Adadmin, Ad patch, required.

Adctrl etc) Analyzing the database performance

Replicating, Fine tuning, Backup using third party tools, and tuning

application and database database performance (Resizing redo

Cloned application/database using logs, temp etc.)

adclone.pl and Cloning to single / Created scripts such as object

multi node creation, grants & privileges etc.

Implemented Custom Application Code deployments ( Manual)

Troubleshooting and bug fixing RAC Administration

Managing Application servers (10g RMAN Administration

AS, Discoverer, BI Discoverer etc) Performance Monitoring

Good at managing Concurrent Understanding Shell Programming

Requests, Programs & managers

Managing, validating Application

and databases using oracle Diag

tools.

PROJECT SUMMARY

Project #3

Project : Support and Maintenance

Duration : Nov 2012 to Till Date..

Role : Oracle Application & Core DBA

Client : Xerox India Ltd, Bangalore.

Description:

XEROX has been in business for more than 100 years. Although

acquisition and mergers have changed the names over the last 20 years, our

products and history are tied to historical names such as The Haliod

company, Rank Xerox, Newly and more recently, The Xerox Goup. This

Project is involved in support to end users and Maintaining Production

Database.

Responsibilities & Contributions

. Responsible for the support and maintenance of the multiple oracle

databases and applications in high availability (24*7) heterogeneous

environment.

. Compiling invalid objects (manually and also using adadmin).

. Using ad-utilities like adadmin, adpatch, adctrl.

. Analysis of apps and database patches for various releases of Oracle

Applications

. Applying patches and Cloning instances.

. Expertise in Database Patching and Cloning.

. Report and resolve all serious Oracle alert log messages, monitor

Diagnostic and Trace files.

. Maintaining and administering Application Users.

. Knowledge on Application Patch analysis and installation.

. Support and Monitor Oracle Application instances.

. Monitoring Concurrent Manager & its operations like starting, stopping

the concurrent managers.

. Splicing of off cycle products and registering them with the Oracle

Applications eBusiness Suite.

. Interacting with the customer to understand their requirements and

their Technical queries.

. Worked on All kind of configuration activities as per customer

requirements.

. Performed tracing for various user sessions and for various concurrent

Programs.

. Maintenance tasks like Purging Concurrent manager log files, Gather

schema statistics

. Managing Workflow and its components through OAM

. Worked on Shared APPL_TOP and Shared Tech Stack Environments

. DBA activities like database monitoring, maintenance and backups

. Knowledge on Configuring DMZ servers.

. Knowledge on upgrading the application database from 9i to 10g

. Expertise in Database Patching and Cloning

. Allocating system storage and planning future storage requirements for

all database systems.

Project #2

Project : Fresh Implementation of 11.5.10.2& Maintenance

Duration : Aug 2011 to Oct 2012

Role : Oracle Application & Core DBA

Client : Bank of Ghana, South Africa

Environment : Oracle Applications 11.510.2., Oracle 10G,

RHEL 3.0

Products : Financial, Technology, SCM WMS, iBusiness

Description:

Bank of Ghana is a South Africa based bank which deals in banking

work. This project involved in the Implementation of Oracle EBS and setting

up the Disaster Recovery site for the Database

Responsibilities:

. Installation and configuring Oracle Applications and Databases

. Troubleshooting Oracle Application & database problems

. Applying both Application & Database patches

. Maintenance of installed Oracle Applications Release 11.5.10.2 suite and

Troubleshooting.

. Sysadmin, Database cloning, Patch applying, Alerts, and other Apps DBA

functions

. Cloning of production instance on regular basis

. Database administration of production and test instances.

. System administration functions like creating users, creating

responsibilities and menus.

. Defining specialized Concurrent Managers, and attaching work shifts.

. Space management

. Interact with customers to understand their technical queries and

provide assistance in resolving them

. Interact with Oracle Support for technical assistance requests

. Create Technical Notes and Documentation

Tivoli/Rman Backup setup

. Created catalog database and configured the Tivoli/Rman backup for

entire Retail servers and system backups.

Project #1

Project : Upgrade from 11.5.10.2 to R12.0.4

Duration : Aug 2010 to, 2011 July

Role : Oracle Application & Core DBA

Client : SRF Limited - New Delhi,

India

Environment : Oracle Applications 11.5.9, R12.1.1.

Oracle 11G

Products : Financial Technology, SCM,WMA,

iBusiness

Profile :

SRF Limited is world leader in manufacturing Refrigerant gases. ICS

has developed and implemented Exports and Imports Management system at SRF

and integrated it with Oracle ERP (11i).ICS has upgraded the Oracle ERP 11i

to R12 successfully in-time under budget with Zero issues.

Responsibilities:

. As a team member I was actively involved in the below phases of project :

. Played as a team member role in SRF Upgrade project.

. Upgrade from Oracle Applications from 11.5.10.2to R12.0.4 and database

from 10.2.0.1 to 11.1.0.7

. Upgrade of discoverer from 3i to 10G EUL.

. Converting single node to multi node after upgrade to R12.1.1

. Created Custom cloning abstract with single script and provided to

client.

. Troubleshooting post upgrade Oracle Application & database problems

. Setting up the customizations in R12 .

. Interact with customers to understand their technical queries and provide

assistance in resolving them

. Create Technical Notes and Documentation.

Name : DILEEP KUMAR KATAMMAGARI

Pan Card : ATGPK7832D

Gender : Male

Marital Status : Single

Nationality : Indian

Languages Known : English, Hindi, and Telugu

Personal Details

Contact this candidate