Database Reliability Engineer

Overview

Innovate With Purpose

Do you want to work for a company that is innovating and making a difference to the health and wellbeing of people all over the world? We’re not about selling meaningless, unnecessary products for corporate profitability. You’ll be working on technology that will revolutionise global health systems so that we can finally get the healthcare we all want - a basic human right.

We like to think of ourselves as a community of start-ups where you can be your true, genuine self. Each of our product teams has the autonomy to decide how they operate and contribute towards our mission of providing each person with the right care at the right time and in the right place. Orion Health is excited to be expanding our galaxy by recruiting for a number of stellar individuals to join our team to help us deliver to our global customer base. If you want to climb aboard the rocketship and help us revolutionise global health systems, astronomical opportunities await.

Position Purpose

The primary objective of the

Database Reliability Engineer

is to provide expertise across database and data platform activities and ensure delivery of critical database workloads within the North American Operations Teams. This position is hands-on with its own workload and will participate in all database responsibilities within the managed environments spanning private and public clouds.

Responsibilities and Key Activities

Managing and maintaining databases, ensuring they operate efficiently, securely, and reliably within private and public cloud environments.

Designing and implementing databases, securing data, backing up and restoring data, monitoring performance, and optimizing database operations.

Optimising manual effort through automation via service-based platforms (e.g., AWS Oracle RDS, AWS SQL Server RDS, AWS PostgreSQL RDS, and managed Apache Cassandra).

Operating queries resulting from query and tuning analysis of Orion Health products.

Providing on-call support outside of regular business hours on a rota across the North American team.

Completing and leading others in meeting timelines and deadlines.

Staying current with relevant technology, especially emerging data platforms useful for tasks and projects.

Business Unit

North American Managed Services

This unit contributes to Orion Health's purpose of enabling client success by introducing and maintaining North American managed environments, policies and procedures in line with ITIL-aligned standards, and improving service management focus for North American customers.

Key Relationships

Internal : Support & Cloud Engineering Director, NA; Operations Service Desk Lead; Service Management; Privacy & Security team; Product owners; Developers; PSA teams

External : Customers, Suppliers / partners and Vendors

Essential Functions

Customer support and internal support & issue resolution

Daily monitoring, management, troubleshooting and issue resolution of database and non-database related infrastructure

Meeting client SLAs and internal OLAs related to data platforms and databases

Participate in project meetings and planning for customer migrations and implementations

Participate in on-call schedules for Operations support

Provide and share database expertise with internal Orion Health teams

Plan training and knowledge sharing to keep technical knowledge current

Plan and lead cross-training and knowledge transfer as necessary

Process improvement

Regular review, planning, and audit of SaaS database infrastructure

Maintain knowledge of the technology landscape

Behavioural and Technical Capabilities

Database Design and Implementation

Designing and building databases : Create database structures to store data based on user needs and business requirements.

Translating logical models into physical designs : Convert conceptual designs into actual database structures.

Collaborating with developers and architects : Work with team members to understand requirements and ensure the database meets needs.

Database Management and Maintenance

Managing database objects : Create, modify, and manage tables, indexes, and other database objects.

Monitoring database performance : Track performance metrics, identify bottlenecks, and optimize queries.

Backing up and restoring data : Implement backup and recovery strategies to prevent data loss.

Ensuring data availability : Ensure database availability for authorized users and minimize downtime.

Maintaining and updating databases : Apply patches, upgrades, and updates to keep software and systems running smoothly.

Data archiving : Move inactive or historical data to long-term storage.

Disaster recovery planning : Implement strategies to safeguard data and ensure availability in unforeseen circumstances.

Data Security

Managing access controls : Control who can access data and what they can see.

Implementing and improving security measures : Protect database from unauthorized access and threats.

Monitoring for security incidents : Track security events and respond to breaches or threats.

Other Responsibilities

Troubleshooting and resolving issues : Diagnose and fix database problems (e.g., performance, errors).

Providing support to users : Guide users on how to use the database and access data.

Capacity planning : Assess future data storage and processing needs.

Documentation and training : Create database documentation and train team members.

ETL : Manage extraction, transformation, and loading of data into the database.

Relevant Experience

Minimum of 5+ years experience in enterprise database support

Experience with physical, virtual and cloud environments

Hands-on experience implementing and supporting highly available, redundant DB solutions (RAC, AWS, etc.)

Strong analytical and problem-solving skills

Experience in implementing disaster recovery of data platforms

Experience in code migration, database change management and full data lifecycle management

Experience implementing and managing Oracle RDS and MS-SQL in AWS

Experience with Amazon S3

Experience with Apache Cassandra and non-SQL data platforms is a plus

Experience with automation, configuration management and orchestration; Infrastructure as code (Puppet, Chef, Ansible, Kubernetes, CloudFormation, Terraform, etc.) is required

Excellent communication and organization skills

Education and Qualifications

Technical certifications demonstrating database technology excellence are highly preferred (e.g., Microsoft SQL Server DBA, AWS Certified Database, Oracle DBA)

A Bachelor's Degree in an appropriate field is desired

#J-18808-Ljbffr