Team Lead DBA / Database Architect

- Technologies in descending order of activity: PostgreSQL, ClickHouse, MongoDB, Greenplum - Interaction with development teams in the context of a database (consulting, training, reviews, optimization of application performance) - Backlog formation, priority management, setting goals, and implementation control - Analysis of incidents and elaboration of solutions to minimize them - Development of documentation on topics: database operation, approaches to performance optimization

- Online database migrations on the Postgres installations with 400K+ tables, 1M+ indexes, 8TB+ and 15K tx/sec using https://github.com/masterlee998/db_converter - Design and refactoring the architecture of existing databases (londiste, pglogical, fdw, schemas, tables, indexes) - Developers mentoring in the DB context (query optimization, caching) - Automation of deployment of monitoring tools for databases (SaltStack, GitLab CI/CD Pipelines) - Development of the high availability PostgreSQL cluster on Patroni (HAProxy, etcd, Postgres 12, pgbouncer) with autotests https://github.com/masterlee998/pg_cluster

- Developers mentoring in the DB context - Collaborate with multiple dev teams - Optimizing the performance of Java SE 8 applications interacting with the PostgreSQL - Development of tool for database anonymization (Python 2.X) - Development of tool for measuring of database coverage during unit testing (Jenkins with Groovy Pipelines, Python with Tornado and WebSockets, HTML5, CSS3, JavaScript) - Development of HA PostgreSQL cluster in Kubernetes (k8s, helm, PostgeSQL 10, Docker, Fluentd, ELK, Clojure + Jepsen)

окт. 2013 – апр. 2017 Продолжительность трудоустройства 3 г. 7 мес. - Developers mentoring in the DB context - Hardware resource planning, forecasting load growth - Development of advanced monitoring and notification tools - Designing the database structure (jsonb, cstore_fdw, ltree, partitioning, schema generation, postgres_fdw) - Optimization of SQL queries - Optimization of DB configuration https://github.com/masterlee998/pg_configurator/blob/master/pg_configurator.py - Automating data backups and server maintenance using Python 3.X (up to 10 hardware servers) - Upgrading instances of PostgreSQL 9.2 -> 9.3 -> 9.4 -> 9.5 -> 9.6 - PostgreSQL maintenance using Python 3.X (reducing bloat of the heap/index, balancing of autovacuum) - Custom data replication using PL/pgSQL (ETL) - Hardware RAID configuring, OS and PostgreSQL performance tuning - Deployment CentOS 6, 7 - KVM deployment - Network security management (firewall rules, attacks diagnostics)

Ярославская область, Россия - Participation in the development of the platform core (C++, Python) - Development business logic on C++ language: C++11, stl, boost, boost::python, boost::multithreading, smart pointers (from boost, stl), boost::mpl, boost::filesystem, boost::thread - Development ORM for PostgreSQL using C++11 - Participation in the development of tool for multi-threaded database conversion (C++11) - Writing scripts on Python 3.X to execute of various application tasks - Development of database changes logging (triggers, PL/pgSQL, hstore) - A number of full-stack tasks (JavaScript)

- Deployment and maintenance Windows Server 2008, 2012 (AсtiveDirectory, Apache, IIS) - Development simple apps with web interface using HTML, ASP, VB - APACS 3000 configuring - Participating in hardware procurement (market research, comparison of solutions)