Postgresql Database Administrator | APEDA | New Delhi

National Institute for Smart Government (NISG); New Delhi; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

National Institute for Smart Government (NISG) in New Delhi seeks an experienced Database Administrator to manage PostgreSQL, with secondary support for MS SQL Server/MySQL. The role emphasizes HA/DR, backups, and performance tuning.

The candidate should have 5+ years in database administration with strong PostgreSQL hands-on experience and familiarity with Linux and cloud DBs. Location is New Delhi, India.

Qualifications

• 5+ years of hands-on PostgreSQL administration and maintenance.
• Strong working knowledge of HA/DR concepts and implementations.
• Experience with backend databases, backups, and performance tuning.
• Exposure to cloud database services (AWS/Azure) a plus.

Responsibilities

• Install, configure, and administer PostgreSQL databases across dev, test, and production.
• Monitor performance, tune queries, and manage VACUUM/ANALYZE and indexes.
• Design and manage HADR setups with streaming replication and failover planning.
• Implement backup/recovery strategies and validate restores regularly.
• Ensure DB security, access control, patching, and compliance.
• Provide secondary admin for MS SQL Server / MySQL and related tasks.
• Document configurations, SOPs, and change records; RCA for incidents.
• Coordinate with infra, app, and security teams for deployments.

Skills

PostgreSQL

HADR

Backup/Recovery

SQL Tuning

Shell/Python

Linux Admin

Cloud DB (AWS/Azure)

Education

BE/B.Tech (CSE/IT)

MCA

M.Sc. (Computers)

Tools

pgBackRest

pgBaseBackup

Patroni

repmgr

pgpool-II

Job description

Designation: Database Administrator, PostgreSQL

Client: Agricultural and Processed Food Products Export Development Authority (APEDA)

Location: New Delhi

Qualification: BE / B.Tech (CSE/IT), or MCA, or M.Sc. (Computers)

Experience: Minimum 5 years in database administration, with strong hands-on PostgreSQL experience

About the Role:

We are looking for an experienced Database Administrator to manage and optimize our PostgreSQL database environments supporting mission-critical applications. The role also involves secondary support for MS SQL Server/MySQL and requires strong working knowledge of High Availability and Disaster Recovery (HADR) practices.

Responsibilities

• Install, configure, and administer PostgreSQL databases across dev, test, and production environments.
• Monitor and tune database performance, query optimization, indexing, VACUUM/ANALYZE, and resource utilization.
• Design and manage HADR setups: streaming/logical replication, Patroni/repmgr/pgpool-II, failover, RTO/RPO, and DR drills.
• Implement backup and recovery strategies (pg_dump, pg_basebackup, pgBackRest/Barman, PITR) and validate through periodic restore tests.
• Ensure database security: role-based access control, encryption, patching, and compliance with security guidelines.
• Provide secondary administration and support for MS SQL Server / MySQL installation, backup/restore, replication, and troubleshooting.
• Perform root cause analysis (RCA) for incidents and maintain documentation of configurations, SOPs, and change records.
• Coordinate with infrastructure, application, and security teams for deployments, migrations, and issue resolution.

Key Competencies:

• 5+ years of hands-on PostgreSQL administration, performance tuning, and maintenance.
• Strong knowledge of HADR concepts: replication, clustering, failover/switchover, RTO/RPO.
• Proficiency in backup/recovery tools, SQL query tuning, and connection pooling (PgBouncer).
• Basic scripting (Shell/Python) and Linux server administration; cloud database exposure (AWS RDS/Azure) is a plus.
• Relevant certifications (PostgreSQL Certified Professional, Azure/MySQL DBA) preferred.
• Strong analytical, communication, and stakeholder-coordination skills.