Programmer Analyst II – Client Service Delivery System

SereneAID; Fredericton; Sur place; CAD 110 000 - 150 000; Plein temps

Résumé du poste

Upstaff Employment Services Inc. is seeking a Programmer Analyst II for Service New Brunswick (SNB) in Fredericton, NB, to maintain and enhance the CSDS. The role requires extensive senior-level programming and systems analysis experience with Oracle, SQL Server, Java, and SSIS/SSRS skills.

The position is a full-time 12-month contract, starting December 1, 2026, onsite at 520 King Street. Candidates must be able to work onsite for the duration and have excellent English communication.

Qualifications

• 15+ years of IM/IT experience required.
• 10+ years as Senior Programmer Analyst, covering programming and systems analysis.
• Excellent English communication, both written and verbal.
• Available to commence December 1, 2026 and onsite in Fredericton NB.
• Experience with healthcare or provincial applications is a plus.

Responsabilités

• Maintain, support, troubleshoot, and enhance CSDS.
• Develop and optimize SSRS reports and SSIS packages.
• Create and modify Oracle PL/SQL stored procedures.
• Develop Java components and work with Oracle/SQL Server databases.
• Support Linux batch jobs and data conversion activities.
• Participate in full development lifecycle including design, coding, testing and deployment.

Connaissances

Java

PL/SQL

Oracle

SQL Server

SSIS

SSRS

Linux batch jobs

Data integration

Formation

University degree in Computer Science or related field

Outils

Oracle Database

Microsoft SQL Server

Description du poste

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-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.

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.

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.