Job DescriptionJob Description – Programmer Analyst IIIRequisition ID: REQ00342
Client: Service New Brunswick (SNB) – Business Application Services
Department: Department of Transportation and Infrastructure (DTI)
Project: Construction Management System (CMS) Replacement
Location: Fredericton, New Brunswick (Remote within Canada with onsite support as required)
Duration: July 20, 2026 – July 23, 2027
Extension: Possible extension up to 9 months based on project requirements and budget approval
Work Hours: Full-time | 7.25 Hours/Day
Maximum Rate: CAD $110/hour
Position OverviewService 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 VB.NET WinForms, Oracle PL/SQL databases, embedded SSRS reporting, and Azure DevOps/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.
The 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 (M1 – M5)M1 – Years of IM/IT Experience- Minimum 15 years of overall IM/IT industry experience.
M2 – VB.Net WinForm Programmer Analyst Experience- Minimum 10 years of experience working as a VB.Net WinForm Programmer Analyst.
M3 – Oracle PL/SQL Database Design & Development- Minimum 10 years of hands-on experience with Oracle PL/SQL database design, development, and support.
M4 – Communication Skills- Strong spoken and written communication skills in English.
M5 – Work Authorization- Must be legally authorized to work in Canada.
Scored Requirements / Mandatory Technical Skills (S1 – S10)S1 – VB.Net WinForm Development- Minimum 10 years of experience developing and maintaining VB.Net WinForm applications and codebases.
S2 – Internal Framework / Code Library Experience- Minimum 3 years of experience contributing to internal application frameworks, reusable templates, or shared code libraries.
S3 – Oracle Database Specifications- Minimum 10 years of experience interpreting and defining Oracle database table structures and field specifications for complex enterprise systems.
S4 – Database Schema Analysis- Minimum 10 years of experience reading, analyzing, and understanding complex Oracle database schemas.
S5 – Visual Studio & Version Control Management- 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 DevOps or Git.
S6 – Advanced Oracle PL/SQL- Minimum 10 years of experience creating, maintaining, troubleshooting, and debugging:
- Oracle Packages
- Procedures
- Functions
- Triggers
S7 – SSRS Reporting- Minimum 7 years of experience developing and maintaining SSRS Reports, including embedded reporting solutions.
S8 – Distributed Team Collaboration- Minimum 10 years of experience working within distributed cross-functional teams including:
- Business Analysts
- DBAs
- Developers
- Technical Leads
- End Users
S9 – Business & Requirements Analysis- Minimum 7 years of experience performing:
- Stakeholder engagement
- Elicitation sessions
- Process reviews
- Functional and non-functional requirements documentation
- Analysis activities
S10 – UI/UX Collaboration- Minimum 10 years of experience collaborating on UI/UX initiatives to deliver:
- User-friendly interfaces
- Accessible applications
- 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:
- VB.Net WinForms
- Oracle PL/SQL
- SSRS
- Visual Studio
- Azure DevOps/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 ceremonies including team scrums and technical discussions.
- Support version control, code merges, and coordinated deployments across multiple developers.
- Collaborate with UI/UX teams to ensure accessible and visually consistent application design.
- Support troubleshooting, debugging, performance tuning, and production support activities.
DeliverablesThe successful candidate will be expected to:
- Develop application components and enhancements based on approved functional specifications.
- Deliver technical solutions across the technology stack including VB.Net, Oracle PL/SQL, SSRS, Visual Studio, and Azure DevOps.
- Analyze and resolve defects and enhancement requests.
- Maintain and update technical and system documentation.
- Participate actively in team scrums and collaborative development activities.
Work Environment- Remote work is permitted within Canada.
- Candidates may be required onsite in Fredericton, NB as needed.
- Work must be performed during Atlantic Standard Time business hours (8:15 AM – 4:30 PM AST).
- Travel expenses will not be reimbursed by SNB.