 Around 8 years of IT experience as SQL Server DBA & Development for 2000 and 2005, 2008/R2, 2012, 2014 and 2016.  Work experience in Always-On, High Availability Concepts like Replication, Clustering, and Mirroring. Backup & Recovery, Log Shipping, and Index Fragmentation.  Installing, Configuring, and Administering MS SQL Server 2005/2008/12/14/16.  Experience in administering the servers by creating User logins with appropriate roles, logins, monitoring the user accounts,  Experience in performance, security, and availability of databases.  Extensive experience in Prepare documentations and specifications on SQL server.  Creating stored procedures and triggers and views. Optimizing the queries.  Extensive knowledge in Database Programming and Development using SQL Server to include Database Architecture, Logical, and Physical Design.  Excellent knowledge in Clustering and Mirroring & Replication & Always-On using High Availability concepts.  Experience in creating SSIS packages for backups and SQL related jobs.  Transferring Data using Data Transformation Services (DTS) Packages  Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, and Index Tuning Wizard/Tuning Advisor to achieve better performance, accessibility and efficiency.  Experience to solve the issues on databases for Dead Lock, capturing long-running SQL queries and worked on creating reports using SSRS.  Experience on SQL Server lower version to higher version Migration and Upgradation from SQL Server 2005 and 2008/R2121416.  Experience on solving issues on SQL server performance using a profiler to find the performance and Blockings & Deadlocks and High Availability concepts.  Proficient in the blocking, performance related to any performance issues.  Worked on call 24/7 Support. ©