Database Developer
Vision Group Retail
Job Description
Job Role: Senior SQL Database Developer Overview We are looking for an experienced Senior SQL Database Developer to join our team. This role is ideal for someone with strong hands-on experience in SQL Server and Azure SQL , especially working with large databases, high-volume data systems, and complex SQL development . We need someone who is comfortable writing advanced SQL logic, solving performance issues, and building reliable database solutions for business-critical systems.
The person in this role will play a key part in designing, improving, and supporting scalable database platforms that handle large amounts of data efficiently. Key Responsibilities Develop, maintain, and enhance complex SQL queries, stored procedures, views, functions, and database objects Write advanced SQL logic for data processing, reporting, validations, reconciliations, and business rules Work on complex joins, CTEs, dynamic SQL, window functions, temp tables, cursors (where required), and performance-focused query design Analyse and optimize slow-running queries using execution plans, Query Store, indexing, and query tuning techniques Work with large Azure SQL databases handling high transaction volumes and large datasets Design efficient and scalable database schemas for long-term growth Implement and manage partitioning, columnstore indexes, compression, archiving, and data retention strategies Troubleshoot blocking, deadlocks, CPU, memory, and IO bottlenecks Support and optimize Azure SQL Database / Managed Instance environments Build and support data pipelines using Azure Data Factory, Synapse, Logic Apps , or similar tools Participate in data migration projects with minimal downtime and proper validation Implement advanced database features such as CDC, auditing, and temporal tables Support deployment and release processes through CI/CD using Azure DevOps / GitHub Provide production support and perform root cause analysis for critical issues Required Experience 5+ years of hands-on experience in SQL Server / Azure SQL Strong experience with large Azure SQL databases and enterprise-scale systems Strong expertise in writing complex SQL code and business logic Excellent knowledge of query optimization, execution plans, indexing, and database tuning Good understanding of partitioning, data modelling, and high-volume processing Experience with ADF, Synapse, Logic Apps , and cloud-based data solutions Exposure to data migration and automated deployments Personal Skills Strong analytical and troubleshooting skills Able to work independently and take ownership Good communication and collaboration skills Detail-oriented with a practical approach to problem solving