Oracle Manager

CH.DATTADRI

Mobile: +91-991*******

E-Mail: *****.***@*****.***

To get a challenging position where I can put my all experience and knowledge to give a

significant growth to the organization

Certification

• Oracle 10g OCA Certified

Profile Snapshot

• Have a 5 months experience as SQL Developer

• Have 2 Year experience as Junior DBA.

• Extensive experience in writing complex sub queries

• Good understanding of the Oracle database, related utilities and tools

• Ability to write complex SQL queries

• Strong technical acumen of Oracle 9i/10g/11g Administration

• A team player with strong communication, analytical, organizational and relationship

management skills

• Experience in working with Tools like Oracle Enterprise Manager’s(OEM’s)

• Hands on experience in database backup and recovery strategies using RMAN

Export/Import, Cold, Hot backups

• Planning and scheduling the Physical backups as well as Logical backups

• Managing the production database for Oracle Server and resize the space of

database/Datafile/Tablespace/Transaction Logs

• Creating, updating, Altering Tablespace, Indexes, Tables, Views,Synonyms, Profile,

Role, Privileges

• Creating/Managing users profiles and analyzing their privileges and tablespace quotas

• Excellent experience Installation and Configuration of different databases on Operating

Systems UNIX and Windows Platforms .

• Monitoring Schema objects(Tables and Indexes) growth

• Monitoring users and transactions

• Confirm that backups have been made and saved successfully in the defined location

• Checking Alert logs Files,Trace Files, System Event Logs for unusual events

Work Experience

Company : Bharadwaja TechLabs, Hyderabad,

Role : SQL Developer

Key Responsibilities handled

• Creating Tables, views,indexing.

• Create user and grant privileges .

• Experience in writing SQL queries and optimizing the queries

• Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored

Procedures, Indexes, and Constraints

• An excellent team player & technically strong person who has capability to work

with business users, project managers, team leads, architects and peers, thus

maintaining healthy environment in the project

• Excellent written, communication and Interpersonal skills.

• Using SQL to query DatabasesPerforming various validations

• Providing high level security for the database by creating proper primary keys and

secondary keys

• Resolve any issues related to the database after deployment of the software at the client

side

• Authenticating and authorizing users

Company : Bharadwaja TechLabs, Hyderabad,

Role : Junior Database Administrator

Key Responsibilities handled

• Installing, configuring and upgrading of Oracle software.

• Conducting physical database design & creation; devising strategy for backups using RMAN,

hot backup, cold backup and logical backup & recovery.

• Creating of table spaces, user maintenance, database security imposition by creation and

granting of roles and privileges.

• Providing technical support to application development teams.

• Interfacing with Oracle technical teams for upgrades, latest version.

• Monitoring the performance of database using performance tools such as AWR, and ADDM .

• Handling tablespaces, data files, redo logs, tables and its segments.

• Creating & administering all database objects, including tables, indexes, views, sequences,

packages and procedures.

• Involved in creating and managing users and objects

• Involved in assigning roles and privileges to different users

• Responsible for solving the database related queries .

• Managing daily and weekly report

• Daily Health check of the Database

• Involved in creating tables and indexes, views. Hot and cold backup

Academic Details

2012 : MCA From R.G KEDIA COLLEGE, HYDERABAD, OSMANIA UNIVERSITY

2008 :B.Sc(Comp) From GOVT.DEGREE.COLLEGE, ARMOOR, OSMANIA UNIVERSITY

: 12th From NARENDHRA JUNIOR COLLEGE, ARMOOR

2004

: 10th From Z.P.H.S ANKSAPOOR

2002

Technical Knowledge

1

2 Database : Oracle 9i/10g/11g

Tools : RDBMS, DBCA,OEM,SQL/Oracle Trace, Emp/Imp, SQL * Loader,

RMAN,AWR,ADDM

3

4 Operating Systems : Windows, LINUX

Languages :SQL,COREJAVA,J2SE,J2EE,HTML,CSS,

JAVASCRIPT,XML.WORDPRESS.

Contact this candidate