PHP

What steps do you take if you discover a failure in a service in the production environment?

Do you have experience working with PHP version 8?

Junior — Middle

МТСАлгоритмикаFMF

What methods can be used to identify and correct errors in statistical data that occur when using the Explain command?

How do you perceive the use of traits in programming?

Junior — Middle

МТСАлгоритмика

Which version of MySQL was used in your project or work experience?

Should you update the current PHP version from 7.x to PHP 8.x in your project?

Explain what the EXPLAIN command does in SQL queries.

Have you ever written complex SQL queries or database queries?

How to implement a method for calculating discounts based on a specific user?

Have you encountered projects where teamwork was necessary?

How to extend the structure of a heavily used database by adding a new column?

Have you had experience working with columns that are automatically created during data processing?

How does monolithic service architecture differ from microservices structure?

Are traits a violation of SOLID principles?

Explain your experience in improving the performance of complex SQL queries

Can you tell what process you followed in your work?

How was the application release carried out in the working environment?

Have you had a task in the form of a list of tasks to be completed at your previous job?