Postgresql Database Administrator

Role & responsibilities

• Installation and configuration.
• Expert in Backup and Recovery including pg_dump, pg_dumpall, setting up WAL (Write Ahead Log) archiving, Point in time recovery.
• Management of PostgreSQL server security and Database health checks.
• Performance tuning, Query tuning by generating and explaining plan for SQL queries.
• Analyse, recommend, and implement configuration for Optimized Performance.
• Creation, managing and migrating PostgreSQL schema, tables, tablespaces and users, roles, and group.
• Ability to plan hardware capacity requirements for storage, memory, and CPU Cycles.
• Setting up replication setup for 3 nodes (Master, Slave, and Disaster Recovery).
• Ability to configure and troubleshoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves.
• Pg pool configuration for connection pooling and load balancing.
• Understanding of UNIX environment with shell scripting.
• Trouble shooting and resolving database issues.