Travel to Office expectationsFor Remote Roles: If this role is remote, there will be in-office events that will require travel to and from the Mississauga and/or Salt Lake City office. These will include, but not limited to, onboarding, team events, semi-annual and annual team meetings.
For Hybrid Roles: If this role is Hybrid, there will be an expectation to reside within commutable distance to the office/location specified in the job listing. This will include, but not limited to, weekly/bi-weekly/monthly events in the office with your specific team. This is a requirement for this role.
Job SummaryThe 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 through automation and coding to reduce toil. They will work closely with Engineering and SRE teams to support new products that require database support.
Key Responsibilities- Work on observability of relevant database metrics and make sure desired database objectives are met.
- Work with the DBA team to understand areas of operational toil and implement automations/processes to help manage PCC's database systems at scale.
- Implement a data-driven approach to performance and availability improvements across database platforms.
- Provide database support to Engineering and SRE teams, including database migrations, query performance, and schema/design improvements.
- Work on database operational workload, performance troubleshooting and root-cause analysis.
- Help standardize database configurations, deployment patterns, and operational processes across SQL Server and PostgreSQL platforms.
- Manage and prioritize operational tickets, incidents, service requests, and database maintenance activities.
Qualifications and Skills- 3+ years of experience working with relational database systems.
- 1+ year working in a Database / SRE / Engineering-related role-• SQL Server or PostgreSQL experience preferred, other DBMS is nice to haves
- Hands-on experience with SQL Server or PostgreSQL administration, performance tuning, replication, high availability, and disaster recovery.
- Experience working in the cloud (AWS, GCP, or Azure - Azure preferred).
- Experience working with IaC tools such as Ansible and Terraform.
- Coding / Automation experience with languages such as PowerShell, C#, SQL, Python, and Go.
- Experience working with source control systems such as Git.
- Experience working with large databases (1+ TB) and managing large database environments is a plus.
- Additional experience with the following tools/systems is a plus: Jira, confluence, Grafana, ClickHouse, and various NoSQL databases.
- Experience working with AI tools, technologies, or AI-assisted development and automation is a plus.
- University or college education in Database Management, Software Engineering, or a related field.
- Some on-call or after-hours work will be required.
$103,400 - $129,300 a year
At PointClickCare, base salary is one of the many components that make up our total rewards package. The CAD base salary range for this position is $103,400-129,300+ bonus + equity + benefits. Our salary ranges are determined by job and level. The range displayed on each job posting reflects the target for new hire salaries for the position across all CAD locations. Within the range, individual compensation is determined by job-related skills and knowledge, relevant experience including professional and lived experience, and/or work location. Your recruiter can share more information about our total rewards package during the hiring process.
#AJ1
#Remote
PointClickCare Benefits & Perks:Benefits starting from Day 1!
Retirement Plan Matching
Flexible Paid Time Off
Wellness Support Programs and Resources
Parental & Caregiver Leaves
Fertility & Adoption Support
Continuous Development Support Program
Employee Assistance Program
Allyship and Inclusion Communities
Employee Recognition ... and more!
