SQL DEVELOPER

Role Summary

Seeking a mid–senior level SQL Developer with a strong focus on database performance and troubleshooting. This role owns query tuning, indexing strategy, and overall database performance, while working closely with internal support teams to investigate and resolve production issues impacting users.

Ideal for someone who enjoys deep-diving into execution plans, optimizing complex queries, and translating technical findings into clear, actionable insights for non-database stakeholders.

Key Responsibilities

Database & Query Optimization

• Analyze and optimize complex SQL queries, stored procedures, and views for performance and maintainability
• Design, implement, and maintain indexing strategies (clustered, nonclustered, covering, filtered indexes)
• Review execution plans to identify bottlenecks (key lookups, scans vs. seeks, parameter sniffing, cardinality issues)
• Recommend schema changes (normalization/denormalization, partitioning) to support scalability
• Monitor database performance using built-in tools (DMVs, Query Store, performance counters) and monitoring solutions
  
  
  

• Partner with internal support teams to diagnose and resolve database-related production issues (slow queries, timeouts, blocking, deadlocks, data inconsistencies)
• Investigate incidents, identify root causes, and recommend both immediate fixes and long-term improvements
• Translate high-level issue reports into concrete technical investigations
• Develop internal scripts, tools, and queries to improve issue triage and resolution efficiency
  
  
  

• Collaborate with application developers to review SQL changes prior to production deployment
• Define and document SQL best practices, coding standards, and performance guidelines
• Participate in code reviews and knowledge-sharing sessions focused on database reliability
• Contribute to capacity planning, performance testing, and growth forecasting
  
  
  

• 5+ years of hands-on SQL experience in a production environment (mid–senior level)
• Strong expertise in Microsoft SQL Server
• In-depth knowledge of:
• Query execution plans and optimization techniques
• Index design, maintenance, and statistics management
• Transactions, isolation levels, locking/blocking, and deadlocks
• Joins, subqueries, CTEs, window functions, and complex reporting queries
  
• Proven experience troubleshooting performance issues end-to-end
• Strong understanding of relational data modeling and schema design
• Ability to clearly communicate technical concepts to both technical and non-technical audiences
• Experience working cross-functionally with support, product, and engineering teams
  
  

• Experience with ETL, reporting, or analytics workloads
• Familiarity with ORMs and their impact on SQL performance
• Background in SaaS, multi-tenant, or high-availability environments
• Exposure to monitoring or APM tools
• Scripting experience (PowerShell, Python, Bash) for automation
• Experience with version control and CI/CD practices for database deployments
  
  
  

• Reviewing and refactoring slow or high-cost queries
• Partnering with support teams to reproduce and diagnose issues
• Analyzing execution plans and runtime metrics
• Advising developers on optimal query and schema design
• Creating internal documentation and troubleshooting playbooks