The opportunity
Secure Every Identity, from AI to Human Identity is the key to unlocking the potential of AI. Okta secures AI by building the trusted, neutral infrastructure that enables organizations to safely embrace this new era.
What you'll do
Design, implement, and operate highly available PostgreSQL clusters (physical: replication, logical replication, sharding/partitioning, failover automation).
Optimize query performance, indexing strategies, schema design, and storage engines.
Perform capacity planning, growth forecasting, and workload modeling.
Own high-availability strategies including automatic failover,: multi-AZ/multi-region setups, and disaster recovery.
Develop automation for any and all tasks including but not limited to: provisioning, configuration, backups, failovers, vacuum tuning, and schema management using tools such as Terraform, Ansible, Kubernetes Operators, or custom tooling.
Build monitoring, alerting, and self-healing systems for PostgreSQL and MySQL.
What they're looking for
- Lead response during database incidents—performance regressions, replication: lag, deadlocks, bloat issues, storage failures, etc.
- Conduct root-cause analysis and implement permanent fixes.
- Partner with software engineers to review SQL, optimize schemas, and ensure: efficient use of PostgreSQL features.
- Provide guidance on database-related design patterns, migrations, version upgrades, and best practices.
