Oracle Management

G.SIVANANDA REDDY

E-mail : ***********@*****.*** Phone: +91-974*******

Objective

To acquire a highly motivating career where I can learn, serve and grow with the organization.

Trainings Undergone:

Trained on Oracle DBA course in Wilshire Technologies, Hyderabad.

Trained on oracle PL/SQL in Naresh Technologies, Hyderabad.

4 years in the field of Oracle database administration & Operating systems.

Hands on experience on Oracle 11g, 10g, and 9i versions.

Having hands on experience and Good knowledge in different environments like HP-UX, SUN SOLARIS, AIX, Linux and Windows.

Interpersonal Skills with the ability to work as an individual and as a team player

Ready to work in anywhere India and I can work in 24X7 environments.

KEY STRENGTHS:

RMAN, Cloning the database, Creating the duplicate database with RMAN.

Experience in Upgrading databases. (10.2.0.1 to 10.2.0.4 & 9i to 10g)

Implementation of high availability solutions with Oracle 10g Physical Standby database, Data Guard, Materialized views.

Having Good Knowledge in Process: Incidents, Changes, Service requests and their severity, Escalation Matrix, etc.

Good Knowledge on Applying patches under UNIX, Linux and Windows platform.

Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.

Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity).

Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental.

Used TKPROF, AWR, ADDM, TOAD for SQL Tuning and Performance tuning

Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.

Hands on experience with Installation, Configuration, Oracle Data Guard, Disaster Recovery and Patching, upgrading and administering Terabytes of Oracle Databases on Oracle 10g/9i.

Oracle Enterprise Management (OEM) with standard management, Jobs, diagnostic, tuning, and change management packs to perform various administrative tasks.

ACADEMIC_QUALIFICATION:

NAME OF COURSE BOARD/ UNIVERSITY PERCENTAGE YEAR

M.C.A Sri Krishnadevaraya University 69% 2012

B.Sc (Computers) Sri Krishnadevaraya University 70% 2009

XII A.P.BOARD 53% 2006

X A.P.BOARD 59% 2003

TECHNICAL SKILLS:

RDBMS/DBMS Oracle 9i, 10g and 11g.

OS Sun Spark 5.10,IBM-Aix, Linux 3.0 & Windows server .

Database Utilities Data pump, Exp/Imp, Data guard, AWR and ADDM.

Languages C, C++, SQL, PL/SQL, Unix Shell scripts

Tools OEM, TOAD, RMAN, SQL Loader.

Projects

Project : Lead Management System

Environment : Oracle 10g

Role : Database Administrator

Location : Hyderabad

Responsibilities:

• Oralce home installed in 3 windows servers.

• I have created databases for Dev/Test/Prod environment.

• Created Database objects related to this project

• Created users & their connectivity

• Performing Environment refresh using Datapump (Expdp / Impdp) utility.

• Monitoring database and performed SQL tuning, Analyzing traces, Gathering table/schema statistics, Analyzing tables and indixes.

• Analyze the database performance using diagnostic tools and gathering the statistics using AWR.

Personal Details

Date Of Birth 7th Jan 1988

Gender Male

Marital Status Single

Phone +91-805*******

E-mail ***********@*****.***

Languages Known English, Telugu and Hindi.

Contact this candidate