Database Reliability Engineer

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 r 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.

Success in this Role looks like…

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

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

Optimisation of all manual effort by exploiting automation via service-based platforms i.e. AWS Oracle™ RDS, AWS Microsoft SQL Server™ RDS, AWS PostgreSQL RDS & managed Apache Cassandra™

Optimally 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 ensuring deadlines are met

Keeping current with relevant aspects of technology, especially emerging data platforms that may be useful in dealing with 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 improve service management focus on all elements of support for North American customers.

Key Relationships

Internal

Support & Cloud Engineering Director, NA, Operations Service Desk Lead, Service Management, Privacy & Security team, Product owners, Developers, PSG teams

External

Customers, Suppliers / partners and Vendors

Essential Functions

Customer Support, internal support & issue resolution

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

Responsible for meeting client SLAs and internal OLAs relating to data platforms & databases

Participate in project meetings and planning for customer migrations and implementations

Participate in on-call schedules for Operations support

Support and supply all internal Orion Health teams with adequate database expertise

Plans training and knowledge sharing to ensure technical knowledge is shared and kept current

Plans & Leads cross training and / or knowledge transfer to colleagues as necessary

Process Improvement

Perform regular review, planning, 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 database designs into actual database structures.

Collaborating with developers and architects :

Work closely with other team members to understand requirements and ensure the database meets the needs.

Database Management and Maintenance

Managing database objects :

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

Monitoring database performance :

Track database performance metrics, identify bottlenecks, and optimize queries to improve efficiency.

Backing up and restoring data :

Implement backup and recovery strategies to prevent data loss in case of failures.

Ensuring data availability :

Make sure the database is available to authorized users and minimize downtime.

Maintaining and updating databases :

Apply patches, upgrades, and other updates to keep the database software and system running smoothly.

Data Archiving :

Moving inactive or historical data from production databases to a dedicated, long-term storage location.

Disaster Recovery Plan :

Implementing strategies and plans to safeguard data and ensure its availability in the event of unforeseen circumstances like hardware failures, cyberattacks, or natural disasters.

Data Security

Managing access controls :

Control who can access the database and what data they can see, ensuring data is secure and protected.

Implementing & Improve security measures :

Implement and improving various security measures to protect the database from unauthorized access, data breaches, and other threats.

Monitoring for security incidents :

Track security events and respond to any security breaches or threats.

Other Responsibilities

Troubleshooting and resolving issues :

Diagnose and fix problems with the database, such as slow performance or errors.

Providing support to users :

Offer guidance and support to users on how to use the database and access data.

Capacity planning :

Assess future data storage and processing needs to ensure the database can handle growing demands.

Documentation & Training :

Creating database documentation and train team members

Data extraction, transformation, and loading (ETL) :

Manage the process of extracting, transforming, and loading 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 through the various stages of the software development life cycle

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

Experience and Management of Amazon Simple Storage Service (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 and continuing education are highly preferred. Such as Microsoft SQL Server DBA, or AWS Certified Database, Oracle DBA.

A Bachelor’s Degree in an appropriate field is desired

#J-18808-Ljbffr