Talent.com
Development Database Administrator

Development Database Administrator

ConnexallNorth York, ON, Canada
10 days ago
Job type
  • Full-time
Job description

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 end-customer sites
  • Stay updated on the latest trends and best practices in database management and development.
  • Share domain and technical expertise, providing technical mentorship and cross-training 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
  • This position does not support a Labour Market Impact Assessment, or any other form of immigration sponsorship .