Senior Data Security Architect

Russell Tobin; Ontario; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading company is seeking a Data Architect / Modeller for a 12-month contract in Toronto, ON. The role involves developing data architecture and requires extensive experience with Azure and database management. Ideal candidates will have strong skills in database design, cloud environments, and data migration.

Qualifications

• Experience in physical database design and DBMS administration.
• Strong Azure cloud environment experience.
• Hands-on experience with Azure SQL Database and T-SQL.

Responsibilities

• Develops and implements data architecture for application development.
• Determines data flow, distribution, database locations, and access methods.

Skills

Database Design

DBMS Administration

Azure Cloud

T-SQL

Data Migration

Big Data

Cybersecurity

Job description

Job title : - Data Architect / Modeller - Intermediate

Location : - Toronto, ON (Hybrid - 3 days a week onsite with flexibility)

Duration : - 12 Months Contract (Possible Extension)

Responsibilities

• Develops and implements the data architecture for application development in a complex and distributed environment, including the determination of data flow, distribution, database locations, and access methods.

Skills, Experience, and Skill Set Requirements

Technical Skills (30%)

• Experience creating physical database designs and operating and managing database management systems (DBMS), including optimization, capacity planning, installation, migration, design, performance tuning, backup, and recovery.
• Extensive experience with cloud environments, especially Azure.
• Hands-on experience with Azure SQL Database, proficiency in T-SQL, SQL maintenance, audit, user and permissions management, and performance tuning.
• Experience with Azure Data Factories, Databricks, Azure Synapse, Cosmos DB, Oracle DBMS, Big Data / Data Lake / Hadoop; certifications are a plus.
• Experience with SSIS, SSRS, Talend, Informatica, NoSQL databases (JSON, XML).

Additional Experience (30%)

• Proficiency in one or more programming languages.
• Experience with cloud-native development, microservices architecture, and data migrations.
• Knowledge of query languages, database rules enforcement, incident, change, and configuration management.
• Experience with communication protocols, distributed data systems, middleware, gateways, and cybersecurity remediation.
• Understanding of information management principles, enterprise architecture, impact analysis, and technology implementation planning.

Communication Skills (10%)

• Ability to prepare documentation, manuals, reports, and assessments.
• Effective presentation of ideas and technical designs in a clear, user-friendly manner.
• High level of customer service to internal and external clients.

Must Have

• Experience in physical database design and DBMS administration, including optimization, capacity planning, installation, migration, design, performance tuning, backup, and recovery.
• Strong Azure cloud environment experience.
• Hands-on Azure SQL Database experience, proficiency in T-SQL, and knowledge of SQL maintenance, audit, user permissions, and performance tuning.
• Experience with Azure Data Factory, Databricks, Azure Synapse, Cosmos DB, Oracle DBMS, Big Data / Data Lake / Hadoop.