What are the responsibilities and job description for the Senior Software Engineer for Query Optimizer position at Quanta Search?
Our client is a community-developed, commercially supported fork of the MySQL relational database management system, making a huge impact on the world.
Xpand is the distributed SQL offering of the Client and is solving one of the most difficult open problems in the software database industry today: scaling transactional workloads. They’ve built our own distributed relational database from the ground up and integrated with MariaDB. Now they are looking for smart and motivated folks to join a small team of developers and take this technology to the next level. They work on:
- C codebase with a custom standard library
- Database fundamentals: B-trees, logging, and recovery, MVCC
- A rule-based, cost-based query planner with top-down optimization similar to Cascades Framework
- An MPP, distributed database with unique query planning challenges that are more complicated (and more interesting) than a single node database
Qualifications
You should be someone with 3 years of experience with query planner development and:
- An understanding of table statistics and cardinality estimation
- Familiarity with the top-down query optimization framework
- Experience with cost modeling
- Experience with development of analytics features for SQL