Query Engine Engineer (Apache Trino Internals) - Remote Work | REF#308568

BairesDev; Montenegro; Remote; BRL 657,000 - 986,000; Full time

Benefits offered by this job

Remote work

Home setup provided

Flexible hours

Parental leave

Paid vacations

Global team

Mentorship

Job summary

BairesDev is seeking a seasoned Query Engine Engineer to work on Apache Trino internals, including the planner, optimizer, and distributed execution at petabyte scale.

You will contribute production-grade code, debug and optimize internals, and collaborate with open-source communities while mentoring peers. This remote role offers flexible hours and a leading global team.

Qualifications

• 6+ years of software development experience.
• Strong Java skills.
• Experience with distributed systems and concurrency.
• Knowledge of SQL engine internals (planning, optimization, distributed execution).
• Database internals foundation beyond writing queries.
• Familiarity with JVM performance (GC, memory).
• Advanced level of English.

Responsibilities

• Contribute production-grade code to the Trino project (planner, execution engine, connectors).
• Debug and optimize Trino internals at enterprise scale.
• Improve performance and scalability for distributed SQL workloads.
• Profile and tune JVM behavior at engine level.
• Collaborate with cross-functional teams and open-source committers.
• Mentor senior engineers and participate in code reviews.

Skills

Java

Distributed systems

SQL engine internals

English (Advanced)

Tools

Kubernetes

PrestoDB/Trino ecosystem

Job description

At BairesDev®, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley.

Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant impact worldwide.

When you apply for this position, you're taking the first step in a process that goes beyond the ordinary. We aim to align your passions and skills with our vacancies, setting you on a path to exceptional career development and success.

Query Engine Engineer (Apache Trino Internals) at BairesDev

We are seeking a Query Engine Engineer with experience in Apache Trino internals to work on the engine itself, not SQL workloads that run on top of it. The work covers the query planner, optimizer, distributed execution framework, and connector architecture at petabyte and enterprise scale. The technology stack centers on the open source Trino project and adjacent ecosystem projects (Iceberg, Hive, Calcite, Parquet, ORC), with ample scope for upstream contribution. We're looking for engineers who have worked on engine-level code in Trino, Presto, or comparable distributed SQL engines, with a solid database internals foundation.

What You’ll Do

• Contribute production-grade code to the Trino project, particularly in the planner, execution engine, or connectors.
• Debug and optimize Trino internals — query planning, cost-based optimization, distributed execution, memory management and spilling, fault-tolerant execution — at enterprise scale.
• Improve performance and scalability of distributed SQL workloads in production environments.
• Profile and tune JVM behavior (GC, memory layout, concurrency) at the engine level.
• Collaborate with cross-functional engineering teams and open source committers on integrations and ecosystem work.
• Mentor senior engineers and raise the engineering bar through code reviews and design critiques.

What We Are Looking For

• 6+ years of experience in software development.
• Strong Java skills.
• Experience with distributed systems and concurrent or parallel programming.
• Working knowledge of SQL engine internals (query planning, optimization, distributed execution, or memory management).
• Database internals foundation: understanding how SQL engines work at the execution layer, not just how to write queries.
• Familiarity with JVM performance characteristics (GC, memory, threading).
• Advanced level of English.

Nice To Have

• Upstream contributions to Trino (merged PRs in planner, execution engine, or connectors); committer status is a strong plus.
• Experience with PrestoDB, Impala, or other federated query engines.
• Knowledge of vectorized execution and adaptive query optimization.
• Exposure to the lakehouse ecosystem (Iceberg, Hive, Calcite, Parquet, ORC).
• Kubernetes and cloud-native deployment experience.

How we do make your work (and your life) easier:

• Remote Work.
• Excellent compensation in USD or your local currency if preferred.
• Hardware and software setup for you to work from home.
• Flexible hours: create your own schedule.
• Paid parental leaves, vacations, and national holidays.
• Innovative and multicultural work environment: collaborate and learn from the global Top 1% of talent.
• Supportive environment with mentorship, promotions, skill development, and diverse growth opportunities.

Join a global team where your unique talents can truly thrive and make a significant impact!