Location: Gatineau, QC (Hybrid)
Duration: 4 years
Security Clearance: Secret & Controlled Goods required
Responsibilities
- Collaborate with stakeholders, team members, product owners, and business analysts to understand requirements, refine data needs, and support the delivery of iterative, value-focused solutions.
- Actively participate in Agile ceremonies, including stand-ups, sprint planning, reviews, and retrospectives.
- Use software development and lifecycle tools such as Oracle SQL Developer, Azure DevOps, and Git to ensure quality, maintain version control, and support configuration management.
- Communicate proactively and effectively with all team members and stakeholders.
- Follow established build and release management processes across Development, Test, Pre-Production, and Production environments, including code promotion, database updates, validation steps, documentation, and required approvals.
- Ensure adherence to applicable information security requirements and data-handling practices.
- Deliver work that follows Government of Canada web accessibility standards.
- 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 developing complex SQL queries and creating PL/SQL stored procedures, functions, packages, and triggers.
- Optimize database performance through query tuning, indexing improvements, bottleneck analysis, and the use of monitoring and diagnostic tools.
- Define and validate source-to-target mappings, transformation rules, and data-quality expectations, ensuring ETL activities align with approved data models and database design principles.
- Produce and maintain documentation related to data models, database design, system architecture, and development processes.
Qualifications
- Education: A post-secondary degree or diploma in engineering, science, computer science, mathematics, or a technology domain
- 10+ years of experience working as a software developer, database modeller, and/or database administrator.
- 3+ years of experience developing and maintaining Oracle databases, including writing complex SQL queries and developing stored procedures, functions, packages, and triggers in Oracle PL/SQL.
- 2+ years of experience designing and maintaining conceptual, logical, and physical data models for Oracle databases.
- 2+ years of experience optimizing database performance, including query tuning, indexing strategies, resolving performance bottlenecks, and using database monitoring or diagnostic tools.
- 2+ years of experience performing extraction, transformation, and load (ETL) activities to move data between relational database systems.
- Experience using tools such as Microsoft Access, Microsoft Azure DevOps, Oracle SQL Developer, and Oracle SQL Developer Data Modeller.
- Experience working in the aviation or aerospace domain is an asset.
Secret Clearance & Controlled Goods Required.
AI Disclosure: We do not use artificial intelligence (AI) tools to screen, assess, or select applicants at any stage of our recruitment process. All applications are reviewed by our recruitment team.
OXARO is committed to fostering an inclusive, equitable and respectful workplace where every individual feels valued and empowered to contribute their best. We believe that diversity drives innovation and strengthens our ability to serve our clients and communities. We are dedicated to ensuring a fair and unbiased recruitment process and welcome applications from members of the four designated groups under the Employment Equity Act: women, Indigenous peoples, persons with disabilities and members of visible minorities.
Accommodations are available upon request for candidates taking part in all aspects of the recruitment process.
We sincerely thank all applicants for their interest in this opportunity. While we appreciate every application, only those selected for an interview will be contacted. 