Database Developer - Information Services

Back to Job List

Date Posted: 10/26/2023

Location: Toronto, ON, Canada

Reference No.: 2023-6381

Position Type: Regular full-time

Department: Information Services

FTE Status: 1.00

Hours of Work: 8 hrs

Campus Site: Bayview

Shifts Weekday Required: Days

Shifts Weekend Required: No Weekends

Statutory Holiday(s) Required: No

The Information Management (IM) team at Sunnybrook Health Sciences Centre is seeking a full-time permanent Database Developer .Information Management is a group within the Information Services (IS) Department at Sunnybrook Health Sciences Centre. Through its established IM Architecture, IM is focused on the acquisition, curation and provisioning of clinical and operational data/information across the organization. This includes growing interest amongst the Sunnybrook research community, and initiatives involving Artificial Intelligence (AI) & Machine Learning (ML).

Job Duties and Responsibilities:

 

  • Optimize database systems for performance efficiency.
  • Create complex queries, functions, scripts, stored procedures and triggers
  • Identify any issues related to database performance and provide corrective measures.
  • Ensure high standards of data quality and integrity in databases.
  • Participate in database design and architecture to support application development projects, create databases with efficient structures
  • Test databases and perform bug fixes.
  • Troubleshoot database related issues in a timely fashion.
  • Apply security best practices to protect databases from unauthorized access & use
  • Evaluate existing database and recommend improvements for performance efficiency.
  • Develop technical and training manuals
  • Provide data management support to users
  • Research and suggest new database products, services and protocols

The ideal candidate must have:

  • Proven work experience as a Database developer working with SQL Server 2017/2019/2022
  • Hands on experience with T-SQL, including Writing Grouped Queries, Pivoting/Unpivoting Data, using SQL Window Functions, Common Table Expressions (CTE)
  • ETL development experience using SSIS
  • Report development experience using SSRS and Power BI
  • Good understanding of database normalization theory (1st, 2nd, 3rd normal forms)
  • Experience developing normalized relational databases
  • Good understanding of data and schema standards and concepts
  • Good understand database design, implementation, troubleshooting and maintenance

Additional preferred experience & skills:

  • Database/ETL experience in a healthcare environment
  • Knowledge of HL7 messaging standards, particularly HL7 FHIR
  • Knowledge of Python for data processing, validation, & orchestration
  • Experience with Microsoft Azure, including use and configuration of Azure Data Factory
  • Linux server configuration & administration

In addition to the above technical skills, all candidates for the above roles shall possess:

  • Excellent oral and written communication skills
  • Analytical abilities and ability to work effectively with technical & business users
  • Ability to understand business requirements and convert them to functional specifications
  • Ability to create technical and functional documentation
  • Ability to work effectively with all levels of management
If you are looking for an exciting opportunity and to build a career in an innovative and dynamic organization, submit your resume by clicking on Apply Now below. 

Sunnybrook Health Sciences Centre is committed to providing accessible employment practices that are in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). If you require accommodation for disability during any stage of the recruitment process, please indicate this in your cover letter.


Sunnybrook Health Sciences Centre is strongly committed to inclusion and diversity within its community and welcomes all applicants including but not limited to: visible minorities, all religions and ethnicities, persons with disabilities, LGBTQ persons, and all others who may contribute to the further diversification of ideas.


Please be advised that in order to be eligible for employment at Sunnybrook, all new hires must have received the full series of a COVID-19 vaccine or combination of COVID-19 vaccines approved by Health Canada (e.g., two doses of a two-dose vaccine series, or one dose of a single-dose vaccine series); AND have received the final dose of the COVID-19 vaccine at least 14 days ago. Medical exemptions or any other kind of requested exemption based upon the Hospital’s obligations pursuant to the Ontario Human Rights Code will be considered on a case-by-case basis.

We thank all applicants for their interest. However, only candidates selected for an interview will be contacted. Sunnybrook Health Sciences Centre is an equal opportunity employer.