Alexander Avchinnikov

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.

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).

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.

Participated in the development of CRM

HTML, CSS, JavaScript, Node.js, MySQL

Developed a website for a law firm

HTML, CSS, JavaScript, Apache

Developed software for microcontrollers

C, C++

PostgreSQL 10 Administrator. Advanced course

Computer Training Center «SibInfoCenter»

Advanced PostgreSQL administration: locks, multi-version concurrency control, logging.

PostgreSQL 10 Administrator. Basic course

Computer Training Center «SibInfoCenter»

Basic PostgreSQL administration: DBMS monitoring, database backup, replication setup.

RedDatabase Administrator

Red Soft

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

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.

The rest of certifications are on Linkedin and my website.