Programmer Analyst II

Project Description

The organization is seeking an experienced Programmer Analyst II to support, maintain, enhance, and optimize the Client Service Delivery System (CSDS), a case management application used to capture and manage client information for Mental Health and Addiction Services, as well as Public Health staff.

The selected candidate will augment the existing technical support team and contribute to both ongoing application maintenance and project-based development initiatives.

The role involves application production support, database programming, reporting, troubleshooting, application enhancements, security improvements, and implementation of technical solutions to meet evolving business requirements.

Responsibilities

• Provide

• application maintenance, technical support, and production support for the

• CSDS application.

• Investigate,

• troubleshoot, and resolve application incidents, errors, and technical

• issues.

• Create,

• maintain, and enhance Microsoft SQL Server Reporting Services (SSRS)

• reports.

• Investigate

• SSRS production issues, respond to service requests, and clarify report

• functionality.

• Develop,

• maintain, and optimize Oracle PL/SQL stored procedures.

• Implement new

• application features and enhancements based on business requirements.

• Reprogram and

• optimize application components to improve efficiency, performance, and

• security.

• Develop and

• execute data conversion scripts to support new application functionality.

• Provide

• technical support to business teams during training and User Acceptance

• Testing (UAT).

• Develop,

• maintain, and update technical documentation, standards, procedures, and

• specifications.

• Develop, test,

• document, and implement technical solutions.

• Participate in

• application release activities and deployment-related tasks.

• Complete

• assigned service requests, incidents, problems, maintenance, and

• development activities.

• Participate in

• incident and problem management and support resolution activities.

• Provide

• operational support as part of the team rotation, including on-call

• support when required.

• Participate in

• team scrums and maintain team knowledge repositories and documentation.

• Perform other

• related duties as assigned.

Requirements

• Mandatory Requirements

• University

• degree in Computer Science or a similar discipline is preferred; an

• equivalent combination of education and experience may be considered.

• Minimum 15

• years of demonstrated IM/IT experience.

• Minimum 10

• years of demonstrated experience as a Senior Programmer Analyst, including

• programming and analysis.

• Excellent

• verbal and written communication skills in English.

• Preferred / Scored Technical Experience

• Experience

• working with provincial healthcare and/or Regional Health Authority

• applications.

• Strong

• experience developing, documenting, coding, testing, and implementing

• technical solutions to meet business requirements.

• Extensive

• experience with Oracle and SQL Server database systems.

• Extensive

• experience maintaining and creating PL/SQL stored procedures.

• Experience

• with Java.

• Experience

• with Linux Batch Jobs.

• Experience

• with SQL Server Integration Services (SSIS).

• Experience

• with Microsoft SQL Server Reporting Services (SSRS).

• Experience

• with version control software.