Senior Database Administrator (ClickHouse)

Stack

Responsibilities

• ▹Own the reliability and performance of production ClickHouse clusters, whether self-hosted on Kubernetes or running on managed services
• ▹Design a standard architecture and tooling to grow to dozens of multi-node clusters without operational work growing at the same pace
• ▹Manage the whole cluster lifecycle as code: provisioning, configuration, scaling, upgrades, migrations
• ▹Build monitoring and alerting that catch problems before users notice them
• ▹Own backups and disaster recovery, and test restores regularly
• ▹Keep clusters secure by default
• ▹Plan capacity and keep infrastructure costs under control
• ▹Be the go-to person on ClickHouse for developers, DevOps engineers, other DBAs and engineering leadership, from schema design to query performance
• ▹Handle routine database requests and automate as many as possible
• ▹Step in during rare production emergencies, including outside business hours, then lead root-cause analysis and contribute to postmortems
• ▹Keep documentation and runbooks up to date, and share knowledge with the team

Requirements

• ▹Deep, DBA-level knowledge of ClickHouse from running it in production (storage, merges, replication, query execution)
• ▹Strong SQL, including optimizing complex analytical queries and reviewing schema design
• ▹Ability to design architecture and automation that holds up across dozens of multi-node clusters
• ▹Experience running a large fleet of databases (dozens or hundreds of instances), not necessarily ClickHouse
• ▹Experience running and maintaining stateful workloads on Kubernetes in production, well beyond initial deployment
• ▹Production use of a Kubernetes operator to run databases (e.g. CloudNativePG, Zalando Postgres Operator, Altinity, the official ClickHouse operator)
• ▹Experience with version upgrades, backup and restore, and migrating large datasets between clusters or regions with zero or minimal downtime
• ▹Strong troubleshooting skills across the whole stack, from queries and schema design down to Kubernetes, Linux, storage and networking

Soft skills

About the company

Tabby is a fintech company founded in 2019 that helps shoppers stay in control of their spending with buy-now-pay-later solutions. Over 25 million users and 70,000+ merchants, including Amazon, Noon, IKEA and SHEIN, use Tabby; it generates over $18 billion in annual transaction volume and is the largest, fastest-growing fintech in the GCC region, valued at $6.5 billion.