Azure SQL DB SME

Be an Early Applicant Remote Hiring Remotely in USA Senior level Remote Hiring Remotely in USA Senior level Serves as the technical authority for Azure SQL architecture, deployment, security, performance, operations, and migrations supporting federal programs. Designs secure Azure Government database environments, leads on-premises SQL Server migrations, develops T-SQL and data models, builds Azure Data Factory pipelines, implements DevOps and infrastructure automation, troubleshoots incidents, optimizes costs, documents standards, and mentors team members. Collaborates with engineering, architecture, data, and DevOps teams on reliable data platforms. The summary above was generated by AI, 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!, * 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 reviews, and code reviews.
• Document database architecture, configurations, runbooks, standards, and best practices, and mentor team members on Azure SQL capabilities., * Microsoft Certified: Azure Database Administrator Associate (DP-300).
• Microsoft Certified: Azure Administrator Associate (AZ-104) or Azure Solutions Architect Expert (AZ-305).
• Microsoft Certified: Fabric Data Engineer Associate (DP-700) or Azure Data Fundamentals (DP-900).
• Experience with Azure Government Cloud and federal compliance frameworks such as FedRAMP High, NIST 800-53, and DISA STIGs.
• Experience with Azure Data Factory, Synapse Analytics, Microsoft Fabric (including mirroring), and Power BI integration.
• Experience with Azure Cosmos DB, Azure Database for PostgreSQL, or other Azure data platforms.
• Familiarity with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), including SSIS in Azure Data Factory.
• Experience with Azure SQL features such as ledger tables, elastic pools, elastic query, and Azure SQL Database Hyperscale.
• Knowledge of application authorization methods for applications and APIs connecting to Azure SQL (e.g., managed identities, service principals, OAuth).
• Experience supporting the Department of Veterans Affairs or other federal agencies., Leads CrowdStrike’s Operational Services portfolio across active and pipeline deployments. Oversees delivery metrics, customer engagements, scoping, forecasting, contracts, resource allocation, and continuous improvement. Partners with Sales, Legal, Product, Engineering, and go-to-market teams while building and mentoring a high-performing services organization. Supports cybersecurity platform engagements and ensures consistent, high-quality customer outcomes. Top Skills: Ai TechnologiesCrowdstrike FalconEdrGainsightPortfolio Management ToolsProject Management ToolsSalesforceSIEMSoar CrowdStrike, Manage data center financial operations through budgeting, variance analysis, financial modeling, month-end close reporting, cost-saving initiatives, and strategic analysis. The role requires data warehousing and modeling expertise, hardware and asset-management understanding, process improvement, automation, and effective communication with leadership and cross-functional partners. Top Skills: Artificial IntelligenceData ModelingData WarehousingExcelMicrosoft Powerpoint Liberty Mutual Insurance

• Bachelor’s degree in Computer Science, Information Systems, or a related technical field (or equivalent experience).
• 7+ years of experience with Microsoft SQL Server database administration, development, or engineering.
• 3+ years of hands-on experience with Azure SQL Database and/or Azure SQL Managed Instance in production environments.
• Expert-level T-SQL skills, including query optimization, indexing, and database performance tuning.
• Deep understanding of Azure SQL deployment options, service tiers (General Purpose, Business Critical, Hyperscale), and purchasing models (vCore, DTU, serverless).
• Experience with performance troubleshooting tools such as Query Store, DMVs, Extended Events, and execution plan analysis.
• Experience migrating SQL Server schemas and data to Azure using Azure Database Migration Service, Data Migration Assistant, or similar tools.
• Strong knowledge of Azure SQL security features, including Microsoft Entra ID authentication, TDE, Always Encrypted, auditing, Private Link, and Key Vault.
• Proficiency with SQL Server Management Studio (SSMS) and Visual Studio Code with the MSSQL extension.
• Experience with PowerShell, Azure CLI, and Infrastructure as Code (Bicep, ARM, or Terraform).
• Familiarity with CI/CD for databases using Azure DevOps or GitHub Actions.
• Knowledge of Agile, Scrum, and SAFe methodologies.
• Ability to obtain and maintain a Public Trust or Suitability/Fitness determination based on client requirements.
• Careful, reliable, and detail-oriented when performing high-impact administration tasks.

2 Hours Ago Remote or Hybrid 45K-85K Annually Junior 45K-85K Annually Junior Artificial Intelligence * Fintech * Insurance * Marketing Tech * Software * Analytics Handle inbound calls and warm leads, advise customers on insurance coverage, match products to their needs, and convert prospects into policyholders. Complete paid Property and Casualty licensing training, represent the Liberty Mutual brand, provide customer-focused service, and meet sales goals. The role is remote and requires working four weekdays plus one weekend day on an assigned shift. Top Skills: Cable InternetDslFiber InternetPc

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute