Enter a job title or keyword

Programmer Analyst II – Client Service Delivery System

Upstaff

Job Location:

Fredericton - Canada

Monthly Salary: Not provided by the employer

Experience Required: 15years

Posted: 29 October 2026 (2 days ago)

Application Deadline: 26 January 2027

Vacancies: 1 Vacancy

Job Summary

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

Client: Service New Brunswick (SNB)

Department: SNB Health Applications

Position: Programmer Analyst II

Contract Start Date: December 1 2026

Contract End Date: November 30 2027

Contract Duration: 12 months

Work Allocation: 100%

Working Schedule: 5 days per week 7.25 hours per day

Work Location: 520 King Street Fredericton New Brunswick Canada

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.

M3 Senior Programmer Analyst 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-specific evidence of the following skills and experience. All experience must be supported by relevant client/employer names project descriptions roles and dates in month/year format.

S1 Provincial Healthcare / Regional Health Authority Applications: 5 Years

Demonstrated experience working with provincial healthcare applications and/or Regional Health Authority systems.
Experience supporting healthcare information systems public health applications or related healthcare business applications.

S2 Technical Solution Development: 10 Years

Demonstrated experience developing documenting coding testing and implementing technical solutions to meet business requirements.
Experience translating business requirements into technical specifications and delivering effective application solutions.

S3 Oracle and SQL Server Databases: 15 Years

Demonstrated experience working with database systems such as Oracle and Microsoft SQL Server.
Experience with SQL development database troubleshooting data processing and performance optimization.

S4 PL/SQL Stored Procedures: 15 Years

Demonstrated experience creating maintaining modifying debugging and optimizing Oracle PL/SQL stored procedures.
Experience implementing application enhancements and business functionality through database programming.

S5 Java: 10 Years

Demonstrated hands-on experience developing maintaining debugging and enhancing Java applications.
Experience supporting enterprise application environments.

S6 Linux Batch Jobs: 10 Years

Demonstrated experience developing maintaining scheduling and troubleshooting Linux batch jobs.
Experience with scripting automated processing job monitoring and resolving execution issues.

S7 SQL Server Integration Services (SSIS): 5 Years

Demonstrated experience developing maintaining and troubleshooting SSIS packages.
Experience with data integration transformation migration and processing.

S8 Microsoft SQL Server Reporting Services (SSRS): 5 Years

Demonstrated experience developing maintaining enhancing and troubleshooting SSRS reports.
Experience providing production reporting support and resolving reporting issues.

S9 Version Control Software: 10 Years

Demonstrated experience using version control software to manage source code track changes maintain code history and support collaborative development.
Candidates should identify the tools used and describe their application in relevant projects.

Ideal Candidate Profile

The ideal candidate is a highly experienced Senior Programmer Analyst with at least 15 years of overall IM/IT experience and at least 10 years in senior programming and systems analysis roles. The candidate should have extensive experience across Oracle SQL Server PL/SQL Java Linux batch jobs SSIS SSRS and version control.

Experience supporting provincial healthcare applications or Regional Health Authority systems will be particularly valuable. Candidates must be able to demonstrate their experience through detailed project histories and be prepared to work onsite in Fredericton throughout the contract period.

Required Skills:

M2 Overall IM/IT Experience Minimum 15 years of demonstrated Information Management / Information Technology (IM/IT) experience. M3 Senior Programmer Analyst 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. S1 Provincial Healthcare / Regional Health Authority Applications: 5 Years Demonstrated experience working with provincial healthcare applications and/or Regional Health Authority systems. Experience supporting healthcare information systems public health applications or related healthcare business applications. S2 Technical Solution Development: 10 Years Demonstrated experience developing documenting coding testing and implementing technical solutions to meet business requirements. Experience translating business requirements into technical specifications and delivering effective application solutions. S3 Oracle and SQL Server Databases: 15 Years Demonstrated experience working with database systems such as Oracle and Microsoft SQL Server. Experience with SQL development database troubleshooting data processing and performance optimization. S4 PL/SQL Stored Procedures: 15 Years Demonstrated experience creating maintaining modifying debugging and optimizing Oracle PL/SQL stored procedures. Experience implementing application enhancements and business functionality through database programming. S5 Java: 10 Years Demonstrated hands-on experience developing maintaining debugging and enhancing Java applications. Experience supporting enterprise application environments. S6 Linux Batch Jobs: 10 Years Demonstrated experience developing maintaining scheduling and troubleshooting Linux batch jobs. Experience with scripting automated processing job monitoring and resolving execution issues. S7 SQL Server Integration Services (SSIS): 5 Years Demonstrated experience developing maintaining and troubleshooting SSIS packages. Experience with data integration transformation migration and processing. S8 Microsoft SQL Server Reporting Services (SSRS): 5 Years Demonstrated experience developing maintaining enhancing and troubleshooting SSRS reports. Experience providing production reporting support and resolving reporting issues. S9 Version Control Software: 10 Years Demonstrated experience using version control software to manage source code track changes maintain code history and support collaborative development. Candidates should identify the tools used and describe their application in relevant projects.

Required Education:

EducationA university degree in Computer Science or a similar discipline is equivalent combination of education and relevant professional experience may be considered.

Apply Now