Who you are

• MySQL experience is a requirement in this role
• 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
• An appetite to work with and develop the MySQL knowledge to rest of the SRE team
• A keen interest in improving your craft by using AI
• A portfolio of successful projects (as well as a collection of lessons learned from failed projects)
• 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 the job involves

• 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
• The Staff Software Developer, Databases 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 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
• 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 with your team
• Elevate and enhance our engineering processes within Clio

Benefits

• Company equity
• 401k
• $500 contribution when you become a parent and/or guardian
• RRSP-matching
• Pension plans
• 4-week minimum vacation
• Work from home when you need to (role-specific)
• Parental leave options for moms and dads
• Customizable extended health benefits (including $2000 per year to spend on counseling)
• Wellness programs including an onsite naturopath physiotherapist, and RMT (location-dependent), healthy snacks, and exercise classes