Oracle Apps

Ajay Kumar Bagri

Oracle Apps DBA

Mobile No: +91-898-***-****

Email: **********@*****.***

Career Objectives:

Being at the threshold of my career, I am looking for core database and

11i, R12 Environment, which would enhance my skill and help me to grow to

take on Professional world.

Profile:

I am an Oracle Apps DBA with 1.5 year of relevant experience as looking for

demanding projects and strive in implementing the best in class technical

solutions. I am seeking a new challenge to call upon my technical skill

set. I constantly work to keep abreast of Oracle technology.

Summary:

. Over 1.5 years of experience in space of Oracle Technology, Database and

Applications Administration.

. Extensive experience in Applications and database across Oracle

Technologies to implementation and maintenance.

. Delivered multiple projects involving implementation of Applications and

Relational Database Management Systems, Client Server Technology and

Database Administration along with installation and maintenance of

database and Applications.

. Good knowledge over Oracle E Business Suite Architecture and

Administration.

. Strong experience in planning and implementation and coordinating total

quality support as Oracle Apps Database Administrator.

. Good communication skills self-motivated, self-starter, problem solver.

Work Experience:

Working as an Oracle Apps DBA, with iWare Logic Technologies Pvt. Ltd. Pune

since October 2011.

Skills:

. Programming Languages - C, SQL.

. Applications/Other software's - Oracle

. Operating System :Linux 5.4, 4.5, Windows 2000/XP

. RDBMS: Oracle 9i, 10g.

. Applications: Oracle Apps 11i and R12.

. Applications and Database Utility and Tools: OAM, SQL*Plus, OEM, Putty,

Toad, WinSCP.

. Database Backup Utility: Oracle RMAN, Oracle Export/ Import, Data pumps.

. Basic Knowledge of RAC.

Academic Qualification:

Degree Board/University Percentage/Grade

B.E RGPV University Bhopal (M.P) 67.31%

in 2010

12th M.P Board Bhopal (M.P) in 2005 62.60%

10th M.P Board Bhopal (M.P) in 2003 68.80%

Professional Experience Details:

Organization Designation Period of Employment

iWare Logic Pvt. Oracle Apps DBA October 2011 to Till

Ltd., Pune date

Work Experience Summary:

Project Title : Oracle E-Business suite 11i support

Client Name : Thermax Pvt. Ltd.

Environment : RHEL 4.5 and 5.4

Software Tools : Oracle Apps 11i, Putty, Toad

Application version : 11.5.10.2

Database version : 10.2.0.4

Duration : Oct. 2011 to May 2012

Responsibilities:

. Cloned single node to single node on Test systems

. Applied latest family/mini pack using adpatch utility

. Administering concurrent managers

. Health check-up and monitoring backup activities.

. Creating users, assigning tablespaces and quotas, assigning roles,

profiles and necessary privileges to users according to the business

requirement

. Monitoring Table spaces, Mount points and Archive logs on daily basis.

Project Title : Oracle E-Business suite 11i support

Client Name : ITW, Hyderabad

Environment : RHEL 4.5

Software Tools : Oracle Apps 11i, Putty, Toad

Application version : 11.5.10.2

Database version : 10.2.0.4

Duration : June 2012 to till date

Responsibilities:

. Applying patches using adpatch utility.

. Check alert log, users up and running at regular interval.

. Check tablespaces and increase the size of tablespaces according to

requirement.

. Cloning Oracle Applications using Rapid Clone.

. Created custom top

. Monitoring database and other log files

. Troubleshooting issues related to apache, concurrent managers

. Performing Backup Activity

. Performed applications Maintenance tasks using adadmin tools like ad-

patch, auto-config, ad-admin, adctrl.

Training Profile:

. Oracle Workforce Development Program (covering Oracle 10g DBA

Fundamentals-I and II) from Oracle Corporation.

. Completed Oracle Apps R12 Install, Patch and Maintain Oracle Applications

training from Oracle Corporation.

. Real Application Cluster (RAC) with oracle 10g, only installation and

basic concepts.

Oracle DBA:

. Administering the database security, creating users, granting roles,

privileges to users, extending the database storage capacity and

optimizing the performances.

. Monitoring and managing data files, undo segments, other segments and

extents.

. Performing Logical backup using Export utility & recovering specific

schema/object using Import utility.

. Monitoring cold, hot backup scripts of the databases supporting different

applications.

. Taking care of table space related issues like increasing the storage

parameter values, resizing the data files, adding new data files etc.

. Installed Oracle 10.2.0(10g)/11.2.0(11g) on Linux and created customized

database.

. Expertise the database using RMAN, cold/hot backup manually.

. Installation and configuration of oracle 10g and oracle 11g on windows,

Linux.

. Managing export and import depending on requirement.

. Storage management including adding data file to the table spaces and

distributing, them among different disk to reduce the I/O contention.

. Managing rollback segments redo log file to avoid the resource

contention.

. Hot/Cold backup of database.

. Backup of initialization /configuration file, control files and archive

log file.

. Create and manage oracle users with appropriate grants and other

privileges.

Oracle Apps DBA:

. Installation of Oracle Apps (11i, R12) etc on different platforms.

. Upgrade Database 9.2.0.6 to 10.2.0.5.

. Upgrade Application 11.5.10.2 to 12.1.1

. Establishing Client Connectivity.

. Oracle Apps Administration.

. Creating Apps Users.

. Providing Apps responsibilities.

. Backup of Oracle Apps (Database and Applications).

. Cloning of Applications and Database using rapid clone.

. Patching of Oracle Application and Database using adpatch and opatch

utilities.

. Recovery of Database and Application in case of crashes.

. Monitoring Load on the system.

. Monitoring Concurrent Requests and Managers.

. Managing the Oracle Apps Services.

Personal Details:

Father's Name : Mr. Babu Lal Bagri

DOB : 15th Oct. 1987

Sex : Male

Marital Status : Unmarried

Languages Known : English, Hindi

Passport No : J9944373 (Valid up to 2021)

Mobile No : +91-898-***-****

Place : Pune

Date :

Ajay Kumar Bagri

REFERENCES:

Contact this candidate