Database Administrator,Postgres SQL

Softenger; Mumbai; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Softenger is seeking an experienced PostgreSQL Database Administrator to manage and optimize PostgreSQL databases across development, test and production environments. The role focuses on performance tuning, security hardening, migrations, replication, and automation to ensure reliable data services.

Ideal candidates bring 4–6 years of hands-on PostgreSQL experience with cluster setup, FDWs, and strong SQL scripting.

Qualifications

• 4–6 years of hands-on experience as a PostgreSQL Database Administrator.
• Strong experience in PostgreSQL administration and troubleshooting.
• Hands-on experience with database hardening and patching – Must Have.
• Experience in PostgreSQL cluster setup and configuration – Must Have.
• Strong knowledge of Foreign Data Wrappers (FDW) – Must Have.
• Hands-on experience with database migration and version upgrades – Must Have.
• Experience with database maintenance jobs and automation – Must Have.
• Strong experience in database user and access management.
• Strong knowledge of performance monitoring, tuning, and optimization.
• Experience with replication and high availability – Good to Have.
• Good understanding of backup, recovery, and DR concepts.
• Strong SQL and database scripting skills.

Responsibilities

• Manage, maintain, and administer PostgreSQL databases across environments.
• Ensure availability, performance, integrity, and security.
• Design and implement database architectures and systems based on requirements.
• Perform troubleshooting, performance tuning, and optimization.
• Monitor health, metrics, capacity, and resource utilization.
• Configure and manage PostgreSQL database clusters.
• Perform hardening, patching, upgrades, and maintenance.
• Plan and execute migrations to latest PostgreSQL versions.
• Configure and manage FDW and related integrations.
• Implement and maintain replication and high-availability solutions.
• Develop and maintain maintenance jobs, scripts, and automation tools.
• Manage database users, roles, privileges, and access controls.
• Implement and maintain backup and disaster recovery processes.
• Stay current with PostgreSQL features and industry best practices.
• Collaborate with development, DevOps, and operations teams.

Skills

PostgreSQL

DBA

Database Admin

Troubleshooting

Hardening

Patching

Cluster setup

FDW

Migration

Replication

Maintenance automation

User management

Performance tuning

Backup & Recovery

Disaster Recovery

SQL scripting

Job description

We are looking for an experienced PostgreSQL Database Administrator (DBA) with 4–6 years of hands‑on experience in database administration, performance tuning, security, migration, and troubleshooting.

The ideal candidate will have strong expertise in managing and maintaining PostgreSQL databases, database clustering, hardening, patching, migrations, performance optimization, and automation. You will work closely with development and operations teams to ensure database availability, reliability, performance, and security.

Key Responsibilities

• Manage, maintain, and administer PostgreSQL databases across development, test, and production environments.


• Ensure database availability, performance, integrity, and security.


• Design and implement database architectures and database systems based on business and application requirements.


• Perform database troubleshooting, performance tuning, and optimization.


• Monitor database health, performance metrics, capacity, and resource utilization.


• Configure and manage PostgreSQL database clusters.


• Perform database hardening, patching, upgrades, and maintenance.


• Plan and execute database migrations, including migration to the latest supported PostgreSQL versions.


• Configure and manage Foreign Data Wrappers (FDW) and related database integrations.


• Implement and maintain database replication and high‑availability solutions.


• Develop and maintain database maintenance jobs, scripts, and automation tools.


• Manage database users, roles, privileges, and access controls.


• Implement and maintain backup and recovery processes.


• Develop and execute disaster recovery (DR) strategies and procedures.


• Monitor and troubleshoot database‑related issues and provide timely solutions.


• Collaborate with development, DevOps, infrastructure, and operations teams to support application and database requirements.


• Maintain database documentation, standards, procedures, and operational runbooks.


• Ensure databases comply with applicable security and data protection requirements.


• Conduct database capacity planning and proactively identify potential performance or resource issues.


• Support database upgrades, patches, configuration changes, and production deployments.


• Stay current with PostgreSQL features, database technologies, best practices, and industry trends.

Required Skills & Experience

• 4–6 years of hands‑on experience as a PostgreSQL Database Administrator.


• Strong experience in PostgreSQL database administration and troubleshooting.


• Hands‑on experience with database hardening and patching – Must Have.


• Experience in PostgreSQL cluster setup and configuration – Must Have.


• Strong knowledge of Foreign Data Wrappers (FDW) – Must Have.


• Hands‑on experience with database migration, including PostgreSQL version upgrades/migrations – Must Have.


• Experience with database maintenance jobs and automation – Must Have.


• Strong experience in database user and access management – Must Have.


• Strong knowledge of database performance monitoring, tuning, and optimization – Must Have.


• Experience with PostgreSQL replication and high availability – Good to Have.


• Good understanding of database backup, recovery, and disaster recovery concepts.


• Strong SQL and database scripting skills.


• Ability to analyze database issues, identify root causes, and implement effective solutions.


• Good communication and collaboration skills.

Key Skills

PostgreSQL | PostgreSQL DBA | Database Administration | Database Troubleshooting | Database Hardening | Patching | PostgreSQL Cluster | FDW | Database Migration | Replication | Maintenance Jobs | User Management | Performance Tuning | Database Optimization | Backup & Recovery | Disaster Recovery | Database Security | SQL | Automation

Preferred Candidate Profile

Candidates who have strong hands‑on experience managing enterprise PostgreSQL environments, including production troubleshooting, clustering, migrations, security hardening, performance optimization, and database automation, will be preferred.

If you are passionate about PostgreSQL and enjoy solving complex database challenges, we would love to hear from you!