MySQL/PHP Application Developer

Permanent work
Full-time

An information agency specializing in financial markets requires MySQL/PHP Application Developer. The format of work is remote, but it will be necessary to visit the office in St. Petersburg or Yerevan once in 3 months.


Responsibilities:

  • Participation in the design of the database, projections for data showcases (sites), development of replicators to keep projections up to date.
  • Maintaining and developing the database operations layer, which is further utilized by other teams.
  • Optimization of complex SQL queries working with large amounts of data to increase performance;
  • Support and development of the project to organize data delivery to clients (data feeds);


Requirements:

  • Strong understanding of relational database design principles, knowledge of SQL (MySQL 8+) and its features (CTE, window functions, triggers, etc.);
  • Experience and understanding of SQL query optimization principles;
  • Strong knowledge of PHP 7.4+, OOP principles, design patterns;
  • Experience as a PHP backend programmer for 5+ years;
  • Experience with GIT;
  • Desire to work in a team;


Will be a plus:

  • Experience working with highload projects and optimizing database structure and SQL queries to increase performance;
  • Experience working with noSQL stores (MongoDB).