Database Developer

Company Description

One of Canada's Best Diversity Employers and Greater Toronto's Top Employers for many consecutive years, William Osler Health System (Osler) provides a safe and supportive health care network to grow your career. Osler is nationally recognized for its commitment to patient safety and is Accredited with Exemplary Standing, the highest rating a Canadian hospital can receive. As a major Ontario hospital system, and home to some of the biggest specialty and emergency departments in the country, Osler serves the 1.3 million residents of Brampton, Etobicoke and surrounding communities. We are proud to offer you incredible exposure to best-in-class health care delivery and challenging hands-on opportunities to stay at the top of your game.

A hospital system built for and by the community, we continue to expand our services to meet the needs of a growing population, creating opportunities for increased hands-on skills development, cross-department training and promotional opportunities. Guided by our accomplished senior leadership team, together we are driving our vision of world-class health care inspired by our people and communities.

At Osler, we invest in careers that go beyond where health care professionals like you can achieve their goals and find deep personal and professional fulfillment. Join our team today!

Job Description

Osler is seeking a Database Developer with a strong background in database management, performance optimization and security along with experience supporting application development teams. While the primary focus of this role is on database development and administration, the ideal candidate should be comfortable working with modern application development tools and assisting developers with database-driven applications.

This role will ensure data integrity, high availability and performance while collaborating with software engineers to optimize database-driven application architectures.

Accountabilities:

• Database development and administration
  • Design, implement and maintain relational (SQL Server, MySQL) and NoSQL databases
  • Perform database tuning, indexing and query optimization to improve performance
  • Ensure database security, backup strategies and disaster recovery planning
  • Monitor database health, performance and storage utilization
  • Manage user roles, permissions and access control to ensure compliance with data security standards
  • Automate and monitor routine database maintenance tasks using scripts and scheduled jobs
  • Provide support for database upgrades, migrations and version control
  • Manage and maintain an up-to-date inventory of databases, including configurations, versions and usage statistics
  • Collaborate with developers to design efficient database schemas and optimize SQL queries
  • Assist in backend application development by creating stored procedures, functions and triggers
• Application development and data integration
  • Work with ETL tools and data migration processes to support reporting and analytics needs
  • Assist in developing custom software solutions using Python, Node.js and .NET
  • Assist in designing and developing RESTful APIs for seamless data exchange
  • Provide guidance on best practices for data modeling, schema design and database versioning
  • Assist in AI-driven analytics and predictive modeling
  • Work with cloud-based technologies including databases
• Technical oversight and operational support
  • Collaborate with teams across the hospital and external vendors to ensure seamless database operations, support and integration with enterprise systems
  • Participate in architecture discussions related to database-driven applications
  • Ability to travel as needed for meetings, vendor coordination, training and on-site system support
  • Stay updated with emerging database and application development technologies to improve operational efficiency
  • Participate in an on-call rotation to provide 24/7 support
  • Work extended hours (days, evenings, nights, weekends) as required

Qualifications

• Proven experience in database management including administration
• Expertise in SQL-based databases (Microsoft SQL Server, MySQL)
• Hands-on experience with database tuning, indexing and performance optimization
• Strong understanding of database security, encryption and compliance
• Experience with backup and disaster recovery strategies, replication and clustering
• Familiarity with NoSQL databases (MongoDB, Firebase)
• Ability to write and optimize stored procedures, functions and triggers
• Hands-on experience with application development using tools like Node.js, .NET or Python
• Working experience with APIs and backend service development
• Exposure to AI-driven data processing and machine learning model integration with databases  an asset
• Knowledge of reporting tools such as Power BI an asset
• Must demonstrate Osler's Values of Respect, Excellence, Service, Compassion, Innovation and Collaboration

Additional Information

Hours: Days and participate in an on-call rotation to provide 24/7 support. Work extended hours (days, evenings, nights, weekends) as required (subject to change in accordance with operational requirements)

Onsite First: Roles that frequently support direct patient care and have dedicated hours when they are available to patients, team members and/or other partners

Application deadline: March 7, 2025

Annual Salary:
Minimum:  $  85,839.00
Maximum: $107,308.50

#LI-LM1 

Osler values inclusivity and diversity in the workplace. We welcome and encourage applicants from diverse backgrounds. We are committed to providing accessible employment practices that are in compliance with the Accessibility for Ontarians with Disabilities Act. If you require an accommodation at any stage of the recruitment process, please notify Human Resources at human.resources@williamoslerhs.ca.

While we thank all applicants, only those selected for an interview will be contacted. Any information obtained during the course of recruitment will be used for employment recruitment purposes only, and not for any other purpose.