Azure Database Architect

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.
  

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.