Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 1 hour ago
SM
Software Developer – CRM – Senior - RQ11653
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – CRM with strong hands-on experience in Microsoft Dynamics 365, Microsoft Power Platform, Azure solution design, Dynamics CRM Customer Service…
Added 1 hour ago
SM
Business Analyst – Senior - RQ11545
S M Software Solutions Inc
Toronto, ON
- Internship
Added 1 hour ago
SM
Software Developer – CRM – Senior - RQ11653
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – CRM with strong hands-on experience in Microsoft Dynamics 365, Microsoft Power Platform, Azure solution design, Dynamics CRM Customer Service…
Added 1 hour ago
SM
Software Developer – CRM – Senior - RQ11500
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – CRM with strong hands-on experience in Microsoft Dynamics 365, Microsoft Power Platform, Azure solution design, Dataverse, Dynamics 365 Customer…
Added 1 hour ago
SM
RQ11431 - Specialized IT Consultant – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…Apps (MDA), Power Pages Portal development, Power Automate, Azure services, Azure Attachment Storage, C# plugin development, and enterprise application integration. The successful candidate…
Added 1 hour ago
SM
Business Analyst – Senior - RQ11545
S M Software Solutions Inc
Toronto, ON
- Internship
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Moncton, NB
- Full-time
Develop reference architectures, design standards, integration patterns, and implementation guidance that enable IT teams to deliver secure and scalable automation solutions.
Added 1 hour ago
SM
Power Builder Developer - 29954-RFR-DTS-074
S M Software Solutions Inc
Winnipeg, MB
- Contract
We are seeking an experienced PowerBuilder Developer to work with one of our Public Sector clients located at 215 Garry Street, Winnipeg, Manitoba. The successful candidate will be…
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Winnipeg, MB
- Full-time
Develop reference architectures, design standards, integration patterns, and implementation guidance that enable IT teams to deliver secure and scalable automation solutions.
Added 1 hour ago
SM
RQ11645 – Software Developer – Full Stack – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Full Stack Software Developer with demonstrated experience designing, developing, testing, and supporting enterprise web applications and AI-enabled solutions. The…
Added 1 hour ago
SM
RQ11431 - Specialized IT Consultant – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…Apps (MDA), Power Pages Portal development, Power Automate, Azure services, Azure Attachment Storage, C# plugin development, and enterprise application integration. The successful candidate…
Added 1 hour ago
SM
Software Developer – CRM – Senior - RQ11653
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – CRM with strong hands-on experience in Microsoft Dynamics 365, Microsoft Power Platform, Azure solution design, Dynamics CRM Customer Service…
Added 1 hour ago
SM
RQ11645 – Software Developer – Full Stack – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Full Stack Software Developer with demonstrated experience designing, developing, testing, and supporting enterprise web applications and AI-enabled solutions. The…
Added 1 hour ago
SM
Power Builder Developer - 29954-RFR-DTS-074
S M Software Solutions Inc
Winnipeg, MB
- Contract
We are seeking an experienced PowerBuilder Developer to work with one of our Public Sector clients located at 215 Garry Street, Winnipeg, Manitoba. The successful candidate will be…
Added 1 hour ago
SM
RQ11645 – Software Developer – Full Stack – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Full Stack Software Developer with demonstrated experience designing, developing, testing, and supporting enterprise web applications and AI-enabled solutions. The…
Added 1 hour ago
SM
Power Builder Developer - 29954-RFR-DTS-074
S M Software Solutions Inc
Winnipeg, MB
- Contract
We are seeking an experienced PowerBuilder Developer to work with one of our Public Sector clients located at 215 Garry Street, Winnipeg, Manitoba. The successful candidate will be…
Added 1 hour ago
SM
Business Analyst – Senior - RQ11545
S M Software Solutions Inc
Toronto, ON
- Internship
Added 1 hour ago
SM
RQ11431 - Specialized IT Consultant – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…Apps (MDA), Power Pages Portal development, Power Automate, Azure services, Azure Attachment Storage, C# plugin development, and enterprise application integration. The successful candidate…
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Toronto, ON
- Full-time
Develop reference architectures, design standards, integration patterns, and implementation guidance that enable IT teams to deliver secure and scalable automation solutions.
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Montreal, QC
- Full-time
Develop reference architectures, design standards, integration patterns, and implementation guidance that enable IT teams to deliver secure and scalable automation solutions.
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Halifax, NS
- Full-time
Develop reference architectures, design standards, integration patterns, and implementation guidance that enable IT teams to deliver secure and scalable automation solutions.
Added 4 hours ago
C
AI Architect (T & I) (Telework/Hybrid)
CBC/Radio-Canada
Montreal, QC
- Full-time
…faster, more scalable and more reliable, ensuring their seamless integration into our critical production ecosystems (PAM, MAM,…
Added 4 hours ago
A
AI Solutions Consultant
Affinity
Burnaby, BC
- Contract
Measure performance against defined success metrics and recommend the next steps for optimization and scaling, including integration with enterprise solutions.
Added 5 hours ago
W
IT Automation Architect
WSP
Montreal, QC
- Full-time
Develop reference architectures, design standards, integration patterns, and implementation guidance that enable IT teams to deliver secure and scalable automation solutions.
Added 5 hours ago
OS
Senior Security Architect
Ontario Securities Commission
Toronto, ON
- Full-time
Guide secure cloud adoption across Azure and AWS environments.

Robertson & Company Ltd.

Ottawa (NCR) - Database Modeller

Gatineau, QC, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 1, 2026
Experience: 10+ years (120 months) of experience as a Software Developer, Database Modeller, and/or Database Administrator within the last 15 years
Posting language: English
Posted: Oct 2, 2026

Original job description

Job Title: Database Modeller / Information Management Modeller (Oracle Database)
Location: National Capital Region (NCR) – Gatineau, QC (Onsite with potential for hybrid)

Overview
We are currently seeking a Senior Database Modeller / Information Management Modeller to support a long-term 4-year Federal Government contract focused on the development, modernization, and sustainment of mission-critical aerospace business management applications within the Department of National Defence. The successful candidate will play a key role in designing and maintaining Oracle database environments, supporting data modernization initiatives, and ensuring high-quality data structures that support enterprise applications.

An active Government of Canada SECRET Clearance is mandatory.

The work is primarily performed in the National Capital Region and will require onsite attendance as directed by the client.

Project Background
This initiative supports the modernization, enhancement, and sustainment of enterprise business applications built on Oracle technologies. The team is responsible for maintaining critical operational systems, modernizing legacy Microsoft Access-based applications, and implementing modern Oracle database and Oracle APEX solutions to support evolving business requirements.

The Database Modeller will work alongside Full-Stack Developers and Data Migration Developers to support:

Oracle database development and sustainment
Data architecture and modelling
Database modernization initiatives
Oracle PL/SQL development
ETL and data integration activities
Performance optimization and tuning
Enterprise application support
Aerospace business management systems modernization

Key Responsibilities

Design, develop, and maintain conceptual, logical, and physical data models for Oracle database environments
Design and maintain Oracle database structures and schemas
Develop and maintain complex SQL queries, stored procedures, functions, packages, and triggers using Oracle PL/SQL
Optimize database performance through query tuning, indexing strategies, bottleneck analysis, and database monitoring tools
Collaborate with developers, business analysts, and stakeholders to define data requirements and support Agile delivery
Support and validate ETL and data migration activities
Define and maintain source-to-target mappings and transformation rules
Produce and maintain database architecture, modelling, and technical documentation
Participate in Agile ceremonies including sprint planning, reviews, retrospectives, and daily stand-ups
Utilize Oracle SQL Developer, Oracle SQL Developer Data Modeler, Azure DevOps, Git, and related development tools
Ensure compliance with DND security, information management, and data-handling standards

Mandatory Requirements
Candidates must demonstrate:

Education

Post-secondary degree or diploma in Computer Science, Engineering, Mathematics, Science, or another technology-related discipline (must be Canadian credential or assessed equivalent)

Experience

10+ years (120 months) of experience as a Software Developer, Database Modeller, and/or Database Administrator within the last 15 years
3+ years (36 months) within the last 5 years developing and maintaining Oracle databases
Experience developing and maintaining:
- Oracle PL/SQL
- Complex SQL queries
- Stored procedures
- Functions
- Packages
- Triggers
Experience designing and maintaining conceptual, logical, and physical data models
Experience working in Oracle database environments supporting enterprise applications

Highly Desirable Experience
Preference will be given to candidates with experience in:

Oracle SQL Developer
Oracle SQL Developer Data Modeler
Microsoft Azure DevOps
Microsoft Access
ETL and data migration activities
Database performance tuning and optimization
Aerospace or aviation environments
Royal Canadian Air Force (RCAF)
Director General Aerospace Equipment Program Management (DGAEPM)
Large-scale database modernization initiatives

Security Requirements

Active Government of Canada SECRET Clearance
Ability to work in an environment subject to Controlled Goods requirements

How to Apply
If you meet the mandatory requirements, please submit:

Updated résumé
Security clearance status
Current location
Availability for discussion

Only candidates who closely align with the mandatory requirements will be contacted.

#DatabaseModeller #DataArchitect #OraclePLSQL #OracleDatabase #DataModeling #ETL #AzureDevOps #DatabaseDeveloper #SecretClearance #GovernmentContract #DND #Aerospace #Hiring #OttawaJobs #GatineauJobs

Apply About employer

More about this job

Responsibilities

Design, develop, and maintain Oracle database schemas and conceptual, logical, and physical data models, including PL/SQL code and complex SQL objects. Support ETL and data migration, optimize database performance, document database architecture, and collaborate with stakeholders and development teams in Agile delivery.

Requirements

Requires a Canadian post-secondary degree or diploma in a technology-related discipline (or assessed equivalent), at least 10 years of relevant experience, and at least 3 years developing and maintaining Oracle databases within the last 5 years. Candidates must have Oracle PL/SQL and data modeling experience, an active Government of Canada SECRET Clearance, and the ability to work in an environment subject to Controlled Goods requirements.

Skills

Oracle Database Development
Oracle PL/SQL
SQL
Database Modeling
Data Architecture
Database Administration
ETL
Data Migration
Database Performance Tuning
Oracle SQL Developer
Oracle SQL Developer Data Modeler
Azure DevOps
Git
Agile Delivery
Technical Documentation
Microsoft Access

Visa sponsorship

Not detected in the job text

Keywords

Oracle Database
Oracle PL/SQL
SQL
Stored Procedures
Functions
Packages
Triggers
Conceptual Data Models
Logical Data Models
Physical Data Models
Data Architecture
ETL
Data Migration
Source-to-Target Mapping
Database Performance Tuning
Oracle SQL Developer
Oracle SQL Developer Data Modeler
Microsoft Azure DevOps
Git
Microsoft Access
Agile
Enterprise Applications
Aerospace
Department of National Defence
Royal Canadian Air Force
SECRET Clearance
Controlled Goods

Report this job