Database Engineer — Postgres Internals
Remote/San Francisco
Full Time
4 days ago
Senior LevelEngineeringWorldwide
$80K - $120K

USD per year

Job Description

What we do

  • ParadeDB is a transactional alternative to Elasticsearch built on Postgres.
  • Builds state-of-the-art full-text search and columnar analytics as a Postgres extension.
  • Used by companies like Modern Treasury, BILT Rewards, Alibaba Cloud, and UnifyGTM to:
  • Eliminate ETL/change data capture tools
  • Add transactional guarantees to their search indexes
  • Perform JOINs on their search data
  • Small, focused engineering team with an office in San Francisco and distributed members across the US and Canada.
  • Series A company with flat structure, strong investors, and room for growth.

What we want

  • Postgres database internals engineer to join full-time.
  • Requirements:
  • Solid foundation in data systems/database internals
  • Experience with Postgres database internals (bonus: experience with pgrx)
  • Proficiency in systems programming with C/C++/Rust/Zig (bonus: Rust)
  • Strong background in full-text search systems and/or data analytics/query engines is a plus
  • Familiarity with Tantivy and/or OLAP query engines like Apache DataFusion is a plus
  • Candidate should be creative, independent, excited by technical challenges, able to teach and learn from the team.
  • Should bring thoughtful opinions, engage with customers, and be willing to wear many hats.

What you want

  • To be part of the core team of a fast-growing infrastructure startup.
  • To wear many hats and interface directly with customers.
  • Passionate about Postgres ecosystem, databases, search technologies, and/or data analytics.
  • Excited about diving deep into Postgres internals and writing high-performance safe Rust code for search and analytical workloads.
  • Interested in learning about internals of Tantivy, Apache DataFusion, columnar file formats like Parquet/Arrow for optimizations in ParadeDB.
  • Believe in open-source and want to contribute to building sustainable open-source business.
  • Desire autonomy over work and opportunity for impactful design decisions.

What you've done

  • Meaningful experience working with Postgres internals (core contributions or high-quality extensions).
  • Prior experience working on complex data systems in Rust, C++, C or Zig; able to navigate complex codebase (bonus: open-source contributions).
  • Architected data system(s) focusing on performance, scalability, maintainability (bonus: Rust).
  • Optimized/debugged complex systems using profiling tools.
  • Prior experience at small high-performing startup.
  • Smart, hardworking, communicative, open to learning new services/frameworks.

What you'll do

  • Develop/optimize ParadeDB Postgres extension implementing features interfacing with block storage, query planner/executor, index definition using Postgres APIs via pgrx.
  • Work with internals of Tantivy; modify Tantivy as needed for new features within ParadeDB extension.
  • Design/implement efficient data structures/algorithms for search/analytical functions inspired by or using Tantivy/DataFusion.
  • Optimize query performance/resource utilization using profiling tools.
  • Develop/maintain documentation including API references/user guides.
  • Engage directly with customers/open-source community on GitHub and Slack.
  • Contribute to technical writing, product demos, content marketing.
  • Help shape ParadeDB's product roadmap and technical direction.

To apply: Send resume and materials to founders@paradedb.com. ParadeDB encourages candidates of all backgrounds; accommodations available upon request at accommodations@paradedb.com.

How to Apply
About ParadeDB

A small, focused team building a Postgres-native alternative to Elasticsearch. The team is distributed across the United States and Canada and is passionate about data systems, search, analytics, Postgres, and Rust.

View Company Profile