PROFILE SUMMARY

I have * years of experience as a SQL Database Administrator.

EXPERIENCE SYNOPSIS

* **** ** ********** ** Domain user Management with Active directory.

Proficiency in SQL Server 2005, 2008, 2008R2, 2012, 2014.

Extensive experience Database administration activities like Planning Backup/Restore strategy, Optimization, Performance Monitoring, Indexing, Data Migration, Log shipping, Clustering etc.

Supported more than 250 instances and large database (2+ TB) in size

Extensive knowledge of SQL Server log shipping, Mirroring, Clustering and Always On.

Exceptional abilities in database management and Management with the organizational and supervisory skills to assure success.

Installation and configuration on workstations and servers.

Manage Database Creation, Objects and Structures.

Administration for Database users Managing Profiles and Privileges.

Backups through User Managed and Create Scripts for Automated SQL Backups.

Managing Log Shipping, Mirroring and Replication of Databases.

Linked server creation.

ACADEMIC QUALIFICATION

Degree

College / University

Year of Passing

B.Tech (IT)

Pune University

2013

TRAININGS & CERTIFICATIONS

08 Months Technical training on .NET and SQL from Seed Infotech Ltd.

03 Months On- the Job training with Espire Infolabs Pvt.Ltd.

Presently working with Espire Infolab Pvt Ltd. as Junior Database Engineer with the role of SQL Server Database Administrator (Jan 2015 – Till date).

SKILLS SUMMARY

Operating System

Windows Server 2003/2008

RDBMS

MS-SQL Server 2005/2008/2008R2/2012/2014

Email Client

MS Outlook

Office Tools / Reporting

Microsoft Office

Backup/Recovery Tool

LiteSpeed, DBArtisan, SQLCompare

Monitoring and Management Tools

Ignite, SCOM, Snappimon

Ticketing Tools

IRIS

PROJECTS HISTORY

1. Project I

Project Description: Impellam Group is the 2nd largest staffing business in the UK and the 12th worldwide. Impellam are providers of Managed Services and Specialist Staffing expertise across the UK, North America, Asia Pacific, and mainland Europe. Though a network of 19 brands, they provide candidates with jobs at all levels, including doctors, lawyers, accountants, nurses, teachers, scientists, receptionists, drivers, chefs, administrators, engineers, cleaners, security guards, and manufacturing and warehouse operatives.

Client

Impellam Group, UK

Duration

Jan2015 – Till date

Environment

SQL Servers 2000, 2005, 2008, 2008R2 and 2012 Servers

Role

MS SQL Server Database Administrator

Responsibilities

Installation and Configuration of SQL Servers 2000, 2005, 2008, 2008R2 and 2012 Servers.

Implementing a DBA maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) and Batch programming.

Scheduling and managing jobs on MS SQL Server 2005, 2008/2008 R2 and 2012.

Creation and deletion of DB users at various levels to implement security by using both SQL level and Active Directory authentication.

Using Microsoft management tool including SCOM to monitor SQL Servers.

Worked on the migration of databases from SQL Server 2005 to SQL Server 2008, 2008R2, 2012.

Monitoring Database Server Performance, tracking user activity, troubleshooting errors

PERSONAL DETAILS

FATHER NAME: RAJENDRA R. UPADHYAY

DOB: 01-June-1990

Marital Status: Single

Nationality: Indian

Address: D-65, Maksudabad Colony, Najafgarh, Delhi-43

Contact this candidate