EDB PostgreSQL DBA – Version Upgrade Specialist
Noblesoft Technologies
- USA
- Permanent
- Full-time
Location - remote within USAWe are seeking a skilled EDB PostgreSQL Database Administrator to lead the upgrade of our database infrastructure from EDB Postgres Advanced Server version 11 to version 15. The ideal candidate will have hands-on experience with pg_upgrade, deep knowledge of PostgreSQL internals, and a strong understanding of enterprise-grade database operations.Key Responsibilities:Upgrade Planning & Execution
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.
Technical Implementation
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.
System & Service Management
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.
Testing & Validation
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.
Documentation & Collaboration
Maintain detailed upgrade runbooks and rollback plans.
Collaborate with DevOps, infrastructure, and application teams.
Provide training and support for post-upgrade operations.Required Skills & Qualifications: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