AMIT SHARMA acdo5y@r.postjobfree.com

(Oracle Database Administrator) m

408-***-**** )

Professional Summary

Years of Experience: 6

Current Currently working in GlobalSoft Inc (San Jose, CA),

Organization: previously worked in Capgemini from July 2011 to Jan

2014. Prior to that worked in Wipro Infotech and

Birlasoft from July 2008 to July 2011.

Responsibility: Primarily involves requirement gathering and

Understanding of database setup, implementation and

administration and Support of 10g, 11g R1 and 11g R2

high end Clustered (RAC) databases, Oracle Data Guard,

ASM, RMAN, Data Pump, Export-Import, OEM Grid Control,

shell scripting and resolving corresponding issues and

troubleshooting for the same.

Skill Summary

* Fundamental and Advanced implementer and administrator for Database in

any enterprise environment.

* Experienced in implementation and administration of Standalone, ASM and

RAC (10g, 11gR1 & 11gR2 RAC GRID) based Oracle databases.

* Experienced in Backup and recovery through RMAN and Export - Import

utility.

* Expertise in Implementation of Oracle RAC (11g R2, 11g R1, 10g R2)

* Experienced in implementation and administration of Oracle Data Guard

(ODG).

* Experienced in OEM Grid Control installation and administration and

done CPU patching through OEM grid also.

* Experienced in working for 24*7 mission critical production databases.

* Experienced in various tools like Quest LiteSpeed for RMAN Backup

compression, Quest PA, HP Service Manager, Asset Manager, UC4, Toad and

etc

* Troubleshooting and performance tuning skills for Oracle RAC, ASM and

Stand-alone databases.

* Experienced in Oracle Golden Gate implementation, configuration and

support.

* Apart from Oracle, experienced and trained on Solaris, AIX, Linux and

windows Operating systems, storage, etc.

* Experienced in Shell Scripting.

* Experience and knowledge on ODA ( Oracle Data Appliance)

* Experience of Microsoft SQL Server Database.

* Good Knowledge of Solaris, AIX, Linux and Windows operating system, as

worked on various UNIX and Windows platforms.

* ITIL V3 certified professional.

* Involved in complete cycle of project (Test, Development, UAT and

Production Env).

* Ability to work independently and in team through established

guidelines.

Projects Synopsis:

Organization Capgemini (July- 2011 to Jan 2014)

Project Title Client - John Deere ( Moline, USA )

Description:

Involved in administration and support of oracle Databases, which includes

Oracle 11g R2, 11gR1 and 10g databases for production, development and

certification/lab environments with added usage of various tools like HP

Service Manager, Asset Manager, UC4, Toad and etc.

Responsibility:

RMAN Backup/recovery issues handling (SCN based recovery, Point in time

recovery, incremental recovery, recovery in case of losing all

controlfiles)

Oracle Data Guard setup and issue handling (Incremental recovery, missing

logfile issue, standby Sync issue, rebuilding standby, scn based log

recovery, error based recovery, etc)

Shell Scripting and maintaining existing scripts.

Experienced in Quest tool PA (Performance Analyzer), for analyzing

performance and generating report through it.

Testing and Deploying Quest LiteSpeed 3.0, 2.2 for RMAN Backup compression

and time reduction for client TEST and DEV environment.

Analyzing production database performance using automatic workload

repository (AWR), statspack report.

Upgraded database in Oracle EBS environment.

Planning Backup/Restoration Strategy, Planning and scheduling Backups,

taking Logical Backups (with Export/Import Data pump utilities).

Database creation, Setup and migration for Test, Dev, UAT and PROD

environments.

Database upgrade to 11g versions from older versions (9i, 10gR1 & R2, 11gR1

etc)

Refresh/rehost of databases from production to development environment.

Owner of OEM Grid control project and established CPU Patching through OEM

to large number of databases.

Daily proactive monitoring of databases with use of HP Service Manager

Tool.

Handing alerts and troubleshooting user's issue (Performance, accessibility

and day-to-day issues)

Schema copy/refresh though Export-Import Data pump.

Tablespace monitoring and management.

Database schema management for all databases.

Handled ONCALL and ONMAIL responsibility.

Organization Birlasoft ( April 2011- July 2011)

Project Title Client - Swissre (Zurich, Switzerland)- Database Support

Description:

Involved in administration and support of Database setup which includes new

