Software Engineer - Postgres Internals

<p>PlanetScale is growing rapidly and reinventing the database space. The PlanetScale platform offers both Postgres and Vitess clusters. Vitess, an open-source database clustering system for horizontal scaling of MySQL, enables businesses to efficiently handle large-scale data workloads — without sacrificing developer experience.</p> <h2>About the role</h2> <p>As a PostgreSQL Core Engineer, you will spend most of your time contributing upstream to the PostgreSQL core engine and maintaining the Postgres extensions — both open-source community projects and Planetscale's proprietary extensions — that power our Postgres offering.</p> <div class="markdown-heading"> <h2 class="heading-element">What You'll Do</h2> <a id="user-content-what-youll-do" class="anchor" href="https://gist.github.com/rafer/9d21bdfe052f3e3dd7b37c5fd2f484f3#what-youll-do"></a></div> <ul> <li>Author and review patches to the PostgreSQL core engine: performance, features, bug fixes, and security — landed through the <a href="https://www.postgresql.org/list/pgsql-hackers/">pgsql-hackers</a> mailing list and the <a href="https://commitfest.postgresql.org/">Commitfest</a> process.</li> <li>Maintain Postgres extensions, both open-source (community projects we depend on) and proprietary (Planetscale-owned). Includes feature work, bug fixes, performance tuning, and major-version compatibility.</li> <li>Review community patches with rigor on correctness, stability, and PostgreSQL coding conventions.</li> <li>Engage the PostgreSQL community in design discussions, the 5 (five) annual Commitfests, and conferences.</li> <li>Root-cause Postgres issues affecting Planetscale customers and turn fixes into upstream patches when applicable.</li> <li>Improve documentation for PostgreSQL and our extensions as part of every change.</li> </ul> <div class="markdown-heading"> <h2 class="heading-element">What We're Looking For</h2> <a id="user-content-what-were-looking-for" class="anchor" href="https://gist.github.com/rafer/9d21bdfe052f3e3dd7b37c5fd2f484f3#what-were-looking-for"></a></div> <p><strong>Required:</strong></p> <ul> <li>Strong <strong>C</strong> programming skills in large, established codebases.</li> <li>Deep knowledge of <strong>PostgreSQL internals</strong>: MVCC, query planner/executor, WAL, vacuum, replication, memory contexts.</li> <li>Demonstrated <strong>open-source contributions</strong> to PostgreSQL or comparable database projects (accepted patches, reviews, or extensions).</li> <li>Fluency with <strong>Git</strong> and the PostgreSQL patch workflow.</li> <li>Comfortable in <strong>Linux/BSD</strong> development environments; able to profile and benchmark database workloads.</li> </ul> <h2><strong>Nice to Have:</strong></h2> <ul> <li>PostgreSQL contribution history.</li> <li>Experience authoring or maintaining a Postgres extension end-to-end (e.g., pgvector, pg_stat_statements, PostGIS).</li> <li>Background in distributed systems, storage engines, or query optimization.</li> <li>Public talks, papers, or blog posts in the Postgres ecosystem.</li> </ul> <div class="markdown-heading"> <h2 class="heading-element">About You</h2> <a id="user-content-about-you" class="anchor" href="https://gist.github.com/rafer/9d21bdfe052f3e3dd7b37c5fd2f484f3#about-you"></a></div> <p>You're someone who deeply understands what it takes to evolve PostgreSQL responsibly — both upstream and through extensions. You've shipped patches to Postgres or authored extensions before, and have strong opinions about what makes a change land cleanly versus stall in review</p> <p>You enjoy wearing many hats and get energized by working on diverse problems across the stack. You ship quickly and iterate based on feedback. You collaborate effectively with engineers in different domains. You're excited about leveraging AI tools to move faster. You make pragmatic technical decisions and can work independently with minimal direction.</p> <h2>Why PlanetScale</h2> <p>We're redefining how high-growth companies manage data at scale—and we work with some of the most exciting brands in gaming, consumer tech, and B2B SaaS. As a Software Engineer, you'll be at the core of building the platform that powers world-class apps used by hundreds of millions of users worldwide. PlanetScale is a profitable company with a philosophy centered around building small teams of p99 individuals and is recognized as one of the fastest growing companies in America.</p> <p>At PlanetScale we believe in supporting people to do their best work and thrive no matter the location. Our mission is to build a diverse, equitable, and inclusive company. We strive to build an inclusive environment where all people feel that they are equally respected and valued, whether they are a candidate or an employee. We welcome applicants of any educational background, gender identity and expression, sexual orientation, religion, ethnicity, age, citizenship, socioeconomic status, disability, pregnancy status, and veteran status.</p> <p>If you have a disability, please let us know if there's any way we can make the interview process better for you; we're happy to accommodate!</p> <h2>Total Compensation and Pay Transparency</h2> <p>An employee's total compensation consists of base salary + variable comp where appropriate + benefits + equity. A member of our Talent Acquisition team will be happy to answer any further questions when we engage with you to begin the interview process.</p> <p><strong>Base salary range: $120,000 - $290,000 USD</strong></p> <p> </p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...