BairesDev
Query Engine Engineer (Apache Trino Internals) - Remote Work | REF#294406
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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!
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location