Staff Software Developer, Back End Infrastructure and Databases

Clio - Cloud-Based Legal Technology; Vancouver; Remote; CAD 158,000 - 198,000; Full time

Job summary

An established industry player in legal technology is seeking a Staff Software Developer to enhance back-end infrastructure and databases. This role offers the opportunity to tackle complex performance and scalability challenges while collaborating with a talented team across Canada. As a pivotal member of the Systems Engineering team, you will drive improvements in database management and architecture, ensuring reliability and high performance. This innovative firm values curiosity and the pursuit of knowledge, making it an exciting place for those looking to make a meaningful impact in the legal sector. Join a mission-driven team dedicated to transforming the legal experience for all.

Benefits

Competitive salary

Top-tier health benefits

Dental and vision insurance

Flexible time off policy

$2000 annual counseling benefit

RRSP matching

Clioversary recognition program

Qualifications

• Hands-on expertise in MySQL database management and performance troubleshooting.
• Solid understanding of database design and optimization techniques.

Responsibilities

• Prepare and modernize Clio's database infrastructure for scalability.
• Investigate and solve performance issues with MySQL databases.
• Collaborate with developers to implement automation for reliability.

Skills

MySQL database management

SQL optimization techniques

Database design

Data modeling

Schema management

Performance problem solving

Cloud environment configuration

Education

Bachelor's degree in Computer Science or related field

Tools

ProxySQL

Percona toolkit

Job description

Staff Software Developer, Back End Infrastructure and Databases

Apply locations Remote - USA Toronto Calgary Vancouver time type Full time posted on Posted 30 Days Ago job requisition id BF-REQ-2417

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 Staff Software Developer, Back End Infrastructure and 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.

The Staff Software Developer will be responsible for discovering, triaging, and solving difficult performance and scalability problems in Clio's core applications and databases. They will primarily be iterating and evolving our infrastructure, data schema, application code, and products in order to solve complicated scalability issues with a goal of achieving high performance, high scalability, and exceptional reliability. By engaging across the organization, you'll help drive our current and future architecture and teach our engineering teams how to implement scalable patterns, particularly at the RDBMS layer.

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.

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 the rest of the SRE team.
• A portfolio of successful projects (as well as a collection of lessons learned from failed projects).

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.

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 min. once per week on our Anchor Day.
• Flexible time off policy, with an encouraged 20 days off per year.
• $2000 annual counseling benefit.
• RRSP matching and RESP contribution.
• Clioversary recognition program with special acknowledgment at 3, 5, 7, and 10 years.

The full salary range for this role is $158,400 to $198,000 to $237,600 CAD. Please note there are a separate set of salary bands for other regions based on local currency.

We aim to hire all candidates between the minimum and the midpoint of the full salary range. We reserve the midpoint to the maximum of the salary band for internal employees who demonstrate sustained high performance and impact at Clio. The final offer amount for this role will be dependent on individual experience and skillset of the candidate. Please note there are a separate set of salary bands for other regions based on local currency.

Diversity, Inclusion, Belonging and Equity (DIBE) & Accessibility

Our team shows up as their authentic selves, and are united by our mission. We are dedicated to diversity, equity and inclusion. We pride ourselves in building and fostering an environment where our teams feel included, valued, and enabled to do the best work of their careers, wherever they choose to log in from. We believe that different perspectives, skills, backgrounds, and experiences result in higher-performing teams and better innovation. We are committed to equal employment and we encourage candidates from all backgrounds to apply.

Clio provides accessibility accommodations during the recruitment process. Should you require any accommodation, please let us know and we will work with you to meet your needs.

Learn more about our culture at clio.com/careers.

At Clio, we are on a mission to transform the legal experience for all. As the world's leading provider of cloud-based legal software, we provide lawyers with low-barrier, affordable solutions to manage and grow their firms more effectively, more profitably, and with better client experiences. Through the cloud, we believe that we can help create a more inclusive legal community and a more equitable legal system.

This is a historic moment in the growth of legal technology! As the first legal practice management unicorn globally, and one of only a handful of Canadian unicorns, this is only the beginning.

If you’ve ever wanted to do the best work of your career, while having a meaningful impact in the lives of others, then Clio is the place for you.