Sr.Oracle DBA

SHIVAKUMAR.N

C/o mohan, pattalamma street

Audugodi, Bangalore

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

Contact No: +91-725*******

PROFILE

Hands-on role in providing high-end release, implementation & Database Administration, Patching, Cloning operations and other regular production support for Oracle RDBMS

As Oracle DBA: 1 yrs.

 Technical responsibilities like Installation, Creation & Monitorining database.

 Worked on diverse platforms like Linux and Windows.

 Basic Unix/Linux Administration skills, which was acquired largely while working at various client sites.

EXPERIENCE SUMMARY

Gmind soft Pvt Ltd from 2009 till date.

PROJECT

Project : WEB-EX COMMUNICATIONS

Organization : Gmind soft Pvt Ltd.,

Client : BANKING MANAGEMENT NIDHI PVT LTD

Role : Oracle DBA

Duration : sept 2009 to Till date.

Technologies : Oracle 10g, UNIX, SQL, PL/SQL, Windows NT

RESPONSIBILITIES

Database Servers:

 Installation of database.

 Managed the database which is accessed by various clients at different location.

 Maintain Oracle database servers in Production, Development and Test environments.

 Extensively use SQL, PL/SQL, DDL, and DML in production, development and test environments.

 Stats pack implementation for optimizing databases servers.

 Rebuilding indexes.

 System Global Area (SGA) and Shared Pool setting.

 Creation of users and roles for different projects and working closely with the developers during its release cycles.

 Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.

 Configuring oracle client to the database.

 Backup and Restoration using RMAN.

 Creating Tables, DB LINKS, Indexes, and Views.

 Creation of network links using listener and tnsnames.

 Creation Tablesapces, resizing of Table spaces.

 Cloning non-production databases from production

 Work with Oracle Support on SEV 1 TARS

 Heavily involved in developing and maintaining partitioned database tables, Table space creation, Bitmap Index, Index rebuilding and developed PL/SQL packages to archive the Partitioned tables

 Monitored backups, space usage, and user activity on daily basis and Performed daily hot backups and weekly Cold backups using RMAN.

 Altered, modified, Partitioned, dropped, created database objects daily on a 24X7 production, Development, testing environments using TOAD and OEM.

 Developed the script files for monitoring the sizes of table spaces, Rollback segments, Temporary segments and percentage of it sizes changing per day.

TECHNICAL SKILLS

Operating System Windows, UNIX, Linux

Languages : SQL,PL/SQL,C,C++

Database

Backup & recovery

Oracle Tolls & Utilities Oracle 10g.

RMAN

Oracle Enterprise Manager, RMAN, Statpack,

PERSONAL PROFILE

Ø Self Confident

Ø Excellent Communication Skills,

Ø Hard Working

Ø Leadership Qualities

Ø Active Team Worker

TRAINING

Successfully completed 4 months training along with certificate on Oracle/DBA from Cambridge Technology India (Oracle Authorized Training Center) Pvt. Ltd Bangalore.

CERTIFICATIONS

 Oracle certified professional (OCP).

EDUCATIONAL SUMMARY

 B.E from, B.G.S. Institute Of Technology,B.G.nagar, during 2009 and acquired 68%.

 DPLOMA at B.E.T.POLYTECHNIC, K.M.Doddy during 2006 and acquired 60%.

SUMMARY

Ø Installation of Operating Systems like RHEL AS 4.0.

Ø Installation of Oracle Database 9i/10g on Windows and Linux platforms with operating system environments.

Ø Schema and User management.

Ø Space maintenance as per requirement for table space and segment.

Ø Good knowledge of hot backup, cold backup and logical backup.

Ø Creating and managing of Database Links and Materialized Views.

Ø Database health monitoring using traces files and alert log.

Ø Well verse with recovery procedures in archive database log mode.

Ø Primary knowledge of PL/SQL scripting and very good in SQL scripting.

Ø Troubleshooting of Oracle network and difficult ORA-errors.

Ø Awareness of STATSPACK reports and AWR reports for tuning of Oracle.

Ø Analyzing the database objects and Rebuilding of Indexes.

Ø Configuring LISTNER and TNSNAMES in network applications

Ø Export/Import of database Objects.

Ø Scheduling of database startup/shutdown through Crontab.

ACADEMIC PROJECT DETAILS

1) Title : GSM BASED METAL AND CHEMICAL BOMB DETECTING ROBOT

Team : 4 Members, Duration: 4 Months.

Description : This is a latest project in the robot industry. This project focus on the metal and chemical hazardous materials and specifically bombs which will be involved in anti social activates. Technically to say this technology uses 2 sensors, say for chemical Hall Effect sensor similarly metal sensor. On detection of those hazardous mistrials by the sensors use these electronic indicators by flashing light and buzzer. Also this devices control using gsm module trough the mobile communication. The robot will move front, back, left right. These will control from any were around the world and made sure that there would no human intervention at those hazardous places hence human life’s can be secured. Using a camera fixed in the module the activities of the electronic module can be easily control and ministries.

2.”Microcontroller Based Household appliances “

Abstract: This project is mainly used to control the many devices which are commonly used in the home like washing machine,tv,and more. These devices can be controlled by using external command.

PERSONAL DETAILS

Name : Shivakumar.N

Date of Birth : 06-10-1984

Father’s name : Nanjappa

Sex / Marital Status : Male /Single

Languages Known : English, Kannada, and Hindi

Nationality : Indian

Present Address : S/o nanjappa, n.g.doddy

Malavalli taluk, mandya district

Hobbies : Reading, Listening Music, Playing cricket

DECLARATION

I agree that the statements made by me above are true, complete and correct.

Date :

Place : Bangalore. Yours Sincerely,

[Shivakumar.N]

Contact this candidate