Data Architect

 

Description:

Data Architect

Job Location: Toronto, ON

Job type: Full Time

Experience - 12+Years

Must Have Technical/Functional Skills

12–15+ years of IT experience with 7–10+ years in database architecture and migration roles.

• Proven experience leading enterprise-scale database migration and modernization programs.

• Strong hands-on experience with Azure, AWS, or GCP data platforms.

• Experience operating at Senior, Lead, or Principal Architect level.

• Deep understanding of relational, NoSQL, and cloud-native database technologies.

TECHNICAL SKILLS

• Relational databases: Oracle, SQL Server, DB2, MySQL, PostgreSQL

• Cloud data services: Azure SQL, Cosmos DB, RDS, Aurora, DynamoDB, Cloud SQL, Spanner

• Migration tools and strategies

• High availability, DR, replication, and backup design

• Performance tuning and optimization

• Infrastructure as Code for data platforms

• Data security, encryption, and access governance

Roles & Responsibilities

..Own and define enterprise database migration and modernization strategies across application portfolios.

• Lead database transformation initiatives including re-host, re-platform, re-architect, and cloud-native redesign approaches.

• Design target-state cloud and hybrid database architectures.

• Assess legacy databases and dependencies (Oracle, SQL Server, DB2, MySQL, PostgreSQL, etc.).

• Lead modernization initiatives from traditional RDBMS to managed PaaS and cloud-native data services.

• Define reference architectures, migration patterns, and standards for databases.

• Design high availability, disaster recovery, backup, and resilience strategies.

• Partner with application, DevOps, and security teams to embed database best practices.

• Drive performance optimization, scalability, and cost optimization (FinOps).

• Provide technical leadership and mentorship to database and cloud engineers.

• Engage senior stakeholders to align data architecture with business outcomes.

DATABASE MODERNIZATION & CLOUD SERVICES

• Architect cloud-managed database platforms (Azure SQL, SQL MI, Cosmos DB, Amazon RDS/Aurora, DynamoDB, Cloud SQL, Spanner).

• Lead adoption of open-source and cloud-native data platforms.

• Design data modernization strategies including polyglot persistence.

• Support modernization of batch, transactional, and analytical workloads.

SECURITY, GOVERNANCE & COMPLIANCE

• Define security-by-design for data platforms (encryption, access control, masking).

• Implement data governance, classification, and compliance controls.

• Partner with security and GRC teams to meet regulatory requirements.

• Ensure data resilience, recovery, and audit readiness.

Generic Managerial Skills, If any

• Executive-level communication

• Strong architectural and analytical thinking

• Risk-based decision making

• Mentorship and technical leadership