Azure SQL DB SME
Core
Technical authority for designing, deploying, securing, and operating Azure SQL database solutions supporting federal programs.
Role type
Senior IC Azure SQL Database Subject Matter Expert
Builds
Secure, scalable, and highly available database environments in Azure Government
Domain
Cloud Data Engineering / Federal IT
Required skills
Azure SQL Database, Azure SQL Managed Instance, T-SQL, database migration, performance tuning, Infrastructure as Code (Bicep/ARM/Terraform), PowerShell, Azure Data Factory, CI/CD pipelines, database security (Entra ID, TDE, Always Encrypted), capacity planning, root-cause analysis
Preferred skills
Azure Government Cloud experience, FedRAMP High compliance, Microsoft Fabric, Azure Cosmos DB, SSRS/SSIS, ledger tables, elastic query
Technologies
Azure SQL, Azure Data Factory, Synapse Analytics, Microsoft Fabric, Power BI, Azure DevOps, GitHub Actions, SQL Server Management Studio, Visual Studio Code, Azure Database Migration Service, Data Migration Assistant, SSMA, BACPAC/DACPAC, Elastic Jobs, Azure Automation, Azure Key Vault
Responsibilities
Advise on deployment options and purchasing models; design and provision secure Azure SQL environments; lead database migrations; develop and optimize ETL processes; write and optimize complex T-SQL; implement security best practices; manage capacity planning and cost optimization; automate maintenance tasks; implement DevOps practices; troubleshoot incidents; document architecture and mentor team members
Seniority
Senior, hands-on IC