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.