Senior PHP Engineer; strong DB

Senior Php Engineer

Intetics Inc., a global technology company providing custom software application development, distributed professional teams, software product quality assessment, and "all-things-digital" solutions, is seeking a highly skilled and experienced Senior PHP Engineer to join our dynamic team.

The client is a leading company specializing in advanced cybersecurity solutions. They provide comprehensive security measures designed to protect sensitive data and systems from cyber threats. Their offerings include vulnerability management, threat intelligence, incident response, and compliance management. With cutting-edge technology and a team of experts, they ensure robust protection for organizations across various industries, helping clients stay ahead of evolving cyber threats and maintain a secure digital environment.

About the project:
The only Risk-Based Vulnerability Management Platform purpose-built for the world's most complex enterprises.

This role is intended to be at the platform level, so "focus on data" in this context means -

• Understanding the interaction between code and the database.
• Understanding the interaction between code and our data. Our data isn't necessarily unique, but we deal with data at a large scale on a legacy codebase, and we need somebody who can come on-board and identify or prevent:
• Code that suffers from off-by-one errors
• Code that suffers from unnecessary exponential-time (O(n^2)) issues or is generally non-performant
• Code that runs fast at a small scale but doesn't run fast at a large scale, or vice versa
• Writing performant queries and best implementing the code to execute them.
• Ability to audit existing queries and recommend improvements either to the query itself or to the code. For instance, maybe it's better to split a single query into two separate queries, execute them separately, and then write code to utilize the result sets together instead of doing a larger, slower, single query.
• Understanding how the code and queries will scale together, and how they will continue to be performant as we continually increase the data by factors of 10.
• Creating databases and recommending logical sort and shard keys as well as indexes. Understanding conceptually what these things mean and how to apply them.
• Auditing or reviewing existing tables and recommending schema/architecture improvement