The role also involves designing and optimizing SQL Server databases, writing complex SQL queries, stored procedures, functions, and views, and troubleshooting database and application performance issues. The candidate should have experience with Entity Framework, LINQ, REST APIs, Git, Azure DevOps, Visual Studio, and SQL Server Management Studio.