Project Oracle

Deepak Pratap Singh (Oracle DBA)

Email:****************@**********.*** Contact: +1-408-***-****

[pic]

A graduate engineer (B.E.), having initiated the IT career on March

****, ****** *.* ***** of total work experience in I.T., involved in Oracle

Database Administration, Oracle Apps & Database Administration, Oracle

Applications Troubleshooting and Unix Administration across multiple

domains, seeking to consolidate the already acquired knowledge and skills

and work with challenging opportunities.

Experience Summary

> Having 4+ years of total Oracle DBA experience.

> Ability to learn quickly and apply new skills to existing problems.

> Interpersonal skills with the ability to work as an individual and as

a team lead.

> Creation, configuration and administration of Oracle databases

(9i,10g)

> Over 4 years of experience in installing, configuring, patching,

cloning and managing Oracle databases.

> Have good knowledge of Oracle architecture.

> Have experience in database refresh and health checks.

> Experienced in upgrading the database from 10.2.0.2 to 10.2.0.4.

> Experienced in hot and cold backup and recovery scenarios.

> Database recovery in various scenarios.

> RMAN backup and recovery skills.

> Automated backups/batch jobs like export & import, database

monitoring, database maintenance using UNIX shell scripts.

> Expertise in tools like REMEDY (Incident management, CRQ, work order),

PRECISE, PATROL, TOAD, PUTTY.

Skill Set

Database : Oracle 9i and 10g

Operating System : Linux, Sun Solaris, AIX

Tools : RMAN, PRECISE, PATROL, REMEDY, TOAD, PUTTY

Languages : SQL9i, PL/SQL, C, C++

Educational Qualification

> B.E. - 2005 from RGPV University, Bhopal (MP)

> 12th - 2000 from MP Board, Bhopal (MP)

> 10th - 1998 from MP Board, Bhopal (MP)

Project Summary

Project Details:

#1 Project Name ET&D DBA Operations

Client Bank of America

Role Shift Lead

Environment Oracle 9i/10g, LINUX, SUN SOLARIS, AIX

Organization Bank of America Continuum India Pvt. Ltd.,

Hyderabad

Duration Apr'2010 till date

Project Description:

Bank of America Corporation (NYSE: BAC) is a financial services company,

the largest bank holding company in the United States, by assets, and the

second largest bank by market capitalization.[5][6][7][8] Bank of America

serves clients in more than 150 countries and has a relationship with 99%

of the U.S. Fortune 500 companies and 83% of the Fortune Global 500. It has

more than 2000 databases (production, development and staging). This

involved centralized administration of around 2000 databases as a 24*7

support system. For space monitoring and file system monitoring BMC Patrol

is used and Remedy ticketing system is implemented to register any type of

database issues. Backup and recovery is done using RMAN and also using the

Operating System tools.

Responsibilities:

> Oracle database support and maintenance.

> Reporting to management with daily health check reports of databases

for preventive measures.

> Providing *24/7 support for all the databases.

> Monitoring alert log and system log files.

> Troubleshooting Oracle connectivity issues.

> Monitoring cold and hot RMAN backup scripts of the databases

supporting different applications.

> Performing export & Import with conventional and direct path.

> Generating AWR reports when required.

> Taking care of Rollback/Undo segments.

> Taking Oracle traces and providing the output of tkprof and explain

plan to development team.

> Taking care of tablespace related issues like increasing the storage

parameter values, resizing the datafiles, adding new datafiles etc.

> Installed different versions of Oracle client on machines.

> Performed RMAN refreshes.

> Created Database and tablespaces, users and all DB objects.

> Upgraded Oracle 10.2.0.2 to 10.2.0.4

> Applied several bundle patches on database as per the request

including CPU patches.

> Performed Production & Dev releases.

> Managed several alerts related to database and filesystems.

> Installed Patrol and Precise on databases and setup blackout and event

settings.

> Reorganizing the database at regular intervals to remove fragmentation

in databases using export and import utilities.

> Creating users when requested and granting them appropriate roles and

privileges.

> Solving different database related issues like taking care of

different processes consuming high CPU resources, listener, connect

string etc...

> Monitoring and resolving lock related issues.

