Database Administrator (MS SQL Server & Azure)

Role Overview

We are seeking a highly skilled Database Administrator with deep expertise in Microsoft SQL Server and working knowledge of Azure SQL Services. You will be responsible for the performance, integrity, and security of our databases. This role is critical in ensuring high availability and disaster recovery readiness, as well as guiding our migration strategy from on-premise to cloud-native solutions.

Key Responsibilities

1. MS SQL Server Administration (On-Premise & IaaS)

• Install, configure, and maintain SQL Server instances (2016/2019/2022).

• Proactively monitor database health, performance, and resource utilization.

• Perform index and statistics maintenance, query optimization, and execution plan analysis.

• Manage complex T-SQL scripting, stored procedures, and jobs (SQL Agent).

• Implement Always On Availability Groups, Failover Clustering, and Log Shipping.

2. Azure SQL Environment Management

• Administer and maintain Azure SQL Database (PaaS) and Azure SQL Managed Instances.

• Configure elastic pools, DTU/vCore tuning, and geo-replication.

• Assist in migration strategies using Azure DMS (Database Migration Service) or backup/restore methods.

• Monitor Azure resource costs and recommend right-sizing of instances.

3. Security & Compliance

• Implement database-level security (Row-Level Security, Dynamic Data Masking, TDE).

• Manage user access, roles, and permissions adhering to least-privilege principles.

• Ensure compliance with data protection regulations (GDPR, HIPAA, SOC2, etc.).

4. Backup & Disaster Recovery

• Design and test backup/restore strategies (Native, Ola Hallengren scripts, Azure Backup Vault).

• Establish RPO/RTO objectives and document DR runbooks.

• Perform regular restoration drills.

5. Automation & CI/CD

• Automate routine maintenance tasks using PowerShell, T-SQL, or Azure Automation.

• Collaborate with DevOps teams to integrate database changes into CI/CD pipelines (Azure DevOps, GitHub Actions).

Qualifications

Must-Have:

• 4+ years of experience as a SQL Server DBA.

• Strong proficiency in SQL Server Performance Tuning, Profiler, and Extended Events.

• Hands-on experience with High Availability (HA) and Disaster Recovery (DR) solutions.

• Azure Experience: At least 1 year of hands-on work with Azure SQL DB or Managed Instance.

• Proficiency in PowerShell scripting or T-SQL automation.

• Solid understanding of backup/recovery models and transaction log management.