Vacancy Opening
AI-Augmented SQL Engineer
Contract: Permanent/ Full Time
Location: Lahore, Pakistan
Hours: 10:00 to 18:30 (Mon to Fri)
Salary: Competitive DOE + 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 specialising 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.
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 you’ll get:
- 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) 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
- Work-Life-Balance
#J-18808-Ljbffr
