ï¶ 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.
©