PostgreSQL Database Admin

Job Description

• Location

• Hyderabad
  Experience - 8-12 Years

• Good understanding of PostgreSQL – Architecture, security, operational knowledge

• Deep understanding of how PostgreSQL manages data, including tablespaces, data files, indexes, WAL (Write-Ahead Logging), and key processes like Postmaster and bgwriter

• Proficiency in installing, configuring, and upgrading PostgreSQL instances.

• Good to have expertise in automating routine DBA task like log management, backups, schema migration, indexing and monitoring.

• Strong knowledge of various backup strategies (e.g., pg_basebackup, WAL archiving) and recovery procedures to ensure data integrity and availability.

• Experience in Applying Patches and troubleshooting patch failure issues.

• Strong work experience in Unix\Linux Operating system and Shell Scripting

• Experience in implementing and managing replication solutions Streaming replication (primary/standby setup). Logical replication.

• Experience on Postgres failover and load balancing.

• Understanding of user roles, privileges, authentication methods, and best practices for securing PostgreSQL databases.