Programmer Analyst II – Client Service Delivery System

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.