Sukhdev Singh

About Sukhdev Singh

Certified SQL Database administrator with 7 years of IT Experience in Database Administration ON Premise an Azure cloud and Development for very large and complex databases in Microsoft SQL Server 2019/2017/2016/2014/2012/2008 R2 / 2008 / 2005 / in Development, Test and Production Environments. Extensively worked on installing, configuring, optimizing and managing different versions SQL Server 2005, 2008 R2, 2012, 2014, 2016 and 2017 updating with latest hot fixes and service packs as per CIS Standards. Expert in Migrating from SQL server 2005 to 2008/2008R2 and 2008/2008R2 to 2012, 2014,2016 and 2017 by using In-Place upgrade process as well as side-by-side upgrade process and documented the Upgrade Process. Proficiency and expertise in SQL Server Backup/Recovery, Disaster recovery planning and Security Management. Good exposure with SQL Server High Availability Always ON Availability Groups, DB mirroring, log shipping and clustering. Hands on experience on SQL SERVER 2016 new features like Query store, IN memory OLTP and database stretching to Azure platform. Expertise in implementation of security models, Database authentication modes, creation of logins, granting permissions and assigning roles to users on databases. Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks. Expert in Monitoring, Optimization, Performance tuning of SQL Server databases using DMVs, Activity Monitor, SQL Profiler, DB Tuning wizard and third-party tools. Expertise in reading and understanding execution plan and fixing the query to execute with low cost. Experience in using Native tools like SQL Server Profiler, extended events, Database Tuning Advisor, Perfmon and third-party tools like IDERA. Troubleshoot performance problems, fine-tuning of databases and index Analysis. Expert in Troubleshooting, resolving issues on databases and applications to match SLAs and providing training to users Expert in Documentation of SQL Server system and database operations, technical specifications, functional specifications, best practices, policies and procedures. Connect with me to get the detailed exposure on SQL/Azure Database Administration. Seeking a challenging opportunity in an esteemed organization which offers scope for a SQL Server DatabaseAdministrator to provide, invest and demonstrate skills and expertise and gain further experience and enhance the company\'s productivity and require US work for any employer

Experience

1. Senior Ms Data Engineer Bigdata-adf-synapse Ssis

   Microsoft

   Oct 2020 — Present · US

Education

• Punjabi University

  Bachelor's degree

  1996 — 1999