Database Developer Jobs

The primary role of Database Developer / Administrator is for database design, development and maintenance to ensure CritiCall Ontario meets the requirements of the Transfer Payment Agreement (TPA) with the MOHLTC. This TPA requires CritiCall Ontario to provide data indicators to Ontario hospitals, LHINs and the Ministry of Health for a wide variety of provincial projects and initiatives independently of Hamilton Health Sciences. The Database Developer / Administrator will be required to provide enterprise database management for data reporting from all of CritiCall Ontario’s information systems.

This position is responsible for design, development and maintenance of our database server for reporting and internal applications. This includes leading and providing guidance with regards to architecture, design, coding, and unit testing. They will also be responding to and resolving support and deployment issues as well as being a domain expert with MS SQL configuration, installation, monitoring, security and disaster recovery activities.

• Ability to work in a fast paced environment with multiple priorities while maintaining high attention to detail and accuracy
• SQL Server 2016 or higher Installation and configuration experience with SQL Server, SQL Server Service Packs and Cumulative Updates
• Familiarity with SSAS, SSIS, SSRS, Power BI, AWS
• Excellent knowledge of data backup, recovery, security, integrity, and SQL programing
• Strong technical knowledge within the DBMS environment including installation, administration, performance analysis, capacity planning and systems management
• Demonstrated organizational and communication skills
• 5+ years of proven working experience as a SQL Server DBA
• Diploma or Degree in Computer Science, Computer Engineering, Information Systems, Information Technology, or equivalent technical related program
• Experience with creating database documentation including ERD’s, data dictionaries and architecture diagrams
• Previous work experience in a clinical or highly regulated sector (pharma, clinical, banking, etc.)

As a condition of employment, you are required to submit proof of full COVID-19 vaccination to Employee Health Services.

Job

Administrative/Service

Primary Location

Ontario-Hamilton

This position will be located at

Offsite Location

Organization

ONTARIO CRITICALL

Status

Regular

Hours per week

37.5

Number of Openings

1

Union Code

Non Union Employees

Minimum Salary

39.2500

Maximum Salary

50.3200

Post Date

Jun 29, 2023, 11:00:00 PM

Jul 6, 2023, 10:59:00 PM

Unit Summary

The CritiCall Ontario Program (CritiCall) is a single, province-wide one-number-to-call to access "resources" for critically ill patients. This 24-hour-a-day physician consultation and patient referral service links hospitals and medical resources across the province of Ontario and provides crucial services for physicians and other care providers. The scope of CritiCall services include: 24-hour-a-day medical 911 physician consultation and patient referral service for hospital based Ontario physicians. A capacity management system documenting the status of and access to acute care beds. Implementation, training and problem solving assistance for the Critical Care Information System (CCIS) to Ontario hospital critical care units.

Schedule Work Hours

Monday to Friday days - 37.5hrs/wk

Guidelines

Hamilton Health Sciences fosters a culture of patient and staff safety, whereby all employees are guided by our Mission, Vision, Values, and Values Based Code of Conduct. Hamilton Health Sciences is a teaching hospital and all staff and physicians are expected to support students and other learners.

To be considered for this opportunity applicants must apply during the posting period. All internal and external applicants may ONLY apply via the Careers website.

Hamilton Health Sciences is an equal opportunity employer and we will accommodate any needs under the Canadian Charter of Rights and Freedom, Accessibility for Ontarians with Disabilities Act and the Ontario Human Rights Code. Hiring processes will be modified to remove barriers to accommodate those with disabilities, if requested. Should any applicant require accommodation through the application processes, please contact HR Operations at 905-521-2100, Ext. 46947for assistance. If the applicant requires a specific accommodation because of a disability during an interview, the applicant will need to advise the hiring manager when scheduling the interview and the appropriate accommodations can be made.

This competition is open to all qualified applicants, however, qualified internal applicants will be considered first. Past performance will be considered as part of the selection process. If you are a previous employee of Hamilton Health Sciences, please note: the circumstances around an employee's exit will be considered prior to an offer of employment

Proficiency in both Official Languages, French and English, is considered an asset

If this position is temporary, selection for this position will be as per the outlined Collective Agreements:

Article 30 (k), CUPE Collective Agreement

Article 10.7 (d), ONA Collective Agreement

Article 13.01 (b) (ii), OPSEU 273 Collective Agreement

Article 14.04, OPSEU 209 Collective Agreement

Article 2.07 and Article 13, PIPSC RT Collective Agreement