Umesh Kumar C R Ph. +91-944*******

Experience Summary

• Umesh Kumar is a Technical Lead and is an Oracle DBA having a core experience of 6+ years. He worked as On Call DBA for the production databases issues and is working as Team lead for DBA group. He has extensive experience in Oracle installations, Creation of databases, backup and recovery, performance tuning, upgradation of databases, creation of users, granting roles and assigning profiles to users, Patching. In addition he is having knowledge on Oracle Apps and Netezza Data Warehouse.

• He has working experience on Oracle 10g RAC, MySQL and MSSQL also.

Education/Certifications & Awards

Bachelor of Engineering from Bangalore University (B.E) – Instrumentation Engineering.

Certificate on Introduction to SQL.

Technical Skills

Data warehouse Netezza Performance Server (NPS)

Operating Systems  AIX, Redhat Linux, Solaris.

RDBMS & Applications  Oracle 9i, 10g, RAC.

 MSSQL and MySQL

Tools & Utilities  Statspack, DBCA, DBUA, OEM, PuTTy, ADDM,SecureCRT,MSTSC,TKPROF, AWR, RDA, Grid Control, RMAN, 10g Client.

Summary of skill sets:

• Around 6 years experience as an Oracle Database Administrator and provided On Call Support.

• In-depth knowledge in administering Oracle databases.

• Installation of Oracle and Creation of databases according to client’s requirement.

• Administering Oracle databases in servers located at various countries.

• Configured the databases to be in backup mode.

• Monitoring the performance of the databases.

• Schema refreshment from one database to another database.

• Upgradation of oracle databases

• Creation of users, assigning roles and profiles to them.

• Configuration of RMAN and usage for backups.

• Daily activities include monitoring the database, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases.

• Worked on installation, maintenance and upgradation of Oracle 10g RAC.

• Knowledge on MSSQL and MySQL servers

• Administration of Netezza Performance Server (Data Warehouse)

• Knowledge of Oracle Apps including user maintenance, cloning, notification mailer maintenance etc.,

Experience Summary:

1.

Project HMH ADM- Others

Client Houghton Mifflin Harcourt

Period Aug 2009 – till now

Role Lead Oracle DBA and also Team Lead for the project

Technology Oracle 10g, RAC and MSSQL

Project Abstract This project was focused on maintenance and providing on call support to Production databases which are having clustering facility.

Supporting the other domains like MSSQL and MySQL also.

Roles & Responsibilities • Backups and Restoration of Databases using RMAN

• Installation of Oracle 9i, 10g, 11g

• Creation of databases.

• Schema refreshments.

• Applying Patches for upgradations and Opatches.

• Grid control Agent installation.

• Import and Export Data using expdp / exp and impdp / imp.

• Performance tuning.

• RAC maintenance

• Maintenance of MSSQL and MySQL

2.

Project IT IS & Oracle Apps Support (Cognizant Technology Solutions)

Client Michaels Stores Inc (US)

Period May 2008 – May 2009

Role Lead Oracle DBA

Technology Oracle 10g, Oracle Apps and Netezza Performance Server

Project Abstract This project was focused on maintenance and providing on call support to 142 databases which includes production, preproduction, development and test databases

Roles & Responsibilities • Backups and Restoration of Databases using RMAN

• Installation of Oracle 9i, 10g, 11g

• Creation of databases.

• Schema refreshments.

• Applying Patches for upgradations and Opatches.

• Grid control Agent installation.

• Import and Export Data using expdp / exp and impdp / imp.

• Performance tuning.

• Oracle Apps Maintenance like cloning and user maintenance

• Netezza Performance Server administration.

3.

Project SAP

Client NetApps

Period June 2007 – Nov 2007

Role Core Oracle DBA

Technology Oracle 10g

Project Abstract This project was focused on creation and maintenance of databases for SAP Team of NetApps in U.S.

Roles & Responsibilities • Backups and Restoration of Databases using RMAN and Snapshot technology.

• Worked with tools like DBCA, Statspack and OEM.

• Creation of databases.

• Installation of Oracle.

• Schema refreshments.

• Applying Patches for upgradations.

• Import and Export Data using expdp / exp and impdp / imp.

• Performance tuning

4.

Project PHOENIX

Client NetApps

Period June 2007 – Nov 2007

Role Senior System Engineer (Senior DBA)

Technology Oracle 9i

Project Abstract This project was focused on providing database Creation and support for NetApps in U.S.

Roles & Responsibilities Worked as a Senior DBA and responsible for

•Backups and Restoration of Databases using RMAN

• Worked with tools like DBCA, Statspack and OEM.

• Creation of databases

• Installation of Oracle

• Schema refreshments.

• Applying Patches for upgradations.

• Import and Export Data using expdp/exp and impdp/imp

• Creation of Data Guard / Standby Databases

• Performance tuning of the databases

5.

Project TGMC Banking System

Client TGMC BANK, Bangalore

Period Nov 2003 to June 2007

Role Hardware Engineer, DBA

Technology Oracle 9i

Project Abstract as a DBA This project was focused on providing database support for TGMC Bank Ltd.

Roles & Responsibilities • Installation of Oracle for new branches and applying application patches.

• Backups and Restoration of Databases.

• Configuration of jobs alerts and database maintenance plans.

• Import and Export Data.

• Monitoring database connectivity and database growth.

• Performance Tuning

Contact this candidate