Senior SQL DBA - Performance & High Availability

Travel Innovation Group; Lahore; On-site; PKR 2,400,000 - 3,600,000; Full time

Benefits offered by this job

Medical Insurance

Pension Scheme

Lunch provided

Professional Certifications

Annual bonuses

Job summary

Calrom Pakistan (Private) Limited, part of Travel Innovation Group, invites applications for a SQL Database Administrator in Lahore. The role focuses on administering SQL Server databases, ensuring performance, availability, integrity, and reliability across production and non-production environments.

You will work with SRE, development, and support teams to optimize databases, implement HA/DR, and support deployments, while documenting procedures and standards for operational excellence.

Qualifications

• Experience administering Microsoft SQL Server databases in production environments.
• Strong knowledge of SQL Server architecture, including databases, tables, indexes, statistics, stored procedures, execution plans, and relationships.
• Experience writing, troubleshooting, and optimising complex SQL queries.
• Experience investigating and resolving database performance issues.
• Experience administering SQL Server Agent jobs, maintenance plans, and scheduled tasks.
• Knowledge of backup, restore, recovery models, and disaster recovery processes.
• Experience supporting SQL Server security, including logins, users, roles, permissions, and least-privilege principles.
• Experience using SSMS for administration, troubleshooting, and performance analysis.

Responsibilities

• Administer, monitor, and maintain Microsoft SQL Server environments across production and non-production systems.
• Investigate and resolve database incidents and performance issues.
• Monitor health, availability, capacity, and performance; proactively identify issues.
• Analyse blocking, deadlocks, long-running queries and resource usage for optimization.
• Write, troubleshoot, and optimise SQL queries, stored procedures, functions, and views.
• Perform controlled data fixes per change governance and audit requirements.
• Validate changes to ensure data accuracy and consistency.
• Manage SQL Server Agent jobs and scheduled maintenance tasks.
• Support backups, restores, and disaster recovery procedures, including testing.

Skills

Microsoft SQL Server

T-SQL

Performance tuning

Backup & DR

SSMS

Windows Server

High Availability

Incident resolution

Tools

SSMS

SQL Server Agent

PowerShell

Azure SQL

Job description

Calrom Pakistan (Private) Limited, part of Travel Innovation Group, invites applications for a SQL Database Administrator in Lahore. The role focuses on administering SQL Server databases, ensuring performance, availability, integrity, and reliability across production and non-production environments.

You will work with SRE, development, and support teams to optimize databases, implement HA/DR, and support deployments, while documenting procedures and standards for operational excellence.