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.

Key Skills
Education

Any Graduate

Back To Jobs