PointClickCare is a leading health tech company dedicated to enhancing healthcare through innovation and technology. The Senior Database Reliability Engineer (SQL) is responsible for managing and optimizing the cloud-based database infrastructure for their SaaS applications, while collaborating with engineering and SRE teams to improve processes and support new product launches.
Responsibilities:
- Managing, building, maintaining, monitoring, and troubleshooting the cloud-based database infrastructure
- Improving processes via automation/coding to reduce toil
- Liaising with engineering and SRE teams to aid in bringing new products to market that require database support
- Working on observability of relevant database metrics and ensuring desired database objectives are met
- Collaborating with the DBA team to understand areas of toil
- Implementing automations/processes to help manage PCC's database systems at scale
- Implementing a data-driven approach to performance and availability improvements to stakeholder database systems
- Providing database expertise to engineering and SRE teams (review of database migrations, queries, performance optimizations, standardizing configurations and deployments of new database systems)
- Assisting the 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
- Experience working with VLDBs (1+ TB) and managing a large number of databases (100+)
- Languages such as Powershell, C#, SQL, Python
- SQL Server experience preferred, MySQL, PostgreSQL nice to haves
- Additional experience with the following tools\systems a plus: Git, Jira, Azure Data Factory, DataBricks, Grafana, InfluxDB and flavors of NoSQL databases