Team Lead DBA / Database Architect
Резюме обновлено 3 года назад

Team Lead DBA / Database Architect

6 000 руб.
Занятость:
График работы:

Опыт работы

Ноябрь 2019 —
март 2021
1 год 4 месяца
Сбербанк
DBA Team Lead
- 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
Ноябрь 2018 —
ноябрь 2019
1 год
Calltouch
DBA Team Lead/ Performance Engineer
- 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
Апрель 2017 —
декабрь 2018
1 год 8 месяцев
Ingram Micro
Senior Software Developer
- 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
4 года 3 месяца
devtodev
PostgreSQL DBA
окт. 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)
Май 2011 —
январь 2013
1 год 8 месяцев
Тензор
Senior Software Developer
Ярославская область, Россия

- 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)
Сентябрь 2010 —
май 2011
8 месяцев
JDC - Gas Turbine, Inc
Network System Administrator
- 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)

Обо мне

I have 9+ years of experience in PostgreSQL administration, performance tuning, in-depth knowledge of tools and techniques for analyzing and benchmarking operating systems, application/algorithm performance. I also have experience in C++ development for about three years.
I can help your company to build an incredible product that will run with the best performance.

My github: https://github.com/masterlee998

Also the last 5 years I develop tools for monitoring and maintenance of PostgreSQL.

Образование высшее

2009
Ивановский государственный энергетический университет им. В.И. Ленина, Иваново (Ивановская область)
ЭМФ, промышленная электроника

Знание языков

Русский — родной
Иностранные языки
АнглийскийA1 — Начальный

Гражданство, время в пути до работы

Гражданство: Россия
Разрешение на работу: Россия
Желательное время в пути до работы: Не имеет значения
Есть вопросы?
По техническим вопросам в работе сайта вы можете написать на почту tech@step-ler.ru