Job Description
Remote $117,300 - $126,100
PointClickCare is a leading North American healthcare technology platform enabling meaningful care collaboration and real‐time patient insights. For over 20 years, the company has been focused on realizing its vision: to help create a world in which providers and plans can confidently deliver frictionless care. Since its inception, PointClickCare has grown exponentially, with over 2,200 employees working to impact millions across North America. Recognized by Forbes as one of the top 100 private cloud companies and acknowledged by Waterstone Human Capital as Canada’s Most Admired Corporate Cultures, PointClickCare leads the way in creating cloud-based healthcare software.
At PointClickCare, we offer a wealth of opportunities and a vibrant culture that empowers our employees. Our dynamic environment is the perfect place to advance your career while engaging in meaningful work alongside incredible colleagues. Here, you’ll discover a space where your talents can thrive, your career can grow, and your work will have a lasting impact on healthcare across North America. We believe that work becomes profoundly fulfilling when driven by a higher purpose.
Join us and be part of a team that is making a real impact.
Job summary:
The Database Reliability Engineer (DBRE) is responsible for managing, building, maintaining, monitoring, and troubleshooting the cloud-based database infrastructure that our mission critical SaaS application runs on.
The DBRE role is also responsible for improving processes via automation\coding to reduce toil. They will be liaising with engineering and SRE teams to aid in bringing new products to market that require database support.
•Work on observability of relevant database metrics and make sure desired database objectives are met.
•Work with DBA team to understand areas of toil. Implement automations\processes to help manage PCC's database systems at scale.
•Implement a data-driven approach to performance and availability improvements to stakeholder database systems
•Provide database support to engineering and SRE teams (review of database migrations, queries, performance optimizations, standardize configurations and deployments of new database systems).
•Assist DBA team in performance troubleshooting and root cause analysis
Qualification and skills:
•3+ Years working with relational databases systems
•1+ years in a DBRE or SRE role
•Experience working in the cloud (AWS, GCP or Azure) Azure preferred
•Coding \ Automation Experience
•Experience working with IaC tools such as Ansible, Terraform.
•Experience working with source control such as GIT.
•SQL Server experience preferred, MySQL, PostgreSQL nice to haves
•Experience working with VLDBs (1+ TB) and managing a large number of databases (100+)
•Languages such as Powershell, C#, SQL, Python
Additional experience with the following tools\systems a plus: Git, Jira, Azure Data Factory, DataBricks, Grafana, InfluxDB and flavors of NoSQL databases.
**Some on-call or after-hours work will be required