AI Augmented - Senior SQL DB Engineer

Role: AI-Augmented SQL Engineer Reports To : Engineering Lead Department: Development / Engineering Shift: Day shift [10:00 am to 06:30 pm (Mondays to Fridays)] Working Model: Onsite Location: Calrom Lahore office; Office #1 & 4, 1st Floor, Askari Corporate Tower, 75/76 D1, Main Boulevard, Gulberg III, Lahore. Contract: Permanent. Salary: Market Competitive (depending on experience) plus additional benefits

Who we are?

Calrom Pakistan (Private) Limited (Microsoft Gold Partner) is tech division of Travel Innovation Group (Lime Management, Aviate and Calrom Limited) which has more than 250 staff all over the world.

Calrom Pakistan Limited is a fast-growing SaaS tech company specializing in group booking solutions, fare distribution, air shopping and ticketing systems for airlines. Our systems are used by some of the world’s largest and most respected airlines, which is a testament to our passion for creating quality and innovative software solutions. About this Role We are looking for an experienced AI-Augmented SQL Engineer to provide specialist SQL engineering capability across our Development teams. The role combines strong SQL expertise with an AI-first approach. You will define SQL standards, best practices and guardrails, and use AI to generate, review, test and optimise SQL queries, stored procedures and database components

The objective is to scale SQL expertise across Development through AI, automation and reusable engineering practices.

SQL Standards & AI Guardrails

· Define SQL engineering standards, best practices and AI guardrails for queries, stored procedures, indexing, schema changes and database components.

· Translate SQL standards into AI prompts, review rules and automated checks

· Define validation and approval guardrails for AI-generated SQL, including when specialist human review is required

· Continuously improve SQL standards, AI guardrails and tooling based on engineering and production findings.

AI-Assisted 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.

You 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.

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.

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:********************************************