Clio - Staff Software Developer, Databases

​What you may have:

• 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

What you should have:

• Hands-on technical expertise with building and configuring MySQL database servers; Bonus points for understanding how to do this in a cloud environment
• Experience investigating and solving performance problems with MySQL databases
• Solid understanding of database design, data modeling, and schema management.
• Familiarity with SQL optimization techniques and best practices.
• Experience using ProxySQL and the percona toolkit
• Be prepared to work with and develop the MySQL knowledge to rest of the SRE team
• A portfolio of successful projects (as well as a collection of lessons learned from failed projects)

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.

We’re looking for a Staff Software Developer, Databases to join our Systems Engineering, Production team. This role is for someone who is passionate about building innovative solutions and being exposed to new challenges and technologies while making an impact. This role is available to candidates across Canada.

What your team does:

Clio is looking for a Staff Software Developer, Databases to join the team that builds and manages our MySQL databases and related systems.

We're building a cross-Canada, distributed team that forms the foundation of Clio's engineering organization:

• 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 labour 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
• Work on transitioning, maintaining, and modernizing our database infrastructure, ensuring performance, reliability, and scalability
• You will use your experience to guide development teams on how to improve and optimize database queries, integrate best practices for schema design and migration
• You will scope, define, and collaborate with developers to implement automation and processes that power reliability of Clio’s datastores;
• Participate in architectural discussions to help shape the future direction of our backend services.
• You'll raise the bar by spreading database knowledge to your team
• Elevate and educate our engineering processes within Clio