[pic]

B Hariram Kishore

Address: SV Cons. F-***

Gemini Col., Ramnagar,

Hyderabad.

( Mobile:- 970*******

E-Mail:k9r0nd@r.postjobfree.com

OBJECTIVE

To be associated with a growing organization as an "Oracle

administrator" and to best utilize my expertise towards the persuasion of

its goals and to work with leading edge of Technologies.

PROFESSIONAL ABRIDGEMENT

> A competent professional with more than 5 years of experience in IT which

includes 4 years in Oracle Database & Administration and 1 year in GIS

Technologies.

> Worked as Engineer-L2 in Rolta India Ltd.

> Proficient in DBA tasks that includes Installation, Configuration,

Administration, Database Tuning, Implementing Backup Strategies and

Table Space management.

> Creating Users and grant privileges according to the requirements.

> Experience in doing backups and recovery using RMAN, Cold/Hot Backups,

Logical Backups(exp/imp).

> Used SQL*Loaders to download the data into warehouse database from the

flat files and other data files across different platforms.

> Knowledge on Performance Tuning of Database and SQL statements like

Gathering Statistics, Locking, UTLRP, SQL Analyze, TKPROF, UTLXPLAN,

UTLXPLS, PLUSTRACE, etc.

> Knowledge on Performance Tuning of Memory like KEEP, RECYCLE, RESULT

Caches.

> Generating the reports like AWR,ASH,ADDM for monitoring the performance

of database.

> Worked on Performance Tuning of the load process using Explain Plan and

DBMS_STATS package.

> Export and Import of database objects using Data pump utilities EXPDP and

IMPDP.

> Good knowledge on DB Links, Migration, Log Miner and applying Patches.

> Administration of 11g Data Guard.

> Provided System support for both development and 24*7 production

environments.

> Effective Interaction with Support and other Application groups through

on call for high priority issues.

> Excellent communication, analytical and problem solving skills and team

player.

> Passed OCA in Oracle 10g DBA(IZO-047,IZO-042).

EDUCATIONAL CREDENTIALS

> B.Tech in Electronics and Communication from Jyothi Engineering College,

Hyderabad,

Andhra Pradesh .

ORGANISATIONAL EXPERIENCE

Jun '07 - Nov '07 Apex Knowledge Technology, Hyderabad.

Dec '07 - Jun` 12 Rolta India Ltd, Mumbai.

CERTIFICATIONS:

Oracle Database: SQL Certified Expert

OCA: Oracle 10g Certified Database Associate.

EMPLOYMENT HISTORY :

Jul'10 - Jun'12 Oracle DBA

Rolta India Ltd., Mumbai

PROJECT-1: SECOND PHASE

Title: E-ON (West-Division, United Kingdom)

Description: Project that involves creation and maintenance of electrical

features. Developed customized database routines specific for database

attribute population, data validation and verification. Also developed the

quality assurance checks involving data entry QA check, database quality

checks.

Responsibilities:

. Installation and Maintenances of Oracle RDBMS on Linux & Windows

platforms

. Creation of Tablespaces and Schemas.

. Created users and grant privileges according to the requirements.

. Export and import of database objects using Data pump utilities EXPDP

and IMPDP.

. DBA activities include database backup (Cold, Hot, Import/Export).

. Use of Import-Export utilities and SQL * LOADER, Data Migration.

. Design and implementation of backup and recovery strategy using RMAN.

. Used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, UTLRP, DBMS_STATS

package, etc for performance tuning.

. Administration of 11g Data Guard for high availability.

. Good knowledge on DB Links.

. Monitoring database health by scheduling shell scripts thru cron jobs.

. Generating the reports like AWR,ASH,ADDM for monitoring the

performance of database.

. Coordinated with other team members in establishing tasks and

deadlines.

Environment: Oracle 10g/11g, RMAN, Dataguard, SQL*Loader, Data

Pump(Expdp/Impdp), LINUX

Jun'08 - Jun'10 Oracle DBA

Rolta India Ltd., Mumbai

PROJECT-2: FIRST PHASE

Title: E-ON (Eest-Division, United Kingdom)

Description: Project that involves creation and maintenance of electrical

features. Developed customized database routines specific for database

attribute population, data validation and verification. Also developed the

quality assurance checks involving data entry QA check, database quality

checks.

Responsibilities:

. Installation, Creation and Maintenances of Oracle RDBMS on Linux &

Windows platforms.

. Creating, checking, extending Tablespaces

. Administered on Creating users, granted/revoked roles & privileges.

. Managed data files, rollback segments, extents, segments, and indexes.

. Export and import of database objects using Data pump utilities EXPDP

and IMPDP.

. DBA activities include database backup (Cold, Hot, Import/Export).

. Extensively used SQL Loader to load data from flat files to the Oracle

Database.

. Extensively worked on performance tuning of the load process using

Explain Plan and DBMS_STATS package.

. Provided System support for both development and 24*7 production

environments.

. Monitoring database health by scheduling shell scripts thru cron jobs.

Environment: Oracle 10g, SQL*Loader, Dataguard, Data Pump(Expdp/Impdp),

LINUX.

Dec'07 - Jun'08 GIS

Rolta India Ltd., Mumbai

PROJECT-1:

Title: E-ON (Eest-Division, United Kingdom)

Description: In this electrical project that involves creation and

maintenance of electrical features for digitizing the maps of electrical

network provided by client. Developed customized database routines specific

for database attribute population, data validation and verification. Also

developed the quality assurance checks involving data entry QA checks and

DBQC checks .

Responsibilities:

. Capturing the Electrical featuress network as per the client

requirement.

. Expertise in anayzing the schematic data (HT,LT,LB,S/S) from the

midas.

. Generating the reports in the software Microstation for solving the

errors for the captured network.

. Expertise in doing QC and additional experience in QA.

Environment: Oracle 10g, Microstation, Midas, Windows XP

Jun'07 - Nov'07 GIS

Apex Knowledge Tech., Hyderabad

PROJECT-2:

Title: VERIDIAN (United States)

Description: I worked as a Jr.CAD Engineer in Apex Knowledge Technology. In

this electrical project that involves creation and maintenance of

electrical features for digitizing the maps of electrical network provided

by client. Developed customized database routines specific for database

attribute population, data validation and verification. Also developed the

quality assurance checks involving data entry QA checks and DBQC checks

Responsibilities:

. Capturing the Electrical featuress network as per the client

requirement.

. Expertise in anayzing the schematic data (HT,LT,LB,S/S) from the

microstation.

. Generating the reports in the software G-Technology for solving the

errors for the captured network.

. Expertise in doing QC and additional experience in QA.

Environment: Oracle 10g, Microstation, GTechnology, Windows XP

NOTABLE ACCOMPLISHMENTS

Got back to back Excellent Grade in Annual appraisal for year 2008, 2009,

2010 & 2011.

PERSONAL FORTE

Date of Birth : 19-09-1984

Father's Name : B.Venkateswara Rao

Declaration

I do hereby declare that all particulars furnished above are correct and

true to the best of my knowledge

and belief.

Place: Hyderabad Thanking you

Date:

Yours sincerely

B.

Hariram Kishore

Contact this candidate