CV

Contact Information

Name Pavlo Golub
Professional Title Senior Developer and PostgreSQL Consultant
Email pavlo.golub@gmail.com
Location Bratislava, Slovakia

Professional Summary

Senior Developer and PostgreSQL Consultant with over 20 years of professional experience specializing in PostgreSQL database optimization, high-performance backend development, and robust, open-source software solutions. Official PostgreSQL Contributor, co-founder of PostgreSQL Ukraine, and Google Summer of Code PostgreSQL Organization Administrator, actively contributing to the PostgreSQL community. Adept at architecting scalable systems, enhancing database reliability, and mentoring technical teams.

Experience

  • 2018 - Present
    Senior PostgreSQL Consultant and Developer
    Cybertec PostgreSQL International
    Provide expert consulting services on PostgreSQL optimization, clustering, and performance tuning. Mentor teams, deliver training, and develop open-source tools.
    • Developed pgwatch, a non-invasive PostgreSQL monitoring solution with Grafana integration.
    • Created pg_timetable, an advanced PostgreSQL job scheduler.
    • Ported Patroni to Windows.
    • Developed vip-manager for PostgreSQL high availability.
  • 2008 - 2018
    Chief of Development
    MicroOLAP Technologies
    Led development of flagship database tools. Managed full product lifecycle and customer support.
    • Directed development of MicroOLAP Database Designer for PostgreSQL.
    • Created and maintained PostgresDAC components.
    • Built PaGoDump & PaGoRestore GUI tools for PostgreSQL backup and restore.

Education

  • 1998 - 2003
    Master's Degree (MEd)
    Kirovograd State Pedagogical University
    Mathematics and Computer Science

Skills

Programming Languages & Frameworks: SQL, Go, Delphi/Pascal, Plain C, Python, TypeScript, PHP, JavaScript/HTML/CSS/Ajax
Databases & Data Management: PostgreSQL, TimescaleDB, Etcd, MySQL, MS Access
DevOps & Tools: Docker, Kubernetes, Git, Github Actions, Grafana, Prometheus, Patroni, PgBouncer, Pgpool2, Bash, PowerShell
Platforms & Operating Systems: Linux, Windows, DOS
IDEs & Development Tools: VS Code, RAD Studio, PyCharm, Sublime Text, pgAdmin, DBeaver, Lazarus/FreePascal, MinGW/GCC, MSYS2, InstallShield, EurekaLog, HeidiSQL, phpMyAdmin, MicroOLAP DB Designer
Professional Skills: Software Architecture Design, Technical Documentation, Performance Tuning, Database Clustering, System Scalability, Mentoring, Technical Training

Languages

English : Fluent
Ukrainian : Native
Slovak : Fluent
German : Basic

Certificates

  • Official PostgreSQL Contributor - PostgreSQL Global Development Group (2024)
  • Google Summer of Code Organization Administrator - Google (2023)

Projects

  • 2023 - Present
    pgwatch
    • No superuser rights or extensions required.
    • Supports AWS RDS, PgBouncer, Pgpool2, and Patroni.
    • Metrics stored in PostgreSQL, TimescaleDB, or Prometheus.
  • 2020 - Present
    pg_timetable
    • Fully database-driven design.
    • Superior to cron for PostgreSQL-related workflows.
    • Supports parallel and conditional job chains.
  • 2018 - Present
    Patroni for Windows
    • Adapted core functionality to support Windows environments.
    • Enabled high-availability clusters on Windows-based infrastructure.
  • 2020 - Present
    vip-manager
    • Automates virtual IP management for failover.
    • Improves availability and recovery times in HA clusters.
  • 2013 - 2018
    MicroOLAP Database Designer for PostgreSQL
    • Support for reverse engineering.
    • Graphical modeling of tables, views, and relationships.
  • 2008 - 2018
    PostgresDAC
    • Streamlined integration with Delphi-based applications.
    • Supported a wide range of PostgreSQL versions.
  • 2008 - 2018
    PaGoDump & PaGoRestore
    • Full support for pg_dump/pg_restore options.
    • Portable and Unicode-enabled Windows applications.
  • 2021 - Present
    pgxmock
    • Supports named parameters and multiple result sets.
    • Widely used in the Go/PostgreSQL ecosystem.
  • 2022 - Present
    pgcov
    • Integrates with standard PostgreSQL test workflows.
    • Helps identify untested code paths in PL/pgSQL functions.
  • 2023 - Present
    confelo
    • Designed for managing technical conference agendas.
    • Lightweight and easy to deploy.