Senior Query Optimizer Software Engineer

Summary

The job is for a Senior Query Optimizer Software Engineer at Voltron Data. The role involves working closely with the development team to build and maintain a SQL parser and query optimizer for large scale single node and distributed query execution engines. The company values impact, open source communities, and diversity.

Requirements

• Familiarize with Apache Arrow compute primitives, compute intermediate representation, compute engine, and other foundational components
• Learn and embrace the Apache development process
• Within a month: Become familiar with Voltron Data’s SQL parser and query optimizer, benchmark queries, make changes to existing query optimization rules, etc
• Within 6 months: Add new query optimization rules, improve decision making in the cost based optimization, integrate non-SQL operations, etc
• Within 12 months: Propose and implement improvements to the query parsing and optimization framework, integrate with a stateful inter-query query engine context, etc

Responsibilities

Build and maintain a SQL parser and query optimizer for large scale single node and distributed query execution engines

Preferred Qualifications

• Previous experience that could be helpful: Building and/or using open source query optimization frameworks like Apache Calcite, Apache Spark Catalyst, Postgres Query Optimizer, and/or others
• Developing in C++, especially using modern C++
• Utilizing serialization libraries like FlatBuffers, Protobuf, Thrift, MessagePack, and/or others
• Working on non-SQL systems and non-SQL computational abstractions

Benefits

• Work from Anywhere - Payroll and Benefits in 150+ Countries
• Unlimited PTO
• Medical, Dental, and Vision
• [USA Only] Retirement
• Home Office Budget
• Continuing Education Budget