Senior SQL Developer

Compunnel, Inc.; Addison (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading technology firm in Texas is looking for a Senior SQL Developer to enhance and optimize complex database logic. The role involves performance tuning, rewriting stored procedures, and collaborating with application teams for better system performance. Candidates should have at least 5 years of experience in SQL Server and T-SQL, along with strong communication skills to interact effectively with technical and non-technical stakeholders.

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.

Responsibilities

• Analyze, optimize, and tune complex T-SQL queries for performance and scalability.
• Refactor and rewrite legacy stored procedures and views.
• Design and optimize indexing strategies.
• Identify performance bottlenecks caused by API call patterns.
• Communicate performance findings and recommendations.

Skills

T-SQL

SQL Server performance tuning

Query optimization

Database access patterns

Collaboration with API teams

Job description

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.