Sql Server Developer - Performance Tuning

Take the next step in your career now, scroll down to read the full role description and make your application. This is a fully remote role. Salary ranges from £40k -£55k – DOE.

The company is seeking an enthusiastic, self-motivated, and dynamic SQL Server Developer with a proven track record in performance tuning and optimization. If you thrive on solving complex database challenges and making systems run faster and smarter, this role is for you.

As part magician and part juggler, you’ll work your magic on SQL Server environments while balancing multiple client needs—delivering solutions under pressure and meeting deadlines with confidence. The Development team is small but ambitious, so we’re looking for someone who enjoys learning new technologies and tackling projects that push boundaries.

Why Performance Tuning Matters to our client:

• It underpins our managed service promise. They proactively detect performance issues, agree remediation plans with clients, and action improvements—supported by real-time monitoring and alerting that captures historical health and performance metrics.
• To make performance measurable. Clients receive structured health checks that classify findings into Performance, Security, and Reliability, with clear severities and recommended actions—so tuning work is prioritized and its impact is visible.
• Deliver tangible outcomes. Recent tuning engagements have reduced query and job runtimes, improved application responsiveness, and simplified index strategies—resulting in noticeable user experience gains and lower operational pressure.
• Apply a repeatable, phase-based approach. From index additions/consolidations/removals to targeted procedure rewrites, changes are implemented gradually, validated with stakeholders, and aligned to each client’s change process.
• Report and learn continuously. Performance reporting and regular reviews ensure improvements are sustained and inform future tuning cycles.

What You’ll Do:

• Diagnose and resolve SQL Server performance bottlenecks across queries, indexes, and execution plans.
• Optimize user-defined functions, stored procedures, and ETL processes for speed and scalability.
• Collaborate with clients and internal teams to translate business requirements into efficient technical solutions.

The Ideal Candidate:

• Excellent written and verbal communication skills and ability to explain technical concepts to non-technical stakeholders.
• Strong problem-solving skills under pressure and detail-oriented and deadline-driven.
• Builds trust and maintains positive relationships with clients and colleagues.

Essential Experience:

• SQL Server design and development with a focus on query optimization and performance tuning.
• Deep understanding of execution plans, indexing strategies, and Query Store.
• PowerShell scripting for automation.
• Azure Databases.

Desirable Skills:

• Azure (Runbooks, Logic Apps, Data Factory) / SSRS, Power BI, Data Warehousing / ETL/ELT technologies.
• CI/CD and source control (Git, Azure DevOps). Exposure to other database platforms (Postgres, Oracle, AWS, MySQL, NoSQL).

What’s on offer:

• Competitive salary.
• Generous Pension Contribution Scheme (up to 10% match).
• Income Protection/Life Insurance.
• 5 weeks’ annual leave plus options to buy/sell days.
• Paid birthday leave, volunteering days, and extra leave for long service.
• Company-sponsored training and certifications.
• Quarterly team training and get-togethers.

Ready to make SQL Server fly? Apply now by submitting your CV to Justine Logic Recruiting. Once approved, you will then be sent a link to a Skills Assessment Form. Only candidates that complete the Skills Assessment form will be considered.

Recruitment Timeline:

• First interviews: Virtual Interview
• Second interviews: In person Interview