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

BairesDev is a leading technology company that delivers innovative solutions to major clients like Google and startups in Silicon Valley. They are seeking a Query Engine Engineer to work on the internals of Apache Trino, focusing on the query planner, optimizer, and distributed execution framework at enterprise scale.

Responsibilities:

• 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

Requirements:

• 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
• 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