PostgreSQL DBA

Job Description PostgreSQL DBA

Job Title:

Job Summary

PostgreSQL DBA

Key Responsibilities

• Install, configure, upgrade, patch, and maintain

  PostgreSQL databases

  .
• Perform database administration activities across development, UAT, and production environments.
• Monitor database health, performance, availability, and capacity.
• Perform

  PostgreSQL performance tuning

  , query optimization, indexing, and database parameter optimization.
• Manage database backup, restore, recovery, replication, and disaster recovery activities.
• Troubleshoot database incidents, connectivity issues, locking, performance bottlenecks, and replication failures.
• Implement and maintain database security, roles, permissions, and access controls.
• Support database migration, upgrades, and environment refresh activities.
• Work on high-availability and failover solutions for critical database environments.
• Provide production support and perform root-cause analysis for database-related issues.
• Collaborate with application, infrastructure, DevOps, and security teams.
• Maintain database documentation, operational procedures, and support runbooks.

Oracle Database Responsibilities

• Good hands-on knowledge of

  Oracle Database

  administration.
• Experience with

  Oracle RAC

  installation, configuration, monitoring, and troubleshooting.
• Knowledge of

  Oracle Data Guard

  for high availability and disaster recovery.
• Support Oracle database performance tuning, backup/recovery, and production issues.

Mandatory Skills

• PostgreSQL DBA

• PostgreSQL installation and configuration
• PostgreSQL backup and recovery
• PostgreSQL replication and HA
• Database performance tuning
• SQL and query optimization

• Oracle Database

• Oracle RAC

• Oracle Data Guard

• Production database support
• Database monitoring and troubleshooting

Good to Have

• PostgreSQL streaming/logical replication
• Patroni or similar HA tools
• Linux/Unix administration
• Shell scripting
• Cloud database technologies
• Automation tools
• Database migration experience
• Disaster Recovery and Business Continuity

Candidate Profile

• 8–12 years

  of experience in database administration.
• Strong hands-on experience as a

  PostgreSQL DBA

  .
• Good working knowledge of Oracle database technologies, particularly

  RAC and Data Guard

  .
• Strong troubleshooting, analytical, and problem-solving skills.
• Experience supporting critical production databases.
• Good communication and stakeholder-management skills.

Key Skills

PostgreSQL | PostgreSQL DBA | Oracle Database | Oracle RAC | Oracle Data Guard | SQL | Performance Tuning | Backup & Recovery | Replication | High Availability | Disaster Recovery | Production Support | Database Security | Linux