TIDB

Principal Software Engineer – Optimizer

TIDB

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Lead

Tech Stack

Distributed SystemsGoJavaLinuxRustSQLUnix

About the role

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

Requirements

  • 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.
Benefits
  • Medical, dental, vision insurance
  • 401k retirement plan
  • Flexible paid time off
  • Gym reimbursement
  • Employee referral bonus program
  • Awesome, supportive coworkers with a good sense of humor

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
database systemsquery optimizationcost-based optimizationquery rewritesjoin orderingcardinality estimationstatistics collectionconcurrencymultithreadingsynchronization primitives
Soft skills
technical leadershiparchitectural visionproblem-solvingimpact-driven