PHP developer(Laravel), MySQL(Percona)

Required developer with experience of 3 years in command of our product: site statistics.
Development and product support is conducted remotely distributed team of 4 people, using Agile methodologies.
The product was on the market in 2018 on a free basis. From 2019 added a paid subscription and at the moment we are the leaders in the market.

Payment from 7 to 15 $/hour
Schedule: 4 hours a day, weekends sat and sun.

Skills required:
- 7 PHP(Laravel)
- MySQL(Percona server)
- Redis(server queue)
- experience with Unix(Debian)
- ability to handle tasks in the background (cron)
- reading and understanding someone elses code
- code refactoring
- create a simple and optimal solutions to complex problems
- sociability and openness
- knowledge of algorithms and experience with the use of patterns
- experience developing REST API
- ability to design complex SQL queries
- experience with a relational database
- experience with MVC frameworks, namely Laravel
compliance with the recommendations of the PSR
- knowledge VueJs Vuex
- understanding how indexes work, the ability to predict the load on the database and optimize queries
- knowledge of regular expressions, also the pros and cons of their use
- using Git

Desirable skills:
- experience in code coverage tests
- experience with Docker, CI, CD
skills system administration
- experience with Apache/Nginx
- experience of working with Kubernetes
- deploy Docker containers in AWS
- designing the database in ClickHouse, or similar analytical DBMS
- understanding and competent application of the principles of SOLID
- experience of developing in a scrum team

Brief description of the technical tasks:
Processing a large number of logs and the results of these data and their combinations on the website. At the moment the server is running debian have a working 9 database mysql(percona), which cope with the current needs, but has limitations when adding new statistics(combination data from the logs). Restrictions are necessary, re-process the files(about 1TB) with logs and put the data into the database, which takes a lot of CPU time.