Postgresql DBA

TENARAI TECHNOLOGIES PRIVATE LIMITED; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

TENARAI TECHNOLOGIES PRIVATE LIMITED is seeking an experienced Senior Database Administrator with deep PostgreSQL and MongoDB expertise. You will own database administration, performance tuning, troubleshooting, and delivery support across our infrastructure.

Provision, configure, and manage PostgreSQL and MongoDB instances across development, staging, and production environments. Conduct health checks, capacity planning, and backups, while managing users, roles, permissions, and access

Qualifications

• Experience in PostgreSQL and MongoDB administration.
• Ability to monitor and optimize database performance.
• Experience with backup and recovery strategies.

Responsibilities

• Provision, configure, and manage PostgreSQL and MongoDB instances across development, staging, and production.
• Perform routine health checks, monitoring, and capacity planning.
• Manage users, roles, permissions, and access control.
• Analyze slow queries and bottlenecks; tune settings.
• Design and automate backup strategies and restore tests.

Skills

Database Administration

Performance Tuning

Troubleshooting

Delivery Support

Tools

PostgreSQL

MongoDB

Job description

We are looking for an experienced Senior Database Administrator with deep expertise in PostgreSQL and MongoDB. The ideal candidate will take ownership of database administration, performance tuning, troubleshooting, and delivery support across our infrastructure.

Provision, configure, and manage PostgreSQL and MongoDB instances across development, staging, and production environments

• Perform routine health checks, instance monitoring, and capacity planning
• Manage user accounts, roles, permissions, and access control policies
• Handle database creation, cloning, schema migrations, and version upgrades
• Analyze slow queries, execution plans, and query patterns to identify bottlenecks
• Tune PostgreSQL settings (shared_buffers, work_mem, effective_cache_size, checkpoint, WAL, etc.)
• Optimize MongoDB queries, index usage, and write concern configurations
• Design and automate backup strategies (full, incremental, WAL-based, continuous archiving)
• Manage MongoDB backups (mongodump, file system snapshots, cloud snapshots)
• Conduct regular restore drills to validate backup integrity and recovery timelines