Oracle Data

Sandeep Kumar Singh

Flat No. **, Dhanya Niketan Apartment

Sector - 42, Noida, Pin-201301

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

Mob No: +91-901*******

Summary of Qualifications

* ***** ** ********** *n Oracle EXADATA Machine, RAC(Oracle Real application cluster), Oracle Restart server, ASM, Data Guard, Data Pump, Backup & Recovery Solution (RMAN), Oracle 12c/11gR2/11g/10g/9i Database Administration on Linux, Sun Solaris 10/9, IBM-AIX 6/7, HP- UX11.3 and Windows platforms.

2+ years of experience in Implementing, Supporting and Patching multiple Exadata Machine.

Experience in designing, implementing and supporting high availability and disaster recovery solutions for mission-critical 24x7x365 environment.

Master's degree in Computer MCA, Oracle Real Application Cluster 11g and Grid Infrastructure Administrator Certified Expert & OCP - 9i/11g.

Excellent communication and interpersonal skills with variety of professionals, clients and staff members

Technical Expertise

Oracle Exadata X4-2 Machine Administration, Patching and Implementation Support.

Exadata ESS /Cell server Support, Exacheck, Sundiag log, Cell/Grid Disk, FlashDisk

Real Application Cluster (RAC), CRS, GRID, Restart Server & ASM

Oracle Database 12c/11g/10g/9i, MSSQL Server, Informix

Disaster Recovery Solutions (Data Guard / Active Data Guard)

Enterprise Manager Cloud/Grid Control 12c/110g

Database Patching (PSU, CPU and SPS patch upgrades), Database Security administration & Auditing

Database Migration, Active RMAN Database Cloning

Non-ASM to ASM Database Migration

Golden Gate, Transportable Tablespace

Backup & Recovery Solution (RMAN)

Oracle Data Pump, SQL*Loader

AWR, ASH, ADDM, ExaCheck & SunDiag

Oracle SQL Developer, PL-SQL Developer

Benchmarking of application workload, Capacity Planning

Toad 10/9/8/7

Linux REDHAT, SUN Solaris, IBM-AIX and HP-UX – Basic Shell Scripting

HP Data Protector, TSM, EMC Legato & Commvault Backup Administration tool

- 2 -

Work Experience

1) HCL Technology 12-Jan-2015 - Present (Sector-126, Noida) Project: LPL Financial Boston, Massachusetts, United States Senior - Database Administrator (Exadata DMA & Oracle RAC Administrator)

Involved in Implementation, Supporting and Patching activities on multiple Exadata X4-2 Machine.

Patching of Standby, Non-Production and production EXADATA Appliance.

Supporting and troubleshooting Database, Cluster, ASM/Disk, ESS/Storage Server & Performance bottleneck on ExadataX4-2 Machine( 3- Exadata Box’s).

Installation and supporting multiple Oracle 11g/12c Real Application Cluster (RAC) setup, Restart Servers, ASM Instances on Exadata appliance, IBM Power servers and REDHAT.

Supporting number of Container & PDB’s database in Oracle12c.

Implementing Backup and Restore terminology to make sure maximum availability and minimum data loss of Production/Business.

Working with oracle Support in case any Hardware Maintenance is required on Exadata Box’s.

Dealing with day to Exadata Storage Server monitoring and Administration.

Generating regular Exadata Health Check report using EXACHECK & SunDiag log.

Handling OMS Server (OEM 12c) and its different operation like, Blackouts, Rules setting, job/activity scheduling, Exadata and other database machine monitoring.

Supporting oracle production, warehouse, development and DR environment.

Working with TSM server to move Database backup on tape.

Working on escalated database tickets to resolve database problems/issues.

Regular maintenance and fine-tuning on the database.

Scheduling the CRONJOB for significance work on production.

Designing new databases / Test database.

Using ACTIVE DATA GUARD for STANDBY DB that makes live data for reporting purpose

Using DATA PUMP (expdp, impdp) for structural & data Backup/Logical of production DB

Optimizing the SQL Queries to resolve performance bottleneck.

Managing schema, Space, Profile, Security etc.

Driving Backup & Recovery Solution (RMAN) for recovery purpose.

Developed Unix Shell scripts & Sql script to automate database operation and database monitoring

Creation of new DB and users, setup RMAN backups, Export, Import and other DB scripts

Regular monitoring of trace, alert log file & all ORA errors

Capacity planning and benchmarking of application workload.

Adhering ITIL Process and Lean IT to provide best practice and support for customer.

Preparing Shift Roster for 24*7*365 availability.

Providing 24*7 remote and onsite support for customers

- 3 -

2) WIPRO InfoTech 28-Feb-2013 to 06-Jan-2015

Projects:

1) Punjab Excise and Taxation 28-Feb-2013 to 14-Sep-2014 2) Indus Towers Limited 15-Sep-2014 to 06-Jan-2015 Installed & managed multiple Oracle-11g/10g RAC (Real application cluster) setup and more than 150 database instances including Oracle Restart and single instance database servers on different platform/OS(IBM-AIX, SUN-SOLARIS, REDHAT).

Responsibilities as a Lead- DBA includes below day to day operation,

Checking database health report submitted by team (in regular interval).

Working on escalated database tickets to Resolve Oracle software and database problems/issues.

Managing DBA team shift roster.

Assigning the work to DBA team to achieve the SLA for the project.

Adhering ITIL Process.

Capacity planning and benchmarking of application workload.

Scheduling the CRONJOB for significance work on production.

Working on ORACLE 11g RAC (Grid Infrastructure) Database with 2-Instances on IBM-AIX 6.1

Provide services for more than 12 database instance on Different platform LINUX/IBM-AIX

Using ACTIVE DATA GUARD for STANDBY DB that makes live Data for reporting purpose

Managing 3-way Sync / 2 RAC DR location(local and remote DR)

Implemented Golden Gate for live cross-platform database migration

Supporting oracle production, warehouse, development and DR environment

Installing and upgrading oracle, Upgrading Oracle from 10.2.0.2 to 10.2.0.4 to Oracle 11.2.0.1

Using DATA PUMP (expdp, impdp) for structural & data Backup/Logical of production DB

Designing new databases / Test database

Regular maintenance and fine-tuning the database

Using HP-DP Tool to manage VLS-TAPE LIBERARY to backup database, application data and archive logs on daily basis

Using commvault backup and restoration tool for database backups.

Spreading the table and index data on different table spaces for better performance

Creation of new DB and users, setup RMAN backups, Export, Import and other monitoring scripts

Using RMAN (Backup & Recovery) Solution for recovery purpose.

Developed Unix Shell scripts & Sql script to automate database operation and database monitoring

Regular monitoring of trace, alert log file & all ORA errors

Provided 24*7 supports

- 4 -

3) Tech Tree IT system P (Ltd). 11-Jun-2012 to 22-Feb-2013 Project: IRCTC - Indian Railway New Delhi, India

This is an Indian railway Internet Ticking Portal by Ministry of Railway. They mainly Deal with all production and development facility of IRCTC –Indian Railway Caterism and Tourism Corporation Limited .Here Production Data Base is on: Oracle 11g RAC- 2 Nodes on HP-Unix. Responsibilities as an Oracle Database Administrator includes below,

Working on ORACLE 11g RAC (Grid Infrastructure) Database with 2-Instances on HP-Ux.

Provide services for more than 5 production database on Different platform LINUX/HP-Ux.

Using ACTIVE DATA GUARD for STANDBY DB that makes live Data for reporting purpose.

Regular monitoring of trace, alert log file & all ORA errors.

Oracle production support and Development environment.

Installing and upgrading oracle, Upgrading Oracle from 10.2.0.2 to 10.2.0.4 to Oracle 11.2.0.1

Using DATA PUMP (expdp, impdp) for structural & data Backup/Logical of production DB.

Designing new databases for Testing Purpose.

Regular maintenance and fine-tuning the database.

Using HP-DP Tool to manage VLS-TAPE LIBERARY to backup database, application data and archive logs on daily basis.

Data need to be extracted from different tables in different schemas/databases for analysis.

Spreading the table and index data on different table spaces for better performance.

Creation of new databases and users, setup RMAN backups, Export, Import and other monitoring scripts.

Using RMAN (Backup & Recovery) Solution for recovery purpose.

Developed some Unix Shell scripts & SQL script to automate database operation and database monitoring.

Provided 24*7 supports.

4) Nippon Data System Limited 12-Dec -2011 to 4-Jun-2012 Project: Rajdhani Power Limited Nehru Place, New Delhi, India Responsibilities as an Oracle DBA includes here, all Oracle DBA- L2 day to day support 5) iWorld Solution P (Ltd.) 16-Apr-2010 to 9-Dec-2011 Project: iWorld Solution P(Ltd.) Faridabad, Haryana, India Responsibilities as an Oracle DBA Associate includes here, all Oracle DBA- L1 day to day support

- 5 -

Freelancer ORACLE DBA & Trainer Aug-2009 to Mar-2016 Worked As Freelancer – ORACLE RAC & Exadata DBA Trainer, and taken couple of corporate training for these below employer.

HCL Training wing

TCS

Karrox Technologies Ltd. for Wipro Infotech

AKS Computers Pvt. Ltd., Noida

EDUSOFT, Noida Sector-12

INTELIPAAT Training Solution

Education & Certification

Oracle Real Application Cluster 11g and Grid Infrastructure Administrator Certified Expert

Oracle Certified Professional - 11g (OCP) on DBA Track from Oracle University

Oracle Certified Professional - 9i (OCP) on DBA Track from Oracle University

ITIL Foundation -V3 Certified (Wipro Internal Certification)

5 Day’s Exadata Machine workshop @ HCL Technology

Master of Computer Applications MCA with 75.98% from Uttar Pradesh Technical University, Lucknow (INDIA)

DEGREE BRANCH UNIVERSITY NAME INSTITUTE NAME DATE ACQUIRED PASSED

% / CGPA

MCA

Master of

Computer

Application

Gautam Buddh

Technical University

formerly UPTU,

Lucknow

AZAD Institute of

Engineering and

Technology,

Lucknow

07/2007 -

05/2010

2010 76%

B. Sc. Mathematics

Dr. RML Avadh

University, Faizabad

(UP)

K S Saket P G

College Faizabad

(UP)

07/2004 -

06/2007

2007 50%

10+2

Physics,

Chemistry, Math

U.P. BOARD

ShivPuri Inter

College, Khandasa,

Faizabad

07/2002 -

06/2004

2004 73 %

10th

Science U.P. BOARD

ShivPuri Inter

College, Khandasa,

Faizabad

07/2001 -

07/2002

2002 57 %

- 6 -

Personal Details:

Date of Birth

Father’s Name

16-04-1988

Mr. Samar Bahadur Singh

Sex Male

Nationality Indian

Marital Status

Mother Tongue

Single

Hindi

Languages Known English, Hindi

Permanent Address Village & Post- Khandasa, Faizabad (U.P.)-224153 Declaration: I hereby declare that all the above information mentioned by me is true and correct to the best of my knowledge.

(Sandeep Kumar Singh)

Contact this candidate