Intermediate Data Architect/Modeller

Randstad Canada; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading company is seeking an Intermediate Data Architect/Modeller for a 10-month hybrid contract in Toronto. The role involves developing data architecture in complex environments and requires experience with databases and cloud technologies, particularly Azure. This position offers a competitive industry rate and potential for extension.

Benefits

Potential for extension

Hybrid role: 3 days onsite / 2 days remote

Competitive industry rate

Qualifications

• Experience creating physical database designs and administering DBMS.
• Hands-on experience with Azure SQL Database and T-SQL.

Responsibilities

• Develop and implement data architecture for application development.
• Manage data flow, database location, and data access methods.

Skills

Database Optimization

Cloud Environments

T-SQL

Performance Tuning

Tools

Azure SQL Database

Azure Data Factories

Databricks

Azure Synapse

Cosmos DB

Oracle DBMS

Big Data/Data Lake/Hadoop

Job description

Do you have experience creating physical database designs and operating and administering database management systems (DBMS), including database optimization, capacity planning, installation, migration, design, performance tuning, backup, and recovery? Do you have experience in cloud environments, especially Azure? If so, this could be a great opportunity for you!

Our client is seeking an Intermediate Data Architect/Modeller for a 10-month contract in Toronto.

This role is hybrid, requiring 3 days onsite per week.

Advantages

• Potential for extension
• Hybrid role: 3 days onsite / 2 days remote
• Competitive industry rate

Responsibilities

• Develop and implement data architecture for application development in complex, distributed environments, including data flow, database location, and data access methods.

Qualifications

Must Have:

• Experience creating physical database designs and administering DBMS, including optimization, capacity planning, installation, migration, design, performance tuning, backup, and recovery.
• Experience with cloud environments, especially Azure.
• Hands-on experience with Azure SQL Database, proficiency in T-SQL, SQL maintenance, audit, user and permissions management, performance tuning.
• Experience with technologies such as Azure Data Factories, Databricks, Azure Synapse, Azure SQL, Cosmos DB, Oracle DBMS, and Big Data/Data Lake/Hadoop. Certifications are a plus.

Summary

If interested in the Intermediate Data Architect/Modeller role in Toronto, please apply online at www.randstad.ca. Qualified candidates will be contacted.

Randstad Canada is committed to fostering a diverse workforce and promoting equity, diversity, and inclusion. We strive to create an accessible workplace for all candidates and employees. Please send any accommodation requests to [e-mail].