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.
