Key Responsibilities

- Manage and administer PostgreSQL / Aurora PostgreSQL production databases.
- Manage MongoDB operational databases including replication, indexing, backup, and performance tuning.
- Manage Redis environments used for caching, session storage, low-latency reads, and application performance.
- Monitor database health, CPU, memory, storage, connections, locks, slow queries, replication lag, and capacity.
- Perform backup, restore, PITR, replication, failover, and DR readiness activities.
- Tune SQL queries, indexes, partitions, vacuum, statistics, connection pools, and PostgreSQL configuration.
- Tune MongoDB indexes, query patterns, document growth, replica sets, and storage usage.
- Support Redis key design, TTL strategy, memory usage, eviction policy, persistence, replication, and failover.
- Manage users, roles, privileges, access control, encryption, audit logging, and security hardening.
- Troubleshoot production issues including slow queries, blocking, deadlocks, connection spikes, storage growth, replication lag, and failover issues.
- Support application releases,



database changes, migrations, patches, upgrades, and rollback planning.
- Create DBA runbooks, monitoring dashboards, alerts, and operational SOPs.

Required Skills

- Strong PostgreSQL administration and performance tuning experience.
- Good experience with MongoDB administration and query optimization.
- Good understanding of Redis operations, memory management, persistence, replication, and cache patterns.
- Strong knowledge of backup, restore, replication, HA, DR, monitoring, security, and access management.
- Valuable understanding of Linux, storage, networking, shell scripting, automation, and production support.
- Experience with pgBouncer, RDS/Aurora, MongoDB replica sets, Redis Sentinel/Cluster, Grafana, Prometheus, CloudWatch, or similar tools.

Experience

- 610 years of DBA experience.
- Strong hands-on production experience with PostgreSQL.
- MongoDB and Redis experience preferred for application/platform workloads.

📌 Transactional DBA (Mumbai)
🏢 Uberlife Consulting
📍 Mumbai