PostgreSQL Administrator

Skills & Qualifications

• Strong experience as a DBA / PostgreSQL Database Administrator
• Experience monitoring, managing, and maintaining mission-critical 24/7 databases
• Good understanding of PostgreSQL architecture
• Experience installing, configuring, and administering PostgreSQL on Linux and Windows machines
• Experience implementing high-availability solutions
• Experience installing and configuring replication and connection pooling
• Expert backup and recovery skills, including pg_dump and WAL archiving
• Experience with PostgreSQL minor and major version upgrades

Nice to Have

• MySQL
• MongoDB
• MSSQL
• Oracle (at least one technology)

Key Responsibilities

• Understand operational requirements, including hardware, architecture, configuration, and integration, while maintaining mission-critical production PostgreSQL databases
• Implement replication using streaming, cascading, and logical methods
• Implement HA solutions for EDB PostgreSQL using EFM and a load balancer
• Manage logical and physical backups and recovery, including PITR recovery
• Administer connection-pooling tools and database auditing
• Perform regular database maintenance, including vacuuming, reindexing, and archiving
• Use community-supported tools such as PgBadger, Slony, pgAdmin, Pgpool, and PgBouncer
• Manage clusters and upgrade or migrate PostgreSQL database versions
• Perform performance tuning
• Develop database automation scripts and maintenance processes
• Provide technical guidance for integration, testing, design, development, and planning of new production systems and databases
• Contribute to the improvement and creation of DBA policies, procedures, and standards