Database Administrator (ClickHouse & PostgreSQL)

About the role

P.I. Works, a company that automates the management of commercial 5G networks, is looking for a ClickHouse and PostgreSQL Database Administrator to join its Engineering team in Istanbul. You will own the reliability, performance and scalability of the databases behind the network automation platform, which processes large volumes of mobile network data for operators worldwide.

Key responsibilities

• Design, operate, monitor and troubleshoot production ClickHouse clusters, including sharding, replication, ClickHouse Keeper/ZooKeeper, MergeTree table design, TTL and partitioning.
• Manage and tune PostgreSQL databases, including high availability (e.g. Patroni), replication, backup and recovery.
• Optimize query performance and storage for high-volume analytical workloads.
• Plan and test backup, restore and disaster recovery procedures.
• Automate provisioning, upgrades and maintenance using Ansible, scripting and infrastructure as code.
• Support application development teams on schema design, data modelling and query optimization.
• Build and maintain test and staging environments.

Required profile

• Bachelor's degree in a related field.
• 4+ years of experience as a DBA, DBRE or data platform engineer.
• Hands-on production experience with ClickHouse or PostgreSQL, and solid working knowledge of the other.
• Oracle DBA background is a plus.
• Ability to work in Turkey.

Required skills

• Replication, high availability and backup/recovery.
• Strong Linux skills and shell scripting.
• Good verbal and written English.