Skip to main content

Senior SQL DB Engineer (with GitHub CoPilot)

Technology
Calrom
Lahore, Pakistan3 weeks ago
Full time

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

Keywords
PDPDevOpsDatabasesRoot Cause AnalysisContinuous Integration (CI)C#Business Intelligence (BI)OptimizationDevelopment ProgramsTelecommunications TowersMicrosoft SQL ServerPowershellPythonSqlCI/CDMaintainability

Interested in this role?