Job Description
Company: Okta
Location: San Francisco, CA
Workplace Type: Hybrid
Employment Type: Full-time
Pay / Compensation: $160,000—$220,000 USD
About the Role
We are looking for a highly skilled Database Reliability Engineer (DBRE) with deep expertise in PostgreSQL at scale and solid experience with MySQL. You will design, operationalize, and optimize the data persistence layer for large-scale, mission-critical systems, focusing on building resilient data infrastructure.
What You’ll Do / Key Responsibilities
- Design, implement, and operate highly available PostgreSQL clusters (physical/logical replication, sharding, failover automation).
- Optimize query performance, indexing strategies, schema design, and storage engines for both PostgreSQL and MySQL.
- Develop automation for provisioning, configuration, backups, and failovers using tools like Terraform or Ansible.
- Lead response during database incidents, conducting root-cause analysis for performance regressions, replication lag, and bloat issues.
Requirements & Qualifications
- 4+ years of hands-on PostgreSQL experience in high-volume, distributed production environments.
- Strong knowledge of PostgreSQL internals (WAL, MVCC, vacuum tuning, logical replication).
- Production experience with MySQL (InnoDB internals, replication, performance tuning).
- Advanced SQL and strong understanding of schema design and query optimization.
- Hands-on experience with cloud environments (AWS or GCP).
Preferred / Bonus Qualifications (if applicable)
- Experience with PgBouncer or HAProxy for connection pooling/load-balancing.
- Exposure to event streaming (Kafka, Debezium) and change data capture.
- Contributions to the open-source PostgreSQL ecosystem.
Benefits & Perks (if applicable)
- Health, dental and vision insurance
- 401(k)
- Flexible spending account
- Paid leave (including PTO and parental leave)
Okta is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, ancestry, marital status, age, physical or mental disability, or status as a protected veteran.