Senior Program Analyst

Postion Title: RQ00397 - Senior Programmer Analyst

Location : Fredericton, New Brunswick

Mode: Contract

Client: Government of New Brunswick / Service New Brunswick (SNB)

Background

A successful candidate will work closely with the existing technical support team to maintain, enhance, troubleshoot, and optimize the CSDS application.

Key Responsibilities

The Programmer Analyst II will be responsible for a combination of ongoing application support, maintenance, and project-based development activities.

Key responsibilities include:

• Provide production support for Microsoft SQL Server Reporting Services (SSRS), including investigating report-related incidents, troubleshooting issues, and clarifying report functionality.
• Develop, maintain, and enhance SSRS reports based on business requirements.
• Analyze, troubleshoot, and resolve application errors, incidents, and system defects.
• Develop, maintain, and enhance PL/SQL stored procedures to support new and existing application functionalities.
• Optimize existing application components to improve system performance, efficiency, and security.
• Develop and execute scripts to convert and migrate data in support of new application functionalities.
• Support business teams during user training, User Acceptance Testing (UAT), and application releases.
• Develop and maintain technical documentation, including standards, procedures, specifications, and operational guidelines.
• Participate in application release management, system maintenance, and production support activities.
• Collaborate with technical and business stakeholders to analyze requirements and deliver effective technical solutions.
• Participate in incident management, problem management, and service request resolution.
• Contribute to team knowledge repositories and ensure documentation is updated regularly.
• Participate in team meetings, Agile ceremonies, and operational support rotations as required.

Additional Requirements: Some after-hours and weekend support may be required. Any overtime or work outside regular business hours must be approved in advance.

Mandatory Requirements

• A university degree in Computer Science or a related discipline is preferred. An equivalent combination of education and professional experience may also be considered.
• Minimum of 15 years of demonstrated IM/IT experience.
• Minimum of 10 years of demonstrated experience as a Senior Programmer Analyst, with strong programming and systems analysis capabilities.
• Excellent verbal and written communication skills in English.

Scored Requirements – Technical Experience

• Experience working with Provincial Healthcare applications and/or Regional Health Authority applications.
• Experience developing, documenting, coding, testing, and implementing technical solutions to meet business requirements.
• Hands-on experience with database management systems, particularly Oracle and Microsoft SQL Server.
• Experience developing, maintaining, and enhancing PL/SQL stored procedures.
• Strong programming and development experience with Java.
• Experience developing, maintaining, and supporting Linux Batch Jobs.
• Experience with SQL Server Integration Services (SSIS).
• Experience developing and maintaining reports using Microsoft SQL Server Reporting Services (SSRS).
• Experience using version control software for source code management and application development.