Senior SQL Server DBA (Azure)

Eila Solutions is seeking a seasoned Senior SQL Server Database Administrator with strong expertise in Azure to join their client’s team. The successful candidate will be responsible for managing and optimizing enterprise-level database environments, ensuring they deliver high performance, reliability, security, and availability. This full-time role is based in Gulshan-e-Jamal, Karachi, and requires a minimum of seven years of SQL Server DBA experience, including at least three years working with Azure platforms.

Key Responsibilities:
Optimize SQL Server performance by tuning queries, analyzing execution plans, indexing, and managing workloads. Design and maintain scalable database schemas and data models to support business needs. Oversee High Availability (HA) and Disaster Recovery (DR) solutions such as Always On Availability Groups, failover clustering, and Azure geo-replication. Administer SQL Server instances across Azure VMs, Azure SQL Managed Instances, and Azure SQL Databases. Implement and manage backup, recovery, monitoring, security, and routine database maintenance strategies. Lead migrations from on-premises SQL Server environments to Azure-based platforms. Automate database operations using PowerShell, dbatools, and Azure CLI tools. Troubleshoot production issues, perform root cause analysis, and provide mentorship to junior DBAs.

Required Qualifications:
A minimum of seven years’ experience as a SQL Server DBA with at least three years managing production workloads on Azure. Strong proficiency with SQL Server versions 2016 through 2022, including T-SQL, query optimization, and performance tuning. Hands-on experience administering Azure SQL Database, Managed Instances, and SQL Server on Azure VMs. In-depth knowledge of HA/DR technologies such as Always On Availability Groups, database mirroring, log shipping, and failover clustering. Practical expertise in backup and restore processes, disaster recovery planning, and database security best practices. Skilled in PowerShell scripting and database automation techniques. Familiarity with Azure networking, storage solutions, and identity management is essential.

Preferred Qualifications and Benefits:
Certification as a Microsoft Certified: Azure Database Administrator Associate (DP-300) is highly desirable. Experience with infrastructure as code tools like Terraform, Bicep, or ARM templates, as well as database CI/CD pipeline implementation, will be considered an advantage. Exposure to data integration and analytics tools such as SSIS, Azure Data Factory, Microsoft Fabric, Synapse Analytics, or Power BI is a plus. Knowledge of other database platforms like PostgreSQL or Cosmos DB is beneficial. Experience working in regulated environments adhering to standards such as SOC 2, HIPAA, or PCI DSS is preferred.

This role offers the opportunity to work in a dynamic environment where advanced database management and cloud technologies intersect, providing significant scope for professional growth and technical leadership.