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.
Key Responsibilities
1. Database Design & Development
- 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.
2. Performance & Integrity
- 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.
3. ETL & Data Integration
- 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.
4. Client Engagement & Analysis
- 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.
5. Technical Leadership & Mentorship
- 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.
6. Business Intelligence & Collaboration
- 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.
Technical Competencies
Essential (Core Expertise)
- Microsoft SQL Server: Deep, production‑grade experience with SQL Server (2016+).
- T‑SQL: Advanced proficiency in writing complex queries, stored procedures, functions, and triggers.
- Performance Tuning: Proven ability to optimise queries, indexing, and execution plans.
- Database Design: Strong experience in schema design, normalisation, and data modelling.
- ETL: Experience with SQL Server Integration Services (SSIS) or similar ETL tools.
- Version Control: Experience with database version control tools (e.g., Redgate, Azure DevOps, Git).
- Tools: Proficiency with SQL Server Management Studio (SSMS), Azure Data Studio, or similar.
Advantageous (Nice to Have)
- Azure SQL: Experience with Azure SQL Database or Azure SQL Managed Instance.
- Business Intelligence: Exposure to Power BI, SSRS, or SSAS.
- Open Source: Experience with PostgreSQL or MySQL.
- DevOps: CI/CD for database deployments.
- Data Warehousing: Experience with dimensional modelling (Star Schemas) and data warehousing concepts.
Qualifications & Experience
Essential:
- 5+ years of experience in SQL development within the Microsoft ecosystem.
- Proven experience in database design, performance tuning, and ETL processes.
- Strong client‑facing or consulting experience is highly valued.
Advantageous:
- BSc Computer Science, Engineering, Mathematics, or equivalent 3‑year qualification.
- Microsoft SQL Server certification (e.g., MCSA, MCSE).
- Experience in the financial services, insurance, or healthcare sectors.
Why Join DVT?
- Work with cutting‑edge database technologies on real‑world, large‑scale projects.
- Be part of a globally recognised software engineering brand.
- Collaborative, agile culture with a strong focus on continuous learning and certification.
- Opportunity to mentor and lead — not just code.
- Competitive remuneration and benefits.
- Exposure to diverse industries and challenging client problems.
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
