Senior Software Developer, Databases

We're looking for a Senior Software Developer, Databases to join our Systems Engineering, Production team. This role is for someone with deep expertise in MySQL, passionate about building robust, scalable database systems, and eager to tackle innovative challenges. As a key player, you'll focus on optimizing, maintaining, and evolving our MySQL infrastructure to support high-performance, mission-critical applications. This is a unique opportunity to be exposed to diverse technologies and make a measurable impact.

This role is available to candidates across Canada (excluding Quebec). If you are local to one of our hubs (Burnaby, Calgary, or Toronto) you will be expected to be in office minimum two days per week for our Anchor Days.

MySQL expertise and backend development experience is REQUIRED.

What Your Team Does:

• We build, secure, and maintain the infrastructure and critical services that power Clio's core applications.
• We help Clions make data-driven decisions by providing observability and transparency for all of our environments.
• We collaborate with the Clio product development teams to build tools that improve workflows and remove manual labor or friction points.

What You'll Work On:

• You'll be responsible for preparing Clio's database infrastructure for the future in terms of scale and reliability.
• You will collaboratively define the roadmap to support business goals, and satisfy application requirements.
• You will investigate and solve performance problems with our MySQL databases and other data stores.
• You will use your experience to guide development teams on how to improve and optimize their use of the databases.
• You will scope, define, and collaborate with developers to implement automation and processes that power reliability of Clio's datastores.
• You will work with the SRE team and help develop their MySQL knowledge.

What You Should Have:

• Backend development experience.
• MySQL expertise.
• Experience investigating and solving performance problems.
• The ability to optimize query performance.
• A portfolio of successful projects (as well as a collection of lessons learned from failed projects).

Who You Are:

• You are equally energized by both your own technical work as well as contributing to the career growth of your team.
• You have strong opinions that are weakly held, and foster that same attitude in others.
• You challenge and enable your team to take initiative, explore, and implement new improvements while balancing that work against satisfying the requirements as defined by the business.
• You believe in providing honest, actionable feedback to your team, and encourage your team to reciprocate.
• You devise roadmaps to guide the future of our datastores infrastructure in terms of scale and data security.

Don't have all of those? The most important part of this job is that you approach new challenges with curiosity and a drive to apply what you learn to fixing root causes, not just symptoms. Deep curiosity and a desire to learn will help you succeed in this job, combined with a drive to help others by shipping code.

Serious bonus points if you have:

• Experience using migrations tools, pt-online-schema-change or gh-ost.
• Experience managing hosts with Puppet.
• Experience working with Docker and Kubernetes.
• Experience developing with Ruby or GoLang.
• Experience managing AWS resources with CloudFormation, Terraform and Ansible.
• Experience scripting with BASH.
• Experience using ProxySQL and the Percona toolkit.

What you will find here:

Compensation is one of the main components of Clio's Total Rewards Program. We have developed a series of programs and processes to ensure we are creating fair and competitive pay practices that form the foundation of our human and high-performing culture.

Some highlights of our Total Rewards program include:

• Competitive, equitable salary with top-tier health benefits, dental, and vision insurance.
• Hybrid work environment, with expectation for local Clions (Vancouver, Calgary, Toronto, and Dublin) to be in office minimum 2 days per week on our Anchor Days.
• Flexible time off policy, with an encouraged 20 days off per year.
• RRSP matching and RESP contribution.
• Clioversary recognition program with special acknowledgement at 3, 5, 7, and 10 years.

Clio is more than just a tech company - we are a global leader that is transforming the legal experience for all by bettering the lives of legal professionals while increasing access to justice.

Summary:

We're looking for a Senior Software Developer, Databases to join our Systems Engineering, Production team. This role is for someone with deep expertise in MySQL, passionate about building robust, scalable database systems, and eager to tackle innovative challenges. As a key player, you'll focus on optimizing, maintaining, and evolving our MySQL infrastructure to support high-performance, mission-critical applications. This is a unique opportunity to be exposed to diverse technologies and make a measurable impact.

This role is available to candidates across Canada (excluding Quebec). If you are local to one of our hubs (Burnaby, Calgary, or Toronto) you will be expected to be in office minimum two days per week for our Anchor Days.

MySQL expertise and backend development experience is REQUIRED.

What Your Team Does:

• We build, secure, and maintain the infrastructure and critical services that power Clio's core applications.
• We help Clions make data-driven decisions by providing observability and transparency for all of our environments.
• We collaborate with the Clio product development teams to build tools that improve workflows and remove manual labor or friction points.

What You'll Work On:

• You'll be responsible for preparing Clio's database infrastructure for the future in terms of scale and reliability.
• You will collaboratively define the roadmap to support business goals, and satisfy application requirements.
• You will investigate and solve performance problems with our MySQL databases and other data stores.
• You will use your experience to guide development teams on how to improve and optimize their use of the databases.
• You will scope, define, and collaborate with developers to implement automation and processes that power reliability of Clio's datastores.
• You will work with the SRE team and help develop their MySQL knowledge.

What You Should Have:

• Backend development experience.
• MySQL expertise.
• Experience investigating and solving performance problems.
• The ability to optimize query performance.
• A portfolio of successful projects (as well as a collection of lessons learned from failed projects).

Who You Are:

• You are equally energized by both your own technical work as well as contributing to the career growth of your team.
• You have strong opinions that are weakly held, and foster that same attitude in others.
• You challenge and enable your team to take initiative, explore, and implement new improvements while balancing that work against satisfying the requirements as defined by the business.
• You believe in providing honest, actionable feedback to your team, and encourage your team to reciprocate.
• You devise roadmaps to guide the future of our datastores infrastructure in terms of scale and data security.

Don't have all of those? The most important part of this job is that you approach new challenges with curiosity and a drive to apply what you learn to fixing root causes, not just symptoms. Deep curiosity and a desire to learn will help you succeed in this job, combined with a drive to help others by shipping code.

Serious bonus points if you have:

• Experience using migrations tools, pt-online-schema-change or gh-ost.
• Experience managing hosts with Puppet.
• Experience working with Docker and Kubernetes.
• Experience developing with Ruby or GoLang.
• Experience managing AWS resources with CloudFormation, Terraform and Ansible.
• Experience scripting with BASH.
• Experience using ProxySQL and the Percona toolkit.

What you will find here:

Compensation is one of the main components of Clio's Total Rewards Program. We have developed a series of programs and processes to ensure we are creating fair and competitive pay practices that form the foundation of our human and high-performing culture.

Some highlights of our Total Rewards program include:

• Competitive, equitable salary with top-tier health benefits, dental, and vision insurance.
• Hybrid work environment, with expectation for local Clions (Vancouver, Calgary, Toronto, and Dublin) to be in office minimum 2 days per week on our Anchor Days.
• Flexible time off policy, with an encouraged 20 days off per year.
• RRSP matching and RESP contribution.
• Clioversary recognition program with special acknowledgement at 3, 5, 7, and 10 years.

Clio is more than just a tech company - we are a global leader that is transforming the legal experience for all by bettering the lives of legal professionals while increasing access to justice.