Oracle Maintenance

VINOD KUMAR E-mail:

*********.*****@*****.***

ORACLE Application DBA Mobile: 077********

OBJECTIVE: Seeking a quality environment where my knowledge can be shared and enriched. And also looking

for the opportunity where I can improve my quality and my administration skills.

PROFESSIONAL SUMMARY

A competent professional with an overall experience of 4 years in Oracle Applications DBA.

Experienced in 10g Database Administration & Oracle Applications DBA 11i/R12

Installing and Maintaining Oracle Applications 11i/R12

Installing and Maintaining Oracle Database 10g/11g

Experience in Cloning of Oracle Applications Using Rapidclone utility

Experience in Applying Patches to Oracle Applications using Adpatch Utility

Experience in Applying Patches to Oracle Database using Opatch Utility

Experience in Ad utilities of Oracle Applications

Experience in System Administration Actives from Front end including users, responsibilities, registering concurrent

programs and requests etc.

Experience in Upgrading Applications from 11i to R12

Experience Trouble Shooting of Concurrent Programs issues

Converting forms from servlet to socket

Using FNDCPASS to change passwords of users

Configuring Printer for users

Checking alert log file to monitor database activities

Experience in Rman of Creating Catalog, Cloning of Database, Backup and Recovery of Database

Upgrading oracle database from 10g/11g.

Configuring Physical standby database.

Generating AWR and ADDMReports.

Configuring OEM and GRID for oracle database 10g

Migration of oracle apps r12 from Solaris to Linux

Migration of oracle dba 10g from Solaris to Linux

EXPERIENCE

Worked As Oracle Application DBA in Accenture from June 2010 to Till Date.

Worked As Oracle Application DBA in Navayuga InfoTech from June 2009 to May 2010.

ACADEMIC QUALIFICATION:

Completed B.tech in 2009 under NagarjunaUniversity in R.V.R & J.CCOLLEGE OF ENGINEERING

with an aggregate of 68.57%.

TECHNICAL PROFILE

ERP : Oracle 11i/R12.

Database : Oracle 10g/11g.

Operating System: Linux/Unix, Windows.

Languages : C, SQL.

Tools : AD Utilities, Rman, Data pump, OEM, OAM, FND Utilities, Putty & Remedy.

PROJECT DETAILS:

Project #1: Support & Maintenance & Upgrade

Company : Accenture

Client : Bhp Billiton(AUS)

Designation : Oracle Apps DBA

Environment : 11i/R12

Duration : Sep 2011 to Till Date.

Responsibilities:

Cloning from production to test instances to applying patches before fixing the bugs and tested in test instance before

moving to the production.

Cloning activities doing by single to single node and multi node to single node using rapid clone process.

Interacting with the users and functional team for resolving the issues.

Implementation of Parallel Concurrent Processing.

Creating the Application users and assigning the responsibility with the approval of reporting managers.

Monitoring Users and Concurrent managers by using ‘sys admin’ from front end.

User account management, creating users, disabling users, responsibility management (adding & retiring

responsibilities).

Used Adadmin to generate jar files, forms and compiling the invalid objects and validating Apps Schema and

relinking executables and also, used f60gen to generate and compile forms.

Applied patches using maintenance mode & hot patch option.

Maintaining snapshot information.

Monitoring Services through OAM

Used AD Controller to see the status of worker’s and restarted failed worker after resolving the problem.

Reduced the patch timing by using merging patches and options.

Implement database backup and recovery procedures using RMAN.

Upgrading oracle Applications from 11i to R12

Upgrading oracle database from 10g to 11g

PROJECT#2: Support & Maintenance& Upgrade

Company : Accenture

Client : Cargil (USA)

Designation : Oracle Apps DBA

Environment : 11i/R12

Duration : June 2010 to Aug 2011.

Responsibilities:

Cloning from production to Patch instances to applying patches before fixing the bugs.

Cloning activities doing by single to single node and multi node to single node using rapid clone process.

Creating the Application users and assigning the responsibility with the approval of reporting managers.

Monitoring Users and Concurrent managers by using ‘sys admin’ from front end.

User account management, creating users, disabling users, responsibility management (adding & retiring

responsibilities).

Used Adadmin to generate jar files, forms and compiling the invalid objects and validating Apps Schema and

relinking executables and also, used f60gen to generate and compile forms.

Applied patches using maintenance mode & hot patch option

Experience in Ad utilities of Oracle Applications

Experience in System Administration Actives from Front end including users, responsibilities, registering concurrent

programs and requests etc.

Good knowledge in Upgrading Applications from 11i to R12

Experience Trouble Shooting of Concurrent Programs issues

Converting forms from servlet to socket

Using FNDCPASS to change passwords of users

Configuring Printer for users

Checking alert log file to monitor database activities

Experience in Rman of Creating Catalog, Cloning of Database, Backup and Recovery of Database

Upgrading oracle database from 10g/11g.

Configuring Physical standby database.

Generating awr and atm Reports

Project#3: Support & Maintenance

Company : Navayuga InfoTech

Client : Nexus Managed Solutions, USA

Designation : Oracle Apps DBA

Environment : 11i/R12

Duration : Aug 2009 to May 2010

Responsibilities:

Maintaining Oracle Application File System and Database using AD Utilities like Adadmin, Adctrl, Adpatch

Single node and Multinode Maintenance of Oracle Applications

Experince in Oracle application Clonning

Responsible for applying patches for Oracle Applications and Database related bugs

Trouble shooting Regarding to patch issues

Performing health checks

Monitoring all running instances to ensure everthing working

Maintaining Snapshot information

Performing Various sysadmin activities like administering concurrent managers, defining users and

submitting request

Sysadmin task like assigning responsibilities and creating new responsibilities

Experience in Rman of Creating Catalog, Cloning of Database, Backup and Recovery of Database

Contact this candidate