Oracle Manager

Bhaskar

Cell: 510-***-****

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

Objective:

As one of the outstanding Oracle Database Administrators in the industry,i

seek opportunities to apply my expertise towards solving large, complex IT

challenges. I have lead various project in 11g/10g/9i/8i using RAC and ASM

for High Availability, Streams for replication, Data guard for Disaster

recovery, RMAN for Backup and recovery. My knowledge, experience and

expertise can help you gain the efficiencies and cost saving, that

organizations are demanding of their IT organizations, expenditures and

budgets.

summary:

Over 8 years of professional experience in Oracle Database administration.

Expert in areas of Oracle 11g/10g/9i/8i, PL/SQL, SQL, SQL*Plus, SQL*Loader.

Expert in Installation of Oracle Database server and clients.

Experienced in Unix, Sun Solaris, HP-Unix, AIX5L, Windows XP/2000/NT/98/95.

Expert in Building RAC, Streams Replication, and Standby Data guard

databases.

Experienced in Backup and recovery using RMAN, Tivoli Data Protection,

Netbackup, Legato Backup and export/import

Expert in troubleshooting and Performance Tuning of Oracle databases using

AWR/ADDM reports, Statspack report, TKPROF, Explain Plan, SQL tuning.

Experienced in SQL * loader, logminer, transportable tablespaces.

Expert at creating and modifying Database objects (e.g. Tables, Indexes,

Views, Sequences, Functions, Procedures, Triggers, Stored Procedures and

Packages).

Experienced in C, C++, Java, Perl, Shell Scripting, XML, HTML.

Expert in SOX, PCI and HIPPA Regulations implementations and compliance.

Experienced Production, Test, and Development DBA.

Experienced in Co-ordinating offshore projects and teams in US, UK and

INDIA

Excellent communication and inter-personal skills, leadership qualities.

Ability to lead and serve as a major contributor of a team effort.

Industry concentrations as follows:

o Entertainment

o Telecommunication

o Energy

o Manufacturing

sKILLS:

Database: - Oracle 11g/10g/9i/8.x

Operating System: - UNIX, Solaris, HP-Unix, AIX5L, Linux, Windows

Languages: - PL/SQL, SQL, SQL*PLUS, Perl, Shell Scripting

Web Development: - XML, HTML, ASP, JSP

Web Servers: - Weblogic, Apache Web Server

Tools: - SQL*PLUS, TOAD, Sql Navigator, PUTTY, OEM Grid Control, RMAN,

SQL* LOADER, Imp/Exp and Data pump.

professional experience:

Walt Disney / IBM Orlando,

FL Oct 07 --- Till

Date

Role: Sr. Oracle Database Administrator

Walt Disney World is one of the biggest client for the IBM which has around

250 database's which includes production, development, integration, QA,

staging, stress test, training and user acceptance. Among them most

critical applications were ODS, One source, CRM, Disneyland retail pricing

optimizer and so on.

Responsibilities:-

. Installed and configured Oracle 11g/10g/9i databases on Sun Solaris.

. Upgrade of oracle 9i to 10g on Sun Solaris.

. Migrated databases from Sun Solaris to HP unix, AIX.

. Implemented RAC for different Prod and UAT system.

. Implemented Data Guard for Disaster recovery

. Tuned the databases using AWR/ADDM, STATSPACK, ESTIMATE, ANALYSE,

INDEXES, EXPLAINPLAN, SQLTRACE and TKPROF.

. Experienced in performance tuning at Instance level (SGA and PGA) and

database level using SQL plus and OEM.

. Proactively identified issues/bottlenecks that are potential problems.

Involved necessary support teams Application, Unix, Network, Storage

etc. and took a corrective action to rectify the issues.

. Trouble-shooted daily issues in the alert logfile's which are

monitored through the script.

. Performed Schema Management, Index rebuilding, Analyzing the tables

and removing the row chaining and row migration.

. RMAN & SQLBACKTRACK configuration for scheduling backups.

. Database refreshes from Production to development databases.

. Performed database cloning to create Test and Development environments

from Production.

. Capacity planning considering future growth with different hardware

and software requirements.

. Database design physical and logical model as per application

requirements.

. Design and Implement database security, auditing and user management

for Supporting developers in tuning and optimal performance

. Efficient in coordination of one-off patches, CPU patches to implement

database changes.

. Written various Shell Scripts for production, development and QA

databases such as startup, shutdown, backup, analyze statistics and

generate consolidated status reports.

. Supported Oncall pager 24x7 support rotation across the team

members.

Environment: Oracle 11g/10g/9i, RAC, Data guard, RMAN, Sun Solaris, HP

UNIX, AIX, Citrix, Service centre, Manage Vnc Viewer, Reflection, Putty,

SFTP, FTP, rlogin

Verizon Tampa,

Florida

Mar 07 - Sept 07

Oracle Database Administrator

. Installation, configurations of multiple Oracle 10gR2 RAC environments

with Oracle Clusterware (CRS) on two node clusters.

. Performed planning and configuration for HA (High Availability)

services.

. Implemented Oracle Streams replication in oracle 10gR2 Databases.

. Upgraded oracle databases from 10.2.0.1 to 10.2.0.3

. Configured OEM Grid control for Monitoring and Notification of

databases.

. Configured Oracle RMAN backups and recovery.

