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.
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.
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.
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.
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.
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.
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.
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.
SQL
Go
Delphi/Pascal
Plain C
Python
TypeScript
PHP
JavaScript/HTML/CSS/Ajax
PostgreSQL
TimescaleDB
Etcd
MySQL
MS Access
Docker
Kubernetes
Git
Github Actions
Grafana
Prometheus
Patroni
PgBouncer
Pgpool2
Bash
PowerShell
Linux
Windows
DOS
VS Code
RAD Studio
PyCharm
Sublime Text
pgAdmin
DBeaver
Lazarus/FreePascal
MinGW/GCC
MSYS2
InstallShield
EurekaLog
HeidiSQL
phpMyAdmin
MicroOLAP DB Designer
Software Architecture Design
Technical Documentation
Performance Tuning
Database Clustering
System Scalability
Mentoring
Technical Training
Mathematics and Computer Science, Master's Degree (MEd), Kirovograd State Pedagogical University
Jan, 1998 - Jan, 2003
Official PostgreSQL Contributor,
Issued on:
Google Summer of Code PostgreSQL Organization Administrator,
Issued on: