Sql Server DBA, Oracle DBA, SSIS package developer and dialer admin

CURRICULUM VITAE

Saurabh Sharma

** *, ****** *, *** Flats,

New Kondali, Mayur Vihar Phase 3,

East Delhi,

Delhi-110096

Phone No. : 999-***-**** E-Mail: ******.********@*****.***

Objective:

With approximately 5 years of experience in Microsoft SQL Server DBA and 3 year 6 month as dialer engineer analyst, I enjoy working in a fast paced, highly motivating position where I can assist others while challenging and expanding my knowledge and understanding of the task at hand. I am seeking a position that will utilize my skills and offer the chance for advancement as well as allow me the opportunity to gain additional skills.

Certifications:

MCSA -- SQL SERVER 2012/2014

70-461 Querying Microsoft SQL Server 2012/2014

70-462 Administrating Microsoft SQL Server 2012/2014

70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Experience:

Working in IEnergizer IT Services Pvt. Ltd. Since January 2015

Worked in XFAS Logistics Pvt. Ltd. From July 2013 to January 2015

Work Experience on:

Microsoft SQL Server (2008):-

Roles: - T-SQL, maintenance (data purging, installation, patching), backup, restore, indexing, security, database development, log shipping, mirroring, replication, clustering, SSIS packages

Microsoft SQL Server (2012):-

Roles: - T-SQL, maintenance (data purging, installation, patching), backup, restore, indexing, security, database development, log shipping, mirroring, replication, clustering, Always on, SSIS packages

Microsoft SQL Server (2014):-

Roles: - T-SQL, maintenance (data purging, installation, patching), backup, restore, indexing, security, database development, log shipping, mirroring, replication, clustering, Always on, SSIS packages

Microsoft SQL Server (2016):-

Roles: - T-SQL, maintenance (data purging, installation, patching), backup, restore, indexing, security, database development, log shipping, mirroring, replication, clustering, Always on, SSIS packages

ORACLE 10G, 11G, 12C: -

Roles: - SQL, maintenance (data purging, installation, patching), backup, RMAN, indexing, IMPDB, EXPDB, security, Tablespace management, database development, Data Guard

Altitude(7.5a1)dialer: -

Roles: - maintenance, L1troubleshooting (loggers, dialer, recorder), operational support (data uploading, desktop level troubleshooting)

ASPECT(7.3) dialer: -

Roles: - data uploading, maintenance, L1troubleshooting, operational support

ASPECT(6.7) dialer: -

Roles: - data uploading, maintenance, L1troubleshooting, operational support

MAJOR Assignments:

CSS Portal :

Project :

CSS Portal

Client :

In House

Role :

Database Design ( create database, create table, TSQL, create SSIS Package, Create Job, security ) and Maintenance ( Indexing, Backup Database, Job maintenance)

Brief description of the project:

This project deals in providing all type of reports of user calling as par the requirement of Ops team.

We use to create SSIS package and use as Jobs in SQL Server to make this easy in way of fetching records from any instance at any time using this portal. Job also moves data from one server to another server to reduce network traffic on run time.

Responsible for:

Understand the requirement of client and Ops team.

Prepare document and structure of requirements.

Creating database and table, views.

Prepare queries and store procedure.

Prepare self-test Data for demo.

Attendance Report :

Project :

Attendance Management System

Client :

In House

Role :

Database Design ( create database, create tables, TSQL, create SSIS Package, create Trigger, create Job, Security ) and Maintenance (Indexing, Backup Database, Job maintenance)

Brief description of the project:

This project is based on maintaining all In-Out record of employees at two levels, first entry for security purposes and other one is for making the attendance record for salary purposes. Employee can see their attendance detail on internal attendance portal.

We have created a instead of trigger on this database if any one try to change the record that record will be inserted in different log table.

Responsible for:

Understand the basic requirement of HR and Management team.

Prepare document and structure of requirements.

Creating database and tables.

Prepare queries and triggers.

Restrict user roles.

Prepare self-test data for demo.

Software exposures:

Software exposures :

Operating systems

ESXI (VM), Windows (7, 8, 10), Windows Server 2008, 2008R2, 2012 R2.

DATABASE

SQL Server (2005, 2008, 2012, 2014, 2016), Oracle (10G, 11G, 12C)

SOFTWARE

VISUAL STUDIO (2010, 2013, 2015)

Educational Qualification:

Matriculation from Translam Academy International, Meerut, with First Division. Year 2006

10+12 from Translam Academy International, Meerut, with First Division. Year 2009

B - Tech (CSE) from Shri Krishna Institute of Engineering & Technology Kurukshetra with First Division. Year 2013

Personal Details:

Father’s name : Mr. Raj Kumar Sharma

Date of Birth : 20/10/1990

Permanent Address : 40 D pocket C SFS Flats New Kondali MV Ph. 3

Languages Known : English and Hindi

Give Emphasis on : Working hard to drive results, Keen Learner, Ability work Under Pressure, Have believe in own Capabilities, Hardworking, Punctual, Leadership, Persistent, Adaptable, Resourceful, Patient listener, down earthy to learn from Mistakes, Self-Motivated, learner

Declaration:

I hereby declare that information given above is true to the best of my knowledge.

Date:

Place:

(Saurabh Sharma)

Contact this candidate