SQL DEVELOPER

Summary
We're looking for a mid–senior level SQL Developer who loves getting to the bottom of performance issues. This person will own query tuning, index strategy, and overall database performance, while also working closely with our Client Care team to troubleshoot production issues and support customers.

If you enjoy digging into execution plans, shaving seconds off heavy queries, and helping non-DB folks understand what's going on under the hood, this role is for you.

Key Responsibilities

Database & Query Optimization

• Analyze and tune complex SQL queries, stored procedures, and views for performance and maintainability
• Design, implement, and refine indexing strategies (clustered/nonclustered, covering, filtered indexes, etc.)
• Review and interpret execution plans; identify bottlenecks (e.g., key lookups, scans vs seeks, parameter sniffing, bad cardinality estimates)
• Recommend and implement schema changes (normalization/denormalization, partitioning, etc.) to support performance and scalability
• Monitor and improve database performance using profiling and monitoring tools (e.g., DMVs, performance counters, Query Store, third-party tools)

Support & Troubleshooting (Client Care)

• Work with the Client Care/Support team to triage and resolve database-related issues (slow screens, timeouts, deadlocks, blocking, data inconsistencies)
• Investigate production incidents, identify root causes, and provide both short-term fixes and long-term solutions
• Translate vague symptoms (this page is slow) into concrete technical investigations
• Build internal tools, scripts, and queries to help Client Care diagnose and resolve issues faster

Collaboration & Best Practices

• Partner with developers to review SQL in new features and refactors before production
• Promote and document SQL best practices, coding standards, and performance guidelines
• Participate in code reviews and knowledge-sharing sessions
• Contribute to capacity planning, growth forecasting, and performance testing strategies

Required Skills & Experience

• 5+ years of hands-on SQL experience in a production environment (mid–senior level)
• Strong expertise in Microsoft SQL Server
• Deep understanding of:
  • Query execution plans and optimization
  • Index design and maintenance (rebuild/reorg, statistics updates)
  • Transactions, isolation levels, locking/blocking, and deadlocks
  • Joins, subqueries, CTEs, window functions, and complex queries
• Experience troubleshooting production performance issues end-to-end
• Comfortable working with large datasets and complex schemas
• Strong understanding of data modeling and relational database design
• Strong communication skills (technical and non-technical audiences)
• Experience in support, client-facing, or cross-functional environments

Nice-to-Have

• Experience with ETL, reporting, or analytics workloads
• Familiarity with ORMs and their SQL impact
• Experience in SaaS, multi-tenant, or high-availability environments
• Exposure to monitoring/APM tools (e.g., New Relic, AppDynamics, Datadog)
• Scripting experience (PowerShell, Python, Bash)
• Experience with version control (Git) and CI/CD for database deployments

What This Role Looks Like Day-to-Day

• Reviewing and refactoring slow or high-cost queries
• Partnering with Client Care to reproduce and diagnose issues
• Inspecting execution plans and DMVs to identify performance problems
• Collaborating with developers on efficient query and schema design
• Writing documentation and playbooks to help teams triage issues independently