EDB PostgreSQL DBA - Remote / Telecommute

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Cynet Systems, is seeking the following. Apply via Dice today!Job Description:Responsibilities:Upgrade Planning And 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 And 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 And 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 And 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 And 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.