high end Oracle 11g R2 GRID based (RAC) Cluster databases for production,

training and education environments.

Responsibility:

Daily monitoring of RAC and non-RAC databases.

Handing alerts and troubleshooting users issue.

Golden gate installation, configuration and support for development

databases.

Schema copy/refresh though Data pump.

Tablespace monitoring and management.

Database schema management for all databases.

Handling basic performance issues.

Export and import through traditional and Data Pump export-import utility.

Organization Wipro Infotech ( July 2008 - April 2011 )

Project Title Client - SAHARA India - Database Implementation and Data

: Migration (Single Handed Project)

Description:

Involved in implementing and administration of DC-DR Database setup which

includes new high end Oracle 11g R2 GRID based (RAC) Cluster databases and

data migrating using DATA PUMP the data from 10g to 11g R2 RAC database

at DC and implementing Oracle Data Guard (ODG) at DR for respective DC

production databases.

Responsibility:

Requirement gathering from various application teams.

Through Understanding the requirement.

Basic configuration of Operating systems required for pre-requisite of

databases.

Installation and configuration of new 11g R2 RAC (Real Application Cluster)

on Solaris Operating System.

Pre-requisite(Network/Storage/OS) for RAC at Operating system and Storage

level.

Implementation of ASM database.

Migration of data through DATA PUMP Export- Import from 10 g to 11g R2 RAC

database.

Backup configuration of databases using RMAN utility in integration with

Legato Backup Software.

Implementation of Oracle 11g R2 Physical Standby Databases (ODG) at DR

site.

DR Drill by Performing Switchover/Failover between DC-DR through Data

Broker for ODG.

Installation and configuration of Enterprise Manager Grid Control and EM

Agents.

Installation of Oracle 10g App Server on Solaris.

Troubleshooting with Oracle 11g R2 cluster and databases.

Project Title UNITECH Wireless Ltd (Uninor) - Database Implementation

:

Description:

Involved in implementing database and server solution which consists of

Oracle 10g databases on Sun Solaris, Red Hat Linux, Microsoft with

non-ASM, ASM and Oracle RAC environment on Sun's T Series and high end M

series Enterprise & HP Servers including EMC clarion SAN boxes.

Responsibility:

Requirement gathering from application team.

Understanding the requirement as per implementation perspective.

Basic configuration of Operating systems.

Implementation of single instance Non-ASM database.

Implementation of Active-passive database.

Implementation of ASM database.

Implementation of RAC (Real Application Cluster) on Solaris and Linux

Operating System.

Patching of Oracle Databases.

Pre-requisite for RAC at Operating system and Storage level.

Migration of Non-ASM database to ASM database.

Migration of single instance database to RAC database.

Backup configuration of databases using Export-Import utility.

Data loading through Oracle Data Pump Utility.

Backup configuration of databases using RMAN.

Testing databases using BCP technology.

Handing Application users issues related to databases.

Project Title Aircel - Database and Server Implementation

:

Description:

The project involved implementing database and server solution which

consists of Oracle 10g databases with non - ASM, ASM and Clustered

environment on Sun's T Series and high end M series Enterprise Edition

Servers including EMC clarion SAN boxes.

Responsibility:

Requirement gathering from application team.

Understanding the requirement as per implementation perspective.

Basic configuration of Operating systems.

Implementation of single instance Non-ASM database.

Manual database creation on raw file system.

Implementation of Active-passive database.

Implementation of ASM database.

Implementation of RAC (Real Application Cluster) on Solaris and Linux

Operating System.

Manual database creation in RAC environment and non-RAC environment.

Backup configuration of databases using Export-Import utility.

Backup configuration of databases using RMAN.

Handing Application users issues related to databases.

Academics

* Bachelor of Engineering (Information Technology, 4 Year Course) from

Rishiraj Institute of Technology, Rajiv Gandhi Proudyogiki

Vishwavidyalaya, Indore, (M.P.), India with 73.5%

Certifications and Rewards

* Oracle Certified Associate for Oracle 10g database.

* Sun Certified System Administrator - 1 for Solaris 10

* ITIL V3 Certified.

* STAR OF THE MONTH Award for Uninor project.

* SPOT Award in Quarter Outstanding Performance Award Ceremony in Wipro.

* Got PROJECT STAR AWARD for client John Deere in CAPGEMINI on client

recommendation.

Contact this candidate