T-SQL Developer

We are seeking an experienced T-SQL Developer to join the Synechron team. This position is predominately remote with occasional travel to Sheffield working with a global energy firm. The ideal candidate will have strong proficiency in Transact-SQL, with a solid understanding of database design, performance optimisation, and advanced SQL features. This role requires problem-solving skills, attention to detail, and the ability to communicate technical solutions effectively. Key Responsibilities: • Develop, optimise, and maintain complex T-SQL queries, stored procedures, triggers, and functions • Analyse and troubleshoot query performance issues, implementing indexing strategies and optimisation techniques • Design efficient and scalable database schemas with a thorough understanding of normalisation, relationships, and indexing • Manage error handling and debugging within T-SQL scripts, including transaction management • Utilies advanced T-SQL features such as Common Table Expressions (CTEs), window functions, and dynamic SQL to solve complex data problems • Ensure database security best practices, including managing permissions, roles, and encryption • Collaborate with stakeholders to understand requirements and provide clear, well-documented solutions • Continuously stay updated on new trends, tools, and best practices in database development and SQL Qualifications: • Proven experience as a T-SQL Developer with strong command of Transact-SQL • Demonstrated ability to write complex queries, stored procedures, triggers, functions, and use advanced SQL features • Strong problem-solving skills, with the ability to approach and resolve complex data challenges • Experience in query optimisation, indexing, and performance tuning, including real-world examples of improvement • Solid understanding of database design principles, normalisation, and relationships • Knowledge of error handling, debugging, and transaction management within T-SQL • Familiarity with tools such as SQL Server Management Studio (SSMS), Azure SQL Database, or other database management systems • Good communication skills with the ability to clearly explain technical concepts and solutions. Preferred Skills: • Experience working with large datasets and high-performance applications • Knowledge of database security practices and encryption techniques • Familiarity with additional tools and technologies linked to SQL Server or similar platforms Long term contract position - Predominately remote - Rate £530pd Inside IR35 Diversity Statement Synechron are proud to be an equal opportunity employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We offer flexible workplace arrangements, mentoring, internal mobility, learning and development programmes to support our global workforce. Empowerment and collaboration are at the core of how we operate. All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.