At a Glance
- Tasks: Contribute to the Trino project and optimise query execution at enterprise scale.
- Company: BairesDev, a leader in tech solutions for top companies worldwide.
- Benefits: Remote work, flexible hours, competitive pay, and excellent growth opportunities.
- Other info: Mentorship and career development in a diverse, innovative environment.
- Why this job: Join a global team and make a real impact in cutting-edge technology.
- Qualifications: 6+ years in software development with strong Java and distributed systems skills.
The predicted salary is between 60000 - 72000 £ per year.
At Baires Dev®, 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 Baires Dev
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 Presto DB, 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!
#J-18808-Ljbffr
Query Engine Engineer (Apache Trino Internals) - Remote Work | REF#294406 employer: BairesDev
BairesDev is an exceptional employer that champions a flexible and inclusive work culture, allowing you to excel as a Senior Java Engineer from the comfort of your home. With a strong emphasis on employee growth and development, you will have access to diverse projects in a multicultural environment, making your contributions to the observability platform both meaningful and rewarding.
StudySmarter Expert Advice🤫
We think this is how you could land Query Engine Engineer (Apache Trino Internals) - Remote Work | REF#294406
✨Join Developer Communities!
Dive into online communities like GitHub or Stack Overflow. Contributing to open-source projects can really showcase your coding skills and catch the eye of hiring managers at companies like BairesDev.
✨Attend Tech Meetups and Hackathons
Get your name out there by attending local tech meetups and hackathons. It's a perfect way to network with industry professionals and fellow interns, while also demonstrating your coding prowess in a collaborative setting.
✨Leverage University Career Services
Don't forget about your university's career services! They often have partnerships with companies like BairesDev, and can help you access exclusive internship listings and workshops tailored for aspiring interns like us.
✨Show Off Your Work
Create a portfolio showcasing your coding projects on a platform like GitHub Pages or personal website. When applying for internships, we should link this to provide tangible proof of our skills and creativity, making us stand out to BairesDev!
We think you need these skills to ace Query Engine Engineer (Apache Trino Internals) - Remote Work | REF#294406
Some tips for your application 🫡
Show Off Your Side Projects:If you've got any side projects or contributions to open source, make sure to highlight them in your CV. We want to see what you can create! Include links to your GitHub or any relevant platforms to give us a taste of your coding style and skills.
Tailor Your CV for Software Engineering:Make your CV pop by tailoring it specifically for software engineering. List relevant programming languages, frameworks, and tools you’ve worked with, and showcase any tech stacks you're familiar with. This will help us quickly see how you fit into the BairesDev team!
Let Your Passion Shine in Your Cover Letter:In your cover letter, don't just list your skills—tell us why you're passionate about software engineering! We love to see candidates who are eager to learn and grow, so share what excites you about this field and how a role at BairesDev can help you on your journey.
Demonstrate Your Learning Mindset:As this is an internship, focus on your willingness to learn and adapt! We’re keen to see examples of how you’ve tackled challenges or learnt new skills in the past. Bring that eagerness to your application, showing us that you're ready to dive into a real-world software environment at BairesDev!
How to prepare for a job interview at BairesDev
✨Showcase Your Coding Skills
Since you're aiming for a software engineering internship, be ready to code on the spot or discuss your past projects. Brush up on your problem-solving skills, and practise coding challenges on platforms like LeetCode or HackerRank. We want to see how you approach problems and apply your knowledge, so having a few coding examples up your sleeve will definitely help!
✨Bring Your Portfolio to Life
Prepare a portfolio that highlights your coding projects—don't just list them! Be ready to explain your thought process, the technologies used, and any challenges you faced. It’s not just about the final product; we want to hear how you made it happen, so this narrative will show your depth of understanding and passion for software development.
✨Get Familiar with Technical Questions
Expect some technical questions or scenarios in the interview that assess your understanding of algorithms, data structures, and software design. Practise explaining your coding decisions clearly—it's less about getting the right answer and more about demonstrating your thought process and reasoning skills, which are crucial for growth in an internship.
✨Highlight Your Willingness to Learn
As an intern, your enthusiasm and eagerness to learn are key! During the interview, emphasise your willingness to tackle new challenges and pick up new skills. Companies like BairesDev are often looking for candidates who can grow with them, so remind us why you're excited about opportunities to learn and contribute in a team environment.
