RQ09252 - Data Architect/Modeller - Intermediate

Maarut Inc; Golden Horseshoe; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading company in the Golden Horseshoe area is seeking a skilled Database Architect to develop and implement data architecture for complex applications. The ideal candidate will have extensive experience with Azure and database management systems, ensuring optimal performance and data accessibility. Strong communication skills are essential for this role, as you will be required to document and present technical concepts clearly.

Qualifications

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

Responsibilities

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

Skills

Database Management

Cloud Environments

T-SQL

Performance Tuning

Documentation

Tools

Azure Data Factories

Databricks

Azure SQL

Cosmos DB

Oracle DBMS

NoSQL

SSIS

SSRS

Talend

Informatica

Job description

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 data access methods.

Requirements

Experience and Skill Set Requirements:

Must Haves:

• Experience creating physical database designs and managing database management systems (DBMS), including optimization, capacity planning, installation, migration, design, performance tuning, backup, and recovery.
• Experience with cloud environments, especially Azure.
• Extensive hands-on experience with Azure SQL Database, proficiency in T-SQL, understanding of SQL maintenance, audits, user and permissions management, performance tuning.
• Hands-on experience with technologies like Azure Data Factories, Databricks, Azure Synapse, Azure SQL, Cosmos DB, Oracle DBMS, and Big Data/Data Lake/Hadoop; certifications are a plus.

Skill Set Requirements:

Technical Skills:

• Experience with database design, management, optimization, and migration.
• Proficiency in cloud environments, particularly Azure.
• Experience with Azure SQL Database, T-SQL, SQL maintenance, audit, permissions, and performance tuning.
• Experience with technologies such as SSIS, SSRS, Talend, Informatica, NoSQL databases, and formats like JSON and XML.

Additional Experience:

• Programming experience, cloud development, microservices architecture.
• Data migration, information retrieval, query languages.
• Database rules enforcement, incident/change management, communication protocols.
• Distributed data systems, middleware, cybersecurity, and information management principles.
• Database administration, data warehouse design, automation, object-oriented analysis, enterprise architecture, impact analysis, and vendor collaboration.

Communication Skills:

• Strong documentation and presentation skills.
• Ability to communicate technical concepts clearly and maintain high customer service levels.