Oracle Database Administrator

CURRICULAM VITAE

Experience Summary:

. * Years of experience as an Oracle Database Administrator and involved

in implementations, backup and recovery methodologies, monitoring

database performance, etc.

. Currently working in Vanz Technologies, Hyderabad as an Oracle

Database Administrator from may 2010.

. Ability to instantly diagnose and apply tuning skills to existing

problems in the database.

. Interpersonal Skills with the ability to work as an individual and as

a team member.

Educational Qualification:

. Bachelor of Technology (B.Tech cse), 2005-2009

Jawaharlal Technological University, Hyderabad, AP,India.

Skill Set:

Databases : Oracle11g, MS Access

Oracle Utilities : RMAN, SQL loader, Export and Import.

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

Operating Systems : Redhat Linux, Unix, Windows XP/NT /2000

/2003

Work Experience:

Organization Designation Period

Vanz Technologies, ORACLE DBA may, 2010 - till

Hyderabad date

As an employee of Vanz Technologies - Hyderabad, as Database Administrator

Since may 2010 - Till Date

ROLES AND RESPONSIBILITIES:

. INSTALLING OF LINUX OPERATING SYSTEM (RHEL 4) WITH ORACLE11G SOFTWARE.

. Creating Primary Database storage structures (tablespace, data files)

and objects like Tables, Indexes.

. Enrolling new users and maintaining system security (Profiles), Roles,

System and object Privileges and managing user quotas.

. Monitoring the unwanted User Session and killing them if needed.

. Rebuild Index to rectify segment fragmentation.

. Identifying Chained Rows and rectify them.

. Loading External Data in to Database (Using SQL *Loader).

. Monitoring Database growth, Re-Organization of Tables.

. Monitor physical and logical backup strategies.

. RMAN backup and recovery

. Monitoring database and collecting statistics by using EXPLAINPLAN,

SQL Trace.

. Managing the Storage Clause for objects depends on the application

such as resizing the objects if need.

. Creation of clone database for the test database environment.

. Logical Backup of Databases using Export and Import Utility.

. Analyze the database performance using diagnostic tools and gathering

the statistics based on statspack reports.

. Attending to day-to-day problems in the Oracle database and taking

suitable actions for trouble shooting including Helpdesk Management

and Documenting Day-to-Day Activities and fixes.

Project Details: managing information system

CLIENT : PC 3000 INTERNATIONAL, DUBAI

Environment : RHEL4, Oracle 11g, WINDOWS 2000

Role : Associate Database Administrator

Project Details:

PC 3000 is a trading company situated in Dubai, which does Trading business

buying Electrical and Electronic goods from different clients situated in

various countries and sell the product to its customers at various

countries. Hence this system maintains an Inventory control system, which

stores items, and its stock details on one hand and buying and selling rate

of each unit of item along with it on another hand. Movement of Items and

Break-Even analysis are shown periodically.

Responsibilities:

. Provided regular DBA support for the database servers.

. Database administration, managing tablespaces, objects, diskspaces.

. Creation of oracle users, oracle roles, granting privileges and

profiles etc.

. Monitoring the database growth, Re-Organization of Tables

. Performed online backup for the entire database

. Monitoring the scheduled backups

. Managing redo logs, checking alert log and trace files for database

performance.

. Provided 24x7 on-call technical supports.

. Monitoring database and performed SQL tuning, troubleshooting

including analyzing traces, reorganizing table spaces, tables and

indices. Utilized explain plans and using STATSPACK for performance

tuning

Project Details: FINANCE MONITORING

CLIENT : LEOMAX FINANCE LTD, SINGAPORE

Environment : RHEL4, Oracle 11g

Role : Associate Database Administrator

Project Details:

The Leomax smart lend caters Lending solutions to all Non-Banking

Financial institutions helping in their day to day operations to complete

their services to their customers within the stipulated time on one hand

and taking necessary reports and projections on income in time on another

hand. The Product is broadly classified into different modules such as

Application and Credit Processing, Disbursements to Dealers, Contract

Creation, Collection and its statistics; Contract Maintenance includes Re-

schedulement and Closure.

Responsibilities:

. Creation and Maintenance of Oracle Databases as per the requirement.

. Creation of schema with quota maintenance.

. Creation of oracle roles, granting privileges and profiles etc.

. Implement backup strategies (regular Hot and Cold backups and logical

backups.)

. Managing undo segments redo logs, Checking alert log and trace files

for errors.

. Development and Implementation of Database Backup Strategy, hot &cold

backups.

. Development and Implementation of Database Recovery Strategy, Complete

and Incomplete recoveries.

. Performed logical backups using Export/Import utilities.

. Analyze SQL statements using Explain Plan

Personal Details:

Father's Name : Mohammed Shareef

Martial Status : Unmarried

Date of Birth : 05-06-1987

Passport Details : G9643801

Contact Address : Plot No 80,S.G.R Township, Ragannaguda (Village),

Turkayamjal, Hayathnagar Mandal,

R.R.Dist,AP-501510

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

Mobile : 990-***-****

Contact this candidate