Staff Software Developer, Databases
About the positionResponsibilities• Prepare Clio's database infrastructure for the future in terms of scale and reliability• Collaboratively define the roadmap to support business goals and satisfy application requirements• Investigate and solve performance problems with MySQL databases• Transition, maintain, and modernize our database infrastructure, ensuring performance, reliability, and scalability• Guide development teams on how to improve and optimize database queries, integrate best practices for schema design and migration• 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• Spread database knowledge to your team• Elevate and educate our engineering processes within ClioRequirements• 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• 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)Nice-to-haves• Equally energized by both your own technical work as well as contributing to the career growth of your team• Strong opinions that are weakly held, fostering that same attitude in others• 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• Believe in providing honest, actionable feedback to your team, and encourage your team to reciprocate• Devise roadmaps to guide the future of our datastores infrastructure in terms of scale and data securityBenefits• 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 acknowledgement at 3, 5, 7, and 10 years Apply tot his job