Job Description
Platform Management: Provision and manage Azure SQL Database (PaaS), Managed Instance, and SQL Server on VMs (IaaS).
Performance Engineering: Utilize Query Store, Azure Monitor, and AIOps tools to identify bottlenecks. Tune complex T-SQL queries and optimize indexing strategies.
High Availability & DR: Design and test Auto-Failover Groups, Geo-Replication, and Point-in-Time Restore (PITR) strategies to ensure zero data loss.
Security & Governance: Implement Always Encrypted, Dynamic Data Masking, and Azure AD (Entra ID) authentication. Conduct regular vulnerability assessments using Microsoft Defender for SQL.
Automation (DBA-as-Code): Use PowerShell, Azure CLI, and Terraform/Bicep to automate database deployments and scaling tasks.
Experience in Azure SQL (Single/MI), Azure Database for PostgreSQL/MySQL.
Proficiency in Azure Cosmos DB (RU vs. Autoscale), Vector search for AI apps.
Experience in Azure SQL Insights, Log Analytics, and Kusto Query Language (KQL).
T-SQL (Advanced), PowerShell, and Python.
Proficiency in Azure Database Migration Service (DMS), bacpac/dacpac orchestration.
Integration with Azure DevOps for Database CI/CD (State-based vs. Migration-based).
