Senior SQL Developer

DVT is a leading global software development and data engineering company, delivering innovative technology solutions to some of the world's most respected brands. We pride ourselves on engineering excellence, agile delivery, and a people-first culture. Our teams work across industries, solving complex problems with cutting-edge technology. We are a community of passionate technologists who continuously push the boundaries of what's possible.

We are looking for a Senior SQL Developer to join our Data & Analytics Practice. In this client-facing role, you will be responsible for the design, development, and maintenance of complex SQL databases, writing efficient queries, stored procedures, and triggers. You will play a key role in database architecture, performance tuning, and mentoring junior developers.

This is a consultative engineering role — you will work directly with clients to understand their business challenges, architect robust database solutions, and lead delivery teams in a fast-paced, agile environment. You will be a technical leader, mentor, and advocate for modern database engineering best practices.

• Schema Design:
  Design, implement, and maintain database schemas, including tables, indexes, and relationships to support business requirements.

• Stored Procedures & Triggers:
  Develop and manage stored procedures, functions, and triggers to automate database operations and enforce business rules.

• SQL Query Optimization:
  Write and optimize complex, high-performance SQL queries to ensure efficient data retrieval and manipulation.

• Data Modeling:
  Design and implement data models that accurately represent the structure and relationships of data, including dimensional and relational modelling where required.

• Performance Tuning:
  Identify and resolve performance bottlenecks in database queries, indexing strategies, and infrastructure.

• Data Integrity & Security:
  Ensure data accuracy, consistency, and security through proper validation, constraints, and access control mechanisms.

• Database Version Control:
  Implement and maintain robust database version control practices, including change scripts and migrations.

• ETL Processes:
  Develop and manage processes for extracting, transforming, and loading data from various sources into target databases.

• Data Pipelines:
  Build and maintain reusable data integration patterns, parameterised scripts, and modular solutions.

• Requirements Gathering:
  Work directly with client stakeholders to elicit, translate, and manage technical and business requirements.

• Solution Design:
  Lead architectural and design sessions, ensuring alignment with business goals and enterprise strategies.

• Documentation:
  Produce clear, high-quality technical documentation across the project lifecycle (pre, during, and post-delivery).

• Estimation & Scoping:
  Contribute to project planning, estimation, and risk assessment for database initiatives.

• Mentoring:
  Share knowledge and provide guidance to junior developers on database-related tasks, promoting best practices and code quality.

• Agile Delivery:
  Actively participate in and guide Agile ceremonies (Scrum, Standups, Sprint Planning, Kanban).

• Standards:
  Enforce database engineering standards, naming conventions, and governance practices across all deliverables.

• Troubleshooting:
  Investigate and resolve complex database-related issues and problems in production and non-production environments.

• BI Integration:
  Connect databases to business intelligence tools (Power BI, SSRS, etc.) for reporting and analysis.

• Collaboration:
  
  Work closely with developers, business analysts, and stakeholders to understand requirements and develop robust solutions.

• Staying Updated:
  Keep up-to-date with the latest SQL Server technologies, trends, and best practices.

• Microsoft SQL Server:
  Deep, production-grade experience with SQL Server (2016+).

• T-SQL:
  Advanced proficiency in writing complex queries, stored procedures, functions, and…