Staff Software Developer, Databases

About the position Responsibilities • 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 Clio Requirements • 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 security Benefits • 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 Apply To this Job