Azure Database Engineer / Azure Data Platform Engineer

MicroSystems Automation Group (MSAG) is Small Business providing Management Consulting, Information Technology, and Physical Solutions products and services that create value and solve complex problems since 1987. We have a rich history of working with clients to understand their business problems and leverage our technical expertise and knowledge to deliver solutions to improve business performance. Our company has a GREAT corporate culture, and we are committed to providing the very best to our clients and employees.

Summary Description:

We are seeking a seasoned Azure Database Engineer to lead a large‑scale modernization and cloud transformation initiative as we migrate our on‑premises database ecosystem into the Azure Government Cloud. This role will be responsible for designing, implementing, and supporting Azure‑based database solutions, with a strong focus on automation, infrastructure as code, database operations, data movement, and platform reliability.

As a key contributor to shaping our future‑state data platform, the engineer will drive automation, standardization, and cloud‑native best practices to build a secure and operationally efficient environment. Because our organization must comply with FIPS 800‑53 and Azure Government Cloud security requirements, candidates must bring proven expertise in designing and operating systems that meet rigorous security and compliance standards from initial architecture through ongoing operations. automation, and operational management of our database platform in Azure Government. The role also includes re-engineering our legacy reporting architecture into a modern, Azure-native reporting platform built on Azure Data Factory and related Azure data services.

Key Responsibilities

• Design, implement, and Azure SQL Managed Instance environments.

• Develop and maintain Infrastructure as Code (Bicep/Terraform) for database infrastructure deployment.

• Automate database provisioning, backup, restore, refresh, and migration processes.

• Design and implement database refresh strategies between Production, Staging, and Development environments, including data masking and obfuscation requirements.

• Build and maintain CI/CD pipelines for database deployments using Azure DevOps.

• Design and support data integration solutions using Azure Data Factory, Self-Hosted Integration Runtime (SHIR), Elastic Jobs, and related Azure data services.

• Implement monitoring, alerting, performance tuning, capacity planning, and operational support processes.

• Collaborate with application architects and development teams on database architecture, schema design, and modernization initiatives.

• Support reporting and analytics platforms through data synchronization, transformation, and reporting database design.

• Establish database governance, security, backup/recovery, disaster recovery, and operational standards.

• Troubleshoot and resolve complex database performance, availability, and operational issues.

• Re-engineer the legacy reporting architecture for Azure: assess existing reports, stored procedures, and ETL processes, then design and build a modernized reporting data layer with ADF pipelines, Elastic Jobs, and reporting-optimized schemas.

• Lead the rationalization and migration of legacy reports onto the new platform, including retiring redundant or obsolete reports, validating data parity, and supporting the BI tool integration.

Required Skills

• 7+ years of SQL Server database engineering experience.

• 3+ years of Azure database platform experience.

• Strong expertise with Azure SQL Managed Instance.

• Strong SQL Server administration and performance tuning skills.

• Experience with Azure Data Factory and SHIR.

• Experience automating database deployments and operational processes.

• Experience with Infrastructure as Code (Bicep or Terraform).

• Experience with Azure DevOps CI/CD pipelines.

• Experience implementing database refresh, masking, and data protection solutions.

• Strong understanding of backup, recovery, HA/DR, and database security practices.

• Experience supporting production-critical database environments.

Preferred Skills

• Experience in Azure Government Cloud environments.

• Experience supporting FedRAMP or other regulated environments.

• Experience with Redgate tools, DbUp, or database DevOps practices.

• Experience with reporting databases, data warehousing, star schema design, and data integration architectures.

• Experience with Power BI, Synapse Analytics, or Azure data platform services.

• Experience working in modernization and cloud migration initiatives.

• Hands-on experience redesigning or migrating a legacy reporting or ETL architecture to Azure (for example ADF, Elastic Jobs, or Azure SQL-based reporting databases).

Ideal Candidate

The ideal candidate is a hands-on database engineer who can bridge traditional DBA responsibilities with modern cloud engineering practices. They should be comfortable owning database infrastructure, automation, operational excellence, and Azure platform engineering while partnering closely with application and solution architects.

MSAG is an Equal Opportunity Employer - Disability and Veteran Find our company reviews on Glassdoor.com https://www.glassdoor.com/Reviews/MSAG-Reviews-E812411.htm

Full-time employees are eligible for paid company benefits, paid time off, sick leave and federal /national holiday pay.