Amit Patil

MSSQL DBA over 6 year's hands-on experience in managing large-scale databases (RDBMS).
Worked on and can train MSSQL 2005, 2008, 2008R2, 2012 servers.
I have proven skills on and can provide Training on : MSSQL DBA, T-SQL concepts, SSRS, SSIS,

Trained 200+ students on MSSQL server and helped them to build career as MSSQL DBA, T-SQL professionals, SQL support engineers.

Experience Summary:
Installation, configuration, maintenance and troubleshooting of MS-SQL Server 2005 and 2008/2008 R2 / 2012 on Windows platforms.
Worked on Applying latest Service pack and PCI patching on SQL server.
Experience in Managing Security of SQL Server 2005/2008/2008 R2 / 2012 Databases by creating Database Logins, Users, Roles and Assigning proper permissions according to the business requirements.
Experienced in Database Migration, Database Refresh and troubleshooting orphan users.
Ensuring that all databases are backed up on a regular basis by monitoring & fixing backup failures. Restore failed Backups on Business requirement.
Database tuning and performance monitoring.
Worked on SSIS & SSRS.
Expert in T-SQL concepts: DDL, DML & DCL, JOINS, Bulk insert, Stored procedure, Functions.
Managing Locks, Deadlocks,
* MSSQL HA & DR.

Training will be on 80% of Practical session and daily assignment with live organisation example.
Students will get exposure to work on Multiple servers (50+) servers daily and will train you on Basics of System Administrator work and responsibilities.