Programmer Analyst III

Job Description – Programmer Analyst III

Location:

Fredericton, New Brunswick (Remote within Canada with onsite support as required)

Duration:
July 20, 2026 – July 23, 2027

Working Hours:

Full‑time – 7.25 Hours/Day. Work must be performed during Atlantic Standard Time business hours (8:15 AM – 4:30 PM AST).

Position Overview
Service New Brunswick (SNB) is seeking two highly experienced Programmer Analyst III resources to support the Department of Transportation and Infrastructure (DTI) in the modernization and replacement of the Construction Management System (CMS). The selected candidates will work within an internal development team consisting of Business SMEs, Project Leads, Technical Analysts, DBAs, Lead Developers, Business Analysts, and Programmer Analysts.

The application environment is centered around  Win Forms, Oracle PL/SQL databases, embedded SSRS reporting, and Azure Dev Ops/Git version control. One resource will primarily support the CMS Replacement initiative as a Senior Programmer Analyst, while the second resource will provide senior‑level development support across other DTI applications and enhancement initiatives.

Successful candidates will contribute to the design, development, maintenance, debugging, deployment, and support of enterprise applications and database solutions while adhering to established internal frameworks, coding standards, and development methodologies.

Mandatory Requirements

Minimum 15 years of overall IM/IT industry experience.

Minimum 10 years of experience working as a  Win Form Programmer Analyst.

Minimum 10 years of hands‑on experience with Oracle PL/SQL database design, development, and support.

Strong spoken and written communication skills in English.

Must be legally authorized to work in Canada.

Scored Requirements / Mandatory Technical Skills

Minimum 10 years of experience developing and maintaining  Win Form applications and codebases.

Minimum 3 years of experience contributing to internal application frameworks, reusable templates, or shared code libraries.

Minimum 10 years of experience interpreting and defining Oracle database table structures and field specifications for complex enterprise systems.

Minimum 10 years of experience reading, analyzing, and understanding complex Oracle database schemas.

Minimum 10 years of experience managing large Visual Studio projects/codebases and coordinating development activities among multiple developers using version control systems such as Azure Dev Ops or Git.

Minimum 10 years of experience creating, maintaining, troubleshooting, and debugging Oracle PL/SQL components:

Oracle Packages

Procedures

Functions

Triggers

Minimum 7 years of experience developing and maintaining SSRS Reports, including embedded reporting solutions.

Minimum 10 years of experience working within distributed cross‑functional teams including Business Analysts, DBAs, Developers, Technical Leads, and End Users.

Minimum 7 years of experience performing stakeholder engagement, elicitation sessions, process reviews, functional and non‑functional requirements documentation, and analysis activities.

Minimum 10 years of experience collaborating on UI/UX initiatives to deliver user‑friendly interfaces, accessible applications, and visually consistent enterprise solutions.

Preferred / Asset Skills

Experience developing C#.Net MVC web applications.

Experience working within public sector or government environments.

Familiarity with enterprise construction management or infrastructure‑related applications.

Experience working in Agile/Scrum environments.

Key Responsibilities

Develop new applications and application components based on functional specifications.

Design, code, test, deploy, and maintain enterprise solutions using  Win Forms, Oracle PL/SQL, SSRS, Visual Studio, and Azure Dev Ops/Git.

Analyze bug reports and change requests and propose technical solutions.

Develop and maintain advanced PL/SQL database objects including procedures, packages, triggers, and functions.

Collaborate with Business Analysts and stakeholders to interpret business requirements.

Produce and maintain technical documentation according to organizational standards.

Participate in Agile…