Senior Program Analyst

BuzzClan; New Brunswick; In loco; CAD 90.000 - 120.000; Tempo pieno

Descrizione del lavoro

The Programmer Analyst II position with the Government of New Brunswick / Service New Brunswick (SNB) is to work with the technical support team to maintain, enhance, troubleshoot, and optimize the CSDS application. The role blends production support with project-based development and requires strong collaboration with business teams.

Candidates should have a university degree in computer science, 15+ years of IM/IT experience, and 10+ years as a Senior Programmer Analyst, with expertise in

Competenze

• University degree in Computer Science or related discipline preferred.
• Minimum 15 years IM/IT experience.
• Minimum 10 years as Senior Programmer Analyst with strong programming and systems analysis capabilities.
• Excellent verbal and written communication skills in English.

Mansioni

• Provide production support for SSRS reports, including investigating incidents and troubleshooting.
• Develop, maintain, and enhance SSRS reports based on business requirements.
• Analyze, troubleshoot, and resolve application errors, incidents, and defects.
• Develop PL/SQL stored procedures to support new and existing functionalities.
• Optimize existing components for performance, efficiency, and security.
• Develop and execute data migration scripts for new functionalities.
• Support business users during UAT and releases.
• Create and maintain technical documentation and standards.
• Participate in release management and production support activities.
• Collaborate with stakeholders to analyze requirements and deliver solutions.
• Contribute to team knowledge repositories and documentation.

Conoscenze

Communication skills

Java

Agile ceremonies

Team collaboration

Formazione

Bachelor's degree in Computer Science

Strumenti

Oracle

SQL Server

SSIS

SSRS

PL/SQL

Linux

Descrizione del lavoro

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.