Sql Server Project

Praveen Singh

Mobile: +91-783*******

E-mail: *****************@*****.*** SQL SERVER DBA

PROFESSIONAL SNAPSHOT

•Having 5.0 years of experience as a Microsoft SQL SERVER Database Administrator in production server maintenance and support.

•Experience on Installing, Configuring, Managing, Monitoring, and Troubleshooting SQL Server.

•Experience in Database Backup and Recovery procedures.

•A regulated team player with problem solving skills.

TECHNICAL SKILL SET

•Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005/2008/2008R2.

•Good understanding of SQL server architecture, Experience in performing regular Backups and scheduling tasks.

•Good knowledge in Database Backup, Restore and Disaster Recoveryprocedures.

•Maintenance of database with the activities of shrink database, Indexing and Re-indexing ofdatabase, Backupof database etc.

•Identifying and resolving Blocking and Dead-lock issues.

•Implementations of SQL logins, roles and authentication modesas part of security Policies for various categories of users.

•Job Automation. Configuring Database Mail, configuring Operators and Alerts.

•Involved in configuring Log Shipping and Database Mirroring.

ACADEMIC QUALIFICATIONS:

•B.E. (Electronics Engineering) from Nagpur University in 2011.

Skill Set:

Operating Systems : windows Server /2008/XP.

Database : MS-SQL Server 2005/2008/2008R2/2012/2016.

Languages : SQL, T-SQL.

Tools : DBSYMPHONY, LOTUS NOTES, TSM, SQL LITESPEED,

GCM PORTAL, CAPACITY PORTAL, Service Now, Salesforce, DPA

Kronos WORK EXPERIENCE:

Current Designation : Database Administrator

Current Role : SQL Server DBA

Duration : Feb’16 - Till Date

HCL WORK EXPERIENCE:

Current Designation :Technical Analyst

Current Role : SQL Server DBA

Duration : Oct’12 – Jan’16

Project : DB ARC Steady State (Deutsche Bank)

Responsibilities:

•Monitor and Manage performance of Project Resources, processes and schedules.

•Monitoring Dev/Test/Pre-production and Production servers and responsible for day-to-day operation and maintenance of production servers.

•Establish and maintain sound backup and recovery policies and procedures and performed point in time recovery plans.

•Configuring high availability options like- SQL Mirroring.

•Migrating objects from test environment to production environment & vice versa

•Installation, Configuration and upgrading of Microsoft SQL Server 2005/2008/R2, Performance Tuning and Query optimization.

•Creating and configuring linked servers, Managing SQL server security and user, logins.

•Monitor status of customer escalations and Drive compliance of defined process.

•Daily Monitoring the DB space Management issues and allocating the required space to databases.

•Making decisions and troubleshooting the SQL server issues.

•Be in constant communication with the Customer on all the open issues (at least once in a shift).

•Active participation in Production support tasks and meeting the deadlines.

•Monitor and Manage performance of Project Resources, processes and schedules.

•Complete SQL Server Core-DBA Activities. (SQL Server 2008/R2)

•Be in constant communication with the Customer on all the open issues.

•Backup/ Restore activities of SQL Databases.

•Experienced in resolving deadlock and blocking issues for concurrent users

•Worked on around 350 Servers.

PERSONAL DETAILS:

Name Praveen Kumar Singh

Date of Birth 02-06-1988

Sex Male

Nationality India

Languages known English and Hindi

Declaration:

I hereby declare that the information furnished above it true to the best of my knowledge.

Place:Delhi

Date: 08/02/2018

Contact this candidate