Staff Database Administrator - Calgary, Canada - CLIO

    CLIO
    Default job background
    Description

    What your team does:

    Clio is looking for a Staff Database Administrator to join the team that builds and manages our MySQL databases and related systems.

    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 Clios 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:

  • Youll be responsible for preparing Clios 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
  • You will use your experience to guide development teams on how to improve and optimize their use of the databases;
  • You will scope, define, and collaborate with developers to implement automation and processes that power reliability of Clios datastores;
  • 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
  • Experience using ProxySQL and the percona toolkit
  • Be prepared to work with and develop the MySQL knowledge to rest of the SRE team
  • A portfolio of successful projects (as well as a collection of lessons learned from failed projects).
  • Dont 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.

    Serious bonus points if you have:

  • Experience using migrations tools, pt-online-schema-change or gh-ost
  • Experience managing hosts with Puppet.
  • Experience working with Docker and Kubernetes.
  • Experience developing with Ruby or GoLang.
  • Experience managing AWS resources with CloudFormation or Terraform.
  • Experience scripting with BASH.
  • What you will find here:

    Compensation is one of the main components of Clios 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 acknowledgement at 3, 5, 7, and 10 years​
  • The expected salary range* for this role is $158,400 to $237,600 CAD. Please note there are a separate set of salary bands for other regions based on local currency.

    *Our salary bands are designed to reflect the range of skills and experience needed for the position and to allow room for growth at Clio. For experienced individuals, we typically hire at or around the midpoint of the band. The top portion of the salary band is reserved for employees who demonstrate sustained high performance and impact at Clio. Those who are new to the role may join below the midpoint and develop their skills over time. The final offer amount for this role will be dependent on geographical region, applicable experience, and skillset of the candidate.