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