Mikhail Bystriakov Email & Phone Number

Объединенные Арабские Эмираты

Lead database object creation, migration, and management of 200+ production and over 600 total database instances, including MySQL, PostgreSQL, and ClickHouse, managing up to 20+TB databases. Implement MySQL partitioning to optimize storage and performance. Conduct performance analysis, query tuning, and security audits across MySQL, PostgreSQL, and ClickHouse.MySQL Administration: Manage diverse MySQL environments (InnoDB, TokuDB, Percona, MariaDB), ensuring high availability with replication, automated backups (Xtrabackup, Mysqlbackup), and custom solutions.PostgreSQL: Administer PostgreSQL databases, optimizing performance, backups, and supporting application integration.Kafka: Manage Kafka clusters for seamless data flow and optimized scalability for large-scale processing.ClickHouse: Administer high-performance ClickHouse databases, supporting real-time data processing and complex queries for financial applications.Kubernetes (K8s): Deploy and orchestrate MySQL, PostgreSQL, Kafka, and ClickHouse databases in Kubernetes environments, ensuring efficient resource management, scalability, and high availability.Python & PHP Automation: Develop custom automation, monitoring, and reporting scripts in Python and PHP, improving operational efficiency.Elasticsearch: Implement Elasticsearch for log aggregation, full-text search, and real-time monitoring, enhancing system insights and troubleshooting.Linux Environment: Manage Linux environments for database and application services (Nginx, Apache, ActiveMQ, Memcached). Automate maintenance tasks using shell scripts, cron jobs, and logrotate.Version Control & Monitoring: Integrate GIT for database version control and collaborate on code reviews. Monitor system performance with Icinga, Grafana, and Percona Monitoring Management, providing 24/7 on-call support.Agile Collaboration: Lead Agile collaboration across departments using Atlassian JIRA.

Москва, Москва, Россия

Led database object creation, migration, and management of databases up to 10+TB, implementing MySQL partitioning to improve storage efficiency. Conducted performance analysis, query tuning, and security audits across MySQL, PostgreSQL, and ClickHouse.MySQL Administration: Managed MySQL databases with various engines, including InnoDB, TokuDB, Percona, and MariaDB, ensuring high availability through replication and backup solutions like Xtrabackup, Mysqlbackup, and custom-built tools.PostgreSQL: Administered and optimized PostgreSQL databases, implementing backup strategies and performance tuning, and supporting application integration with the database.Kafka: Managed Kafka messaging systems, ensuring seamless data flow between applications and databases while optimizing Kafka clusters for scalability.ClickHouse: Administered ClickHouse databases, optimized for high-performance analytical queries, and supported large-scale data processing for financial transactions.Python & PHP: Developed custom scripts in Python and PHP for database automation, monitoring, and performance reporting, ensuring efficient database management and data retrieval.Elasticsearch: Implemented Elasticsearch for log aggregation and real-time monitoring, supporting full-text search functionality and enhancing data insights.Linux: Managed Linux-based environments for database servers and related services (Nginx, Apache, ActiveMQ, Memcached), automating server tasks with shell scripts, cron jobs, and logrotate.Integrated GIT into database development, enhancing version control and code review processes. Monitored server performance using Icinga, Grafana, and Percona Monitoring and Management, with 24/7 rotational on-call support across the full software stack.Agile Collaboration: Collaborated with cross-functional teams using Agile methodologies and Atlassian JIRA driving continuous improvement in database administration and software development processes.

Moscow, Russian Federation

At Alpari Limited, a leading FOREX broker in the Russian Federation with a global presence, I managed a dynamic environment of over 100 MySQL database servers, ensuring seamless operations across various international branches (Europe, India, China, etc.). Key responsibilities and achievements included:- Administered a diverse range of MySQL engines (InnoDB, TokuDB) and employed advanced replication strategies and logical data structures to optimize performance.- Led database object creation and migration initiatives, ensuring smooth transitions between databases and subsystems.- Conducted in-depth performance analysis and query tuning, utilizing tools such as pt-query-digest, while developing scripts to automate monitoring and reporting for quick issue resolution.- Integrated version control into database development using GIT and Atlassian Fisheye, facilitating thorough code reviews and collaborative development workflows.- Streamlined data backup processes by automating daily/hourly backups and implementing robust recovery solutions using tools like Xtrabackup, Mysqlbackup, and custom-built software.- Implemented user access security audits and query validations through MySQL-proxy and custom Lua/Python scripts, maintaining high-security standards across databases.- Managed large-scale databases (up to 1.5TB) and applied MySQL partitioning techniques to optimize storage and query performance.- Provided 24/7 on-call support for the full software stack, covering database servers, Nginx, Apache, ActiveMQ, Memcached, PHP, and Java-based applications.- Developed internal software solutions for administration panels and data visualization tools, supporting operational efficiency and strategic decision-making.- Played a key role in the AGILE development environment, collaborating with cross-functional teams through Atlassian tools (JIRA, Fisheye, Stash) and TeamWox.

Smolensk, Russian Federation

● Integrated, modernized and tested federal government program for health care among the population of Smolensk (~ 240,000 people). Launched the pilot project in the region.● Developed and maintained MySQL databases.● Made daily backups and reserve copy of databases.● Close integration with Microsoft Server 2008 R2 software and Hyper-V virtualization technology.● Developed network topology among branches of the organization. Fourteen remote offices with need to work with the real-time-changed data. ● Developed monthly reports to interact with five insurance companies based on raw existing data and using SQL (ETL scripts). ● Fixed logic errors in the current unstable version of integrated software.● Service maintained more than two hundred computers.● Contributed to technical documentation, and produced technical memos for released products.● Maintained excellent working relationships with medical stuff, financial, accounting departments and external organizations.● Made decisions of need of technical equipment, make plan for the annual purchase and modernization of existing equipment.● Developed and maintained of internal information exchange systems. Experience in PHP, MySQL, SOAP, XML, JSON.● Developed documentations of technical information protection and regulation.

Master'S Degree, Computer Engineering And Information Technology, 4.5

Bachelor'S Degree, Automated Information Processing And Management,, 4