Oracle Management

ARUN BONTHU

Mobile No: +91-846*******

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

CAREER OBJECTIVE

To make strong career as Oracle DBA for challenging and critical environment

EDUCATION

• B.Tech(IT) from SwarnaBharathi College Of Engg (JNTU hyd) with 55% (2010)

• Intermediate from Aditya Jr. College with 66% (2006)

• SSC from Z.P.High School with 76% (2004)

CERTIFICATIONS

• Oracle Certified Associate DBA (ID: OC1120139).

TECHNICAL SKILLS

• Programming languages : .NET, HTML(Basics)

• Databases : ORACLE

• Operating Systems : Windows XP, Windows 7,RHE Linux 4

TRAINING ATTENDED

• Oracle 10g Database Administration

• Oracle SQL and PLSQL

DUTIES& RESPONSIBILITIES

• Ensure Primary/Standby database availability

• Monitoring successful Backups at standby database

• Ensure client failover for standby database in case of crash

• Successful switchover of standby to production in case of crash

• Verify that the primary database logs are being applied to the standby database

• Ensure Oracle listener functionality

• Monitoring and verifying successful backup completion (Cold/Hot/Rman)

• Oracle 9i & 10g & Linux AS 4 Installation

• Refresh database (Cloning)

• Refresh controlfile

• Monitoring and verifying successful backup of Archivelog files

• Monitoring and Analyzing Index /Table space fragmentation

• Rebuilding Indexes/Tables when appropriate

• Check for Row Chaining and take corrective actions

• Check and resolve in-doubt transactions

• Check and resolve/terminate Hung connections

• Check snapshots/materialized view refresh and resolve issues

• Check alert log for Oracle errors and take necessary corrective actions

• Check Sqlnet log for errors and take nessary corrective actions

• Check for core dumps and remove them

• Monitor and track file system space usage for databases that have files with “autoextend on” enabled

• Trim alert log and sqlnet logs every two months

• Maintain Buffer Cache Hit ratio above 85%

• Maintain Library Cache Hit ratio above 90%

• Maintain Dictionary Cache Hit ratio above 90%

• Check CPU and Processor usage using TOP command

• Configuring and Monitoring OEM

• Working closely with system administrator to install all software and patches

• Monitor and optimize the performance of the database

• Creating new users and manage privileges

• Created and managed different kinds of tablespace issues and Storage parameters

• Check the running processes, memory, paging, block IO, traps and cpu activity using VMSTAT command

• Check the zombie processes running and kill them using KILL command

ORACLE DBA SKILLS

• Complete user management and profile management

• Excellent in Standby databases

• Configuration of Disaster Recovery Setup

• Having Sound knowledge of RMAN

• Monitoring backups of database

• Reorganizing Database

• Getting deleted data by applying Required archives to DBMS_LOGMNR package

• Oracle 11g new topics

• Streams Replication

• Security via Virtual Private Database using ROW/COLUMN level Masking

• Flashback Database with rvwr(Recovery Writer)

• Backup and Recoveries using Recovery Mananger (RMAN)

• Creation and execution of RMAN scripts

• RMAN copy command ,TSPITR and Block recovery

• Automatic Storage Management (ASM)

• Duplicate database using RMAN

• Duplicate database using RMAN on REMOTE SERVER

• Backup based duplication and active database duplication

• Standby FAIL OVER,SWITCH OVER and FLASHBACK failed Primary Servers

• Read Only Standby, Active Dataguard, Snapshot Standby

ACHIEVEMENTS

• Successfully implemented standby on HP-UX servers

• Successfully migrated non ASM database to ASM

• Successfully installed Oracle 10g setup over Linux AS4 OS

• Successfully installed Oracle 10g and Oracle 11g on RHEL5 OS

• Successfully upgraded database from 10.2.0 to 11.1.0

• Successfully solved client connection errors

• Successfully recovered database from SYSTEM file crash using HOT backup

• Successfully recovered database from CONTROLFILE crash with backup controlfile using HOT backup after RESETLOGS

• Successfully completed Object Point in time recoveries using HOT and RMAN backups

• Successfully applied PSU and CPU PATCHES

PROJECT UNDERTAKEN

Academic Project : Application for simulating call center capacity requirements

Period

Front-end

:

: 4 Months (Completed on March 2010)

ASP.NET with C#.NET

Back-end : SQL Server 2005

Role : Application Designer

Description

: Using this application, call center management can simulate and arrive at the optimal resource capacity for the excepted volumes. They can also predict the resource requirements for future, by simulating expected workload and call volumes based on the projects in the pipeline.

PERSONAL INFORMATION

Sex and Marital Status : Male and Single

Father’s Name : Mr.B.DavidRaju

Age : 22years

Date of birth : 01-06-1989

Nationality / Citizen : Indian

Language Proficiency : English and Telugu

Hobbies : Traveling, Listening to music

Having Valid Passport : YES

Address : #3-65, Siddhard Nagar,

G.Vemavaram,

I.Polavaram (mandal),

East Godavari (Dist.),

Pin 533464

I hereby declare that the above mentioned information is correct to the best of my knowledge.

Date:

Place: Hyderabad (B.Arun)

Contact this candidate