Alexandra Kuznetsova

Technologies

February 2024 - current

July 2021 - February 2024

Starting as database engineer, studied the possibilities of PostgreSQL monitoring and analyzed different monitoring solutions. Went to the post of software engineer and continued development of mamonsu - PostgresPro own monitoring solution.
Made some talks:
Mamonsu monitoring agent: a brief tutorial
Mamonsu 3.0: New Features and Quick Start (Zabbix Meetup Online)
PostgreSQL, Python, Zabbix, GitHub CI
Participated as a software engineer in PostgresPro Enterprise Manager development.
Python, Go, PostgreSQL
Created pgpro-otel-collector - monitoring tool based on OpenTelemetry Collector.
Go, OpenTelemetry, PostgreSQL

August 2019 - June 2021

Administrated PostgreSQL servers. Designed custom PostgreSQL metrics for monitoring system, automated bloat monitoring and vacuuming on a cluster of 40+ PGs.
PostgreSQL, Zabbix, bash, Ansible
Created a tool for custom 1C data area (part of a PG dump) recovering. Tool built a dump based on data from external 1C specific data statistics system.
PostgreSQL, pg_dump, Python
Took part in the development of a solution for finding similar large texts in PostgreSQL. Created PostgreSQL extension in C to perform words embedding. Here is the talk of my mentor about this solution.
PostgreSQL, C

June 2018 - August 2019

Took part in the development of the ETL-like subsystem in PL/pgsql.
PostgreSQL, PL/pgsql
Created a tool for tracking non-optimal SQL queries and automatic creation of tasks for query correction. Bad queries were calculated on the basis of pg_stat_statements and other statistics.
PostgreSQL, Python, ELK
Created PostgreSQL extension to track orphaned files.
PostgreSQL, PL/Python

Higher Education
Perm State University (ПГНИУ), Faculty of Mechanics and Mathematics
Major: Computer Security
Graduation Year: 2022

Additional education
Yandex Practicum
Major: Advanced Golang Developer
Graduation Year: 2023