ClickHouse & PostgreSQL DBA for Global 5G Platform

P.I. Works, Inc.; Pendik; On-site; TRY 300,000 - 520,000; Full time

Job summary

P.I. Works is seeking a ClickHouse & PostgreSQL Database Administrator to join our Engineering team in Istanbul.

You will own the reliability, performance and scalability of the databases behind our network automation platform, which processes large volumes of mobile network data for operators worldwide. Design, operate and optimize production ClickHouse and PostgreSQL clusters, implement HA and backup strategies, and automate provisioning and maintenance using Ansible and IaC.

Qualifications

• Bachelor’s degree in a related field.
• 4+ years of experience as a DBA / DBRE / data platform engineer.
• Hands-on production experience with ClickHouse or PostgreSQL, and solid knowledge of the other.
• Experience with replication, high availability and backup/recovery.
• Strong Linux skills and shell scripting.
• Good verbal and written English.
• Being able to work in Turkey.

Responsibilities

• Design, operate, monitor and troubleshoot production ClickHouse clusters (sharding, replication, Keeper, MergeTree tables, TTL, partitioning).
• Manage and tune PostgreSQL databases including high availability (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 (Ansible, scripting, IaC).
• Support application development teams on schema design, data modelling and query optimization.
• Build and maintain test and staging environments.

Skills

ClickHouse

PostgreSQL

Linux

Shell scripting

Education

Bachelor’s degree in a related field

Tools

Patroni

Ansible

Job description

P.I. Works is seeking a ClickHouse & PostgreSQL Database Administrator to join our Engineering team in Istanbul.

You will own the reliability, performance and scalability of the databases behind our network automation platform, which processes large volumes of mobile network data for operators worldwide. Design, operate and optimize production ClickHouse and PostgreSQL clusters, implement HA and backup strategies, and automate provisioning and maintenance using Ansible and IaC.