cv

Basics

Name Pavlo Golub
Label Senior Developer and PostgreSQL Consultant
Email pavlo.golub@gmail.com
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.

Work

  • 2018.01 - 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.01 - 2018.01
    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.

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

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

Languages

English
Fluent
Ukrainian
Native
Slovak
Fluent
German
Basic

Projects

  • 2023.01 - Present
    pgwatch
    • No superuser rights or extensions required.
    • Supports AWS RDS, PgBouncer, Pgpool2, and Patroni.
    • Metrics stored in PostgreSQL, TimescaleDB, or Prometheus.
  • 2020.01 - Present
    pg_timetable
    • Fully database-driven design.
    • Superior to cron for PostgreSQL-related workflows.
    • Supports parallel and conditional job chains.
  • 2018.01 - Present
    Patroni for Windows
    • Adapted core functionality to support Windows environments.
    • Enabled high-availability clusters on Windows-based infrastructure.
  • 2020.01 - Present
    vip-manager
    • Automates virtual IP management for failover.
    • Improves availability and recovery times in HA clusters.
  • 2013.01 - 2018.01
    MicroOLAP Database Designer for PostgreSQL
    • Support for reverse engineering.
    • Graphical modeling of tables, views, and relationships.
  • 2008.01 - 2018.01
    PostgresDAC
    • Streamlined integration with Delphi-based applications.
    • Supported a wide range of PostgreSQL versions.
  • 2008.01 - 2018.01
    PaGoDump & PaGoRestore
    • Full support for pg_dump/pg_restore options.
    • Portable and Unicode-enabled Windows applications.