Database Modeller / Information Management Modeller

This resource owns data modelling and Oracle database design for two in-house engineering products, working alongside a Full-Stack Developer and a Data Migration Developer, and is supported by DND's own database administrators.

What you'll do

• Design, develop, enhance, and maintain conceptual, logical, and physical data models for Oracle database environments, ensuring consistency, integrity, and alignment with business and system requirements.
• Design, enhance, and maintain Oracle database structures, including complex SQL queries and PL/SQL stored procedures, functions, packages, and triggers.
• Optimize database performance through query tuning, indexing improvements, bottleneck analysis, and monitoring/diagnostic tooling.
• Work collaboratively with the Data Migration Developer to define and validate source-to-target mappings, transformation rules, and data quality expectations for ETL activities.
• Produce and maintain documentation for data models, database design, and development processes.

Must-have

• Proven experience designing conceptual, logical, and physical data models, ideally for Oracle environments.
• Strong Oracle SQL / PL-SQL development skills (stored procedures, functions, packages, triggers).
• Experience with database performance tuning and diagnostic tooling.
• Fluent English, spoken and written, with minimal errors.
• Must be a Canadian citizen — a requirement for eligibility for the Government of Canada Secret-level personnel security screening this role needs to start work.
• Able to work on-site at 455 Boulevard de la Carrière, Gatineau, QC, on a primarily in-person basis.

Nice-to-have

• Already holds an active Government of Canada Secret-level clearance
• Experience supporting ETL/data migration initiatives from a modelling perspective.
• Prior delivery experience on a Government of Canada IT services contract.