Senior Oracle Database Modeller – Aerospace & Government

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

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