3105 - Database Architect

Contract opportunity – hybrid; must be willing to go onsite in St. Paul when needed.

About the role

As an Azure Database Engineer, you will participate in the analysis, design, development, implementation, and potentially ongoing support of Azure Databases and Data Lakes, with a primary focus on the Data Lakehouse and its integrated data reserves. Responsibilities include administering, maintaining, and securing data to ensure efficient and reliable data storage solutions. You will collaborate with cross-functional teams to optimize data workflows, support data-driven decision-making, and implement best practices for data security and integrity in Azure environments. This position also provides mentorship to other Database Engineers.

Responsibilities

• Support design and implementation to improve, modernize, and transform data-driven service delivery.
• Ensure data assets are structured, accessible, secure, and align with DCYF, MNIT, and Enterprise goals.
• Recommend data platforms and tools to support enterprise data architecture.
• Develop data models and ensure data access patterns are optimized.
• Maintain necessary documentation.
• Coordinate with necessary teams to meet security standards.
• Support design and development of disaster recovery solutions.
• Provide knowledge transfer.

Qualifications

• Strong experience designing, developing, and implementing data lakes and relational/non-relational databases in Azure.
• Strong experience with Databricks and Oracle databases.
• Experience developing and implementing data transformation solutions and cloud infrastructure integrations.
• Experience coding and testing programs/scripts to load data using Azure data load utilities.
• Experience with CI/CD pipelines and cloud computing concepts.
• Experience with tools such as Azure Monitor, Azure Data Factory, SQL Analytics, Query Performance Insight, Azure Resource Manager, Pearl, and Azure CLI/PowerShell for infrastructure management.
• Experience mentoring others in the needed technologies.
• Experience developing and implementing backup and recovery strategies using tools such as Azure Backup or Geo-replication.
• Experience with role-based access control, encryption, and network security.
• Strong organizational and time management skills.
• Desired: 10 years’ experience in data architecture or data management.
• Knowledge of data concepts, data modeling, schema design, and indexing strategies.
• Knowledge of Azure SQL instances, managed instances, and elastic pools.
• Knowledge of Data Warehouse Administration and Teradata Data Warehouse.