Senior Database Engineer

Jobber•Edmonton, AB

1d•Hybrid

About The Position

Jobber is seeking a Senior Database Engineer to join their Product Engineering team. This role focuses on developing software that addresses real-world problems for small businesses, aiming to help them succeed. The company culture is built on values of humility, support, and dedication, fostering a collaborative environment where teams have autonomy and contribute to the company's future. Jobber emphasizes releasing products frequently, managing technical debt, and using customer feedback to improve their offerings. They are committed to employee professional growth through extensive onboarding resources, tutorials, hackathons, mentorship opportunities, and empathetic leadership that promotes work-life harmony. The Product Engineering team is crucial to Jobber's success, creating software for tens of thousands of users globally. The McCloud team, specifically, ensures Jobber runs smoothly by building high-performance, highly available systems, optimizing resource usage, managing critical infrastructure with minimal downtime, and empowering developers. This role offers a chance to work on complex, high-impact systems central to Jobber's operations. Jobber encourages continuous learning and development through regular 1:1s, manager support, and a dedicated Learning and Development team.

Requirements

5 to 10 years administering databases such as Postgres, Oracle or MySQL, preferably in a cloud environment.
Understanding of Postgres internals and query analysis tools like explain plan.
Familiarity with DB performance monitoring tools like RDS Performance (Database) Insights.
Experience with Disaster Recovery / High Availability architectures.
Familiar with some “glue” languages (eg. Bash, Python, Ruby).

Nice To Haves

Familiarity with Infrastructure as Code, preferably Terraform
Familiarity with AWS technologies including: RDS Aurora, RDS Proxy and Database Migration Services or their non-AWS equivalents.
Understanding of caching technologies like Redis and Memcache
2-3 years development experience
Experience with Rails ActiveRecord
Experience with Terraform
Experience with ElasticSearch
Experience with AWS Redshift

Responsibilities

Build and maintain an industry-leading product that helps customers and their small businesses be successful.
Solve problems that millions of entrepreneurs are facing.
Ensure infrastructure remains available and responsive to customers.
Ensure the stability and scalability of Aurora Postgres databases.
Identify and fix issues such as cache optimization, query optimization, indexes, and IOPS.
Ensure appropriate monitoring and alerting are in place for database performance.
Proactively address issues and reactively understand what triggered an issue.
Collaborate with development teams on schema design and query optimization.
Perform refactoring, primarily through Rails ActiveRecord.
Conduct cost analysis and optimization of databases in the AWS cloud.