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.