Senior SQL Server DBA - Azure

Eila Solutions is seeking an experienced Senior SQL Server Database Administrator with expertise in Azure to join a dynamic team based in Gulshan-e-Jamal, Karachi. This full-time role requires a professional who can manage and optimize enterprise database environments, ensuring high performance, reliability, security, and availability. The ideal candidate will have over seven years of SQL Server DBA experience, including at least three years working with Azure cloud technologies.

Key Responsibilities

- Optimize SQL Server performance through query tuning, execution plan analysis, indexing strategies, and workload management.
- Design and maintain scalable database schemas and data models to support business needs.
- Manage High Availability (HA) and Disaster Recovery (DR) solutions, including Always On Availability Groups, failover clustering, and Azure geo-replication.
- Administer SQL Server environments on Azure Virtual Machines, Azure SQL Managed Instance, and Azure SQL Database platforms.
- Implement and maintain backup, recovery, monitoring, security, and routine database maintenance procedures.
- Lead migrations of on-premises databases to Azure cloud infrastructure.
- Automate database operations using PowerShell, dbatools, and Azure CLI to improve efficiency and reduce manual intervention.
- Troubleshoot production incidents, perform root-cause analysis, and provide mentorship to junior DBAs.

Required Qualifications

- Minimum of 7 years’ experience as a SQL Server Database Administrator, with at least 3 years managing production workloads on Azure.
- Strong proficiency in SQL Server versions 2016 through 2022, including T-SQL programming, query optimization, and performance tuning.
- Hands-on experience with Azure SQL Database, Azure SQL Managed Instance, and SQL Server hosted on Azure VMs.
- In-depth knowledge of High Availability technologies such as Always On Availability Groups, database mirroring, log shipping, and failover clustering.
- Practical skills in backup and restoration processes, disaster recovery planning, and database security best practices.
- Proficiency in scripting and automation using PowerShell, along with familiarity with database automation tools.
- Solid understanding of Azure networking, storage solutions, and identity management principles.

Preferred Qualifications

- Microsoft Certified: Azure Database Administrator Associate (DP-300) certification is highly desirable.
- Experience working with infrastructure as code tools such as Terraform, Bicep, or ARM templates, and familiarity with database CI/CD pipelines.
- Exposure to data integration and analytics tools including SSIS, Azure Data Factory, Microsoft Fabric, Synapse Analytics, or Power BI.
- Knowledge of additional database platforms such as PostgreSQL or Cosmos DB is advantageous.

This role offers the opportunity to work in a challenging environment where advanced database administration skills and cloud expertise are valued. Candidates who thrive in collaborative settings and are passionate about optimizing database performance in Azure cloud environments will find this position rewarding.