Manager Project
Resume:
AMIT SHARMA ****.******.******@*****.**
(Oracle Database Administrator) m
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