PostgreSQL & ClickHouse DBA · High Availability & Disaster Recovery · Ansible Automation · Open Source
English · Русский
fmalkov91@gmail.com · fmalkov91@proton.me
I am a database administrator, software developer, and open-source enthusiast. My professional work focuses on PostgreSQL and ClickHouse infrastructure: reliability, replication, backup and recovery, monitoring, and automation. Outside of DBA work, I build practical tools for Windows and other platforms and explore software architecture, security, and AI-assisted engineering.
I care about clear interfaces, predictable behavior, user control, and the ability to recover safely when something goes wrong.
| Project | What it does |
|---|---|
| NetRuleRouter | Work-in-progress desktop app for rule-based traffic routing across VPN tunnels and multiple internet sources (different providers, Ethernet, Wi-Fi, mobile hotspots), with rules by domain, address, or application. Written in Rust. |
| codexSync | Local-first GUI and CLI for moving Codex chats, projects, settings, and local state between your own machines, with conflict handling, backups, and recovery. |
| WinStoreRegion | Temporarily switches the Windows region for Microsoft Store installs, then restores the original setting. Written in Rust. |
| Pakomichi | A bridge from Git releases to APT and DNF: install and update .deb/.rpm packages published in Releases with the usual apt/dnf commands, without separate package repositories. In design. |
| ZDashstitch | Local GUI tool for building, cloning, and safely maintaining global Zabbix dashboards: assemble pages from several templates, prepare projects offline, and replace a host across many widgets at once. Targets Zabbix 7.4. Written in Rust. Early development; the dashboard editor is not ready yet. |
| CommentRake | Human-in-the-loop tool for finding, reviewing, and cleaning up source-code comments; the developer always makes the final call. Pre-alpha. |
| Reconstellate | Local-first desktop platform for digitising, analysing, matching, assembling, and reconstructing objects from 2D profiles, 3D meshes, and fragments. The first domain pack focuses on archaeological pottery. Active development. |
| Project | What it explores |
|---|---|
| CHLOYA | An evolving methodology for AI-assisted software engineering: bounded context, explicit responsibilities, transferable project knowledge, and verifiable results. |
| PageCheck | Pre-alpha browser extension that looks for signs of hidden or deceptive page content, suspicious links, and visual manipulation. Not a security guarantee. |
| Web Security Scenario Lab | A controlled, client-side research lab for reproducing misleading web-page patterns and testing detection tools. |
Older experiments, libraries, and other projects are available in my repositories.
I send fixes and features to open-source projects I use. Pull requests, dates and status: CONTRIBUTIONS.md.
13+ years in IT, starting in 2011 with networks and servers in a university lab, then research software development, and database administration in production. Full resume: PDF · DOCX.
NIC Telecom (National Research Center for Telecommunications) — Database Administrator
August 2026 – Present
Modernizing and maintaining PostgreSQL and ClickHouse infrastructure in the telecommunications sector: replication, backup and disaster recovery, monitoring, automation with Ansible, and high-availability design.
Rostelecom — Database Administrator
December 2023 – February 2026
Operated and supported high-load database systems for a large telecommunications company (600+ database instances, PostgreSQL with Patroni-based high availability, ClickHouse, Cassandra), with a focus on reliability, monitoring, security, and automation.
Horizon LLC — Systems Engineer, Laboratory Information Systems
June 2022 – October 2023
Administered Windows and Linux servers and supported PostgreSQL, Oracle, and MongoDB: troubleshooting, log analysis, backups, and monitoring. Automated routine tasks with Python and integrated laboratory analyzers and electronic-signature workflows.
Scientific Centre for Family Health and Human Reproduction Problems — IT Infrastructure & Systems Administration Specialist (part-time)
September 2020 – January 2026
Administered Linux virtual machines and Proxmox VE, including the migration from VMware; maintained backups and PostgreSQL-based services (Moodle, GitLab, internal Django applications, BigBlueButton) for research, healthcare, and education.
- 2020–2021 · Irkutsk National Research Technical University — Lecturer. Undergraduate laboratory classes and practical technical training.
- 2018 · Institute of System Dynamics and Control Theory, SB RAS — Programmer. Django applications, Redmine and GitLab administration, database design.
- 2017–2021 · Irkutsk National Research Technical University — Junior Researcher. Research and software projects, grants and publications; OpenStack and storage systems.
- 2015–2017 · Irkutsk Scientific Centre, SB RAS — Junior Researcher. Grant-funded research and software projects.
- 2015 · UMNIK grant project — Software Developer. C++/Qt, database design, image analysis with OpenCV.
- 2011–2013 · Irkutsk National Research Technical University — Research Laboratory Assistant / Technician Programmer. Local networks, workstations, servers, and computer labs.
My earlier research focused on 3D scanning and virtual reconstruction of archaeological artifacts: recovering ceramic vessel profiles from 3D scans and recreating missing fragments with virtual reconstruction and 3D printing. I also co-authored, with neurosurgery specialists, a systematic review of 3D printing in neurosurgery.
2014 · Virtual reconstruction of ceramic vessels from 3D scans
Original title: «Виртуальное восстановление сосудов на основе 3Д сканирования».
Ancient Cultures of Mongolia and Baikal Siberia, proceedings of the 5th International Scientific Conference, Kyzyl, Part II, pp. 157–161.
Focus: reconstructing vessel profiles from 3D scanning data.
Proceedings and bibliographic entry
2018 · Recreating small missing fragments of ceramic vessels using virtual reconstruction and 3D printing
Original title: «Воссоздание малых недостающих фрагментов керамических сосудов с помощью методов виртуальной реконструкции и 3D-печати».
Virtual Archaeology, international forum proceedings, State Hermitage Museum, St. Petersburg. Co-authored with A. V. Kharinsky.
Focus: digitally reconstructing missing fragments and producing physical replacements through 3D printing.
Proceedings (PDF)
2019 · 3D-Printing Technology in Neurosurgery: A Systematic Review
Original title: «Технология 3D-печати в нейрохирургии: систематический обзор».
Pediatric Neurosurgery and Neurology, No. 2–3 (60–61), pp. 75–98. Co-authored with neurosurgery specialists.
Focus: clinical and educational uses of 3D printing, including anatomical models, surgical planning, and training.
Journal issue archive
Other earlier publications cover scientific information systems, computer vision, biological data analysis, and other interdisciplinary topics.