cv
Basics
Name | Pavlo Golub |
Label | Senior Developer and PostgreSQL Consultant |
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
Certificates
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.