EDB PostgreSQL DBA - Remote / Telecommute

Summary: The role of EDB PostgreSQL DBA involves designing and executing an upgrade strategy from EDB Postgres 11 to 15, ensuring data integrity and minimal downtime. The position requires technical implementation, system management, testing, and collaboration with various teams. The candidate will also be responsible for maintaining documentation and providing training for post-upgrade operations. This is a remote position based in the USA, classified as outside IR35.

Key Responsibilities:

• Design and execute a comprehensive upgrade strategy from EDB Postgres 11 to 15 using pg_upgrade.
• Prepare and validate upgrade environments, ensuring compatibility of locales, encodings, and configurations.
• Perform pre-upgrade consistency checks and post-upgrade validations.
• Minimize downtime and ensure data integrity throughout the upgrade process.
• Install and configure EDB Postgres Advanced Server 15 alongside version 11.
• Create and manage empty clusters using initdb for upgrade targets.
• Modify pg_hba.conf to enable trust authentication during upgrade.
• Execute upgrade commands with appropriate flags and environment settings.
• Perform post-upgrade tasks including ANALYZE, deprecated feature checks, and performance tuning.
• Stop and manage services across Linux/Windows environments to ensure safe upgrade conditions.
• Use tools like pgpass.conf or .pgpass for secure authentication during upgrade.
• Revert to previous versions if necessary using documented rollback procedures.
• Conduct thorough testing of applications post-upgrade.
• Monitor logs and system performance to ensure stability.
• Validate compatibility of extensions (e.g., PostGIS) and third-party tools.
• Maintain detailed upgrade runbooks and rollback plans.
• Collaborate with DevOps, infrastructure, and application teams.
• Provide training and support for post-upgrade operations.

Key Skills:

• Bachelor's degree in Computer Science or related field.
• 5+ years of experience as a PostgreSQL/EDB DBA.
• Proven experience upgrading PostgreSQL/EDB versions using pg_upgrade.
• Strong command-line and scripting skills (Bash, Python).
• Familiarity with Linux and Windows server environments.
• Knowledge of EDB Postgres Advanced Server features and Oracle compatibility mode.
• Excellent troubleshooting and communication skills.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT