> Markdown version of [/jobs/ext/4032761-senior-platform-engineer-datastores](https://www.wearedevelopers.com/jobs/ext/4032761-senior-platform-engineer-datastores). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Platform Engineer, Datastores

- **Company:** ROOTLY, INC.
- **Location:** San Francisco, CA, United States (Remote available)
- **Experience:** Expert
- **Contract:** Temporary contract
- **Skills:** OpenTofu, Amazon Web Services, Databases, Data Stores, Software Debugging, Amazon DynamoDB, Elasticsearch, PostgreSQL, Load Testing, Ruby on Rails, Redis, Web Services, Datadog, AWS Lambda, Indexer, Backend, Apache Kafka, Database Replication, Front End Software Development, Terraform, OpenSearch
- **Published:** October 30, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=73a0cdc380661aa9

## About the Role

* 5+ years building and running production systems, with significant time on datastore performance and reliability.
 * Experience supporting multi-tenant systems at scale, including tenant isolation, noisy-neighbour protection, and keeping one customer's traffic spike from degrading service for everyone else.
 * Deep knowledge of PostgreSQL internals: 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.
 * You fix the class of problem, not the instance, and leave behind tools and docs others use.
 * You write production-grade software, and you're comfortable working in an application codebase, not only in the database., * Experience with Rails, ActiveRecord, and Sidekiq at scale.
 * Experience with Redis as a queue and cache under heavy load.
 * Experience with cross-region replication and database failover.
 * Experience with Kafka or DynamoDB.

## Description

As a Senior Platform Engineer focused on datastores, you'll be the team's expert on PostgreSQL, OpenSearch, Kafka, and Redis. You'll find and fix the locking, pooling, and query problems that can slow Rootly down under load, and you'll raise the whole engineering team's depth through pairing, reviews, and runbooks rather than owning the datastores alone.
Like everyone on Platform, you'll also share responsibility for the platform as a whole and take your turn on call. You'll work closely with our platform engineering leader, and with product engineers to shape how their features store and query data., * Own the performance and reliability of PostgreSQL, OpenSearch, and Redis in production.

 * Find and fix lock contention, connection pooling limits, slow queries, and job fan-out that degrade under load.
 * Lead capacity planning and load testing so we know our limits before a customer's worst day finds them.
 * Set standards for schema changes, migrations, indexing, and query patterns, and build checks that catch problems before they ship.
 * Review data-heavy changes from product teams and teach the patterns behind your feedback.
 * Build the dashboards, runbooks, and alerts that let any engineer debug a datastore incident.
 * Partner on multi-region data replication and recovery with the Infrastructure side of Platform., * Fixed the top locking, pooling, and slow-query issues behind our historical SEV0 incidents.
 * Established a load testing baseline and capacity plan, so we know our limits before customers find them.
 * Put schema change and migration standards in place, backed by automated checks.
 * Built dashboards, runbooks, and alerts that let any engineer on call debug a datastore incident.
 * Spread datastore depth across the team, so reliability doesn't depend on any one person., * Backend: Ruby on Rails, PostgreSQL, OpenSearch, Redis, Sidekiq, AWS Lambda, ECS, Kafka, DynamoDB
 * Frontend: Turbo, Stimulus, ViewComponents
 * Infrastructure: AWS, OpenTofu/Terraform (IaC), Datadog