> Database links creation to access the data from remote databases.

> Interacting with other teams frequently in order to resolve various

issues.

#2 Project Name Qtel Oracle EBS upgrade

Client Qatar Telecom

Role Team Member - Oracle Apps DBA

Organization Satyam Computer Services Ltd.

Duration Feb '08 - March '09

Team Size Project: 8 Module: 2

Environment Application: Oracle Applications 11i

Database: Oracle Database 10g

O/s: HP-Unix

Project Details:

Qtel is Telecom giant in Qatar. They are the responsible body for providing

high quality voice and data services.

This project was up-gradation and migration project. New system was to be

migrated with 11i with 10g database. In addition to this the new system has

to be deployed on new platform as well as with HA architecture. The project

was a challenging task due to its complex architecture.

Responsibilities:

> Requirement gathering and research and analysis on source systems.

> Installation and maintenance of Oracle Applications 11i

> Analyzing and suggesting the best and low cost architecture according

to clients need.

> Suggesting on backup and routine server maintenance policies.

> Cloning from Multi-Node shared architecture to Single Node

architecture.

> Testing on various issues and migrate them to Production.

> Supporting the Production Instance.

> Upgrading application 11.5.9 to 11.5.10.2

> Upgrading database 9i to 10g

> Configuring load balancers with Application

> Implementing shared application tier file system

> Implementing DMZ

> Integration of discoverer 10g with 11i

#3 Project Name DCS DBA INDIA PRACTICE

Client Merrill Lynch

Role Team Member

Environment Oracle 9i/10g, LINUX, SUN SOLARIS, AIX

Organization Satyam Computer Services Ltd.

Duration July '06 - Dec'07

Project Details:

Merrill Lynch, a mutual fund company having around 1000 databases (450

production and development and staging). This involved centralized

administration of around 1200 databases as a 24*7 support system. It

consists of 3 types of databases like production, development and staging.

For space monitoring and file system monitoring BMC Patrol is used and

Remedy ticketing system is implemented to register any type of database

issues. Backup and recovery is done using RMAN and also using the Operating

System tools.

Responsibilities:

> Creating database and tablespaces.

> Automating Daily Jobs using autosys and regular Monitoring of

operating system and database log files

> Online Database Backup, Archived redo log files and Offline backup.

> Implementations of quotas in both Operating System level and database

level

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

> Created users and granted appropriate privileges.

> Implemented Backup & recovery strategy.

> Complete Database and system administration support for the project.

> Maintaining System security, defining of roles, profiles.

> Configuring Recovery catalog for RMAN.

> Monitored performance related issues

> Taking Oracle traces and providing the output of tkprof and explain

plan utilities to the development team.

> Database Reorganization regularly for removing row migrations and

fragmentation

> Used different v$ views to study the database activities.

> Solving different database related issues like taking care of

different processes consuming high CPU resources, listener and connect

string etc.

> Monitor the database by collecting statistics of instance and files by

querying data dictionary views Explain Plan, SQL trace files and

TKPROF, STATSPACK to find ways to improve the database's performance.

> Expertise on PATROL, Tivoli, Remedy, ITSM, OEM, TOAD and Autosys.

Achievements

> Received "Certificate of Recognition"- In recognition of outstanding

contribution excellence for period July-Sep 2009.

Have received this award for managing the critical production Patching

and upgrade tasks in very short notice without any issues and

delivered database within SLA.

> Received "ZEAL - Zest for Excellence, Achievement and Leadership"-

recognized as an exceptional performer for the month of Dec 2009.

Have received this award for most consistent performer over the year,

handling shifts efficiently and for considerably reducing the number

of alerts in queue by fixing patrol configuration issues and

installation of Precise on over 400 production and development

databases.

Career Profile

Organization Designation Duration

Bank of America India Pvt Analyst April 2009 - Sep 2010

Ltd.

Satyam Computer Services Software Engineer Mar 2006 - April 2009

Ltd.

Personal Details

Name Deepak Pratap Singh

Email Id ****************@**********.***

Date of Birth 19-Sep-1982

Contact No. +91-994*******

Location Hyderabad

Passport No. F8350056 Valid Upto: 26 June

2016

Contact this candidate