Full-Stack Developer (Oracle APEX & SQL)
- Gatineau, QC, Canada
Applications open in a new tab.
Job details
- Apply by
- Posting language
- English
- Posted
Original job description
About The Role
Insi is building its delivery team for a federal government client (Department of National Defence, TBIPS Supply Arrangement) supporting the sustainment of in-house Oracle-based engineering and airworthiness management products. This resource performs full-stack development across the UI and data layers of these applications.
What you'll do
Insi is building its delivery team for a federal government client (Department of National Defence, TBIPS Supply Arrangement) supporting the sustainment of in-house Oracle-based engineering and airworthiness management products. This resource performs full-stack development across the UI and data layers of these applications.
What you'll do
- Develop, enhance, and maintain backend logic in Oracle databases: complex SQL queries, stored procedures, functions, packages, and triggers using Oracle PL/SQL.
- Design, enhance, and maintain user interfaces in Oracle Application Express (APEX), translating user stories and business requirements into intuitive UI designs, workflows, and interactive prototypes.
- Participate actively in Agile ceremonies (stand-ups, sprint planning, reviews, retrospectives).
- Use Azure DevOps and Git for version control, quality assurance, and configuration management.
- Document software designs, system architecture, and codebase for maintainability.
- Hands-on production experience with Oracle SQL and PL/SQL (stored procedures, functions, packages, triggers).
- Hands-on production experience with Oracle APEX front-end development.
- Experience with Azure DevOps / Git-based workflows and Agile delivery.
- Fluent English, spoken and written, with minimal errors - no interpreter or assistance permitted.
- Must be a Canadian citizen - a requirement for eligibility for the Government of Canada Secret-level personnel security screening this role needs to start work.
- Able to work on-site at 455 Boulevard de la Carrière, Gatineau, QC, on a primarily in-person basis (hybrid only if approved case-by-case by the client).
- Prior delivery experience on a Government of Canada IT services contract (TBIPS, ProServices, or similar).
- Familiarity with Unified Codes APEX Office Print (AOP).
More about this job
Responsibilities
Develop and maintain Oracle database logic and Oracle APEX user interfaces for engineering and airworthiness management applications. Participate in Agile delivery, use Azure DevOps and Git, and document software designs, system architecture, and code.
Requirements
Requires production experience with Oracle SQL and PL/SQL, Oracle APEX front-end development, and Azure DevOps or Git-based workflows in an Agile environment. Applicants must be fluent in English, Canadian citizens eligible for Secret-level screening, and able to work primarily on-site in Gatineau.
Skills
- Oracle SQL
- Oracle PL/SQL
- Oracle APEX
- Stored Procedures
- Functions
- Packages
- Triggers
- Front-End Development
- Back-End Development
- Azure DevOps
- Git
- Agile Delivery
- User Interface Design
- Software Documentation
- System Architecture
Visa sponsorship
Not detected in the job text
Categories
- Software
- Technology
- Government & Public Sector
- Engineering
Keywords
- Oracle
- Oracle SQL
- PL/SQL
- Oracle APEX
- Stored Procedures
- Functions
- Packages
- Triggers
- Full-Stack Development
- Front-End Development
- Back-End Development
- User Interface Design
- Workflows
- Interactive Prototypes
- Azure DevOps
- Git
- Agile
- Quality Assurance
- Configuration Management
- Software Design
- System Architecture
- Engineering Applications
- Airworthiness Management
- Government of Canada
- TBIPS
- Secret-Level Security Screening
- Unified Codes APEX Office Print
- AOP