Prokhor Pastushenko

Middle Database Developer @Speech Technology Center

Saint Petersburg, RU

MAIN TOOLS:1. PostgreSQL (different versions)- Development of tables, views, functions, procedures, etc- Bug fixes and optimization of SQL queries- Creation, editing, optimization of indexes- Setting up Postgres configuration based on the characteristics of the machine (\"tuning\")- Replication, clustering, sharding, partitioning - Deploying a database in Docker (+ Docker compose)- Full Text Search (+ pg_trgm)2. ClickHouse (different versions)- Development of tables (variable engines), views, functions, etc- Bug fixes and optimization of SQL queries- Replication, clustering, sharding- Setting up ClickHouse configuration based on the characteristics of the machine (\"tuning\")- Deploying a database in Docker (+ Docker compose)3. MongoDB (different versions)- Development of collections, filling with documents (manual, dump)- Bug fixes and optimization of queries- Creation, editing, optimization of indexes- Deploying a database in Docker (+ Docker compose)- Working with geodata4. MS SQL Server (2008)- Development of tables, functions, procedures, jobs, etc- Bug fixes and optimization of SQL queries- Creation, editing, optimization of indexes- Full Text Search5. Python 3+- Writing various scripts (requests, aiohttp, multi-threading/processing, sharedtypes, logging)- Writing various scripts for testing / selecting / inserting data for databases (psycopg2, asyncpg, clickhouse-driver, pymongo)OTHER TOOLS:Greenplum, TimeScale, Redis, YDB, Tarantool, ElasticSearch, Sphinx, Manticore, Weaviate- Was the subject of research (complexity of deployment, capabilities, speed of basic operations, clustering possibilities)

Тольяттинский Государственный Университет

Магистр Компьютерных Наук