Senior Platform Database RUN Engineer

InVita Healthcare Technologies; Ottawa; Hybrid; CAD 115,000 - 125,000; Full time

Job summary

InVita Healthcare Technologies in Canada is seeking a Senior Platform Database RUN Engineer to join the Platform Engineering team. The role focuses on MAK.care with support for eProgesa, P.H.S/eTraceLine, Cosmas, and eDRM product lines.

Responsibilities include expanding database capabilities (SQL Server, Aurora, MySQL, DB/2), participating in database design, development, testing, and documentation, and driving reliable data solutions while collaborating across teams.

Qualifications

• Extensive experience in database related software development.
• Hands-on experience working in SQL.
• Proven experience in Oracle and at least one more database data model optimization.
• Experience in Oracle Goldengate and a similar replication solution for at least one database.
• Experience in the development of "cross-database" solutions.
• Strong background in Linux/Unix operating systems and networking concepts; Linux and shell scripting.
• Highly analytical mindset, with an ability to see both the big picture and the details.
• Innovation, Flexibility, and Adaptability – undertake tasks with a positive attitude and respond well to management and customer requests.
• Proven ability to make recommendations to resolve problems by using judgment that is consistent with InVita Healthcare Technologies culture, policies, and procedures.
• Effective communication and collaboration skills suitable for liaising with colleagues within the team and beyond to the broader project team, both on a one to one and to many bases.
• Fluency in English (verbal and written); and
• At least Bachelor’s degree in a software engineering related field (or equivalent experience).

Responsibilities

• Operate as part of a team expanding the scope of databases that can be used such as SQL Server, Aurora, MySQL, DB/2,
• Participate in the selection of new databases
• Participate in the design of new databases
• Prototype of new databases
• Develop new databases
• Testing of new databases
• Participate in the implementation of new database solutions
• Recommend improvements
• Documenting work as appropriate

Skills

SQL

Oracle

Goldengate

Cross-database

Linux/Unix

Shell scripting

Analytical mindset

Communication skills

English fluency

Education

Bachelor’s degree in software engineering or related field

Tools

Oracle Goldengate

Aurora

MySQL

DB2

SQL Server

Job description

About InVita Healthcare Technologies

InVita Healthcare Technologies delivers the world's most comprehensive human biologics software solutions managing blood, organ, and tissue workflows, enabling unmatched visibility and compliance to improve patient outcomes and save lives. Trusted by blood organizations, organ procurement organizations, hospitals, forensic laboratories, public health agencies, and government institutions worldwide, InVita's solutions empower organizations to fulfill their mission, optimize operations, and better serve their communities. Learn more at invitahealth.com.

Job Title:

Senior Platform Database RUN Engineer

Location:

Hybrid - Ontario, must be in commutable distance from Downtown Ottawa and/or St. Laurent/East End

Reporting to:

Platform Engineering Team Lead OR Platform Operations Team Lead

Hours of work:

Typical hours of work are from 8:30 AM until 5:30 PM local time Monday through Friday. Flexibility of Working Hours dependent on location. Additional hours may be necessary as needed. This position is exempt from overtime.

Overview:

This role will primarily focus on MAK.care, with supporting capabilities across the eProgesa, P.H.S/eTraceLine, Cosmas, and eDRM product lines.

Key Responsibilities

• Operate as part of a team expanding the scope of databases that can be used such as SQL Server, Aurora, MySQL, DB/2,
• Participate in the selection of new databases
• Participate in the design of new databases
• Prototype of new databases
• Develop new databases
• Testing of new databases
• Participate in the implementation of new database solutions
• Recommend improvements
• Documenting work as appropriate

Key Outcomes

• Quality and on time delivery of activities
• Quality and on time delivery of documentation

Qualifications/Experience

• Extensive experience in database related software development;
• Hands-on experience working in Query languages (SQL);
• Proven experience in Oracle and at least one more database data model optimization;
• Experience in Oracle Goldengate and a similar replication solution for at least one database;
• Experience in the development of "cross-database" solutions;
• Strong background in Linux/Unix operating systems and networking concepts; Linux and shell scripting;
• Highly analytical mindset, with an ability to see both the big picture and the details;
• Innovation, Flexibility, and Adaptability – undertake tasks with a positive attitude and respond well to management and customer requests. Must be prepared to meet business goals and respond well to change;
• Proven ability to make recommendations to resolve problems by using judgment that is consistent with InVita Healthcare Technologies culture, policies, and procedures;
• Effective communication and collaboration skills suitable for liaising with colleagues within the team and beyond to the broader project team, both on a one to one and to many bases;
• Fluency in English (verbal and written); and
• At least Bachelor’s degree in a software engineering related field (or equivalent experience).

Physical Demands and Work Environment

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodation may While performing the duties of this position, prolonged periods of sitting at a desk and working on a computer may be required.

• Additionally, the employee is regularly required to talk or listen.
• The employee frequently is required to use hands or fingers, handle, or feel objects, tools, or controls.
• The employee is occasionally required to stand, walk; sit; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl.
• The employee must occasionally lift and/or move up to 15 pounds.
• Specific vision abilities required by this position include close vision, distance vision, color vision, peripheral vision, and the ability to adjust focus.
• The noise level in the work environment is usually moderate.

This job description in no way states or implies that these are the only duties to be performed by the employee(s) incumbent in this position. Employee(s) will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments.

This document does not create an employment contract, implied or otherwise, other than an "at will" relationship.

InVita provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

The Pay Range For This Role Is

115,000 - 125,000 CAD per year(Hybrid (ON, CA))