· Lead complex administration and optimization of mission-critical SQL Server and Azure SQL environments; architect and configure Always On Availability Groups, geo-replication, Azure failover groups, and HADR workflows to meet RPO/RTO objectives.
· Lead database migration projects (on-premises SQL Server to Azure SQL Managed Instance, Azure SQL Database, or IaaS), utilizing Azure Database Migration Service (DMS) and hybrid network integration patterns.
· Perform advanced performance engineering: deep wait-stat analysis, blocking/deadlock mitigation, complex T-SQL tuning, Query Store and Extended Events diagnostics, and index strategy redesign.
· Implement and enforce advanced security controls: Always Encrypted, Dynamic Data Masking, Row-Level Security (RLS), Azure Key Vault integration, Purview sensitivity labeling, and STIG/SOC 2 baseline configurations.
· Build and maintain Infrastructure as Code (IaC) deployment pipelines using Terraform or Bicep; integrate database schema migrations and deployments into Azure DevOps or GitHub Actions CI/CD workflows.
· Configure and operate Microsoft Fabric workspaces, Lakehouses, Warehouses, and integration pipelines; manage Fabric capacity scaling, workspace access models, and operational support runbooks.
· Partner with data engineering, architecture, governance, and application teams to improve data quality, lineage tracking, metadata completeness, and platform service delivery.
· Contribute to governance execution by configuring Microsoft Purview data cataloging, verifying data lineage, and enforcing data classification standards.
· Conduct root cause analysis for complex incidents; lead post-incident reviews and present findings and remediation plans to technical stakeholders.