Senior SQL DB Engineer (with GitHub Copilot)

About the role

Calrom is looking for a strong SQL Engineer with an AI, automation and enablement mindset. The role turns SQL expertise into standards, guardrails and AI-assisted tooling that lets SQL be generated, reviewed and optimised safely at scale.

Key responsibilities

• Use AI to write and optimise SQL queries, stored procedures and database components within defined engineering guardrails.
• Build AI-assisted capabilities to generate and review SQL for performance, security, reliability and maintainability.
• Use AI for execution-plan analysis, indexing recommendations, troubleshooting, root-cause analysis, documentation and test generation.
• Review complex or high-risk database changes where specialist engineering judgement is required.
• Enable development teams to safely use AI for routine SQL development and database work.
• Work with developers, QA engineers and DevOps to embed SQL standards and AI-assisted checks into Pull Requests and CI/CD pipelines.
• Support knowledge sharing through documentation, internal demos and peer mentoring on SQL best practice and safe AI usage.

Required profile

• Strong experience with Microsoft SQL Server and T-SQL.
• Proven ability in database troubleshooting and root-cause analysis.
• Hands-on experience with Git, Pull Requests and CI/CD.
• Exposure to Azure SQL, and scripting or development in C#, Python or PowerShell, is an advantage.

Required skills

• Query optimisation, performance tuning and reading execution plans.
• Indexing, stored procedures and database design.
• SQL engineering standards and best practices.
• Experience with GitHub Copilot, OpenAI / Azure OpenAI, AI-assisted development or automated code review is an advantage.

What we offer

• Modern office in central Lahore with open-plan environment.
• Medical insurance (OPD+IPD) for self and dependents; pension scheme fund after probation; EOBI.
• Gym passport or building gym, onsite secured parking for cars and bikes.
• Monthly mobile allowance (PKR 2,700) for senior software/data engineers, bi-annual bonuses of 10% of basic salary, referral bonus of PKR 25,000.
• Personal development program, career progression and clear career path, paid professional certifications, monthly birthday celebrations and company-sponsored recreational trips and team-building events.
• Company-provided lunch every day, leave bank and encashment policy.