I have * years of experience as a SQL Database Administrator.
* **** ** ********** ** 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.
College / University
Year of Passing
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).
Windows Server 2003/2008
MS-SQL Server 2005/2008/2008R2/2012/2014
Office Tools / Reporting
LiteSpeed, DBArtisan, SQLCompare
Monitoring and Management Tools
Ignite, SCOM, Snappimon
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.
Impellam Group, UK
Jan2015 – Till date
SQL Servers 2000, 2005, 2008, 2008R2 and 2012 Servers
MS SQL Server Database Administrator
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
FATHER NAME: RAJENDRA R. UPADHYAY
Marital Status: Single
Address: D-65, Maksudabad Colony, Najafgarh, Delhi-43