Tech Stack

Description

You will design, operationalize, and optimize the data persistence layer powering Okta's large-scale, mission-critical systems. This hands-on engineering role focuses on building resilient data infrastructure, collaborating with SRE, Platform, and Engineering teams to ensure performance, reliability, and automation.

Requirements

• 4+ years hands-on PostgreSQL experience in high-volume production environments
• Strong knowledge of PostgreSQL internals: WAL, MVCC, vacuum tuning, query planner, indexing, logical replication
• Production experience with MySQL (InnoDB, replication, performance tuning)
• Experience building automation with Go or Python
• Experience with monitoring tools like Prometheus, Grafana, Datadog

Responsibilities

• Design and operate highly available PostgreSQL clusters with physical/logical replication, sharding, and failover automation
• Optimize query performance, indexing strategies, schema design, and storage engines
• Perform capacity planning, growth forecasting, and workload modeling
• Develop automation for provisioning, configuration, backups, failovers, vacuum tuning, and schema management using Terraform, Ansible, or Kubernetes Operators
• Lead incident response for database issues and conduct root-cause analysis