Posted 02 July, 2026
PostgreSQL Database Consultant
NR Consulting
PAN India
Full Time
Reference: 365_463738_26-06567
Title: PostgreSQL Database Consultant
Location: PAN India
Exp: 10+ Yrs
Job Description:
Key Responsibilities
Install, configure, administer, and maintain PostgreSQL database environments.
Monitor database health, performance, and capacity planning activities.
Perform database performance tuning, query optimization, and indexing strategies.
Design and implement high-availability and disaster recovery solutions.
Manage backup and recovery processes and validate restoration procedures.
Troubleshoot database issues, identify root causes, and implement corrective actions.
Support database migration projects from Oracle, SQL Server, MySQL, or other databases to PostgreSQL.
Implement database security, user management, access controls, and auditing.
Automate routine DBA tasks using shell scripting, Python, or other automation tools.
Collaborate with development teams on schema design, SQL optimization, and release deployments.
Create and maintain database standards, operational procedures, and documentation.
Provide production support and participate in on-call activities when required.
Required Skills
PostgreSQL Administration
Strong hands-on experience with PostgreSQL Database Administration.
Expertise in PostgreSQL architecture, configuration, and internals.
Experience with PostgreSQL versions 11/12/13/14/15/16 or higher.
Knowledge of partitioning, indexing, replication, and vacuum processes.
Performance & Optimization
SQL query tuning and execution plan analysis.
Performance monitoring and troubleshooting.
Index optimization and database benchmarking.
Capacity planning and resource management.
High Availability & Disaster Recovery
PostgreSQL Streaming Replication.
Logical and Physical Replication.
Experience with Patroni, Pgpool-II, repmgr, or similar HA solutions.
Backup and recovery using pgBackRest, Barman, WAL-G, or equivalent tools.
Database Migration
Database migration and upgrade planning.
Migration from Oracle, MySQL, SQL Server, or other RDBMS platforms.
Data validation and performance optimization post-migration.
Security & Compliance
Role-based access control (RBAC).
Database encryption and auditing.
Compliance and security best practices.
Tools & Technologies
PostgreSQL
pgAdmin
PgBouncer
Patroni
pgBackRest
Barman
Linux/Unix Administration
Shell Scripting
Python (preferred)
Git
Monitoring tools such as Prometheus, Grafana, ELK, Nagios, or Zabbix
Preferred Qualifications
Experience with PostgreSQL in cloud environments (AWS RDS/Aurora PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL).
Knowledge of Kubernetes and containerized database deployments.
Exposure to DevOps and Infrastructure-as-Code tools such as Terraform and Ansible.
PostgreSQL certification is a plus.
Location: PAN India
Exp: 10+ Yrs
Job Description:
Key Responsibilities
Install, configure, administer, and maintain PostgreSQL database environments.
Monitor database health, performance, and capacity planning activities.
Perform database performance tuning, query optimization, and indexing strategies.
Design and implement high-availability and disaster recovery solutions.
Manage backup and recovery processes and validate restoration procedures.
Troubleshoot database issues, identify root causes, and implement corrective actions.
Support database migration projects from Oracle, SQL Server, MySQL, or other databases to PostgreSQL.
Implement database security, user management, access controls, and auditing.
Automate routine DBA tasks using shell scripting, Python, or other automation tools.
Collaborate with development teams on schema design, SQL optimization, and release deployments.
Create and maintain database standards, operational procedures, and documentation.
Provide production support and participate in on-call activities when required.
Required Skills
PostgreSQL Administration
Strong hands-on experience with PostgreSQL Database Administration.
Expertise in PostgreSQL architecture, configuration, and internals.
Experience with PostgreSQL versions 11/12/13/14/15/16 or higher.
Knowledge of partitioning, indexing, replication, and vacuum processes.
Performance & Optimization
SQL query tuning and execution plan analysis.
Performance monitoring and troubleshooting.
Index optimization and database benchmarking.
Capacity planning and resource management.
High Availability & Disaster Recovery
PostgreSQL Streaming Replication.
Logical and Physical Replication.
Experience with Patroni, Pgpool-II, repmgr, or similar HA solutions.
Backup and recovery using pgBackRest, Barman, WAL-G, or equivalent tools.
Database Migration
Database migration and upgrade planning.
Migration from Oracle, MySQL, SQL Server, or other RDBMS platforms.
Data validation and performance optimization post-migration.
Security & Compliance
Role-based access control (RBAC).
Database encryption and auditing.
Compliance and security best practices.
Tools & Technologies
PostgreSQL
pgAdmin
PgBouncer
Patroni
pgBackRest
Barman
Linux/Unix Administration
Shell Scripting
Python (preferred)
Git
Monitoring tools such as Prometheus, Grafana, ELK, Nagios, or Zabbix
Preferred Qualifications
Experience with PostgreSQL in cloud environments (AWS RDS/Aurora PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL).
Knowledge of Kubernetes and containerized database deployments.
Exposure to DevOps and Infrastructure-as-Code tools such as Terraform and Ansible.
PostgreSQL certification is a plus.
