Senior Database Reliability Engineer (SQL)

Database Reliability Engineer (DBRE)

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

Qualification and skills:

• SQL Server experience preferred, MySQL, PostgreSQL nice to haves
• 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.
• 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

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!

It is the policy of PointClickCare to ensure equal employment opportunity without discrimination or harassment on the basis of race, religion, national origin, status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law. PointClickCare welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. Please contact View email address on click.appcast.io should you require any accommodations.

PointClickCare is committed to Information Security. By applying to this position, if hired, you commit to following our information security policies and procedures and making every effort to secure confidential and/or sensitive information.

136900 - 152100 CAD a year