Development Database Administrator – Toronto

  • Toronto

    GlobeStar Systems is a leader in integrated clinical communication. Our cornerstone
    product, Connexall®, is an award-winning Enterprise grade IoT platform, purpose built
    for the healthcare industry. Connexall® is a sophisticated and customizable end-to-end
    integration and communication platform that helps its customers improve clinical
    workflow, reduce alarm fatigue, and drive better patient and staff outcomes.

    Job Title: Development Database Administrator

    Type: Full-Time

    Start Date: Immediate

    Location: Toronto, Ontario

    Job Summary

    Reporting to the Data & Analytics Team Lead, the Development Database Administrator will be a key member of the Solutions Development Teams. This role involves implementing, configuring, maintaining, securing, and optimizing SQL Server and PostgreSQL RDBMS systems within the Solutions Development department. The goal is to ensure the availability and consistent performance of these systems. The candidate will collaborate closely with developers and engineers to implement best practices across multiple stages of data and analytics product development, from design to delivery. This position requires hands-on expertise in deploying data warehouse and analytical solutions.The ideal candidate will be capable of working both independently and collaboratively and possess strong technical, interpersonal, and communication skills.

    Primary Responsibilities

    • Understand and follow GlobeStar’s ISO-13485-2016 Quality Management
      System, and all relevant operating procedures and work instructions

    • Install, configure, and maintain Solution Development SQL Servers and
      PostgreSQL databases, including all associated software and hardware (Windows
      servers, virtual machines, SQL Server tools and components including SSIS, SSRS,
      SSMS, SSDT and Encryption)

    • Ensure high availability, performance, and scalability of databases to support
      application development

    • Design and implement database backup, recovery, and disaster recovery
      strategies

    • Collaborate with developers to design and optimize database schemas, indexes,
      and queries

    • Provide guidance on best practices for database development and integration

    • Review and optimize SQL scripts, stored procedures, and triggers

    • Monitor database performance and conduct regular tuning to optimize query
      execution

    • Identify and resolve bottlenecks, deadlocks, and other performance issues

    • Implement database security measures, including user access controls and
      encryption

    • Ensure compliance with organizational and industry standards for data security

    • Work closely with the Data & Analytics Team to support reporting and analytics
      needs

    • Assist in automating data workflows and pipelines as required

    • Maintain comprehensive documentation of database configurations, procedures,
      and policies

    • Support deployment of the product by providing documentation, preparing
      deployment scripts and producing deployment plans

    • Assist the Connexall Operations team and provide consultations for
      troubleshooting and deployment of database and analytics products at endcustomer sites

    • Stay updated on the latest trends and best practices in database management
      and development

    • Share domain and technical expertise, providing technical mentorship and crosstraining to other peers and team members

    • Other duties as assigned

    Qualifications

    • Bachelor’s Degree or equivalent in Computer Science, Software Engineering or a
      similar discipline

    • 2+ years experience in database administration, particularly with SQL Server and
      PostgreSQL

    • 2+ years work experience as database developer is a big asset

    • Experience with deployment and maintenance of data warehouse and analytical
      solutions

    • Expert knowledge in SQL server performance tuning, optimization and
      troubleshooting tools

    • Expertise is T-SQL programming and scripting

    • Experience with SSRS, SSIS and SSAS

    • Experience working with Windows server, including Active Directory

    • Experience with Azure SQL Administration is a plus

    • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL
      Server

    • MCSA and/or MCITP certifications a plus

    • Excellent written and verbal communication

    • Flexible, team player, “get-it-done” personality

    • Ability to organize and plan work independently

    • Ability to work in a rapidly changing environment

    • Ability to multi-task and context-switch effectively between different activities
      and teams

    Benefits

    • Competitive annual salary

    • A rich benefits package, including medical, dental, life, and long-term disability
      insurance

    • Retirement savings plan with employer contributions

    • Professional development & training opportunities

    • Education Reimbursement Program

    • Flexible work arrangements (Hybrid)

    • Collaborative & inclusive work environment

    Apply Now