Senior T-SQL Developer

Job Summary
We are looking for an experienced T-SQL Developer to design and build database logic — ranging from simple lookups to complex, multi-step processing — on Microsoft SQL Server. This role has a strong emphasis on Dynamic SQL, used to drive configuration-based execution, where business rules, parameters and processing paths are controlled through metadata/configuration tables rather than hard-coded logic. The ideal candidate is comfortable building flexible, reusable and performant database components that adapt their behaviour at runtime based on configuration.
Key Responsibilities
Design and develop database logic of varying complexity — from simple parameterized procedures to complex, multi-branch processing logic
Build and maintain Dynamic SQL-driven stored procedures that execute different logic paths based on configuration/metadata tables
Design configuration-driven frameworks (metadata tables, control tables, parameter-driven templates) that allow business rules to be modified without code changes
Write and optimize complex T-SQL queries, stored procedures, functions, triggers and views
Ensure Dynamic SQL is built securely (e.g., using sp_executesql with parameterization) to prevent SQL injection and support plan reuse
Analyze and tune query performance, including execution plans for dynamically generated queries
Design and maintain configuration/control tables that drive execution logic, filtering, joins or transformation rules
Collaborate with business analysts and application teams to translate changing business rules into configuration-driven logic rather than repeated code changes
Develop robust error handling, logging and auditing for dynamically executed SQL
Refactor static/hard-coded logic into flexible, configuration-driven Dynamic SQL solutions where appropriate
Participate in code reviews, unit testing and documentation of Dynamic SQL logic and configuration schemas
Troubleshoot and debug dynamically generated queries in production environments
Ensure data integrity, security and compliance across all database objects
Required Skills & Qualifications
3+ years of hands-on T-SQL development experience on Microsoft SQL Server
Strong, demonstrable experience with Dynamic SQL, including sp_executesql, parameterized dynamic queries and dynamic object/column resolution
Strong expertise in stored procedures, functions, triggers, views and cursors
Solid understanding of SQL injection risks and secure Dynamic SQL coding practices
Experience with query performance tuning and execution plan analysis, including for dynamically built queries
Ability to translate variable/changing business logic into generalized, reusable, parameter-driven code
Solid understanding of relational database design, normalization and data modelling
Strong analytical and debugging skills, particularly for troubleshooting runtime-generated SQL
Nice-to-Have Skills
Experience building rules engines or config-driven ETL/processing frameworks in SQL Server
Familiarity with SSIS for orchestrating configuration-driven data workflows
Experience with Azure SQL Database, SQL Managed Instance or AWS RDS for SQL Server
Knowledge of PowerShell or scripting for automation around configuration deployment
Exposure to Agile/Scrum development methodologies
Experience with version control tools (Git, TFS/Azure DevOps)
Familiarity with logging/auditing frameworks for dynamically executed code
Soft Skills
Good communication skills and ability to work with business and technical stakeholders
Strong attention to detail, especially when validating dynamically constructed logic
Ability to think in terms of reusable, generalized solutions rather than one-off fixes
Comfortable working with ambiguous or evolving business rules and translating them into structured configuration
Collaborative mindset for working with DBAs, developers and business teams

Work arrangement
No