Job Title: Database Modeller / Information Management Modeller (Oracle Database)Location: National Capital Region (NCR) - Gatineau, QC (Onsite with potential for hybrid)OverviewWe 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 BackgroundThis 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 sustainmentData architecture and modellingDatabase modernization initiativesOracle PL/SQL developmentETL and data integration activitiesPerformance optimization and tuningEnterprise application supportAerospace business management systems modernizationKey ResponsibilitiesDesign, develop, and maintain conceptual, logical, and physical data models for Oracle database environmentsDesign and maintain Oracle database structures and schemasDevelop and maintain complex SQL queries, stored procedures, functions, packages,



and triggers using Oracle PL/SQLOptimize database performance through query tuning, indexing strategies, bottleneck analysis, and database monitoring toolsCollaborate with developers, business analysts, and stakeholders to define data requirements and support Agile deliverySupport and validate ETL and data migration activitiesDefine and maintain source-to-target mappings and transformation rulesProduce and maintain database architecture, modelling, and technical documentationParticipate in Agile ceremonies including sprint planning, reviews, retrospectives, and daily stand-upsUtilize Oracle SQL Developer, Oracle SQL Developer Data Modeler, Azure Dev Ops, Git, and related development toolsEnsure compliance with DND security, information management, and data-handling standardsMandatory RequirementsCandidates must demonstrate:EducationPost-secondary degree or diploma in Computer Science, Engineering, Mathematics, Science, or another technology-related discipline (must be Canadian credential or assessed equivalent)Experience10+ years (120 months) of experience as a Software Developer, Database Modeller, and/or Database Administrator within the last 15 years3+ years (36 months) within the last 5 years developing and maintaining Oracle databasesExperience developing and maintaining:Oracle PL/SQLComplex SQL queriesStored proceduresFunctionsPackagesTriggersExperience designing and maintaining conceptual, logical, and physical data modelsExperience working in Oracle database environments supporting enterprise applicationsHighly Desirable ExperienceOracle SQL DeveloperOracle SQL Developer Data ModelerMicrosoft Azure Dev OpsMicrosoft AccessETL and data migration activitiesDatabase performance tuning and optimizationAerospace or aviation environmentsRoyal Canadian Air Force (RCAF)Director General Aerospace Equipment Program Management (DGAEPM)Large-scale database modernization initiativesSecurity RequirementsActive Government of Canada SECRET ClearanceAbility to work in an setting subject to Controlled Goods requirements#J-18808-Ljbffr

📌 Ottawa (Ncr) - Database Modeller (Gatineau)
🏢 RobertsonLtd.
📍 Gatineau