Staff Software Developer, Databases

SummaryWe’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 and the US. If you are local to one of our hubs (Burnaby, Calgary, or Toronto) you will be expected to be in office minimum twice per week on one of our Anchor Days.What you’ll work onDiscover, triage, and solve 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 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.You will prepare 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, and to 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.What you may haveYou are energized by both your own technical work and contributing to the career growth of your team.You have strong opinions that are weakly held, and foster that attitude in others.You challenge and enable your team to take initiative, explore, and implement new improvements while balancing that work with business requirements.You believe in providing honest, actionable feedback to your team, and encourage reciprocal feedback.You devise roadmaps to guide the future of our datastores infrastructure in terms of scale and data security.What you should haveHands-on technical expertise with building and configuring MySQL database servers; Bonus points for cloud environments.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 for the rest of the SRE team.A keen interest in improving your craft by using AI.A portfolio of successful projects (and 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, combined with a drive to help others by shipping code.What you will find hereCompensation 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 includeCompetitive, equitable salary with top-tier health benefits, dental, and vision insuranceHybrid work environment, with expectation for local Clions (Vancouver, Calgary, Toronto, and Dublin) to be in office minimum 2 days per week on Anchor DaysFlexible time off policy, with an encouraged 20 days off per year$2000 annual counseling benefitRRSP matching and RESP contributionClioversary recognition program with acknowledgement at 3, 5, 7, and 10 yearsThe full salary range for this role is $171,400 to $214,300 to $257,200 CAD. Salary bands may differ based on location and local currency. Additionally, benefit offerings may differ by location. The final offer amount depends on experience and skillset. There are separate salary bands for other regions based on local currency.Diversity, Inclusion, Belonging and Equity (DIBE) & AccessibilityWe are committed to diversity, equity and inclusion. We encourage candidates from all backgrounds to apply. Clio provides accessibility accommodations during the recruitment process; please let us know if you require any accommodation.Learn more about our culture at clio.com/careersDisclaimer: We only communicate with candidates through official @clio.com email addresses.ApplyIn-house performance coach, Katie, helps Clions accelerate their career development.At Clio, we’re creating a human and high performing culture. Find out what keeps us grounded. Learn more. #J-18808-Ljbffr