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

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!


Apply now!


#BD-PRIO-2026