Senior SQL Developer - Client site Addison Texas
About The Position
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.
Requirements
- 5+yrs expertise in Microsoft SQL Server (2016–2022)
- 5+yrs proficiency in T-SQL
- 3 +yrs experience in query optimization and performance tuning
- 3 +yrs Hands-on experience rewriting complex stored procedures, views, functions, and triggers
- 3 + 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 behavior
- Excellent communication skills, especially 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
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 (clustered, non-clustered, filtered as appropriate)
- 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
- Provide guidance on best practices for calling stored procedures from APIs
- Clearly communicate database performance findings and recommendations to both technical and non-technical stakeholders
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
