Postgres Database Administrator (DBA)

Who are we?

Who are we?

We are a young and fast-growing start-up from Utrecht focusing on the e-commerce and online marketing sectors. Channable was founded 7 years ago and developed into a company with an international team of 150 innovative and enthusiastic professionals. While you can still benefit from the start-up vibe, working at Channable also means being part of a professional company with a highly skilled Development team. We are now looking for a Postgres Database Administrator who likes the challenge of a continuously rescaling environment.

How we develop software

We have a strong engineering culture with a focus on correctness, reliability, and maintainability of our code. We have a number of services written in Python and in Haskell. Each service exposes a REST API and our services are composed together in a service-oriented architecture in which we can continuously improve each service.

We employ a continuous integration pipeline that allows us to quickly and safely deploy features, updates and fixes several times per day. Our infrastructure is running on Google Compute Engine and we strive to automate each part of the software development process as much as possible.

Job description

What will your role be?

You will be contributing to the improvement and scaling of our data infrastructure and the smooth operation of our tool. You will be primarily responsible for our core Postgres databases, which power the main services that Channable is built on. You can rely on your colleagues from the DevOps team and our development teams, who have a deep appreciation for relational databases, and Postgres in particular. You will review and advise them in their schema designs and help us find simple and elegant solutions.

Summarized, your tasks will include (but will not be limited to) the following:

  • Be a resident SQL and Postgres expert at Channable;
  • Administrate our Postgres databases on a daily basis;
  • Set up replication and backups for new databases;
  • Prepare and execute major version upgrades of our databases;
  • Debug and troubleshoot slow SQL queries and other performance issues;
  • Review data models and advise our dev teams on schema-design questions;
  • Manage our DB infrastructure as code (that can be reviewed and version-controlled);
  • Hardening and securing our databases against attacks and abuse;
  • Improving and maintaining our monitoring and alerting systems for our databases;
  • Developing new tools that help us improve and run our infrastructure.

If you want to read more about our development adventures, check out our tech blog: https://tech.channable.com/

You can also take a look at some of our open-source work at https://github.com/channable to get a feeling of how we work together and what our code looks like.

Who are we looking for?

Ideally, you have extensive experience working with relational databases professionally (preferably Postgres). You are a SQL expert who can write and debug complex queries with ease. You can read a query plan and find the bottlenecks within it (even if the data model itself turns out to be the problem). You can help us scale our TB+ Postgres instances to 10k requests/second and beyond while keeping the latency to low milli-seconds. You enjoy pushing the system to its limits and thinking about architectural improvements that we could be making to our database schemas. You are a team player and you can identify yourself with our core values. In more concrete terms, we would like you to have the following:

  • Extensive experience working with relational databases, preferably Postgres;
  • Advanced knowledge of SQL (DDL, DML, ACID, transactions, MVCC, etc.);
  • Familiar with practical concerns, like connection-pooling, physical and logical replication, backups, upgrading between major versions;
  • Experience scaling a relational database in both size and the number of requests/s;
  • Decent knowledge of Linux and its system administration tools;
  • Security-awareness and familiarity with concepts like defense-in-depth and the principle of least privilege;
  • Database modeling and architecture skills;
  • Team-player who can communicate clearly both orally and in writing;
  • Committed to high engineering standards.

And then there are some things that are ‘nice to have’:

  • Knowledge of Postgres internals (e.g. how MVCC is implemented);
  • Background in computer science and/or good understanding of data structures and algorithms;
  • Experience in managing infrastructure with either GCE, AWS, or Azure;
  • Hands-on experience with distributed systems;
  • Programming skills in one or more languages (preferably in Python);
  • Familiarity with infrastructure as code tooling, such as Ansible and Terraform.

Candidates of all levels are encouraged to apply. Our preference is to hire a candidate with at least a few years of experience, but we’re also open to applications from recent graduates.

Practical requirements

  • EU citizenship or a work permit, preferably already living in The Netherlands;
  • Available for at least 4 days a week, preferably full-time.

What do we offer?

  • Challenging full-time function with space for personal initiative;
  • Work within a multi-disciplinary DevOps team, with other specialists;
  • Colleagues who are knowledgeable about SQL and Postgres in particular;
  • Unique scaling challenges, helping us to push Postgres to its limits;
  • Competitive salary within a clear career structure;
  • Career opportunities within Channable;
  • Working for a fast-growing company with a young and ambitious team;
  • Awesome office in the city center of Utrecht and activities like hackathons and sports groups.

'What’s great about DevOps at Channable is the innovation and the culture. You get to work with cool new technologies and find solutions to new challenges. It’s a quickly growing company, where engineering and people are central. Everything you hear about the great culture is true: the colleagues are super helpful, you learn quickly and the parties are great fun.'

- Tijmen de Jong, DevOps Engineer

Sounds interesting?

Send us your cv, motivation letter, and web presence by clicking on the 'apply now' button. We will respond within 5 working days. The procedure includes two rounds of (online) interviews.

Do you have any questions about this vacancy? Please contact Mart (mart.vreeswijk@channable.com).

Do you want to see more of Channable and your future colleagues? Check out our social media channels like Instagram and Linkedin!

Contact by job agencies and recruiters will not be appreciated. Each recruiter or headhunter who approaches us agrees with a donation of € 250,- for Make-A-Wish.