Ottawa (NCR) - Database Modeller

Robertson & Company Ltd.; Outaouais; Hybrid; CAD 120,000 - 160,000; Full time

Job summary

Robertson & Company Ltd. seeks a Senior Database Modeller / Information Management Modeller to support a long-term federal contract in the National Capital Region (Gatineau, QC).

The role focuses on designing and maintaining Oracle database environments, data modernization, and ensuring robust data structures for enterprise applications. Onsite with potential for hybrid work, you will collaborate with Full-Stack Developers and Data Migration Specialists, apply SCRUM/Agile practices, and ensure

Qualifications

• Post-secondary degree in a tech field.
• 10+ years in software development or database modelling/administration.
• 3+ years building and maintaining Oracle databases.
• Experience with Oracle PL/SQL, complex SQL, stored procedures, functions, packages and triggers.
• Experience designing data models and supporting enterprise applications in Oracle environments.

Responsibilities

• Design, develop, and maintain data models for Oracle databases.
• Maintain Oracle database structures and schemas.
• Develop complex SQL queries, PL/SQL, packages, and triggers.
• Optimize performance via tuning and analysis.
• Collaborate with developers and analysts to define data requirements.
• Support ETL and data migration activities.
• Document architecture and data modelling artifacts.
• Participate in Agile ceremonies and use DevOps tools.

Skills

Oracle PL/SQL

SQL queries

Data modelling

Performance tuning

Agile delivery

Collaboration

Education

Post-secondary degree in Computer Science/Engineering/Math/Science

Tools

Oracle SQL Developer

Oracle SQL Developer Data Modeler

Azure DevOps

Git

Microsoft Access

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

• 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