Andrei Zhidenkov, Developer in Berlin, Germany
Andrei is available for hire
Hire Andrei

Andrei Zhidenkov

Verified Expert  in Engineering

Software Developer

Berlin, Germany

Toptal member since June 18, 2020

Expertise
PostgreSQLSQLPythonLinuxFlaskAlgorithmsGitMySQLDockerKubernetesAnsible
Bio

Andrei has more than 14 years of professional experience in database design. He began working in Oracle and later migrated to PostgreSQL. He uses Python and Bash to write scripts and back-end services and GNU/Linux as an operating system for business and personal purposes. When designing databases, Andrei sees the big picture and he pays close attention to small details.

Portfolio

N26 GmbH
Python, MySQL, PostgreSQL
Lazada
Kubernetes, Docker, PostgreSQL
AT Consulting LLC
Ansible, Bash, Python, Docker, PostgreSQL

Experience

  • SQL - 15 years
  • Git - 10 years
  • Python - 10 years
  • Linux - 10 years
  • PostgreSQL - 8 years
  • Bash Script - 7 years
  • Flask - 7 years
  • REST - 7 years

Availability

Part-time

Preferred Environment

Bash, Vim Text Editor, Git, PostgreSQL, Linux

The most amazing...

...database I've developed was a PostgreSQL as a service project for one of the largest eCommerce platforms in Southwest Asia serving millions of customers daily.

Work Experience

Senior Data Engineer

2019 - PRESENT
N26 GmbH
  • Designed a new version of the provisioning and auditing system for this German online bank using PostgreSQL.
  • Maintained more than 100 database instances for scheduled upgrades, problem-solving, and 24/7 on-call support.
  • Wrote code for maintenance automation using Python and Amazon RDS API.
  • Advised developers and reviewed many database schemas to make them more performant in a high-load environment.
  • Designed a database architecture to store and search quickly among millions of transactions using several criteria.
Technologies: Python, MySQL, PostgreSQL

Principal Data Engineer

2018 - 2019
Lazada
  • Designed and launched a PostgreSQL as a service project for Lazada, one of the largest eCommerce platforms in Southwest Asia.
  • Developed a zero-downtime PostgreSQL upgrade process.
  • Configured instruments for database load and query monitoring using Prometheus, Grafana, and pgBadger.
  • Reduced the number of incidents in database clusters, improved the security posture, and decreased maintenance overhead.
Technologies: Kubernetes, Docker, PostgreSQL

Senior Database Developer

2015 - 2018
AT Consulting LLC
  • Developed the database architecture for a large state project that involved the implementation of sharding and replication using pglogical and streaming.
  • Set up streaming and logical replication for failover and integration with other database systems.
  • Created Docker containers with applications and databases for local development and testing.
  • Set up a database backup mechanism for all project databases.
  • Analyzed user requirements and identified limitations and opportunities for the expansion of existing systems.
  • Created database schemas (UML diagrams) and wrote SQL scripts for database deployments.
  • Designed a data quality control module for a project that minimized inconsistencies while data is loaded from external sources.
  • Set up an SQL migration mechanism for roughly 300 database instances.
Technologies: Ansible, Bash, Python, Docker, PostgreSQL

Senior Database Developer

2012 - 2015
CoMagic
  • Optimized slow queries to enhance site performance.
  • Improved order-processing algorithms and troubleshot system errors and database performance issues.
  • Moved back-end logic to stored procedures to increase system performance.
  • Developed a database architecture for the CRM using PostgreSQL.
  • Created a reporting module for CoMagic's web analytics system.
  • Built custom utilities that assist in the development process (code versioning) using Python, Bash scripting, Flask, and uWSGI.
Technologies: Bash, Python, PostgreSQL

Experience

PostgreSQL as a Service

http://www.lazada.com
I delivered PostgreSQL as a service to developers. The service includes replication, automatic failover, and a 99.9999% database availability guarantee. The project reduced database preparation time from several hours to several minutes, and service level agreements allowed developers to understand how to better set up and configure their applications.

Real Estate Registry

This is a huge distributed database for the Russian government that stores information about all real estate in Russia. It stores more than 6 PB of data and uses PostgreSQL as a relational database engine. I also developed a technology to perform map-reduce queries on this database.

Education

2001 - 2007

Master's Degree in Space Engineering

Bauman Moscow State Technical University - Moscow, Russia

Skills

Libraries/APIs

Matplotlib

Tools

Ansible, Git, GitLab, GitLab CI/CD, Vim Text Editor

Storage

PostgreSQL, MySQL

Languages

Python, SQL, Bash Script, Bash

Frameworks

Flask

Platforms

Linux, Docker, Kubernetes

Paradigms

REST

Other

Document Parsing, Regular Expressions, Algorithms, Bots

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring