SQL Server | Sr. .NET Developer

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.