PointClickCare is a leading health tech company focused on delivering exceptional care through innovative solutions. The Senior Database Reliability Engineer will manage and optimize the cloud-based database infrastructure for their SaaS application, working closely with engineering and SRE teams to enhance performance and availability.
Responsibilities:
- 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 expertise 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
Requirements:
- 7+ Years working with relational databases systems (3+ at a Senior, lead or architect level)
- 2+ years in a DBRE or SRE role
- Experience working in the cloud (AWS, GCP or Azure)
- 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
- Some on-call or after-hours work will be required
- Additional experience with the following tools\systems a plus: Git, Jira, Azure Data Factory, DataBricks, Grafana, InfluxDB and flavors of NoSQL databases