CAREER

OBJECTIVE

. Professional with around *.2 + 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 Mar

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 #4

Project : Support and Maintenance

Duration : June, 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 #3

Project : Implementation of 11.5.10.2& Maintenance

Duration : July, 2011 to May 2012

Role : Oracle Application & Core DBA

Client : NDOH (National Department of

Health SA Govt)

Environment : Oracle Applications 11.510.2., Oracle 10G,

RHEL 3.0

Products : Financial, Technology, SCM WMS, iBusiness

Description:

NDOH - National Department of Health SA Gov- Government of South

Africa. This project involves Implementation of Finance, Warehouse and

Supply Chain Solution.. This project involved setup and testing of the

instance.

Responsibilities:

. Installation and configuring Oracle Applications and Databases

. Troubleshooting Oracle Application & database problems

. Applying both Application & Database patches

. 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

Selected accomplishments

Database Upgrade from 9I to 10 G Up-gradation & migration from

AIX to Linux

. Planned and presented the Document about the steps for migrating

database from old low configuration to higher end server with minimal

downtime

. Prepared migration plan with adding new node and removing it once

migration completed.

. Reduced down time of Up gradation by creating a new RAC setup and make

it as a new oracle home

Tivoli/Rman Backup setup

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

entire Retail servers and system backups.

Project #2

Project : Support and Maintenance

Client : SIDEL CO Group

Role : Oracle Apps DBA

Duration : Nov 2010 to June 2011

Responsibilities & Contributions

. Supporting 24/7 production environment

. Performing daily Health Checks.

. Cloning with Online and Offline Backups.

. Monitoring the mount point size limits and taking necessary

actions if requires.

. Generate Applications Files Tasks (Generate Applications Files Menu,

Message Files, Form Files, Report Files, Graphics Files, and Product

JAR Files).

. Analyzing and applying appropriate patches as and when required.

. Creating new users, assigning responsibility using system

administrator responsibility.

. Managing tablespaces for storage.

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

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

. Relink/rebuild/regenerate/recompile all Oracle Apps objects.

. Experience in Managing concurrent managers, concurrent programs and

defining Custom Managers to run specific type of requests and enhance

the performance.

. Defining and managing application users, assigning and revoking

responsibilities

. DBA activities like database monitoring, maintenance and backups

. Taking hot,cold and rman database backup including Whole database

backup, control file backup, archive log.

. Created new user accounts, profiles, roles and privileges

. Interact with oracle support for technical assistance requests

. Monitoring tablespaces for space usage and adding required space

whenever it reaches threshold.

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

Diagnostic and Trace files.

Project #1

Project : Upgrade from 11.5.9 to R12.1.1

Duration : May, 2010 to Oct, 2010

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.9 to R12.1.1 and database from

9.2.0.6 to 11.1.0.7

. Upgrade the middle ware BPEL database from 9.2.0.6 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.

Contact this candidate