Senior Software Engineer, Query Optimization

About the role

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. 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. This role can be based remotely in the U.S. or Canada, limited to Eastern or Central time zones only.

Responsibilities

• Innovate in the area of flexible schema databases and help build a world-class query optimization system.
• Research state-of-the-art query systems to inform design.
• Leverage deep knowledge of the product’s strengths and weaknesses and industry trends to provide technical vision and direction.
• Set initiative-level strategy, architect plans, and lead the team towards successful execution.
• Advise and partner with management on roadmap decisions, processes, and architectural designs.
• 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.
• Work with other engineers to coordinate seamless changes in a feature-rich, large code base.
• Work with other teams including client drivers, cloud services, enterprise tools, support, consulting, education, and marketing to coordinate changes or contribute to their projects.
• Influence and grow team members through active mentoring, coaching, and leading by example.
• Within three months, contribute to development of a project slated for the next major version and fix a few bugs in a minor version of the latest stable release; learn about MongoDB's project lifecycle and long-term goals.
• Within six months, take on code review responsibilities and play an active role in drafting and reviewing the design for new features; expand the team's horizons by presenting a favorite paper or system architecture related to query systems.
• Within twelve months, contribute to the long-term technical roadmap of the MongoDB Query team based on extensive past experience in the query space.

Requirements

• 5+ years of experience in data management systems, distributed systems, or large-scale backend engineering.
• Experience with building