SQL Database Administrator (Calrom)
Travel Innovation Group
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
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
Tools
Job description
Contract
Permanent / Full Time
Location
Calrom Lahore office; Askari Corporate Tower, 1st Floor
Shift pattern
11:00 am to 7:30 pm (Mondays to Fridays)
Salary
Market Competitive (depending on experience) plus additional benefits
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.
We’re looking for a SQL Database Administrator (SQL DBA) to join our team and help ensure the performance, availability, integrity, and reliability of our Microsoft SQL Server environments supporting business-critical applications.
The role will focus on administering SQL Server databases, investigating and resolving database-related incidents, optimising database performance, maintaining high availability, and supporting controlled data changes where required. You will work closely with our SRE, development, and application support teams to ensure our database platforms remain secure, resilient, and performant.
This is an excellent opportunity for someone who enjoys solving complex technical problems, improving database reliability, and developing their expertise across SQL Server administration, performance tuning, and operational support-
Tasks & responsibilities include:
- Administer, monitor, and maintain Microsoft SQL Server environments across production and non-production systems.
- Investigate and resolve database-related incidents, performance issues, and operational problems.
- Monitor database health, availability, capacity, and performance, proactively identifying potential issues.
- Analyse blocking, deadlocks, long-running queries, and resource utilisation to optimise database performance.
- Write, troubleshoot, and optimise SQL queries, stored procedures, functions, and views.
- Perform controlled data fixes in accordance with change management, governance, and audit requirements.
- Validate database changes to ensure data accuracy, integrity, and consistency.
- Manage SQL Server Agent jobs, scheduled maintenance tasks, and automated operational processes.
- Support SQL Server backup, restore, and disaster recovery procedures, including recovery testing where required.
- Assist in maintaining SQL Server High Availability solutions, including Failover Cluster Instances (FCI) and Availability Groups.
- Support application releases by validating database changes before and after deployments.
- Work closely with development teams to review database designs, improve query performance, and implement long-term solutions to recurring issues.
- Produce and maintain documentation for database administration procedures, incident investigations, recovery processes, and operational standards.
- Identify opportunities to improve database performance, automation, monitoring, security, and operational efficiency.
- Strong experience administering Microsoft SQL Server databases within production environments.
- Excellent knowledge of Microsoft SQL Server architecture, including databases, tables, indexes, statistics, stored procedures, execution plans, and database 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 database tasks.
- Good understanding of SQL Server backup, restore, recovery models, and disaster recovery processes.
- Experience supporting SQL Server security, including logins, users, roles, permissions, and least-privilege principles.
- Experience using SQL Server Management Studio (SSMS) for administration, troubleshooting, and performance analysis.
- Experience performing controlled production database changes whilst maintaining data integrity and auditability.
- Knowledge of database monitoring, capacity planning, and performance optimisation techniques.
- Strong analytical and troubleshooting skills with excellent attention to detail.
- Excellent communication skills and the ability to collaborate effectively with developers, infrastructure engineers, and business stakeholders.
- Strong organisational skills with the ability to manage multiple priorities in a production support environment.
- Experience supporting SQL Server Failover Cluster Instances (FCI).
- Knowledge of Windows Server Failover Clustering (WSFC).
- Experience supporting SQL Server Always On Availability Groups and other High Availability and Disaster Recovery (HADR) solutions.
- Experience with database maintenance automation using PowerShell, SQL, or Python.
- Knowledge of index optimisation, statistics management, partitioning, and database performance tuning.
- Experience using database monitoring tools such as Redgate SQL Monitor, SentryOne, SolarWinds DPA, or similar.
- Experience working within ITIL-based support environments and incident management processes.
- Experience supporting cloud-hosted SQL Server environments (Azure SQL, Azure SQL Managed Instance, or SQL Server on Azure/AWS).
- Familiarity with database release management and deployment tooling.
- Understanding of database governance, auditing, and compliance best practices.
- Strong analytical and problem-solving abilities.
- Excellent attention to detail and commitment to database reliability.
- Ability to prioritise effectively during production incidents.
- Strong communication and collaboration skills.
- Eagerness to continually develop SQL Server and database administration expertise.
- Ability to work effectively in a fast-paced operational environment.
- Successfully administer production and non-production SQL Server environments with minimal supervision.
- Maintain high database availability while meeting agreed service levels.
- Improve database performance through proactive monitoring, query optimisation, and tuning initiatives.
- Successfully support database releases, upgrades, and maintenance activities with minimal business impact.
- Contribute to improvements in database monitoring, automation, backup, and recovery processes.
- Reduce recurring database incidents through root cause analysis and preventative improvements.
- Participate effectively in incident response, problem management, and post-incident reviews.
- Maintain accurate documentation covering database administration procedures, disaster recovery, and operational support.
- 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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
