Senior SQL Developer

The Senior SQL Developer will be responsible for optimizing, refactoring, and enhancing complex database logic while ensuring efficient integration between SQL Server stored procedures and API-driven applications. This role requires deep expertise in T-SQL, performance tuning, and query optimization, along with the ability to collaborate with application, API, and DBA teams to improve overall system performance, reliability, and maintainability. Key Responsibilities Analyze, optimize, and tune complex T-SQL queries for performance and scalability. Refactor and rewrite legacy stored procedures, views, functions, and triggers to improve execution efficiency and maintainability. Optimize database access patterns used by API-driven applications. Design and optimize indexing strategies, including clustered, non-clustered, and filtered indexes. Identify performance bottlenecks caused by API call patterns, excessive round-trips, or inefficient parameter usage. Tune stored procedures consumed by RESTful or service-based APIs. Enforce T-SQL best practices and performance-focused coding standards. Collaborate with API and application developers to ensure optimal interaction between applications and database logic. Provide guidance on best practices for calling stored procedures from APIs. Communicate performance findings and recommendations to technical and non-technical stakeholders. Required Qualifications 5+ years of experience with Microsoft SQL Server (2016–2022). 5+ years of proficiency in T-SQL. 3+ years of experience in query optimization and performance tuning. 3+ years of hands-on experience rewriting complex stored procedures, views, functions, and triggers. 3+ years of understanding API-to-database interaction patterns (e.g., REST APIs calling stored procedures). Strong knowledge of execution plans, indexing strategies, statistics, and SQL Server optimizer behavior. Excellent communication skills when working with application and API teams. Strong analytical and troubleshooting abilities. Ability to work independently while collaborating across teams. Proactive mindset toward performance and reliability improvements. #J-18808-Ljbffr