1 day ago
Toronto, CanadaSenior
Responsibilities
- Own the production performance and reliability of PostgreSQL, OpenSearch, and Redis.
- Diagnose and resolve lock contention, connection pooling limits, slow queries, and job fan-out under load.
- Lead capacity planning and load testing for web services.
- Set standards for schema changes, migrations, indexing, and query patterns, including automated checks.
- Review data-heavy product changes and teach effective datastore patterns.
- Build dashboards, runbooks, and alerts for datastore incident diagnosis.
- Partner with Infrastructure on multi-region data replication and recovery.
- Share platform on-call responsibility and improve datastore knowledge across the engineering team.
Requirements
- 5+ years building and running production systems, with significant experience in datastore performance and reliability.
- Experience supporting multi-tenant systems at scale, including tenant isolation and noisy-neighbor protection.
- Deep knowledge of PostgreSQL internals, including locking, MVCC, query plans, indexing, vacuum, and connection pooling.
- Experience running OpenSearch or Elasticsearch at scale.
- Experience with capacity planning and load testing for web services.
- Ability to solve systemic problems and leave behind reusable tools and documentation.
- Ability to write production-grade software and work comfortably in an application codebase.
- Preferred experience with Rails, ActiveRecord, and Sidekiq at scale.
- Preferred experience using Redis as a queue and cache under heavy load.
- Preferred experience with cross-region replication, database failover, Kafka, or DynamoDB.
- Degrees and big-name company experience are not required.
Benefits
- Competitive compensation and early equity in a venture-backed company.
- Comprehensive medical, dental, and vision coverage.
- Three weeks of vacation, unlimited sick and mental health days, and a company-wide end-of-year shutdown.
- $500 home-office setup stipend.
- Unlimited token usage and access to AI tools.
- High-impact environment with direct influence on company direction.
- Accommodations are available on request during the recruitment process.
Tech Stack
About Rootly
Rootly builds an AI-native incident management platform for SRE and DevOps teams, integrated with Slack and Microsoft Teams to coordinate on-call response, resolution, and retrospectives. It sells B2B SaaS subscriptions used by companies such as NVIDIA, Figma, Canva, and Squarespace. The privately held company is headquartered in Toronto and raised a $15.2M Series A in 2023.