
Database Administrator (ClickHouse & PostgreSQL)
P.I. Works · Istanbul, Turkey · Onsite
Weak hiring record · median 866 days open
All reasons
- 91% of this employer's openings are over 60 days old
In its favour
- Still listed on the employer's own board
P.I. Works is the first company in the world to automate the management of a commercial 5G network.
Our automated network management products and services empower Mobile Operators to accelerate network transformation and to drive network quality and efficiency on the path to 5G. These solutions have been deployed across 91 mobile network operators in 64 countries around the world.
Come and join us to work with the leading telecom operators around the world and redefine the mobile experience worldwide by contributing to our research and development efforts.
About the role
We are looking for 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.
What you will do
- Design, operate, monitor and troubleshoot production ClickHouse clusters (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 (Ansible, scripting, IaC)
- Support application development teams on schema design, data modelling and query optimization
- Build and maintain test and staging environments
Required 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 working knowledge of the other
- Oracle DBA background is a plus
- 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
Skills
- ClickHouse
- PostgreSQL
- Ansible
- Linux
- Shell
More jobs at P.I. Works
All 11- Network Data Solutions Delivery Engineer(South Africa)P.I. Works · Johannesburg, South Africa3mo ago
- Mobile Transport Network Planning and Optimization EngineerP.I. Works · Remote3mo ago
- Software Product Design Engineer (Product Owner)P.I. Works · Istanbul, Turkey3mo ago
- Network Data Solutions Delivery Engineer (United Kingdom)P.I. Works · Reading, United Kingdom4mo ago
- Software ArchitectP.I. Works · Istanbul, Turkey2y ago
Similar roles
- Senior Data Engineer, Credit ReportingSezzle · Türkiye · USD 4,500–6,000/mo4d ago
- Data Engineer II, Credit ReportingSezzle · Türkiye · USD 2,800–4,500/mo4d ago
- Data EngineerSurgo Health · Istanbul, Türkiye4d ago
- Data Science ProfessionalTikTak · İstanbul, Türkiye · USD 0/yr10d ago
- Working student (m/f/d) - LVS Data AnalystABB · Ratingen, North Rhine-Westphalia, Germany · Blucina, Jihomoravsky, Czechia · Wroclaw, Lower Silesian, Poland +313d ago
- Data LeadLyrebird Studio · Istanbul24d ago