Programmer Analyst II – Client Service Delivery System

Fredericton, Canada | Posted on 10/28/2026

Job Description: Programmer Analyst II – Client Service Delivery System (CSDS)

Client: Service New Brunswick (SNB)

Department: SNB – Health Applications

Contract Start Date: December 1, 2026

Contract End Date: November 30, 2027

Contract Duration: 12 months

Work Allocation: 100%

Work Model: 100% Onsite

Position Overview

Upstaff Employment Services Inc. is seeking an experienced Programmer Analyst II – Client Service Delivery System (CSDS) for Service New Brunswick (SNB), within its Health Applications department.

The successful candidate will support the Provincial Health Application Services (PHAS) team in maintaining, enhancing, troubleshooting, and optimizing the Client Service Delivery System (CSDS). This case management application supports Mental Health and Addiction Services and Public Health staff in capturing and managing client information.

The role involves a combination of application maintenance, production support, database programming, reporting, application enhancements, data conversion, and project-based development. The ideal candidate will bring extensive senior-level programming and systems analysis experience, strong database development skills, and a proven track record supporting complex enterprise applications.

This is a full time, 12-month contract requiring onsite work in Fredericton, New Brunswick. Candidates must be available to start on December 1, 2026, and commit to the onsite arrangement for the assignment.

Key Responsibilities

- Maintain, support, troubleshoot, and enhance the Client Service Delivery System (CSDS).




- Investigate and resolve application incidents, production issues, system errors, and service requests.
- Develop, maintain, modify, and troubleshoot Microsoft SQL Server Reporting Services (SSRS) reports.
- Create, maintain, and optimize Oracle PL/SQL stored procedures to implement new business functionalities.
- Develop, maintain, and enhance Java application components.
- Work with Oracle and Microsoft SQL Server databases to support application functionality, data processing, and performance optimization.
- Develop, maintain, and troubleshoot Linux batch jobs and associated scripts.
- Use SQL Server Integration Services (SSIS) for data integration, transformation, and migration activities.
- Develop data conversion scripts to support new application functionalities and business requirements.
- Analyze business requirements and translate them into technical specifications and effective solutions.
- Participate in the full development lifecycle, including design, documentation, coding, testing, implementation, and ongoing support.
- Support business teams during user acceptance testing (UAT), training, and validation of application changes.
- Prepare and maintain technical documentation, system specifications, operational procedures, and coding standards.
- Support application releases, deployments,



incident management, and problem resolution.
- Participate in team scrums, operational support rotations, and knowledge-sharing activities.
- Identify opportunities to improve application efficiency, performance, reliability, and security.
- Provide approved after-hours or weekend support when required.
- Comply with all applicable SNB confidentiality, privacy, information security, and workplace policies.

Requirements

Mandatory Requirements

Candidates must meet all mandatory requirements to qualify for submission.

M1 – Education

A university degree in Computer Science or a similar discipline is preferred.

An equivalent combination of education and relevant professional experience may be considered.

M2 – Overall IM/IT Experience

Minimum 15 years of demonstrated Information Management / Information Technology (IM/IT) experience.

Minimum 10 years of demonstrated experience as a Senior Programmer Analyst, covering both programming and systems analysis.

M4 – Communication Skills

Excellent verbal and written communication skills in English.

Ability to communicate effectively with technical teams, business stakeholders, and end users.

Ability to prepare clear technical documentation and specifications.

M5 – Availability and Onsite Commitment

Must be available to commence the assignment on December 1, 2026.

Must be willing and able to work onsite at 520 King Street, Fredericton, New Brunswick.

Must be available for the full-time assignment from December 1, 2026, to November 30, 2027.

Scored Technical Requirements

Candidates must provide project

📌 Programmer Analyst II – Client Service Delivery System (Fredericton)
🏢 SereneAid
📍 Fredericton