Database Administrator

Stewart Pakistan Private Limited; Lahore; On-site; PKR 670,000 - 1,339,000; Full time

Job summary

Stewart Pakistan Private Limited in Lahore seeks an entry-level MSSQL & Azure SQL DBA to provide first-level support, monitoring, and maintenance of on-premises SQL Server and cloud-based Azure SQL environments. The candidate will handle routine tasks, respond to alerts, and escalate complex issues to L2/L3 teams while ensuring database availability, performance, and stability.

Requirements include basic SQL Server knowledge, T-SQL, and familiarity with Azure monitoring tools.

Qualifications

• Bachelor’s degree in computer science, IT, or related field.
• Willingness to work rotational/night shifts.
• Strong analytical and problem-solving skills.
• Basic knowledge of SQL Server backups, restore, and maintenance.
• Familiarity with Azure SQL Database concepts and monitoring tools.

Responsibilities

• Monitor SQL Server and Azure SQL health, availability, and alerts.
• Perform daily health checks: backups, disk space, services, logs, jobs.
• Respond to incidents within defined SLAs; escalate as needed.
• Perform backups/restores and verify backup jobs.
• Monitor and resolve blocked processes, long-running queries, and HA/DR basics.
• Manage logins, roles, and permissions (SQL & Azure AD).
• Document activities, prepare handover reports, update runbooks.
• Escalate unresolved issues to L2/L3 support.

Skills

SQL Server knowledge

Azure SQL basics

T-SQL queries

Incident response

Communication & ticketing

Education

Bachelor’s degree in CS/IT

Tools

Azure Monitor

SQL Server tools (SSMS, Agent)

SCOM/SolarWinds/Redgate

PowerShell

Job description

Job Summary

We are seeking entry-level (L1) MSSQL & Azure SQL DBA to provide first-level support, monitoring, and maintenance of on-premises SQL Server and cloud-based Azure SQL database environments. The candidate will handle routine operational tasks, respond to alerts, and escalate complex issues to L2/L3 teams while ensuring database availability, performance, and stability.

Key Responsibilities

• Monitor database health, availability, jobs, and alerts for both on-prem SQL Server and Azure SQL.
• Perform daily health checks (backups, disk space, SQL services, error logs, job status).
• Handle and respond to incidents/tickets within defined SLAs.
• Perform backups and restores; verify backup jobs and troubleshoot failures.
• Monitor and resolve failed SQL Agent jobs / Elastic Jobs (Azure).
• Manage user access, logins, roles, and basic permissions (SQL & Azure AD authentication).
• Monitor blocking, long-running queries, and basic performance issues.
• Support High Availability setups (Always On, Log Shipping, Mirroring, Azure geo-replication) at a monitoring level.
• Document activities, prepare shift handover reports, and update runbooks.
• Escalate unresolved or complex issues to L2/L3 teams.

Azure SQL Specific Responsibilities:

• Monitor Azure SQL Database / Managed Instance health using Azure Portal and Azure Monitor.
• Track DTU/vCore utilization, storage, and performance metrics.
• Monitor automated backups, Point-in-Time Restore (PITR), and geo-replication status.
• Basic support for Azure SQL configuration (firewall rules, connectivity issues).
• Raise alerts for resource scaling needs (compute/storage) to higher teams.
• Familiarity with Azure alerts, Log Analytics, and basic KQL queries (good to have).

Required Skills:

• Basic knowledge of SQL Server (2012/2014/2016/2019/2022) architecture.
• Understanding of backup/restore, recovery models, and jobs.
• Familiarity with T-SQL queries (SELECT, JOIN, basic troubleshooting).
• Knowledge of indexes, deadlocks, and blocking concepts.
• Basic understanding of HA/DR concepts (Always On, Log Shipping, Clustering).
• Basic understanding of Azure SQL Database & Azure SQL Managed Instance concepts.
• Awareness of monitoring tools (SCOM, Redgate, SolarWinds, Azure Monitor, or native tools).
• Good communication and ticketing tool experience (ServiceNow, Remedy, JIRA).

Good to Have:

• Microsoft certification (Azure Data Fundamentals DP-900, Azure Database Administrator Associate DP-300, or SQL Server certifications).
• Exposure to Windows Server and basic scripting (PowerShell / Azure CLI).
• Awareness of other cloud databases (AWS RDS).

Educational Qualification:

• Bachelor’s degree in computer science, IT, or related field.

Soft Skills:

• Willingness to work in rotational/night shifts.
• Strong analytical and problem-solving skills.
• Team player with a proactive attitude.

Timings: 6PM TO 3AM OR candidate must be flexible with the rotational working hours

Location: NASTP, Lahore