Oracle Manager

Basker Dubbaka

*****-***.***@*****.***

Mobile: +46-723******

[pic] [pic]

Personal Skills: Comprehensive problem solving abilities with good attitude

and aptitude, having enough communication skills, flexible, interest,

sincerity, fast learning, self motivated, hard work, persistence, ability

to lead effectively, team builder and facilities.

Main Strength: I am a dedicative, deterministic, hard working person with

good logical thinking, positive attitude, adaptable to any kind of

environment and having well leading skills.

Professional Experience

* Worked as Oracle DBA in Tata Consultancy Services, Hyderabad.

Duration: December October 2007 to November 2008

* Worked as Oracle Developer in Apollo Computing Laboratories,

Hyderabad.

Duration: June 2005 to January 2007.

Certification & Training:

. Oracle Certified Professional on 11g (OCP) ID-OC1105908

. Oracle Certified Associate on 11g (OCA) ID-OC1105908.

. Undergone Professional Training on Oracle DBA, SQL, My SQL, PL/SQL,

and Developer Suite 2000 in iVAS Software Solutions from December 2011

to February 2012.

Current Status: Working as official consultant for University of Boras,

Sweden.

Software Exposure:

Operating Systems : Windows-2000, Windows-XP, Linux.4, UNIX

Programming Languages : C, SQL, PL/SQL, Shell Scripting, PHP, HTML

Database : Oracle DBA, 10g RAC, Developer Suite 2000, My SQL

Database Tools/Utilities : Forms & Reports, RMAN, Data Pump, OEM

Application Package : Ms-Office 2007

Educational Profile:

. Master of Science in Industrial Engineering from Boras University,

Sweden .

. Bachelor of Engineering in Mechanical Engineering from Andhra

University, Visakhapatnam.

. D.M.E from C.R .Polytechnic, Chilakaluripeta.

. S.S.C from Z.P.H.S, Gudur.

Professional Summary:

. Possess 2+ Years of Real time Experience as DBA and Oracle Developer.

. Worked on Oracle 11g/10g/9i databases as a Database Administrator.

. Experience in handling DBA duties such as oracle Software installation

and creation of database, backup & Recovery and Production Database

Maintenance.

. Tablespaces creation, proactive space management, user management,

database security imposition by creation and granting of roles,

privileges and assigning quotas.

. Expertise in backup & recovery strategies through physical & logical

backups.

. Exposure in RMAN Backup & Recovery strategies.

. Also included in frequent interaction with Developers, and working

with them in developing the applications using SQL Trace and Explain

Plan utilities.

. Involved in configuration of DataGaurd (physical standby database)

. Involved in Implementation of Oracle 10g 2 node cluster on Red Hat

Linux.

. Installation Clusterware Software and Configure the ASM with RAW

Slices.

. Involved in performing database Upgradation as part of new release.

. Applied database patches using Opatch utility.

. Ability to interact with end users, self-motivated, quick learner and

team player with good communication skills.

. A quick learner with an ability to rapidly achieve organizational

integration assimilates job requirements and employs new methods and

technologies.

Project Profile

Project #1

Client : Johnson and Johnson.

Role : Oracle DBA

Duration : October 2007 to November 2008

Team Size : 6

Platforms : Linux

Responsibilities:

* Implementation of Oracle 10g 2 node RAC on Red Hat Linux

* Upgradation of Oracle database from 9.2.0.3 to 10.2.0.2.

* Worked Extensively on ASM Disk group Management activities (Like Add

disks as per requirement, planning the database growth for near

feature).

* Backup & Recovery - Hot backup and Export/Import

* Monitored the growth of Tablespaces and resolve fragmentation issues.

* Refreshed QA and Development Environments with Data pump and RMAN

duplications

* Environment creation for all supported environments as per the

Requirement i.e. Development, Test, Production

* Tuning SQL statements using Explain Plan, SQL Trace & AWR.

* Created users, granted privileges and created user profiles

* Managing Redo log files in archive log mode for online backup.

* Monitored table spaces & their growth and took proper actions.

* Involved in configuration of DataGaurd (physical standby database).

* Cloning the database though RMAN as per the requirement.

* Apply critical Oracle patches

* Customer interactions and troubleshooting

#Project: Goods Inwards System (GIS)

Duration: October 2006 to January 2007

Environment: Oracle 10g and Developer 2000 (Forms 6i and Reports 6i)

Description:

Goods Inwards System (GIS) is an integrated Module, which covers the

activities of Stores, Purchase and Goods Inwards Functions of a

Manufacturing Organisation. This Module has provisions to capture Supplier

Details (Vendors) required for the Purchase Department. It facilitates

Stores to check the stock of the Raw Materials used and System

automatically places Purchase Requisitions to the Purchase Department.

Purchase Department can place Purchase-Orders and keep track of the Work-

orders given to the Vendors. When the raw material is received,

corresponding Stock is updated.

As a Software Engineer the responsibilities for this project included:

Involved in Design Reviews and Code Reviews.

Involved in Coding, Unit Testing, Supporting Testing Personnel, Preparing

Unit Test Cases for the Modules.

Developing GUI Screens and Reports using Forms 6i and Reports 6i, Written

Oracle Back-end Procedures, Packages and Triggers.

Involved in Database creation, Managing Table Spaces, Estimating Storage

requirements for Database objects, Auditing etc

#Project : GCIX (Global client information exchange)

Duration: June 2005 to October 2006

Role: Team member

Description:

Database Controlling has committed to build a replacement for the existing

GCPC system. This solution named G-CIX or Global Customer Information

Exchange.

An important design goal of G-CIX is the timely provision ? reporting - of

flexible and detailed revenue information by client to these Relationship

Managers.

In this manner, G-CIX will efficiently utilize Business Processes and IT

resources that are already in place.

A key responsibility would be that of providing accurate and consistent

Customer and Revenue data.

Developed Forms.

* Developed stored procedures for various requirements of this domain

* Managing and Co-coordinating the team

* Providing solutions to technical issues

* Testing unit developed by other developers.

* User support and maintenance of the system.

Environment Oracle 8i (SQL*Plus & PL/SQL), Forms 6i.

DBA SKILLSET

. 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 .

. Security via Virtual Private Database using ROW/COLUMN level

Masking.

. Flashback Database with rvwr (Recovery Writer).

. Backup and Recoveries using Recovery Manager (RMAN).

. Creation and execution of RMAN scripts.

. Automatic Storage Management (ASM).

. Duplicate database using RMAN.

. Duplicate database using RMAN on Remote Server.

. Standby Failover, Switchover and Flashback failed Primary Servers.

. Read Only Standby, Active Dataguard,Snapshot Standby

Achievements :

. Successfully migrated non ASM database to ASM .

. Successfully installed Oracle 10g setup over Linux AS4 OS .

. Successfully upgraded database from 10.2.0 to 11.1.0 .

. Successfully solved client connection errors .

. Successfully recovered database from Controlfile crash with backup

controlfile using HOT backup after RESETLOGS .

. Successfully applied PSU and CPU patches.

Projects in Master's level:

. Master thesis on "Role of Information Technology in Lean Enterprise

Systems" URI: http://hdl.handle.net/2320/6642

References:

Company: iVAS Software Solutions

Name: Prathibha

Designation: HR Manager

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

Company: Apollo Computing Laboratories

Name: B.Karunkar Reddy

Designation: Project Leader

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

Personal Profile:

Name : D.Baskar

Qualification : M.Sc

Languages Known : Telugu, Hindi, English and Basic Swedish

Gender/marital Status : Male/Married

Hobbies : Listening music, Playing Cricket.

(D.Baskar)

Contact this candidate