Senior SQL DB Engineer (with GitHub CoPilot)
Job description
What we are looking for A strong SQL Engineer with an AI, automation and enablement mindset who can turn SQL expertise into standards, guardrails and AI-assisted tooling that enables SQL to be generated, reviewed and optimised safely at scale.
You are supposed to have:
· Strong experience with Microsoft SQL Server and T-SQL.
· Strong experience in query optimisation, performance tuning and reading execution plans.
· Strong experience with indexing, stored procedures and database design.
· Proven ability in database troubleshooting and root-cause analysis.
· Strong understanding of SQL engineering standards and best practices.
· Hands-on experience with Git, Pull Requests and CI/CD.
· Experience with GitHub Copilot, OpenAI / Azure OpenAI, AI-assisted development or automated code review is an advantage.
· Exposure to Azure SQL, and scripting or development in C#, Python or PowerShell is an advantage.
AI-driven SQL Engineering
· 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.
Enablement & Collaboration
· Enable Development teams to safely use AI for routine SQL development and database-related work.
· Work closely 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.
Exciting benefits we offer?
- Modern office in central Lahore with a great space to kick back and relax or collaborate with the team.
- Medical Insurance (OPD+IPD) for self & dependents (Spouse, children and as well as Parents).
- Pension Scheme Fund (Applicable after Probation Period).
- Gym Passport (or) Building Gym (available here in Askari Corporate Tower).
- Due Annual Increments (+) Inflation based adjustments (if applicable).
- (PDP) - Personal Development Program.
- Career Progression and Clear Career Path (SIFA based).
- Company Provided Lunch Everyday.
- Open Plan Environment.
- Company Sponsored Recreational (Local) Trips (and/or) team building events and activities.
- Company Celebration Dinners (e.g) Annual dinners, Iftar dinners. Etc.
- Company Paid Sports Activities.
- Onsite Secured Parkings for your Cars and Bikes.
- Company Paid Professional Certifications. (i.e) reimbursements subject to business needs.
- Monthly Birthday Celebrations of Employees.
- Bi-annual Bonuses (10% of your basic salary)
- Referral Bonuses. (PKR. 25,000)
- Leave Bank & Encashment Policy.
- Monthly Mobile Allowance (PKR. 2,700) for Senior Software Engineers / Senior Data Engineers.
- EOBI.
- W O R K - L I F E - B A L A N C E
Get to know us more …
We’re so glad this position has caught your eye! Take a deeper look into who we are and what we do by visiting our website > https://www.calrom.com/
OR email in confidence at: nsiddiqui@calrom.com
Interested in this role?