Job description

JOB DESCRIPTION:We are seeking a seasoned Senior SQL Server Developer / Full Stack .NET Developer with extensive experience in Microsoft SQL Server architecture and processes. The ideal candidate will have a strong background in server-side coding of database-heavy applications, with advanced expertise in stored procedures, table indexes, query optimization, and database maintenance. DUTIES AND RESPONSIBILITIES:Develop and maintain database solutions using Microsoft SQL Server, focusing on server-side coding and optimization techniques.Design and implement stored procedures, table indexes, and index statistics to improve query performance and database efficiency.Utilize tools such as SQL Server Management Studio (SSMS) to analyze query execution plans and identify opportunities for optimization.Perform database and table maintenance tasks, including backup and recovery, index rebuilding, and database consistency checks.Implement and manage MS SQL Change Tracking, Change Data Tracking, Broker Services, and Replication as needed for data synchronization and tracking.Collaborate with other developers to review code written in Entity Framework and ensure adherence to best practices and performance standards.Develop APIs and web forms to query data from SQL Server databases and integrate with front-end applications.Stay updated on emerging technologies and best practices in SQL Server development, database optimization, and data management. REQUIREMENTS:Minimum 10 years of experience with Microsoft SQL Server and T-SQL development.Minimum 8 years of experience with ADO.Net and C# programming.Proficiency in Entity Framework and reviewing code written in Entity Framework.Strong understanding of SQL Server architecture, including stored procedures, table indexes, and query optimization techniques.Experience with tools used to optimize SQL Server performance, such as SQL Server Management Studio (SSMS) and query execution plans.Excellent attention to detail and problem-solving skills.Experience with database maintenance tasks and tools.Familiarity with APIs and web forms for querying data.Strong communication and collaboration skills.

Requirements