Oracle DBA

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

Mobile# +1-813-***-****

EXPERIENCE SUMMARY:

Around 7.5 years of experience in the area of maintaining "Relational

database management systems" History of successfully managing multiple

versions Oracle Databases in mixed OS environments, Demonstrates a

consistently strong work ethic and capable of delivering timely results,

possesses strong analytic and problem solving skills. On-call support and

Team leading skills.

CORE COMPETENCIES:

. Handled more than 500 servers running 1000+ cluster finance databases

in multiple environments. Handled Oracle 9i/10gRAC/11g production

databases for JP Morgan Chase & Co.

. Proficient in Installation, Configuration, Maintenance and Tuning of

11g/10g/ 9i and 10gRAC, Linux, Windows, Implementation and migration of

ASM to Non-ASM, NON-ASM to ASM.

. Implemented Backup & Recovery strategies using RMAN and Hot/Cold backup

for Oracle 11g/10g/9i databases in Windows, Solaris and LINUX

environment.

. Coordinated and Upgraded Test/Development/Pre-production/Production

databases to latest Oracle Version.

. Experience in 10g, 11g RAC Implementation, Administration and

configuration. RAC installation using ASM. RAC backup and recoveries

using RMAN.

. Experience in configuration and maintenance of stand by database/Data

Guard.

. Strong technical skills combined with customer support and customer

interaction skills.

. Cloning and Re-building the databases from Production to other

Environments in a short time. RMAN cloning, hot / cold backup cloning.

. DBA support for multiple production, Staging, development, QA and test

environments.

. Good Knowledge of LINUX OS.

. Excellent Communication and Interpersonal Skills. Strong technical

skills combined with customer support and customer interaction skills.

. OEM installation, configuration and monitoring databases through OEM.

Having around 7.5 years of IT experience and currently working with client

MOSAIC as Senior DBA providing Level 2/3 support.

ACADEMICS

. SSC from Mumbai University (S.T Xavier's high school Andheri (E))

. HSC In science from Mumbai University (National College Bandra)

. BE electronics from MUMBAI University passed out in 2006.

. Oracle 9i, 10g certified.

INDUSTRY EXPERTISE:

. Banking, Telecom, Finance & Insurance, Automobile, Manufacturing,

Retail

. Support and Services

. Testing, Support, Database design, DBA administration, Documentation.

TECHNICAL SUMMARY

SKILLS TOOLS

Operating Systems Solaris, AIX, HP-UX, Linux, Windows 2008

Languages Shell Scripting

Database(s) Oracle 9i, 10g, 11g, 10gRAC,11gRAC, SQL SERVER

Tools & Utilities TOAD, OEM

WORK HISTORY

Duration Organization Designation

Oct 2011 - Till Date Igate Patni Lead Engineer

June 2010 - Aug 2011 HTC/JP Morgan Chase & Co. - Sr. Oracle DBA

Contract

Dec 2007 - Feb 2010 Qsoft Systems Currently CTE DBA Consultant

Jan 2007 - Dec 2007 Spanco Telesystems and Database Executive

Solutions

WORK EXPERIENCE

Igate/ Patni Lead Engineer

Oct 2011 - Till Date

Roles and Responsibilities for client HAVI GLOBAL SOLTIONS,MOSAIC:

Migrating databases from 11.2.0.1 to 11.2.0.3 and 10g to 11g

Migrating RAC databases from 11.2.0.1 to 11.2.0.3

Adding, removing disks from ASM disk groups.

Monitoring through OEM and TOAD.

Creating and testing services on RAC

Using EXPDP/IMPDP for different levels of restores.

Created shell scripts for exp/imp.

Using RMAN duplicate commands for cloning databases.

Compreessed tables and Indexes for saving disk space.

Using SPM 11g feature for tuning

OS/Platforms

Linux (OEL)

Environment

11gRAC,11g,RMAN,TOAD,OEM, Shell script

HTC Global Sol/JP Morgan Chase & Co., Sr. Oracle DBA (10g RAC & Data Guard)

Mumbai, INDIA

June, 2010 - Aug, 2011

Roles and Responsibilities:

Providing production support for JP Morgan Chase & Co. databases

RAC installations on Linux

Troubleshooting RAC 10g and 11g Node eviction issue.

Resolving some tuning issues on Locks or index statistics, Slowness and Hang

issues.

Expert in Patch sets, PSU, CPU.

Creating and Managing Standby databases, Failovers and Switchover.

OS/Platforms

Sun Solaris, HP-UX, Linux

Environment

Oracle (10g, 9i,11g,11gRAC)

CTE ( Cambridge technologies India Consultant - Oracle DBA

PVT LTD ) Formerly known as Q-SOFT

Dec 2007 - Feb 2010

Roles and Responsibilities:

Working on windows as well as Linux systems on 9i and 10g DB

Handling 40 DB In the west and south region of India as well as handling

db issues of other countries and other regions of India

Handling critical production and DR databases including RTGS, SFMS, NEFT,

QPH, PG systems, SC-CAPS.

Daily monitoring and maintenance activities on production databases:

instance availability check, alert log check, space monitoring, CPU load

average check, daily export backup check.

Weekly/monthly activities: executing weekly cold backups, rebuilding

indexes, analyzing tables, purging activity.

Capacity planning.

Database Tuning, analyzing wait events, monitoring databases using OEM Grid.

Performing database/table restoration as and when required.

Creation and maintenance of standby Database (Data Guard)

Switchover and Switch back on RAC and single instance DB

Installation of Windows failsafe.

OS/Platforms

Windows

Environment

Oracle 9i,10g

Spanco Telesystems and solutions PVT Junior database executive

LTD

Jan 2007 - Dec, 2007

Roles and Responsibilities:

Daily monitoring and maintenance activities on production databases:

instance availability check, alert log check, space monitoring, CPU load

average check, daily export backup check.

Weekly/monthly activities: executing weekly cold backups, rebuilding

indexes, analyzing tables, purging activity.

Oracle DB monitoring.

Capacity planning.

Personal Details

Name : Ish Diwan

Visa Details : H1B visa.

Nationality : India

Marital Status : Single

Contact this candidate