Java Programmer # 26-27285

Us Tech Solutions; Fredericton; On-site; CAD 110,000 - 150,000; Full time

Job summary

Us Tech Solutions is seeking an experienced Senior Programmer Analyst to support and enhance a critical case management application in the public healthcare sector. The role covers maintenance, production support, database development, reporting, and project-based enhancements.

The candidate will maintain and develop SSRS reports, optimize PL/SQL and SQL Server procedures, provide training and UAT support, and produce technical documentation.

Qualifications

• 15+ years IM/IT experience with overall expertise.
• 10+ years as Senior Programmer Analyst.
• 5+ years healthcare or regional health authority apps.
• 10+ years developing, documenting, coding, testing solutions.
• 15+ years with Oracle and SQL Server.
• 15+ years maintaining PL/SQL stored procedures.
• 10+ years with Java.
• 10+ years with Linux batch jobs.
• 5+ years SSIS.
• 5+ years SSRS.
• 10+ years with version control software.

Responsibilities

• Maintain, support, and enhance existing business applications and case management systems.
• Develop, maintain, and troubleshoot SSRS reports.
• Investigate and resolve production reporting issues, application errors, incidents, and service requests.
• Develop, maintain, and optimize Oracle PL/SQL stored procedures to implement new functionalities.
• Develop, document, code, test, and implement technical solutions to meet business requirements.
• Support Java-based application development, maintenance, and troubleshooting.
• Create and troubleshoot Linux batch jobs supporting data processing activities.
• Work with Oracle and SQL Server databases to support data management and reporting requirements.
• Develop and maintain SSIS packages and related data integration processes.
• Write data conversion scripts to support new functionalities and enhancements.
• Optimize existing components for efficiency, performance, and security.
• Support business teams with training and UAT.
• Create and maintain technical documentation and standards.
• Use version control to manage source code and changes.
• Participate in releases, incident/problem management, and ongoing production support.
• Contribute to team knowledge repositories and collaborate with stakeholders.
• Participate in on-call support as needed.

Skills

Java

SQL and PL/SQL

Reporting and BI

Problem solving

Documentation

Communication

Education

Bachelor's degree in Computer Science

Tools

SSRS

SSIS

Oracle

SQL Server

PL/SQL

Linux

Job description

We are seeking an experienced Senior Programmer Analyst to support and enhance a critical case management application used within the public healthcare sector. The role involves a combination of ongoing application maintenance, production support, database development, reporting, and project-based enhancements.

The successful candidate will be responsible for maintaining and developing reporting solutions, resolving application issues, implementing new functionalities through database stored procedures, and optimizing existing systems for improved efficiency and security. The role also involves supporting business users with training and user acceptance testing, maintaining technical documentation, and developing data conversion scripts to accommodate new application requirements.

The candidate will collaborate with technical and business teams to ensure application stability, data accuracy, and the successful delivery of system enhancements. Occasional after-hours and weekend support may be required.

Responsibilities

• Maintain, support, and enhance existing business applications and case management systems.
• Develop, maintain, and troubleshoot Microsoft SQL Server Reporting Services (SSRS) reports.
• Investigate and resolve production reporting issues, application errors, incidents, and service requests.
• Develop, maintain, and optimize Oracle PL/SQL stored procedures to implement new application functionalities.
• Develop, document, code, test, and implement technical solutions to meet business requirements.
• Support Java-based application development, maintenance, and troubleshooting.
• Create, maintain, and troubleshoot Linux batch jobs supporting application and data processing activities.
• Work with Oracle and SQL Server databases to support data management, application functionality, and reporting requirements.
• Develop and maintain SQL Server Integration Services (SSIS) packages and related data integration processes.
• Write data conversion scripts to support new functionalities and application enhancements.
• Optimize existing application components to improve efficiency, performance, and security.
• Support business teams with application training and user acceptance testing (UAT).
• Create and maintain technical documentation, including standards, procedures, specifications, and operational guidelines.
• Use version control software to manage source code and track application changes.
• Participate in application releases, incident and problem management, and ongoing production support activities.
• Contribute to team knowledge repositories and collaborate with technical and business stakeholders.
• Participate in on-call operational support and provide after-hours or weekend assistance when required and approved.

Duration: 12 Months

Experience

• Minimum 15 years of overall Information Management / Information Technology (IM/IT) experience.
• Minimum 10 years of experience as a Senior Programmer Analyst, including programming and systems analysis.
• Minimum 5 years of experience working with provincial healthcare and/or regional health authority applications.
• Minimum 10 years of experience developing, documenting, coding, testing, and implementing technical solutions.
• Minimum 15 years of experience with database systems such as Oracle and SQL Server.
• Minimum 15 years of experience maintaining and creating PL/SQL stored procedures.
• Minimum 10 years of experience with Java.
• Minimum 10 years of experience with Linux batch jobs.
• Minimum 5 years of experience with SQL Server Integration Services (SSIS).
• Minimum 5 years of experience with Microsoft SQL Server Reporting Services (SSRS).
• Minimum 10 years of experience with version control software.
• Demonstrated experience in application maintenance, production support, troubleshooting, and resolving technical issues.
• Strong analytical, problem-solving, documentation, and communication skills.
• Ability to work onsite in Fredericton, New Brunswick, and participate in after-hours support as required.

Skillsets

• Programming Languages: Java and application programming.
• Database Technologies: Oracle, Microsoft SQL Server, SQL development, and database troubleshooting.
• PL/SQL Development: Creating, maintaining, and optimizing stored procedures.
• Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), report development, and production support.
• Data Integration: SQL Server Integration Services (SSIS) and data processing workflows.
• Operating Systems and Batch Processing: Linux batch jobs, job monitoring, and troubleshooting.
• Version Control: Source code management and version control software.
• Application Support: Incident management, problem resolution, application maintenance, production troubleshooting, and system enhancements.
• Testing and Implementation: Technical solution development, coding, testing, implementation, and user acceptance testing (UAT).
• Data Conversion: Scripting and data transformation to support application enhancements.
• Documentation: Technical specifications, operational procedures, standards, and knowledge management.
• Collaboration: Business user support, application training, stakeholder communication, and teamwork.

Education

• A university degree in Computer Science or a similar discipline is preferred.
• An equivalent combination of education and professional experience may be considered.
• Excellent verbal and written communication skills in English are required.

US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

AI Statement

By applying, you acknowledge that AI-assisted tools may be used during hiring