EDB PostgreSQL DBA
- USA
- Permanent
- Full-time
- 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.
- 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.