Senior Query Optimizer Software Engineer

closed
Logo of Voltron Data

Voltron Data

πŸ’΅ $175k-$210k
πŸ“Remote - Worldwide

Job highlights

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
This job is filled or no longer available