There's a PostgreSQL Administrator opening at a company in Andheri East, Mumbai. It's a full-time, on-site role, paying INR 75,000 a month.
Skills you'll bring
PostgreSQL expertise is central to this role, backed by strong general SQL skills. You'll need real, hands-on experience with replication setups, backup and recovery procedures, and performance tuning, since these aren't things you can learn purely from documentation the week before an interview.
A few additional skills would help an application stand out:
- PostgreSQL certification or formal training
- Experience with high-availability tools such as Patroni or repmgr
- Familiarity with monitoring tools like pgBadger or pg_stat_statements
- Comfort managing a cloud-hosted PostgreSQL instance, such as AWS RDS or Azure Database for PostgreSQL
What you'd be doing
- Design and maintain database structures that support both current needs and reasonable future growth
- Optimize slow queries, working through execution plans to find where time is actually being spent
- Manage backup schedules and data security, keeping recovery procedures tested and current, not just set up once and forgotten
- Monitor database systems for reliability, catching warning signs before they become downtime
A recent problem worth mentioning: replication lag between primary and replica servers started climbing steadily overnight, and it turned out a long-running analytics query on the primary was holding a transaction open just long enough to delay WAL segment cleanup. Spotting it meant checking pg_stat_replication alongside the query logs rather than assuming a network or hardware issue. That kind of cross-checking is a normal part of keeping a PostgreSQL environment healthy.
Qualifications and experience
A bachelor's degree is required. The listing on Naukri Mitra notes that the hiring team places heavy weight on demonstrated command of database design, query optimization, and backup procedures in the interview process, more so than on the specific degree title. This role calls for 36 months of hands-on PostgreSQL administration experience.
Pay and benefits
The role pays INR 75,000 a month. Standard benefits include health insurance, paid time off, and provident fund contributions. Since the position is on-site in Andheri East, employees also have access to an on-site cafeteria and cab or commute support, which is especially useful given how much of Mumbai's workforce commutes long distances to reach this part of the city.
What the work is like
Most days move at a steady pace, tuning queries and reviewing monitoring dashboards, but database incidents don't wait for convenient timing. A production issue at 2 am still needs someone to look at it, and administrators on this team rotate through on-call coverage rather than any one person carrying it alone. People who stick with database administration long-term tend to say the problem-solving, tracing a slow query back to its actual root cause, is what keeps the work interesting after the basics become routine.
Applying
Send a resume that details specific PostgreSQL environments you've managed, including database size, replication setup, and any performance issues you've diagnosed and fixed. If you've built or maintained a disaster recovery process, explain how it's structured and how often it's tested. Shortlisted candidates will work through a real query optimization scenario during the technical interview.
