Azure Database Architect
Integres, LLC is a Service-Disabled Veteran Owned Small Business (SDVOSB) established to provide high-quality, insightful, and agile information technology-based solutions. Integrity is foundational to our work, and we develop solutions that respond to evolving organizational challenges using industry best practices and innovative techniques. We prioritize a servant-leadership approach, fostering a corporate family culture that values excellence, accountability, and work/life balance. Our employees are empowered to contribute meaningfully, engaging with customers as true partners. We also encourage community and volunteer participation as part of our commitment to corporate citizenship.
About the role
We are seeking an experienced Azure Database Architect to support the modernization of Minnesota's Child Welfare Information System (CCWIS). This role focuses on designing and implementing Azure-based databases, Data Lakes, and Data Lakehouse solutions while consolidating data from 87 county databases into a centralized Azure data platform. The position is remote/hybrid, based in St. Paul, MN, with interviews conducted via Microsoft Teams.
Responsibilities
- Design, develop, and implement Azure Data Lakes, Data Lakehouse, and database solutions.
- Architect scalable, secure, and high-performance data storage environments.
- Develop data models and optimize data access patterns.
- Support data transformation, migration, and Azure cloud integrations.
- Implement backup, disaster recovery, and security strategies.
- Configure and manage Azure SQL databases, managed instances, and elastic pools.
- Build and maintain CI/CD pipelines and Azure infrastructure.
- Monitor and optimize database performance using Azure monitoring tools.
- Collaborate with cross-functional teams and provide technical leadership and mentoring.
- Maintain technical documentation and ensure compliance with enterprise security standards.
Requirements
- 10+ years of experience in Data Architecture or Database Management.
- Strong expertise in Azure Data Lakes, Azure SQL, relational and non-relational databases.
- Hands-on experience with Azure Databricks and Oracle Databases.
- Experience with Azure Data Factory, Azure Monitor, SQL Analytics, Query Performance Insight, Azure Resource Manager, Azure CLI/PowerShell, and CI/CD pipelines.
- Strong knowledge of data modeling, schema design, indexing strategies, and cloud infrastructure.
- Experience with backup/recovery, geo-replication, RBAC, encryption, and network security.
- Familiarity with Teradata Data Warehouse administration is a plus.
- Excellent communication, documentation, and mentoring skills.
Benefits
- Comprehensive healthcare and insurance: medical, dental, vision, short- and long-term disability protection, basic life, and AD&D insurance.
- 401(k) Savings Plan.
- Accrued Paid Time Off (PTO).
- Employee Recognition and Rewards.
- Employee Referral Bonuses.