Job Description
Job Description:
• As an Azure Database Architect, this position will participate in the analysis and design, and support 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.
• The responsibilities will include designing, administering, maintaining, and securing data to ensure efficient and reliable data storage solutions.
• The position 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 will provide mentorship to other architects and database engineers.

Job Responsibility:
• 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.
• 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.

Desired Qualifications:
• Strong experience with designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
• Strong experience with Databricks.
• Strong experience with Oracle databases.
• Experience developing and implementing data transformation solutions and cloud infrastructure integrations.
• Experience coding and testing programs and scripts to load data using Azure data load utilities.
• Experience with CI/CD pipelines.
• Experience with 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 in 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.

Requirements

Desired Qualifications:
• Strong experience with designing, developing, and implementing data lakes and relational and non-relational databases in Azure.
• Strong experience with Databricks.
• Strong experience with Oracle databases.
• Experience developing and implementing data transformation solutions and cloud infrastructure integrations.
• Experience coding and testing programs and scripts to load data using Azure data load utilities.
• Experience with CI/CD pipelines.
• Experience with 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 in 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.