PostgreSQL Database Administrator

Must Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc. Trouble shoot and resolve database connectivity issues (pgbouncer,pgpool) Managing tablespaces, data files, redo logs and database objects Pgbench for PostgreSQL Performance test. Expertise with Postgres system metrics and optimization strategies Provide assistance on database administration, backup, and disaster recovery of PostgreSQL databases. Responsible for regular backups.(pg_dump, pg_basebackup, pg_BackRest) and recovery of databases (pg_restore, parallel restoring, write-ahead log) Stay informed of security patches and updates from PostgreSQL. Evaluate and implement as needed. Experience wit

Keyskills