Oracle Manager

MADHU

Mobile: +91-973*******

E-mail:***********@*****.***

Experience Summary:

Having 3.8 years of experience with Oracle AppsDBA with R12.

Experience to upgrade oracle applications from 11.5.10.2 to 12.1.3

Experience on Application & Database Patching using ADPatch and Opatch

Good experience in Cloning Oracle applications in single node to multinode, multi node to single node environments.

Experience on shared applicationtier,and sharedappltop environments.

Having experience on upgradation from 9i to 10g, 10g to 11g.

Managing concurrent managers using sysadmin module.

Having experience on RMAN backups and RMAN cloning.

Experience in Exp/Imp and Datapump utilities.

Experience on ASM file system and databases using ASM file system.

Good Knowledge on Dataguard (Phyisical Standby).

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

Maintaining RAC database using command line utility srvctl.

Good Knowledge in applying patches to various Oracle Homes (RAC) using Opatch.

Education Qualification:

B .Sc Computer Science from Nagarjuna University from the

year 2004-2007.

Professional Experience:

Working as Oracle Apps DBA with Ness Technologies from OCT 2010 to Till date.

Worked as Oracle Apps DBA with Mahindra Satyam from AUG 2008 to JULY 2010.

Skill sets:

Database : Oracle 9i, 10g and 11g

ERP : Oracle E-Business suite 11.5.10.2 and 12.1.3

Operating System : Linux/ Unix, Windows.

Languages : Sql-Server, Java Script, HTML

Tools : DATAPUMP, RMAN, OEM, OAM, PUTTY, DBCA

DBUA,TKPROF/SQL Trace

Project: 1

Organization : Ness Technologies

Client Name : Honywell

Duration : Jul-2011 to Till date

Role : Oracle Apps DBA Consultant

Environment : Oracle 9i/10g,OracleApps11i/R12

Responsibilities:

Providing *24/7 Support on production instances.

Upgraded oracle application from 11.5.10.2 to 12.1.3

Cloning of E-Business suite 12.1.3

Upgraded the oracle Database from 9i to 10g,10g t0 11g

Appling Oracle Application Patches and Database Patches.

Resolving login issues for end users using the applications.

Resolving issues related to concurrent programs.

Monitor all the concurrent managers whether running or inactive.

Trouble shooting the problems related to Apache, Reports and Forms.

Maintaining Application file system using utilities such as Adadmin, Adctrl, Adpatch, Admrgpch, Adident.

Project:2

Organization : Ness Technologies

Client Name : PegaSystems

Duration : Oct-2010 to May-2011

Role : Oracle Apps DBA Consultant

Environment : Oracle 9i/10g,RAC,OracleApps11i

Responsibilities:

Performed health checks of Oracle Applications.

Good experience in Cloning Oracle applications in single node to multinode, multi node to single node environments

Applied Database Patches using Opatch.

Upgraded the oracle Database from 9.2.0.6 to 10.2.0.4.

Configuring network using netmgr, netca utilities to communicate between server and client.

Monitoring of ad workers status using adctrl utility while applying patches.

Clong of Oracle Application through Rapid Clone

Applying CPU patches every quarter in applications and oracle database.

Managing Concurrent Managers and Concurrent Programs.

Used adutilities for compiling Apps Schema

Used the AD utilities like adadmin, adconfig, adpatch, adsplice

Applying patches to oracle homes on RAC.

Taking backup of ocrfiles and votedisks.

Maintaining RAC database using command line utility srvctl

Project:3

Organization : Mahindra Satyam

Client : Cisco

Duration : Aug-08 to July-10

Role : Oracle Application and Database Administrator

Environment : Oracle 9i/10g,OracleApps11i

Apps DBA and Core DBA responsibilities

Performing health checks of Application services.

Worked on Application and Database Cloning using Cold and Hot methodologies.

Creation of control files, Redo Log files and data files.

Checking invalid objects and compile through adadmin tool

Performing the logical backups using Export and Import utilities.

Have been involved in Database upgrade projects from 9.2.0.3 to 10.2.0.4 in

11.5.10.2 application environment

Extensive usage of Ad utilities such as adadmin, adctrl, adsplice, adconfig.

Patching oracle applications using adpatch utility.

Maintaining Application Database objects like validating and compiling objects.

Cloning from PRODUCTION instance to Development and Test Instances.

Resolving of issues while cloning.

Maintaining the Concurrent Managers from System Administration Module.

Checking long running Concurrent Programs.

Enabling the trace to the long running Concurrent requests and Finding out the reason by analyzing its trace file and consequently fixing it.

Cloning database using RMAN.

Daily alert log file check.

Disk space check at O/S level.

Changing Apps user password using FNDCPASS.

Performing database Health checkups

Monitor and report status of instance (capacity, size/limit, performance, etc.)

Patch Applications for resolving performance and bug issues.

Maintenance included relinking applications objects and regenerating forms and reports using all.

Troubleshoot the Applications issues and performance problems.

Contact this candidate