Azure SQL DB SME

About Our Team

Our employees thrive in a culture that’s fast-paced and ego-free, where innovation and collaboration are encouraged at every turn. We are an organization that provides federal agencies instant access to experienced and talented professionals who understand their unique challenges and know the most efficient ways to address them. We are continually investing in resources and talent, so we stay prepared with specialized teams in place who are experts in creating tailored technologies. Our solutions empower Federal organizations to grow, modernize, and succeed in a rapidly evolving landscape.

We value all voices and want to attract talent from all backgrounds. We’re on the lookout for individuals who are passionate about technology and thrive in environments where problem-solving is approached with creativity and enthusiasm. If you’re someone who enjoys continuously expanding your skill set while tackling real-world business problems, you’ll feel right at home with us. Veterans and military spouses are especially encouraged to bring your unique and valuable experience to our team.

About the Role:

We are seeking an experienced Azure SQL DB SME to serve as the technical authority for the design, deployment, security, performance, and operation of Azure SQL database solutions supporting federal programs. The ideal candidate will bring deep hands-on expertise across the Azure SQL family, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines, along with strong T-SQL, performance tuning, high availability/disaster recovery, and database migration skills. You’ll architect and maintain secure, scalable, and highly available database environments in Azure Government, lead migrations from on-premises SQL Server, and partner with developers, data engineers, and DevOps teams to ensure applications and data pipelines are built on a reliable data foundation. By joining our organization, you’ll help federal agencies modernize their data platforms and deliver better services to the people who depend on them!

Key Responsibilities

• Serve as the subject matter expert for Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs, advising on the right deployment option, service tier, and purchasing model (vCore, DTU, serverless, elastic pools, and Hyperscale).
• Design, provision, and configure secure, scalable Azure SQL environments in Azure Government using Infrastructure as Code (Bicep, ARM templates, Terraform), PowerShell, and Azure CLI.
• Plan and lead database migrations from on-premises SQL Server and other platforms to Azure SQL using Azure Database Migration Service, Azure Migrate, Data Migration Assistant, SQL Server Migration Assistant (SSMA), and BACPAC/DACPAC tooling.
• Design and implement scalable, secure, and efficient data pipelines using Azure Data Factory (ADF).
• Develop and optimize ETL processes to ingest, transform, and store data in Azure Data Lake, SQL, and Synapse Analytics.
• Write, review, and optimize complex T-SQL, including stored procedures, functions, views, triggers, and indexing strategies.
• Design and maintain relational data models and database schemas that support application, reporting, and analytics workloads.
• Implement database security best practices, including Microsoft Entra ID (formerly Azure AD) authentication, managed identities, RBAC, Transparent Data Encryption (TDE), Always Encrypted, Dynamic Data Masking, Row-Level Security, SQL auditing, Private Link/private endpoints, firewall rules, and Azure Key Vault.
• Manage capacity planning, scaling, and cost optimization across Azure SQL resources, including reserved capacity and right-sizing recommendations.
• Automate database maintenance and operational tasks using Elastic Jobs, SQL Agent (Managed Instance), Azure Automation, and PowerShell.
• Implement database DevOps practices, including SQL Database Projects, SqlPackage, schema versioning, and CI/CD pipelines using Azure DevOps or GitHub Actions.
• Support integration of Azure SQL with Azure Data Factory, Synapse Analytics, Microsoft Fabric, and Power BI for data movement, reporting, and analytics.
• Troubleshoot and resolve database incidents, including blocking, deadlocks, connectivity issues, and resource contention, and conduct root-cause analysis.
• Collaborate with software engineers, architects, data engineers, and DevOps teams, and participate in Agile/Scrum ceremonies, design rev…