# Principal Software Engineer – Postgres

Remote from[Netherlands](https://jobicy.com/job-region/netherlands.md)Annual salary Undisclosed Salary information is not provided for this position.
Check our [Salary Directory](https://jobicy.com/salaries.md) to estimate the average compensation for similar roles.Department  [Software Engineering](https://jobicy.com/categories/engineering.md) Employment type Full Time, Job posted23 Jun 2026Apply before23 Jul 2026Experience level  Senior
Views / Applies 901 / 202 [About company](https://jobicy.com/company/clickhouse.md) [Share](#share)

About [Clickhouse](https://jobicy.com/company/clickhouse.md)

The fastest open-source column-oriented OLAP database to generate analytical reports in real-time.

*

[Computer Software](https://jobicy.com/company-category/software.md)
*  2021

Verified job posting This job post has been [manually reviewed](https://jobicy.com/tools/help-center/employee/how-does-jobicy-verify-the-legitimacy-of-remote-job-listings.md) for authenticity and compliance.       Tailor Resume Check Job Fit Cover Letter

### Tailor my resume to this job

Discover how to best rewrite and optimize your resume for this specific job. You'll receive personalized suggestions and detailed guidance to highlight your key strengths, effectively address the job requirements, and make your application more compelling to recruiters and hiring managers.     After analyzing your resume, I can provide several recommendations to better position yourself for this role.  Your background in software development shows strong technical skills, particularly in Java and Python development. However, for this Senior Backend Developer position, I notice there could be more emphasis on your experience with microservices architecture and cloud technologies, which are key requirements for this role. I recommend highlighting specific projects where you utilized these technologies and quantifying your achievements to demonstrate impact... Upgrade to Plus

### Am I a good fit for this job?

Understand your compatibility with this specific job opportunity. Our detailed analysis will assess your resume against the role's requirements, providing insights into your potential fit, key skill alignments, and areas you might need to develop to be a strong candidate.     After assessing your resume against the job requirements, here's a summary of your fit:  1. Overall Match: Moderate Fit (Approx. 65-70%). Your resume shows good alignment with several core responsibilities for the Project Manager role, especially your experience in agile methodologies and stakeholder communication.
2. Key Strengths: Your PMP certification and proven track record in delivering projects on time are strong assets for this position.
3. Potential Gap: The role specifies experience with 'XYZ specific software', which is not explicitly mentioned in your resume. If you have this experience, ensure it's highlighted.
4. Recommendation: Consider adding a quantifiable achievement related to budget management, as this is often a key metric for PM roles... Upgrade to Plus

### Cover Letter Assistant

Need help writing a compelling cover letter? Our system can analyze this job and your resume to help you draft personalized paragraphs that highlight your strengths and impress hiring managers.      Let me help you draft a strong opening...  Dear Hiring Manager, I am writing to express my keen interest in the Senior Marketing Manager position. My background in developing data-driven marketing strategies and leading successful product launches, as detailed in my resume, directly aligns with your need for a candidate capable of enhancing brand visibility and driving market share growth. I am confident I can make a significant contribution to your team... Upgrade to Plus

###  AI Summary

ClickHouse is seeking a Principal Software Engineer with deep expertise in PostgreSQL internals to lead the design and implementation of advanced database systems features. This high-impact role involves extending Postgres capabilities, optimizing performance, and providing technical leadership. The ideal candidate has 10+ years of experience in systems programming with C/C++ or Rust, strong knowledge of database engine internals, and a proven track record of shipping large-scale systems. ClickHouse offers the opportunity to work on foundational database technologies in a high-autonomy environment.

### Role DNA

Job Complexity Easy Hard

AI Insight This role requires 10+ years of experience, deep expertise in PostgreSQL internals, and the ability to lead complex systems design, making it one of the most challenging positions in software engineering.

### Salary Analysis

Median  Market Rate  $250,000US Market $200k – 350k 0 $385k      AI Insight The salary range for this role is not specified, but based on market data for a Principal Engineer with Postgres expertise, the median is estimated at $250,000. This is competitive for senior technical roles in the database systems domain.

### Core Skills Required

[PostgreSQL](https://jobicy.com/jobs?search_keywords=PostgreSQL.md) [C++](https://jobicy.com/jobs?search_keywords=C.md) [Rust](https://jobicy.com/jobs?search_keywords=Rust.md) [Systems Programming](https://jobicy.com/jobs?search_keywords=Systems+Programming.md) [Database Internals](https://jobicy.com/jobs?search_keywords=Database+Internals.md) [Performance Optimization](https://jobicy.com/jobs?search_keywords=Performance+Optimization.md) [Distributed Systems](https://jobicy.com/jobs?search_keywords=Distributed+Systems.md) [Open Source](https://jobicy.com/jobs?search_keywords=Open+Source.md) [Technical Leadership](https://jobicy.com/jobs?search_keywords=Technical+Leadership.md) [Storage Engines](https://jobicy.com/jobs?search_keywords=Storage+Engines.md)

### Cover Letter Sample

Dear Hiring Manager,

I am writing to express my strong interest in the Principal Software Engineer - Postgres position at ClickHouse. With over 10 years of experience building high-performance database systems in C++ and Rust, I have developed deep expertise in PostgreSQL internals, including storage engines, replication, and query execution. I am particularly excited about ClickHouse's mission to redefine real-time analytics and data infrastructure.

In my previous role at [Company], I led the design and implementation of a distributed replication system that improved throughput by 40% while maintaining strong consistency. I also contributed to open-source PostgreSQL extensions used by thousands of developers. My background in performance optimization and low-level instrumentation aligns perfectly with the challenges described in this role.

I thrive in high-autonomy environments and am passionate about mentoring engineers and setting engineering standards. I am eager to bring my expertise to ClickHouse and help shape the future of Postgres-based systems.

Thank you for considering my application. I look forward to discussing how I can contribute to your team.

Sincerely,
[Your Name]

Copy

### Sample Interview Questions

Describe your experience with PostgreSQL internals. Which subsystems (e.g., storage, replication, query execution) have you worked on most extensively?I have extensive experience with PostgreSQL's storage engine, specifically working on the buffer manager and WAL (Write-Ahead Log) to optimize I/O patterns. I also contributed to the replication subsystem by implementing a custom logical decoding plugin for real-time data streaming. Additionally, I optimized query execution by rewriting parts of the planner for better join order selection.How would you approach optimizing a slow query that involves complex joins and aggregations on a large dataset?First, I would use EXPLAIN ANALYZE to identify bottlenecks. Common issues include sequential scans, poor join order, or lack of indexes. I would consider adding composite indexes, rewriting the query to use more efficient joins (e.g., hash join vs. nested loop), or partitioning the table. If the query is still slow, I might look into materialized views or caching strategies. At the system level, I would profile memory usage and I/O to ensure the configuration is optimal.Explain a time when you had to make a trade-off between performance and simplicity in a database system. How did you decide?In a project to implement a new indexing method, we had to choose between a B-tree (simple, well-understood) and a custom LSM-tree (higher write throughput but more complex). Since the workload was write-heavy, we opted for the LSM-tree, but we invested in thorough testing and documentation to manage complexity. The trade-off paid off with a 3x improvement in write performance.How do you stay updated with the latest developments in database technology, and how have you applied new knowledge to your work?I follow PostgreSQL mailing lists and attend conferences like PGConf. Recently, I learned about the new incremental sorting feature in PostgreSQL 13 and applied it to reduce sort memory usage in our analytics queries. I also experiment with new storage technologies like NVMe and use that knowledge to optimize buffer pool management.Describe your experience with open-source contributions. How do you balance contributing to upstream projects with proprietary work?I have contributed patches to PostgreSQL's core for bug fixes and performance improvements. I balance this by allocating 10% of my time to open-source work, which also benefits our proprietary extensions. For example, a patch I upstreamed for parallel query execution reduced our internal query times by 20%.

## About ClickHouse

Recognized on the 2025 Forbes Cloud 100 list, ClickHouse is one of the most innovative and fast-growing private cloud companies. With more than 3,000 customers and ARR that has grown over 250 percent year over year, ClickHouse leads the market in real-time analytics, data warehousing, observability, and AI workloads.

The company’s sustained, accelerating momentum was recently validated by a $400M Series D financing round. Over the past three months, customers including Capital One, Lovable, Decagon, Polymarket, and Airwallex have adopted the platform or expanded existing deployments. These customers join an established base of AI innovators and global brands such as Meta, Cursor, Sony, and Tesla.

We’re on a mission to transform how companies use data. Come be a part of our journey!

About the Role

ClickHouse is expanding its capabilities in the database systems domain, building next-generation infrastructure that redefines performance, scalability, and developer experience. We’re looking for a Principal Engineer with deep expertise in systems programming and database internals — particularly Postgres — to help us push boundaries in how databases are built and operated at scale.

This is a strategic and high-impact role for an engineer who can work independently across complex technical areas: from storage and performance optimization to distributed coordination and extension development. You’ll shape critical components of our data platform, mentor other engineers, and drive architectural direction for systems that serve massive workloads.

## What You’ll Do

* Lead design and implementation of advanced systems features across areas like storage, replication, query execution, and performance optimization.
* Contribute to and extend Postgres internals — improving reliability, scalability, and efficiency.
* Prototype and build extensions that expand Postgres’s core capabilities and integrate with cloud-native infrastructure.
* Collaborate with product, infrastructure, and cloud platform teams to deliver robust, developer-friendly experiences.
* Profile and optimize database performance using low-level instrumentation and benchmarking.
* Provide technical leadership, set standards for engineering excellence, and mentor senior engineers.
* Operate with significant autonomy and ownership — driving projects from concept to production.

## About You

* 10+ years of experience building systems software in C/C++ or Rust (Go experience a plus).
* Deep knowledge of PostgreSQL or other database engine internals, including storage, execution, or replication subsystems.
* Strong understanding of concurrency, operating systems, and performance engineering.
* Proven ability to ship large-scale systems or core infrastructure features end-to-end.
* Experience contributing to open-source databases or similar complex systems is highly desirable.
* Pragmatic problem solver with a bias for simplicity and measurable impact.
* Thrives in a high-autonomy, high-velocity environment.

## Why Join Us

* Work on foundational database technologies at the intersection of performance, reliability, and usability.
* Shape the future of Postgres-based systems and cloud data infrastructure.
* Operate with autonomy in a small, high-talent team that values depth, craftsmanship, and impact.
* Contribute to an ambitious vision: making data systems faster, simpler, and more powerful for developers everywhere.

#LI-remote

## Compensation

For roles based in the United States, the typical starting salary range for this position is listed above. In certain locations, such as the San Francisco Bay Area and the New York City Metro Area, a premium market range may apply, as listed.

These salary ranges reflect what we reasonably and in good faith believe to be the minimum and maximum pay for this role at the time of posting. The actual compensation may be higher or lower than the amounts listed, and the ranges may be subject to future adjustments.

An individual’s placement within the range will depend on various factors, including (but not limited to) education, qualifications, certifications, experience, skills, location, performance, and the needs of the business or organization.

If you have any questions or comments about compensation as a candidate, please get in touch with us at [paytransparency@clickhouse.com](mailto:paytransparency@clickhouse.com).

## Perks

* Flexible work environment – ClickHouse is a globally distributed company and remote-friendly. We currently operate in over 20 countries.
* Healthcare – Employer contributions towards your healthcare.
* Equity in the company – Every new team member who joins our company receives stock options.
* Time off – Flexible time off in the US, generous entitlement in other countries.
* A $500 Home office setup if you’re a remote employee.
* Global Gatherings – We believe in the power of in-person connection and offer opportunities to engage with colleagues at company-wide offsites.

Culture – We All Shape It

As part of a rapidly scaling start up, you will be instrumental in shaping our culture.

Are you interested in finding out more about our culture? Learn more about our values [here](https://clickhouse.com/company/careers). Check out our[blog posts](https://clickhouse.com/blog) or follow us on [LinkedIn](https://www.linkedin.com/company/clickhouseinc/life/0c1ee7f4-2129-488d-b413-e7f6270659fd/?viewAsMember=true) to find out more about what’s happening at ClickHouse.

Equal Opportunity & Privacy

ClickHouse provides equal employment opportunities to all employees and applicants and prohibits discrimination and harassment of any type based on factors such as race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Please see [here](https://clickhouse.com/legal/applicant-privacy-notice) for our Privacy Statement.

Show more

[Apply now >](https://jobicy.com/jobs/144518-principal-software-engineer-postgres.md)

>  Annual salary information is not provided for this position. Explore salary ranges for similar roles in our [Salary Directory ›](https://jobicy.com/salaries.md)

*

![Upload CV](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSI2NSIgaGVpZ2h0PSI2NSIgZmlsbD0ibm9uZSIgeG1sbnM6dj0iaHR0cHM6Ly92ZWN0YS5pby9uYW5vIj48ZyBjbGlwLXBhdGg9InVybCgjQSkiPjxwYXRoIGQ9Ik0wIDBINjVWNjVIMFYwWiIgZmlsbD0iIzAyOWFlYiIvPjxnIGZpbGw9IiNmZmYiIHN0cm9rZT0iI2ZmZiIgc3Ryb2tlLXdpZHRoPSIyIj48cGF0aCBkPSJNMzMuMDQ5IDE1LjQ1NGExLjQzIDEuNDMgMCAwIDAtMi4wOTcgMGwtNy41NzkgOC4xNDdhMS4zOCAxLjM4IDAgMCAwIC4wOSAxLjk3MyAxLjQ0IDEuNDQgMCAwIDAgMi4wMDgtLjA4OGw1LjEwOS01LjQ5MnYyMC42MWExLjQxIDEuNDEgMCAwIDAgMS40MjEgMS4zOTdjLjc4NSAwIDEuNDIxLS42MjUgMS40MjEtMS4zOTd2LTIwLjYxbDUuMTA5IDUuNDkyYTEuNDQgMS40NCAwIDAgMCAyLjAwOC4wODggMS4zOCAxLjM4IDAgMCAwIC4wOS0xLjk3M2wtNy41NzktOC4xNDZ6TTE2Ljc2OSAzOC40YzAtLjc3My0uNjItMS40LTEuMzg1LTEuNFMxNCAzNy42MjcgMTQgMzguNHYuMTAybC4yMTUgNi4yMjljLjIyMyAxLjY4LjcwMSAzLjA5NSAxLjgxMyA0LjIxOHMyLjUxIDEuNjA3IDQuMTcyIDEuODMzYzEuNi4yMTggMy42MzYuMjE4IDYuMTYuMjE4aDExLjI4bDYuMTYtLjIxOGMxLjY2Mi0uMjI2IDMuMDYxLS43MDkgNC4xNzItMS44MzNzMS41ODktMi41MzggMS44MTMtNC4yMThDNTAgNDMuMTEzIDUwIDQxLjA1NSA1MCAzOC41MDNWMzguNGMwLS43NzMtLjYyLTEuNC0xLjM4NS0xLjRzLTEuMzg1LjYyNy0xLjM4NSAxLjRsLS4xOSA1Ljk1OGMtLjE4MiAxLjM3LS41MTUgMi4wOTUtMS4wMjYgMi42MTJzLTEuMjI4Ljg1My0yLjU4MyAxLjAzOGMtMS4zOTUuMTktMy4yNDMuMTkzLTUuODkzLjE5M0gyNi40NjJjLTIuNjUgMC00LjQ5OC0uMDAzLTUuODkzLS4xOTMtMS4zNTUtLjE4NC0yLjA3Mi0uNTIxLTIuNTgzLTEuMDM4cy0uODQ0LTEuMjQyLTEuMDI2LTIuNjEyYy0uMTg3LTEuNDEtLjE5MS0zLjI3OS0uMTkxLTUuOTU4eiIvPjwvZz48L2c+PGRlZnM+PGNsaXBQYXRoIGlkPSJBIj48cGF0aCBmaWxsPSIjZmZmIiBkPSJNMCAwaDY1djY1SDB6Ii8+PC9jbGlwUGF0aD48L2RlZnM+PC9zdmc+)

### Upload your resume now

To unlock remote work opportunities and be discovered by global employers.

This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content.

## How to apply

## See a few more

Similar Software Engineering remote jobs

*
![TechMagic logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/09/3015c753-221.png)

TechMagic

[Middle Strong General QA (with AI)](https://jobicy.com/jobs/145122-middle-strong-general-qa-with-ai.md)

We are looking for a Middle strong General QA Engineer with 3+ years of experience to join a distributed product team and take ownership of quality across the full testing…

![Ukraine flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/ua.svg)
UA•Full TimeNEW*
![Cision logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/08/e9661342-221.jpeg)

Cision

[Software Developer II](https://jobicy.com/jobs/145141-software-developer-ii.md)

At Cision, we believe in empowering every individual to make an impact. Here, your voice is heard, your ideas are valued, and your unique perspective fuels our collective success….

![Canada flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/ca.svg)
CA•Full TimeCAD 96,395-110k/year*
![Aviatrix logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/c783b38c-221.jpeg)

Aviatrix

[MTS Cloud Test](https://jobicy.com/jobs/145145-mts-cloud-test.md)

WHO WE ARE: Aviatrix® is pioneering the Cloud Native Security Fabric — the architecture the Containment Era requires. The Cloud Native Security Fabric governs every workload communication path across…

![USA flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/us.svg)
US•Full TimeNEW*
![Truelogic logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/e7ae6cb6-221-1.png)

Truelogic

[Senior Full-stack Engineer (React OR Vue/Python) – Investment (Latam)](https://jobicy.com/jobs/146283-senior-full-stack-engineer-react-or-vue-python-investment-latam.md)

About TruelogicAt Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of…

![LATAM flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/latam.svg)
LATAM•Full TimeNEW*
![Zartis logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/06/9bd0869f-221.webp)

Zartis

[Senior Platform Engineer](https://jobicy.com/jobs/148224-senior-platform-engineer.md)

The company and our mission: Zartis is a global AI transformation and technology consulting partner where talented engineers and technologists work on cutting edge innovation. We partner with ambitious organizations…

![Europe flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/eu.svg)
EU•Full TimeNEW*
![NBCUniversal logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/836510d4-221-2.jpg)

NBCUniversal

[Data Engineer, Engineering & Operations](https://jobicy.com/jobs/148199-data-engineer-engineering-operations.md)

Company DescriptionNBCUniversal is one of the world’s leading media and entertainment companies. We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to…

![USA flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/us.svg)
US•Full TimeUSD 115k-145k/year*
![Lingraphica logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2021/12/0ebd0674d0b000a5783705e1b9ae1dd7.png)

Lingraphica

[Software Engineer – Unity](https://jobicy.com/jobs/148197-software-engineer-unity.md)

Company DescriptionLingraphica is a mission-driven organization that provides speech-generating devices to help improve communication, speech, and quality of life for people with communication impairments. Lingraphica is a leader in augmentative and alternative communication…

![USA flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/us.svg)
US•Full TimeUSD 84k-97,400/year*
![Veeam Software logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/f7716b71-221.jpg)

Veeam Software

[Software Developer in Test (JavaScript)](https://jobicy.com/jobs/144087-software-developer-in-test-javascript-2.md)

Veeam is the Data and AI Trust Company, specializing in helping organizations ensure their data and AI are fully understood, secured, and resilient to enable the acceleration of safe AI…

![Poland flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/pl.svg)
PL•Full TimeNEW*
![Aviatrix logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/c783b38c-221.jpeg)

Aviatrix

[Senior Solutions Architect – ACE](https://jobicy.com/jobs/148145-senior-solutions-architect-ace.md)

WHO WE ARE: Aviatrix® is pioneering the Cloud Native Security Fabric — the architecture the Containment Era requires. The Cloud Native Security Fabric governs every workload communication path across…

![USA flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/us.svg)
US•Full TimeUSD 121,829-143,328/year*
![Chainguard logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/e4b6aacf-221.jpeg)

Chainguard

[Engineering Manager, Internal Developer Platform](https://jobicy.com/jobs/148144-engineering-manager-internal-developer-platform.md)

Chainguard is the trusted source for open source. By delivering hardened, secure, and production-ready builds of all the open source software engineers and AI agents rely on, Chainguard helps organizations…

![USA flag](https://cloud.jobicy.com/nyc4-cold/img/round-flags/us.svg)
US•Full TimeUSD 205k-230k/year
[More Jobs](https://jobicy.com/jobs.md)