Duration: 12 Months
Job DescriptionWe 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.
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.
About US Tech Solutions:
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
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
