Senior postgresql database engineer

To join our team. If you're excited to be part of a winning team, Cirrus Labs () is a great place to grow your career.
Experience: 5+ years
Location: Bangalore/Hyderabad
Shift Time: 3 PM - 12 AM IST
Duties and Responsibilities:
1) Produce clear scaling options (e.g. replicas + routing”, move to Aurora + N readers”, proxy + tune”, partition hot tables”) with tradeoffs, cost modeling, and risk, not only tuning the current box.
2) Performance: Profile workloads (pg_stat_statements, EXPLAIN ANALYZE, logs), tune queries and indexes, reduce lock contention and bloat, advise on connection pooling and transaction patterns.
3) Schema & migrations: Own database migration scripts – review DDL changes, migration risk, and rollout strategy; help design partitioning, constraints, and data lifecycle (archival, retention).
4) RDS / Aurora operations: Size instances, storage, and I/O; understand replication, failover, reader endpoints, RDS parameter groups, backups, PITR, major ...