×
Pavlo Golub

Pavlo Golub

Senior Developer and PostgreSQL Consultant

Bratislava
English, Ukrainian, Slovak, German

Background


About

About

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.

Work Experience

Work Experience

  • Senior PostgreSQL Consultant and Developer, Cybertec PostgreSQL International

    Jan, 2018 - Present

    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.

  • Chief of Development, MicroOLAP Technologies

    Jan, 2008 - Jan, 201810 years

    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.

Projects Experience

Projects Experience

  • pgwatch

    Jan, 2023 - Present

    Non-invasive PostgreSQL monitoring tool with Grafana dashboards and multi-environment support.

    • No superuser rights or extensions required.

    • Supports AWS RDS, PgBouncer, Pgpool2, and Patroni.

    • Metrics stored in PostgreSQL, TimescaleDB, or Prometheus.

  • pg_timetable

    Jan, 2020 - Present

    Advanced PostgreSQL job scheduler with support for SQL commands and system operations.

    • Fully database-driven design.

    • Superior to cron for PostgreSQL-related workflows.

    • Supports parallel and conditional job chains.

  • Patroni for Windows

    Jan, 2018 - Present

    Port of the high-availability PostgreSQL tool Patroni to Windows.

    • Adapted core functionality to support Windows environments.

    • Enabled high-availability clusters on Windows-based infrastructure.

  • vip-manager

    Jan, 2020 - Present

    Cross-platform VIP manager for PostgreSQL HA setups.

    • Automates virtual IP management for failover.

    • Improves availability and recovery times in HA clusters.

  • MicroOLAP Database Designer for PostgreSQL

    Jan, 2013 - Jan, 20185 years

    Visual tool for designing and managing PostgreSQL database schemas.

    • Support for reverse engineering.

    • Graphical modeling of tables, views, and relationships.

  • PostgresDAC

    Jan, 2008 - Jan, 201810 years

    Delphi/C++ Builder components for direct access to PostgreSQL databases.

    • Streamlined integration with Delphi-based applications.

    • Supported a wide range of PostgreSQL versions.

  • PaGoDump & PaGoRestore

    Jan, 2008 - Jan, 201810 years

    Portable GUI tools for PostgreSQL backup and restore.

    • Full support for pg_dump/pg_restore options.

    • Portable and Unicode-enabled Windows applications.

Skills

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

Education

Education

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

    Jan, 1998 - Jan, 2003

Certificates

Certificates

  • Official PostgreSQL Contributor,

    Issued on:

  • Google Summer of Code PostgreSQL Organization Administrator,

    Issued on: