Programmer Analyst Ii - Client Service Delivery System

Programmer Analyst II – Client Service Delivery System
Fredericton, Canada | Posted on 10/28/2026Job Description: Programmer Analyst II – Client Service Delivery System (CSDS)Client:
Service New Brunswick (SNB)Department:
SNB – Health ApplicationsContract Start Date:
December 1, 2026Contract End Date:
November 30, 2027Contract Duration:
12 monthsWork Allocation:
100%Work Model:
100% OnsitePosition 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.
#J-18808-Ljbffr