. Configured Oracle data pump (expdp).

. Provided backup support for production DBA.

. Applied CPU patches for July and other oracle related patches for

Streams replication.

. Installed and configured 10g Enterprise Manager and Grid Control.

. Patched Oracle Database Server 10g using Opatch.

. Supported development effort by providing SQL statement tuning and

optimizing ETL procedures and removing load.

. Query performance bottlenecks by using tools Explain Plan, SQL Trace,

Tkprof, TOAD and Oracle Enterprise Manager.

. Established database backup/recovery strategy for different databases.

. Applied different recovery procedures for complete and incomplete

recoveries depending on the type of failure.

. Proactively monitoring, identifying areas that need to be improved in

the application and database using AWR, ADDM and 10g OEM Grid

Monitoring.

. Setting up and maintaining user accounts and profiles.

. Provided on-call support regarding production-related database

problems

Environment: Oracle 11g/10g R2 RAC, Sun Solaris 5.10, ASM, ERWIN, GRID,

AWR, ADDM, OEM, Data Guard, Reflection,Shell TSM and perl Scripts

British Petroleum /IBM

INDIA Aug 05 - Feb

07

Oracle Database Administrator

Responsibilities:-

. Maintained about 100 database's in production, development and

integration.

. Installed Oracle software on Solaris and Windows, Create New

databases, Install Oracle client and set up the tnsnames entry

according to client specifications.

. Regular backup of Production database using RMAN/Hot backup using

Tivoli, archival methods, and regular testing of recovery in test

environment & and in clone database.

. Good experience in backup and recovery using RMAN.

. Database Upgrade and Security Patching

. Migrated Oracle 8i/9i databases to Oracle 10g.

. Setup physical standby database as part of disaster recovery plan.

. Managing various kinds of backup and Recovery Issues, online backup

and offline backup

. Oracle database performance tuning using statspack, explain plan,

tkprof and OEM.

. To work as team player in 24x7 environment, for resolving any problem

tickets logged by the client with IBM Help Desk.

. Adhere to IBM policy and commitment towards the project, and to

dispose all available recourses for timely resolution of the problem

ticket.

. To co-ordinate with the client for appropriate down time for the

databases for any change management activities, keeping in mind the

production loss.

. Daily house keeping activities like checking database growth and

taking appropriate actions for capacity management

. Making changes to the parameter file as requested by the customer and

ensuring a clean database startup for the changes to take effect

. Oracle User management tasks including creation of User Accounts,

assigning privileges, Password change and dropping user as per client

request.

. Safe Guarding Customer Data by ensuring that tables with sensitive and

critical data can be accessed by only selected group of users as per

client requirement

. Create and maintain documentation and standards.

. Performed the health check for every quarter.

Environment: NT/2000/2003, Sun Solaris 5.x, AIX 4.3,5L Manage Now,

Putty, RDP, CPMA, Tacacs, Oracle 8.x/9i.x/10g,Xmanager,Vnc Viewer, Humming

Bird, Aventail

Telecommunications/BSNL

INDIA June 01 -

June 05

Oracle Database Administrator

BSNL(Bharat Sanchar Nigam Limited) is India's largest telecom company.

Dotsoft package developed by AP TELECOM Hyderabad circle office.DOTSOFT

Package deals with Telephone billing/Commercial/Fault booking/Directory

Enquiry fields of any Big Telephone Exchange having line capacity more than

300k.This package consists of 4 modules including Sub-Ledger processing.

Responsibilities: -

. Maintained about 100 databases which were production and

integration.

. Installed Oracle software on Linux Create new databases as per

requirement.

. Regular backup of Production database using RMAN

. Performed installation of Oracle software products and database

creation and upgrade.

. Managing various kinds of backup and Recovery Issues, online backup

and offline backup

. Monitoring the Database for growth and add space to the tablespaces.

. Refresh of the integration database from the production database.

. Configured Oracle Data guard for production database.

. Write shell script for hot backup and monitoring the DBA activities.

. Oracle database performance tuning using statspack, explain plan,

tkprof and OEM.

. Responsible for data integrity and user security.

. Managing Partition Tables & Indexes.

. Perform consistent system performance review. Identify problems that

may occur in the future before they occur.

. Perform database re-organizations as required to assist performance

and ensure maximum uptime of the database.

. Implemented backup and recovery strategies for archiving and non-

archiving databases

. Participated in planning and implementation of off-site Disaster

Recovery planning and testing.

. Create and maintain documentation and standards.

. Checking the database backuplogs and alertlogfiles and fix the issuse

based on the error.

. Daily schema level backups using export utility and weekly full

database backup

. Perform database upgrade patch on Oracle database.

. Other DBA tasks like space management, rollback segments, Extents,

invalid objects, DB links and tuning, Partitions, loading data for

users, procedures and tools used using utilities like import, export.

. Trained the BSNL staff about the usage of application.

. Created application responsibilities, users and providing privileges

Environment:- Windows 2000, IBM AIX 4.3.3, Putty,Remote desktop,Vnc

viewer,Reflection, Oracle 8.x, rlogin,Oracle Forms & Oracle Reports

education:

Master of Computer Application Osmania University, Hyderabad,

INDIA

Bachelors of Computer Science Osmania University, Hyderabad,

INDIA

Contact this candidate