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)