Senior Software Engineer, Query Optimization

<p>Join the MongoDB Server Query Optimization team, and help us build a world-class distributed open-source query optimizer. Our team plays a crucial role in the experience and performance of data processing. We are responsible for the MongoDB Query Language and the lifecycle of each query, through parsing, optimization and plan selection.</p> <p>We have tons of interesting problems to solve with a direct impact on users for transactional, time-series, and analytical workloads. The team is endeavoring to systematically rewrite every major component of our optimization and execution systems. We need your help to design and build the heart of a distributed, flexible schema, document database.</p> <p><em>This role can be based remotely in the U.S. or Canada, limited to Eastern or Central time zones only.</em></p> <h3>Candidate Profile</h3> <ul> <li>5+ years of experience in data management systems, distributed systems, or large-scale backend engineering</li> <li>Experience with building production-level code with a large user base, robust design structure and rigorous code quality</li> <li>Degree in Computer Science or similar field, or equivalent practical experience, with strong competencies in data structures, algorithms, and software design/architecture</li> <li>Experience with large code bases written in C++ or another systems programming language. You'll need to trace down defects, estimate work complexity, and design evolution and integration strategies as we rewrite different components of the system</li> <li>A strong foundation in core database internals is essential. While direct experience in query optimization is a massive bonus, it is not a prerequisite. We are also excited to meet candidates with strong backgrounds in compilers, language transpilers, or distributed storage systems</li> </ul> <h3>Position Expectations</h3> <ul> <li>Innovate in the area of flexible schema databases. Help us build a world-class query optimization system</li> <li>Research state-of-the art query systems to inform our design</li> <li>Leverage deep knowledge of the strength and weakness of the product and of industry trends to provide technical vision and direction&nbsp;</li> <li>Set initiative level strategy, architect plans, and lead the team towards successful execution</li> <li>Advise and partner with management on roadmap decisions, processes, and architectural designs</li> <li>Identify, design, implement, test, and support new features related to query performance and robustness, query language enhancements, diagnostics, and integration with other products and tools</li> <li>Work with other engineers to coordinate seamless changes in a feature-rich, large code base</li> <li>Work with other teams including clie