Job Title : Senior SQL Developer
Location : Addison, TX (Hybrid)
Type : Contract
Job Summary
- We are seeking a highly experienced 8+ years in SQL Server / T-SQL Developer with deep expertise in query optimization, performance tuning, and refactoring complex database code, along with a strong understanding of how APIs interact with SQL Server stored procedures and databases.
- The ideal candidate will work closely with application, API, and DBA teams to ensure that database logic is efficient, scalable, and correctly consumed by upstream services. This role plays a key part in improving performance, reliability, and maintainability across database-driven applications.
Key Responsibilities
SQL Server Development & OptimizationAnalyze, optimize, and tune complex T-SQL queries for performance and scalabilityRefactor and rewrite legacy stored procedures, views, functions, and triggers to improve execution efficiency and maintainabilityOptimize database access patterns used by API-driven applicationsDesign and optimize indexing strategies (clustered, non-clustered, filtered as appropriate)Performance Tuning & API InteractionIdentify performance bottlenecks caused by API call patterns, excessive round-trips, or inefficient parameter usageTune stored procedures consumed by RESTful or service-based APIsCode Quality & StandardsEnforce T-SQL best practices and performance-focused coding standardsCollaboration & CommunicationCollaborate with API and application developersProvide guidance on best practices for calling stored procedures from APIsClearly communicate database performance findings and recommendations to both technical and non-technical stakeholdersRequired Skills & Qualifications
5+yrs expertise in Microsoft SQL Server (2016 2022)5+yrs proficiency in T-SQL3 +yrs experience in query optimization and performance tuning3 +yrs Hands-on experience rewriting complex stored procedures, views, functions, and triggers3 + yrs Solid understanding of API-to-database interaction patterns (e.g., REST APIs calling stored procedures)Strong knowledge of execution plans, indexing strategies, statistics, and SQL Server optimizer behaviorSoft Skills
Excellent communication skills, especially when working with application and API teamsStrong analytical and troubleshooting abilitiesAbility to work independently while collaborating across teamsProactive mindset toward performance and reliability improvements