Job Summary
- SQL Server Developer
Essential Skills/Basic Qualifications:
- Expert T‑SQL development (complex query design, stored procedures/functions, set-based approaches) with strong code quality and review discipline.
- Strong SQL Server performance engineering (execution plans, indexing, partitioning, tempdb, concurrency) and ability to diagnose production issues under pressure.
- Testing mindset and automation: tSQLt (or equivalent), data quality assertions, and ability to produce repeatable evidence for security/risk/control reporting.
- Good understanding of secure database development and data controls (access management, auditing, sensitive data handling) and confidence engaging with security and risk stakeholders.
Desirable skills/Preferred Qualifications
- Source control and branching strategies (Git/GitLab), pull requests, and code review standards.
- CI/CD tooling (e.g., GitLab) and release automation for database deployments.
- Artefact/repository management (e.g., Nexus) and dependency/version control.
- Scripting/automation (e.g., PowerShell and Linux shell scripting, plus Python where needed) and familiarity with server scheduling/orchestration patterns.
- Data governance/records management awareness (retention and evidencing) and how these apply to data products and reporting.
Working knowledge of Java and/or Scala particularly where used alongside Spark-based data processing.
Key Responsibilities
2. To conduct comprehensive code reviews, establish and oversee quality assurance processes, performance optimization , implementation of best practices and coding standards to ensure successful delivery of complex projects.
3. To ensure process compliance in the assigned module| and participate in technical discussions/review as a technical consultant for feasibility study (technical alternatives, best packages, supporting architecture best practices, technical risks, breakdown into components, estimations).
4. To collaborate with stakeholders to define project scope, objectives, deliverables and accordingly prepare and submit status reports for minimizing exposure & closure of escalations.