Oracle Project

Sekhar Reddy

Mobile:+91-962*******

E-Mail: **********@*****.***

Experience Summary :

. Having 3.8 years of experience in DBA CONSULTANT strong experience in

supporting production, development and test environments for Oracle E-

Business Suite.

Employment Details:

. Working as a DBA CONSULTANT in Birlasoft limited .

Professional Summary

. Experience in applying application patches

. Experience in application and database Cloning.

. Administrating and troubleshooting of Apache, Conc.Mgr, forms and

database issues.

. Managing Concurrent Managers and concurrent requests

. Experience in running AD Utilities to administer the Applications.

. Performing and validating Database and Application Backups

. Experience in code migrations to Dev, Test and Prod Instances.

. Applied the RDBMS patches using Opatch utility.

. Coordinating with Oracle Support for Trouble shooting issues

. Providing ongoing support to Functional and development Teams

. Working under the environment of 24X7 DBA support.

Educational Qualification

. B.Sc computers froms St.joseph's degree college in the year of

2009.

Technical Skills

Primary Skills Oracle11i & R12 APPS DBA, Oracle 10g & 11gDBA

Operating System RHEL 4.8,5.0. Windows 2003/xp

Databases Oracle (10g,11g,)

ERP Oracle E-Business Suit ( 11.5.10.2,R12)

Utilities Export, Import, RMAN

Employment Summary

Project #2:

Client : AIG, USA

Role : DBA CONSULTANT

Technologies : Oracle RDBMS 10g,11g,Oracle application

11.5.10.2,r12.RAC

Duration : JULY 2012 To Till date

Project Description:

Fusion is a Insurance project for AIG. It provides

different services for AIG. It deals personal and corporate insurance.

This project handles only corporate insurence and it deals with claims

and draft. In this project there are different modules which are Load,

Preprocessing, coverage validation and Monthly updates. Fourth week of

every month claims will process. (TPA)Third party will verify the claims.

Roles & Responsibility:

. Installation & configuration of Operating System (RHEL4) and 11g

Clusterware Software for RAC

. Installation of Oracle Binaries for ASM and DB,Cluster Database

Creation(dbca, manual)

. Add or Remove Node,Utilities like tkprof, oradebug,SRVCTL Utilities in

10g RAC

. Server side, Client side load balancing,AWR Report generate.

. Configuration and maintain ASM instances and Standby database

. Monitoring the Application System with Oracle Enterprice Manager

(OEM).

. Used Oracle Application tools for maintaining database and application

like adpatch, adadmin, adctrl,etc...

. Administering Concurrent Manager and Concurrent Requests

Troubleshooting of Forms Server and Reports Server.

. Supporting development teams, general troubleshooting & Support in

administration of production & test instances.

. Performed Application admin tasks using ADADMIN utility.

. Changing Apps,Applsys and also product and end users passwords using

with FNDCPASS.

. Create Users and adding Responsibilities as part of SYSADMIN tasks.

. Interacting with Oracle support for technical assistance.

. Good experience in backups and recoveries.

. Export/import of schemas and tables from production to test/dev

Project #1

Client : Meijer, USA

Role : ORACLE DBA

Technologies : Oracle RDBMS 10g.Oracle Applications

11.5.10.2

Duration : MAY 2011 To JULY 2012

Project Description:

MealBox is a groundbreaking online widget that allows you to

search recipes, create meal plans, build shopping lists, and access great

coupons online. With hundreds of delicious recipes.MealBox widget is

featured with a sharp powerful search engine for searching recipes, fast

and fun to plan one's meal and a customized shopping list which cuts'-off

one's time and money along with these one can set up their own profile on

the mealbox.For availing this facility one must create an account at

meijer.com.

Roles & Responsibility:

. Experience in Oracle RDBMS software installations(8i, 9i and 10g),

Working with multiple Oracle homes.

. Installed 11g RDBMS & Oracle Applications 11i on Red Hat Enterprise

Linux.

. Maintaining the Database & Application of Oracle E-Business suit.

. Compiling Invalid Objects,Regularly checking Alert log.

. AD-administration (usage of ad utilities like adadmin, adctrl, adpatch

etc).

. Monitoring Active Users, Active Responsibilities.

. Applying patches (One-off) as & when required.

. Patching (Both Database and Application).

. Application user creation / responsibilities assignment.

. Troubleshooting Apps components like Forms, Apache and Concurrent

Managers.

. Refresh from production to test environment.

. Monitored the Applications and database using OEM.

Contact this candidate