Photo

Alexander Avchinnikov

Database administrator

Adept database administrator with 4+ years of experience. Skilled in MySQL/MariaDB. Confident knowledge of Linux. Proficient in programming.

Work experience

2022 -
present

Team lead
Greenatom
  • Managed the MySQL admin team. Trained new employees to work in Linux and MySQL. Conducted interviews with candidates for the team.
  • Developed a training system for new employees (VirtualBox, Linux, MySQL, Bash).
  • Participated in research and seminars (MySQL tuning performance, Front-end development tools). Prepared technical specification and instructions.
  • Conducted an audit of DBMS and identified performance issues. Performed troubleshooting.
  • Provided on-call support for DBMS. E.g., data recovered from backup, resolved production issues, tuned performance.

2018 -
2022

Database administrator
Greenatom
  • Administered MySQL, MariaDB, PostgreSQL and RedDB (Firebird) servers.
  • Performed tuning of DBMS performance (including using MySQLTuner), monitoring and troubleshooting.
  • Configured ProxySQL and failover clusters (master/slave, master/master). Tested configurations on VirtualBox and VMware.
  • Wrote scripts in Bash. E.g., monitoring of DBMS metrics that are not available in zabbix, creating DB backups and deleting old copies, generating strong passwords. Using my scripts accelerated the execution of routine tasks by about 5 times.
  • Developed corporate web application for registration of a pass (HTML, CSS, JS, Vue.js).

2014 -
2018

System engineer
A&B Company
  • Administered Windows, MS SQL, 1C, Mail, FTP.
  • Deployed and hosted databases on servers.
  • Troubleshot software and operating system.
  • Developed company websites (HTML, CSS, PHP, Bitrix, WordPress).
  • Supported internal and external customers: database backup and recovery, updated 1C-configuration.

Side projects

2021 -
2022

Participated in the development of CRM
HTML, CSS, JavaScript, Node.js, MySQL

May
2020

Developed a website for a law firm
HTML, CSS, JavaScript, Apache

May
2014

Developed software for microcontrollers
C, C++

Certifications

Jul
2021

RedDatabase Administrator
Red Soft

RedDatabase is based on Firebird. Key skills: DB backup and recovery, DBMS performance monitoring, creation of a failover cluster.

Feb
2017

Operation of information systems
1C Company

Administration of Windows operating systems and MS SQL DBMS, searching for bottlenecks in the hardware and software of the server.