Senior Oracle APEX Full-Stack Developer

OXARO Inc.; Ottawa; On-site; CAD 120,000 - 170,000; Full time

Job summary

OXARO Inc. in Ottawa is seeking a senior software developer with strong Oracle PL/SQL and Oracle APEX expertise to design and implement data-driven applications across UI and backend layers.

You will collaborate with stakeholders in an agile environment, maintain code in Git and Azure DevOps, ensure accessibility and security standards, and document architectures and code for long-term maintainability. This role requires 10+ years in software development or database modelling, with hands-on

Qualifications

• 10+ years of experience as a software developer or database modeller.
• 2+ years Oracle APEX development.
• 2+ years Oracle PL/SQL development.
• 2+ years designing UI from user stories and requirements.

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 Oracle SQL Developer, Azure DevOps, and Git to ensure quality, maintain version control, and support configuration management.
• Communicate proactively with all team members and stakeholders.
• Follow build and release management processes across Development, Test, Pre-Production, and Production environments.
• Ensure adherence to information security requirements and data-handling practices.
• Deliver work that follows government accessibility standards.
• Provide full-stack development across UI and data layers.
• Develop, enhance, and maintain backend logic in Oracle databases using PL/SQL.
• Design, enhance, and maintain UI in Oracle APEX translating requirements into designs and prototypes.
• Document software designs, system architecture, processes, and codebase.

Skills

Full-stack development

Oracle PL/SQL

UI/UX design

Agile methodologies

Communication

Education

Bachelor's degree in Engineering/CS/Math

Tools

Oracle SQL Developer

Azure DevOps

Git

Oracle APEX

AOP (APEX Office Print)

Microsoft Access

Job description

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.
• Provide full-stack development expertise across the application's user interface and data layers.
• Develop, enhance, and maintain backend logic in Oracle databases, including writing and optimizing complex SQL queries, stored procedures, functions, packages, and triggers using Oracle PL/SQL.
• Design, enhance, and maintain user interfaces in Oracle APEX, translating user stories, business requirements, and user-research findings into intuitive designs, workflows, wireframes, and interactive prototypes.
• Document software designs, system architecture, processes, and the codebase, including technical notes and supporting materials required for maintainability.

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 and/or database modeller.
• 2+ years of experience developing applications in Oracle Application Express (APEX).
• 2+ years of experience developing and maintaining complex queries, stored procedures, functions, packages, and triggers using Oracle PL/SQL.
• 2+ years of experience designing user interfaces, including translating user stories, business requirements, and user-research findings into UI designs, workflows, wireframes, and prototypes.
• Experience using tools such as Microsoft Access, Microsoft Azure DevOps, Oracle SQL Developer, and Unified Codes APEX Office Print (AOP).
• Experience working in the aviation or aerospace domain is an asset.

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.