Data Architect (Government of Canada Secret-level clearance)

TV2 Consulting; Ottawa; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A consulting firm seeks a Data Architect to support web portal applications for the Government of Canada. The successful candidate will design high-performing database applications and work closely with development teams. This role requires a Bachelor's degree in a related field, 7 years of experience, strong analytical skills, and Government of Canada Secret-level clearance. The position offers a hybrid work model with a standard business schedule, occasional after-hours support compensation.

Qualifications

• Government of Canada Secret-level clearance is mandatory.
• Minimum of 7 years of experience in database architecture or related roles.
• Hands-on experience with secure, scalable, high-performing database applications.

Responsibilities

• Design and code application programs; perform testing, debugging.
• Collaborate with remote teams and adapt quickly to challenges.
• Provide operational support for portal solutions during business hours.

Skills

Highly organized and detail-oriented

Strong problem-solving skills

Team player

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

Oracle 11g and 19c

PL/SQL

Toad

JIRA

GitHub

Jenkins

UCD

Job description

Job Description

Salary:

Role Summary

We are seeking a Data Architect to join the Government of Canada delivery team, supporting secure web portal applications (DynaDocs and CanaDocs) and their underlying infrastructure. This role focuses on the database layer of applications, working closely with development teams and stakeholders to design, develop, and deploy secure, scalable, and high‑performing solutions. The ideal candidate is self‑directed, detail‑oriented, and motivated, with strong analytical, problem‑solving, and communication skills.

Key Responsibilities

• Design and code application programs; perform testing, debugging, and installation for highly available systems.
• Review, analyze, and modify programming systems to meet evolving requirements.
• Collaborate effectively with remote teams, adapting quickly to new challenges and learning rapidly.
• Apply sound judgment to understand complex business use cases and design appropriate solutions.
• Ensure operating efficiency of existing application systems.
• Maintain documentation of systems development and revisions.
• Conduct analyses of organizational needs and goals to inform application system development.
• Build secure, scalable, performant, and highly available database applications.
• Utilize DevOps/CICD pipelines and tools such as JIRA, GitHub, Jenkins, and UCD.
• Work within Agile methodologies including Scrum, SAFe, and Kanban.
• Provide operational support for portal solutions during business hours (weekdays, 8 AM 5 PM EST).
• Support incident and change management, including after‑hours work when required (compensated accordingly).
• Remediate defects, develop enhancements, and conduct quality assurance testing prior to deployment.
• Deploy defect fixes and enhancements into production environments.
• Provide infrastructure, network, and database support as required.

Technical Requirements

• Oracle 11g and 19c
• PL/SQL
• ANSI SQL
• Toad

Qualifications and Skills

• Highly organized and detail‑oriented, with the ability to manage multiple assignments under aggressive timelines.
• Comfortable working with change and ambiguity in a competitive environment.
• Ability to work efficiently in a hybrid environment (3 days on‑site, 2 days remote).
• Strong problem‑solving skills with complex, technical, and abstract concepts.
• Team player with confidence to challenge and elevate issues when necessary.
• Previous experience in the telecommunications industry and Government of Canada contracts is an asset.
• Government of Canada Secret‑level clearance (mandatory).

Education & Experience

• Bachelors degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Minimum of 710 years of experience in database architecture, application development, or related technical roles.
• Hands‑on experience with secure, scalable, and high‑performing database applications.

Work Schedule

• Standard business hours: Monday to Friday, 8 AM 5 PM EST.
• Hybrid work model: 3 days on‑site in Ottawa, 2 days remote.
• Occasional after‑hours support required for incident and change management (compensated by time in lieu or overtime).