B. DENNIS KUMAR

D.B.ADMINISTRATOR

EMAIL: ozrime@r.postjobfree.com

Contact : 805-***-****

:098**-***-***

OBJECTIVE :

To pursue a challenging career in your esteemed organization and to utilize my skills of experience to the best possible extent to grow professionally with your organization.

PROFESSIONAL SUMMARY :

.

Working as Oracle DBA in SONATA SOFTWARE Pvt Ltd Bangalore, India

Acquired around 1.5 yrs of experience in infrastructure services (as Oracle DBA (9i/10g,11g))

Profound Understanding of Oracle 9i/10g/11g Architecture and creation of databases

Good understanding on 11g features

Expertise in Table space Management and User Management.

Creating tablespaces, sizing the System Tablespace, and allocating default Tablespace for users.

Transportable Tablespace using Export/Import utility..

Creating users with restricted access, with default and Temporary Tablespaces.

Creating and managing user access to the database, assigning privileges, and roles.

Creating roles and granting to users based on their group requirements.

Creating profiles and attaching them with users.

Exporting and importing databases.

Creating and Managing DBLINK to link schema objects residing on remote database

Experienced in creation and maintenance of DB objects, tablespaces and datafiles

Experienced in Database backups (Logical, Cold, Hot Backups & RMAN)

EXPERIENCE:

Working As ORACLE DATABASE ADMINISTRATOR (Sept 2010 – Till Date ) in SONATA SOFTWARE Pvt Ltd Bangalore, India

PLATFORM EXPERIENCE:

Operating Systems : Red Hat Enterprise Linux AS4 Update4, Windows 2000/XP

Languages : SQL

Databases : Oracle 10g

Tools/Utilities : SQL*plus, SQL Loader

Domain Knowledge : Oracle DBA (core)

EDUCATION:

Bachelor of Technology in INFORMATION TECHNOLOGY (2006-2010) in ST.Theressa Institute of Technology and Sciences (STIET) affiliated to JNTUK with an Aggregate: 58.69%.

Intermediate with Mathematics, Physics and Chemistry as major subjects awarded by Board of Intermediate Education from (2004-2006) in Sri Chaitanya Junior College, Visakhapatnam with an Aggregate: 77.5%

Xth standard (SSC) in St”Anns English Medium High School Visakhapatnam affiliated to Board of Secondary Education in year (2003-2004) with an Aggregate: 74.5%

PROJECT EXPERTISE

PROJECT :

Client : Telephone and Data Systems (CHICAGO).

Role : Oracle DBA Admin

Duration : Sep’ 10 to present.

Environment : RHEL 4.6, UNIX, Linux

Team Size : 5

Description: TDS is on Oracle database residing on servers. The TDS application provides two user interfaces. The first is a client/server-based interface and second one is web-based application written in oracle Active Server Pages. This interface provides read-only database access.

As an Oracle Database Administrator, my primary roles and responsibilities Involved:

I was involved with the onsite technician in resolving the issues which were not fixed by the L1 agents or the FSR( onsite technicians) it was a next level support to the customer and then identify the issue and resolve it. As part of my responsibility my role was to validate the troubleshooting done by the L1 agent and check the troubleshooting and then provide additional troubleshooting to resolve the issue effectively.

I was gauged on the resolution provided and the resolution provided is not causing any further issue to the customer's system.

RESPONSIBILITES:

Installations of oracle9i/10g on Linux and Windows.

Creation of database. Creation of users and assigning the privileges and roles to the users.

Monitoring database’s availability and check the alert log files for errors.

Reorganization and resizing of Data files and Table spaces.

Create database links & enable Archive log mode.

Oracle network configuration (NETCA).

Export and Import of whole database or selected schemas.

Upgrade database from 9i to 10g.

PERSONAL INFORMATION :

Father’s Name : L.BALARAJU

Date of Birth : 06-11-1988,

Gender : Male,

Nationality : Indian,

Languages Known : English,Tamil,Telugu,Hindi.

Hobbies : Playing cricket(Represnted Andhra State Team and Player of

JNTU University Cricket team)

Declaration

I hereby declare that the above-mentioned information is correct and true to the best of my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.

(Dennis kumar.B)

Contact this candidate