PostgreSQL and ClickHouse Database Administrator

[…] is looking for a PostgreSQL & ClickHouse Database Administrator to ensure the reliability, availability, security, performance, and recoverability of the Bank’s PostgreSQL and ClickHouse database platforms.

will initially focus on database platforms supporting the Bank’s BPM and Data Warehouse / Enterprise Data Management (EDM) environments and will progressively support PostgreSQL and ClickHouse platforms across the Bank as their use expands. You will administer production database environments, implement and maintain high-availability and disaster-recovery mechanisms, optimize database performance, and support the Bank’s evolving OLTP → CDC/Kafka → OLAP/ClickHouse data architecture in collaboration with Infrastructure, Data Engineering, Development, Architecture, and Information Security teams. 3+ years of relevant professional experience in database administration, preferably with production PostgreSQL and/or ClickHouse environments.

Hands-on experience with PostgreSQL administration, including clustering, replication, performance tuning, backup, and recovery. Practical knowledge of ClickHouse administration, including clustering, replication, performance optimization, and analytical workloads. Strong Linux administration skills (Ubuntu/RHEL/CentOS), including system parameters, storage, disk I/O, and performance optimization.

Practical understanding of High Availability (HA), replication, backup/recovery, and Disaster Recovery (DR) principles and te