SQL Server Lead

Job description

Anticipated Contract End Date/Length: December 31, 2026 Work Set Up: Hybrid (2–3 days per week in office; remaining days remote) Clearance Required: BPSS Eligibility Required Our client in the Information Technology and Services industry is looking for a SQL Server Lead to design, develop, and optimize enterprise-scale SQL Server solutions supporting security, risk, control, and records management initiatives. This hands-on technical leadership role requires deep expertise in SQL Server development, performance engineering, data modeling, and database architecture to deliver trusted, resilient, and compliant data platforms. The successful candidate will lead technical delivery, mentor engineers, and collaborate with cross-functional stakeholders to build scalable, high-performing database solutions while ensuring compliance with enterprise security and governance standards. What you will do: Lead the end-to-end delivery of SQL Server components from requirements gathering through design, development, deployment, and documentation. Design, develop, and optimize complex T-SQL stored procedures, functions, views, and database objects. Build and maintain scalable data models and physical schemas that support security, risk, control, and records management reporting. Engineer resilient batch and near-real-time data processing solutions. Perform data profiling, root cause analysis, incident investigation, and problem management. Optimize SQL Server performance through execution plan analysis, indexing strategies, partitioning, statistics management, and IO/CPU tuning. Implement automated testing, data quality checks, reconciliations, and repeatable validation processes. Support SIT, UAT, deployment, and release management activities. Ensure database solutions comply with security, classification, retention, access control, auditing, and segregation of duties requirements. Collaborate with engineers, analysts, architects, product owners, and governance teams to translate business and regulatory requirements into technical solutions. Review code, enforce development standards, and mentor team members on SQL Server best practices. Monitor production environments, troubleshoot issues, and implement performance improvements and automation. Maintain clear data lineage, documentation, and interfaces between upstream and downstream data products. Proactively manage delivery risks, dependencies, and continuous improvement initiatives. Bachelor's degree in Computer Science or a closely related discipline, or equivalent professional experience. Demonstrated expertise in SQL Server development with advanced T-SQL programming, including complex queries, stored procedures, functions, and set-based development. Strong experience designing and optimizing SQL Server workloads through execution plan analysis, indexing, partitioning, concurrency management, and performance tuning. Proven experience designing and implementing enterprise data models and database schemas. Experience developing secure database solutions with strong knowledge of access controls, auditing, sensitive data handling, and security best practices. Strong understanding of testing methodologies, including SQL unit testing, automated data quality validation, and reconciliation processes. Experience supporting production database environments, including incident management, troubleshooting, and performance optimization. Familiarity with Git or GitLab source control, branching strategies, pull requests, and code review processes. Experience with CI/CD pipelines and database deployment automation. Familiarity with artifact repository management tools such as Nexus. Experience with PowerShell, Linux shell scripting, Python, or similar automation technologies. Understanding of data governance, records management, retention policies, and regulatory compliance requirements. Working knowledge of Java and/or Scala, particularly within Spark-based data processing environments, is preferred. Strong stakeholder management, communication, mentoring, and technical leadership skills. Ability to manage multiple priorities while delivering high-quality solutions in a fast-paced enterprise environment. Please submit a CV/resume (mandatory) along with your application. All your information will be kept confidential according to EEO guidelines. Candidates must be legally authorized to live and work in the country where the position is based, without requiring employer sponsorship. HelloKindred is committed to fair, transparent, and inclusive hiring practices. We assess candidates based on skills, experience, and role-related requirements. We appreciate your interest in this opportunity. While we review every application carefully, only candidates selected for an interview will be contacted. HelloKindred is an equal opportunity employer. We welcome applicants of all backgrounds and do not discriminate on the basis of race, colour, religion, sex, gender identity or expression, sexual orientation, age, national origin, disability, veteran status, or any other protected characteristic under applicable law. Who is HelloKindred? HelloKindred are specialists in staffing marketing, creative and technology roles, offering a range of talent solutions that can be delivered on-site, remotely or hybrid. Our vision is to make work accessible and people’s lives better. We do this by disrupting traditional employment barriers – connecting ambitious talent to flexible opportunities with trusted brands.