Database Administrator

Softenger; Maharashtra; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Softenger in Mumbai is seeking an experienced PostgreSQL Database Administrator (DBA) with 4+ years of hands-on experience in database administration, performance tuning, security, troubleshooting, migration, and high-availability environments.

The role involves managing PostgreSQL databases, ensuring high availability, performance, integrity, and compliance. You will have strong exposure to hardening, patching, clustering, migration, user management, maintenance activities, and optimization.

Qualifications

• 4+ years of PostgreSQL DBA experience.
• Experience with clustering and high-availability setups.
• Strong knowledge of FDW, backups, and performance tuning.

Responsibilities

• Manage PostgreSQL databases across dev/test/prod.
• Monitor health, availability, performance, and capacity.
• Perform tuning, hardening, patches, upgrades, and security tasks.
• Design and maintain PostgreSQL clusters and high‑availability setups.
• Plan migrations with minimal downtime.
• Automate repetitive admin tasks and maintain runbooks.

Skills

PostgreSQL DBA

Database troubleshooting

Database hardening

FDW

Migration & upgrades

Maintenance jobs

User & role management

Performance tuning

Backup & recovery

Security & data integrity

Replication

Cloud databases

Scripting/automation

Tools

PostgreSQL cluster setup

Job description

PostgreSQL Database Administrator (DBA)

Experience: 4+ Years

Employment Type: Full-time

Job Location: Mumbai

Shift: 24/7

Job Summary :

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

The ideal candidate will be responsible for managing and maintaining PostgreSQL databases, ensuring high availability, performance, integrity, security, and compliance. The candidate should have strong experience in database troubleshooting, hardening, patching, clustering, migration, user management, maintenance activities, and performance optimization.

Key Responsibilities

• Manage, maintain, and administer PostgreSQL databases across development, testing, and production environments.
• Monitor database health, availability, performance, capacity, and key database metrics.
• Perform database performance tuning and optimization, including query and configuration optimization.
• Troubleshoot database issues, identify root causes, and implement effective solutions.
• Perform database hardening, patching, upgrades, and security‑related activities.
• Design, configure, and maintain PostgreSQL database clusters and high‑availability environments.
• Plan and execute database migrations and version upgrades with minimal downtime.
• Configure and manage Foreign Data Wrappers (FDW) and related database integrations.
• Implement and maintain database backup, recovery, and disaster recovery processes.
• Manage database replication and ensure data consistency and availability.
• Manage database users, roles, permissions, access controls, and security policies.
• Ensure database data integrity, security, and availability in accordance with organizational standards.
• Collaborate closely with development, DevOps, infrastructure, and operations teams to support application and database requirements.
• Automate repetitive database administration tasks using scripts and appropriate tools.
• Develop and maintain database scripts, utilities, monitoring processes, and operational documentation.
• Conduct database capacity planning and proactively identify potential performance or storage issues.
• Maintain database standards, procedures, architecture documentation, and operational runbooks.
• Ensure compliance with applicable data protection and security requirements.
• Stay current with PostgreSQL releases, database technologies, best practices, and industry trends.

Must-Have Skills

• PostgreSQL Database Administration – 4–6 years
• Strong experience in database troubleshooting
• Hands‑on experience with database hardening and patching
• Experience in PostgreSQL cluster setup and configuration
• Strong knowledge of Foreign Data Wrappers (FDW)
• Hands‑on experience with database migration and version upgrades
• Experience with database maintenance jobs and activities
• Strong experience in database user and role management
• Strong knowledge of database performance monitoring, tuning, and optimization
• Experience with backup and recovery processes
• Good understanding of database security, availability, and data integrity

Good-to-Have Skills

• Experience with PostgreSQL replication
• Knowledge of high‑availability and disaster recovery solutions
• Experience with database monitoring and automation tools
• Exposure to cloud‑based database environments
• Knowledge of scripting/automation for database administration

What We’re Looking For

• Strong analytical and troubleshooting skills
• Ability to work independently and resolve complex database issues
• Good communication and collaboration skills
• Strong focus on database security, reliability, and performance
• Ability to work effectively with cross‑functional development and operations teams