10 Aug
|
Virima
|
Bengaluru
Location: Bengaluru, Karnataka, India
Team: Platform / SRE • Experience: 5–8 years • Type: Full-time
Role Overview
Own the reliability, availability, performance, and security of our databases—PostgreSQL, MongoDB, and MySQL—running container-native, highly available on Kubernetes. You’ll design the architecture, automate operations, guide domain teams on optimal schema & query design, and lead backup/restore and disaster recovery (DR) with clear RPO/RTO objectives.
What You’ll Do
- Architecture & HA
- Design and operate HA clusters on Kubernetes (StatefulSets, PDBs, anti-affinity, topology spread, CSI storage, auto-failover).
- Choose and operate DB operators/distributions (e.g., Zalando/Crunchy for Postgres, Percona for MongoDB/MySQL or equivalents); maintain versioning/patching strategy.
- Implement multi-AZ replicas, read-replicas, and connection pooling/proxying (e.g., pgBouncer/HAProxy/Envoy) for scale.
- Performance & Scalability
- Capacity planning, sizing, and benchmarking; own p95/p99 latency and throughput KPIs.
- Query/index tuning,
VACUUM/ANALYZE/auto-analyze strategies (Postgres), sharding/replica-set tuning (MongoDB), and InnoDB/Group Replication tuning (MySQL).
- Data Modeling & Reviews
- Partner with domain teams on schema/design reviews, migration strategies (Flyway/Liquibase/Alembic), and query best practices to keep services rapid and cost-efficient.
- Backup, DR & Compliance
- Own backup/restore (base backups, PITR/WAL/GTID, snapshotting), tested DR runbooks, and RPO/RTO targets; run quarterly game days.
- Implement data retention, encryption (at rest & in transit), auditing, and access controls (RBAC/KMS/Secrets).
- Automation & CI/CD
- Everything-as-code: Helm/Terraform/Ansible for DB infra; GitOps pipelines for changes, safe rollout/rollback, and automated smoke checks.
Requirements
Minimum Qualifications
- 5–8 years as a DBA/DBRE with production experience in PostgreSQL plus MongoDB and MySQL (at least two in depth).
- Strong Kubernetes f
📌 Senior Database Administrator (Bengaluru)
🏢 Virima
📍 Bengaluru