At a Glance
- Tasks: Develop and modernize Oracle APEX applications for critical aerospace systems.
- Company: Join a leading tech firm supporting the Federal Government.
- Benefits: Competitive salary, hybrid work options, and professional growth opportunities.
- Other info: Active Government of Canada SECRET Clearance required; dynamic team environment.
- Why this job: Make an impact in aerospace tech while working with cutting-edge Oracle technologies.
- Qualifications: 10+ years in software development, especially with Oracle APEX and PL/SQL.
The predicted salary is between 92970 - 113630 $ per year.
We are currently looking for a Senior Full-Stack Developer to support a long-term 4-year Federal Government contract focused on the development, modernization, and sustainment of enterprise applications built using Oracle technologies. The work is primarily performed in the National Capital Region and candidates should be prepared for onsite work when required.
An active Government of Canada SECRET Clearance is mandatory. This role will support the development and sustainment of mission-critical aerospace management systems. The successful candidate will be responsible for both front-end and back-end development activities, including Oracle APEX application development, Oracle database programming, user interface design, and full-stack software development.
Project Background
- Oracle APEX application development
- Full-stack software development
- Oracle database development and maintenance
- User interface and workflow design
- Oracle PL/SQL development
- Agile software delivery
- Enterprise application modernization
- Aerospace business management systems modernization
Key Responsibilities
- Develop, enhance, and maintain Oracle APEX applications
- Design and develop front-end user interfaces and application workflows
- Develop complex Oracle SQL and PL/SQL code
- Create and maintain stored procedures, functions, packages, and triggers
- Translate business requirements and user stories into technical solutions
- Design user experiences, workflows, wireframes, and prototypes
- Develop and maintain application backend logic and database structures
- Document software designs, architecture, and technical solutions
- Participate in Agile development and modernization initiatives
Mandatory Requirements
- Post-secondary degree or diploma in Computer Science, Engineering, Mathematics, Science, or another technology-related discipline from a recognized Canadian institution or equivalent.
- 10+ years of experience working as a Software Developer and/or Database Modeller within the last 15 years.
- 7+ years of experience developing applications using Oracle Application Express (Oracle APEX).
- 7+ years of demonstrated experience developing and maintaining Oracle PL/SQL.
- 7+ years of demonstrated experience developing and maintaining complex SQL queries.
- 7+ years of demonstrated experience developing and maintaining stored procedures, functions, packages, and triggers.
- 7+ years of demonstrated experience developing and maintaining Oracle database objects.
- 7+ years of demonstrated experience designing user interfaces for applications.
- 7+ years of demonstrated experience translating business requirements into UI designs.
- 7+ years of demonstrated experience in user workflow design.
- 7+ years of demonstrated experience in wireframe development.
- 7+ years of demonstrated experience in prototyping.
- 7+ years of demonstrated experience in user experience design.
Highly Desirable Experience
- Aviation experience
- Aerospace experience
- Royal Canadian Air Force (RCAF) experience
- Director General Aerospace Equipment Program Management (DGAEPM) experience
- Microsoft Access experience
- Microsoft Azure DevOps experience
- Oracle SQL Developer experience
- Unified Codes APEX Office Print (AOP) experience
- Enterprise application modernization experience
- Large-scale Oracle development initiatives
Security Requirements
- Active Government of Canada SECRET Clearance
- Ability to work in an environment subject to Controlled Goods requirements.
Senior Full-Stack Developer – Ottawa employer: Robertson & Company Ltd.
Robertson & Company Ltd. is an exceptional employer, offering a dynamic work environment in the heart of the National Capital Region. With a strong commitment to employee growth and development, we provide opportunities for professional advancement while fostering a collaborative culture that values innovation and teamwork. Our focus on meaningful projects within the defence sector ensures that our employees contribute to impactful initiatives, making their work both rewarding and significant.
