Oracle Management

U.SOWMYA

PH: +91-964*******

EMAIL : **************@*****.***

Career Objective

To excel in the field of information Technology as an Oracle Database Administrator by contributing continuously towards organizational growth by providing seemless database support and to utilize every opportunity to achieve both personal and professional development.

Profile

As a Management Trainee, completed intensive full time training program in 10g,11g Oracle DBA, having the below DBA technical skills

Academic record

Education Board/University Year of Passing Percentage %

BTECH

JNTU

2011

69.57

INTERMEDIATE

Board of Intermediate

2007

88.6

S.S.C

S.S.C

2005

85

Software proficiency

RDBMS : Oracle R12,11g,10g/9i

Languages : SQL,PL/SQL

Operating Systems : Windows, LINUX

Tools : RMAN, export, import

LINUX Admin skills

understanding and working with various shells, creating and managing users, files, directories, finding The space utilization, changing permissions, changing the ownerships, searching the files, setting up of umask, through knowledge in vi editor, managing the processes, using system monitoring utilities, scheduling the scripts

DBA skills

Installation:

• Oracle 10g, 11g,R12 software installation on various clients/ servers platforms working with multiple oracle homes.

• Databases using various methods ( dbca ) creating and managing multiple Databases with single oracle home.

• Enabling archiving, Database cloning offline and online,

.

Space Management:

• Creating tablespace.

• Monitoring the database growth on daily basis.

• Resizing datafile size, Adding datafiles as per the space requirement..

• Modification of tablespaces, datafiles.

Security:

• Implement and Maintain Database Security

• Creating / Altering / Dropping Users as and when required and administer their respective quotas.

• Create and Maintain Roles and assign necessary privileges to users according to business requirements.

• Password file authentication.

. .

Backup and Recovery:

• Establish and Maintain Healthy Backup & Recovery Strategies and Procedures

• Performing Hot Backup.

• Recovering the Database without or Minimal Loss of Data.

• Evaluating the Backup & Recovery Procedures on a Test Database to Minimize the Loss on Real Time Scenario.

• Knowledge in configuring and managing backup through RMAN utility.

• Knowledge in Hot and Cold backup and Logical backup

• Knowledge in cloning database.

.

Oracle Networking:

Configured Listeners on server side and TNS Aliases on the clients’ side.

Configuring listener (listener.ora) using netca, netmgr and local naming methods (tnsnames.ora), testing it with tnsping,

Real Oriented Projects Done

Installation of Oracle 10g, 11g (on Oracle Enterprise Linux 64 bit).

User managed backup (using scripts and RMAN).

Catalog Database Creation.

Tablespace Point in time recovery.

Cloning database

. Oracle Applications DBA Skills

• Installed oracle E-business suite in both single node and multi node environments.

• Knowledge in R12 oracle E-business suite architecture.

• Knowledge in maintaining oracle applications using adadmin.

• Applying patches and performing ad activities and several worker issues.

• Knowledge in finding the versions of application files

• Creating Users and Assigning responsibilities using sysadmin

• Knowledge in patching oracle applications, applied patch history.

• Cloning E-Business Suite using rapid clone.

Personal Profile

Name : U.Sowmya

Father’s name : U.Yadagiri

Nationality : Indian

Marital status : Single

Linguistic Skills : English,Hindi,Telugu.

Declaration

I hereby declare that the above information furnished is correct as per my knowledge.

Place: Hyderabad

U.SOWMYA

Contact this candidate