TiDB, powered by PingCAP Logo

TiDB, powered by PingCAP

Principal Software Engineer - Optimizer

Reposted 3 Days Ago
Easy Apply
Remote
Hiring Remotely in United States
Expert/Leader
Easy Apply
Remote
Hiring Remotely in United States
Expert/Leader
The Principal Engineer will lead the architectural vision for the TiDB optimizer, focusing on query optimization and enhancing the performance of the TiDB database, employed by large organizations globally.
The summary above was generated by AI

Join us as we scale our business by building on our tremendous success around the world. The massive database market is going to double over the next few years and TiDB is a global player positioned as a major disruptor with TiDB Database and Database as a Service offering. TiDB is an open-source, cloud-native, distributed SQL database for elastic scale and real-time analytics. Large and high-growth organizations in markets as varied as financial services, logistics, gaming, e-commerce and software as a service have successfully deployed and expanded their TiDB footprint on mission-critical applications. Our strong open-source community roots (39,500+ stars on GitHub), innovative products and inclusive culture draw passionate and dedicated people to our company. Learn more about TiDB careers and join our team to be at the forefront of innovation and growth.

 
Role Overview
As a Principal Engineer on the TiDB Optimizer team, you will be a key technical leader responsible for the architectural vision and execution of our query optimization engine. Your work will directly impact the performance, reliability, and predictability of one of the most critical components of the TiDB database. You will tackle deep and complex challenges in query planning, cost-based optimization, and adaptive processing to ensure TiDB remains a world-class distributed SQL database for our global users. This is a high-impact role that offers the opportunity to shape the future of data infrastructure for thousands of companies.
 
Responsibilities 
  • 10+ years of experience in software development with a proven track record of designing, building, and shipping complex database systems or data-intensive distributed systems.
  • Extensive hands-on experience in the design and development of a database query optimizer (e.g., cost-based optimization, query rewrites, join ordering, cardinality estimation, statistics collection).
  • Strong expertise in concurrency, multithreading, and synchronization primitives.
  • Fluency in one or more of the following: C, C++, Go, Rust, or Java.
  • Experience developing in Unix/Linux environments.
 
Qualifications
  • Familiarity with existing query optimizer frameworks like Apache Calcite or GPORCA.
  • Practical experience with other database or data processing technologies such as Oracle, SQL Server, PostgreSQL, MySQL, Flink, or Spark.
  • Tackle some of the most challenging problems in distributed databases and query optimization.
  • Your work will be critical to the performance of thousands of TiDB clusters worldwide.
  • Join a world-class team of database kernel engineers and be a recognized technical leader.
  • Contribute to a leading open-source project with a vibrant and active community.

We encourage people from underrepresented groups to apply. Come advance with us! In keeping with our values, no employee or applicant will face discrimination/harassment based on: race, color, ancestry, national origin, religion, age, gender, marital domestic partner status, sexual orientation, gender identity, disability status, or veteran status. TiDB also strives to prevent other, subtler forms of inappropriate behavior (e.g., stereotyping) from ever gaining a foothold in our organization. Whether blatant or hidden, barriers to success have no place at TiDB.

Top Skills

Apache Calcite
C
C++
Flink
Go
Gporca
Java
Linux
MySQL
Oracle
Postgres
Rust
Spark
SQL Server
Unix

Similar Jobs

2 Minutes Ago
Easy Apply
Remote or Hybrid
US
Easy Apply
238K-328K Annually
Expert/Leader
238K-328K Annually
Expert/Leader
Marketing Tech • Social Media • Software • Analytics • Business Intelligence
The Vice President of Revenue Marketing will lead global demand generation, optimize marketing strategies, and drive revenue growth by managing multi-channel marketing efforts and high-performing teams.
Top Skills: AeoConversion Rate OptimizationDigital MarketingEmail MarketingGeoGrowth MarketingMarketoPerformance MarketingProgrammatic MarketingSalesforceSeoWeb Strategy
An Hour Ago
Easy Apply
Remote
United States
Easy Apply
165K-205K Annually
Senior level
165K-205K Annually
Senior level
Fintech • Insurance • Machine Learning • Other • Analytics • Financial Services • Automation
The Staff Product Design Engineer will lead the development of Pie's Design System, blending engineering and design to create scalable user interfaces. Responsibilities includearchitecture ownership, component development, integration of AI tools, and documentation, ensuring usability for all teams.
Top Skills: AICi/CdFigmaGitJavaScriptReactStorybook
An Hour Ago
Remote
United States
139K-244K Annually
Senior level
139K-244K Annually
Senior level
Artificial Intelligence • Cloud • Consumer Web • eCommerce • Information Technology • Software
The Lead Software Engineer will define and implement the technical vision for backend solutions, oversee project execution, and mentor team members while focusing on scalability and high availability in a data-intensive SaaS platform.
Top Skills: DockerGCPGoJavaMemcachedMySQLOtelPHPPythonRedis

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account