PostgreSQL and ClickHouse Database Administrator

PostgreSQL and ClickHouse Database Administrator 🏢 Converse Bank 📍 Armenia · On-site 🕐 Full Time About the role Converse Bank 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. The role 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. What you’ll do 🗂 • Administer, configure, upgrade, patch, monitor, and maintain PostgreSQL and ClickHouse databases, clusters, and related services. • Manage database users, roles, permissions, RBAC, encryption, SSL/TLS, and secure connectivity in accordance with the Bank’s security requirements. • Implement and maintain High Availability (HA), replication, clustering, and Disaster Recovery (DR) solutions, including Patroni, PgBouncer, Streaming Replication, ClickHouse Keeper/ZooKeeper, ReplicatedMergeTree, and sharding. • Implement and automate backup, recovery, and DR procedures using technologies such as WAL-G, pgBackRest, and clickhouse-backup, including regular recovery testing. • Monitor database health, availability, performance, resource utilization, and capacity, proactively identifying and resolving reliability and performance issues. • Perform query analysis and optimization, configuration tuning, indexing, storage optimization, capacity planning, and growth management for PostgreSQL and ClickHouse workloads. What we’re looking for 🔎 • 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. • Understanding of OLTP → CDC → Kafka → OLAP/ClickHouse architecture, including data capture, streaming, ingestion, data consistency, monitoring, and failure handling. • Hands-on experience with CDC/Kafka-based data pipelines involving PostgreSQL and ClickHouse. • Understanding of Data Warehouse, OLAP, Big Data, and enterprise data-platform architectures. How to apply 🙋 Open on ITA Jobs and apply → More IT vacancies in Armenia, matched to your CV — jobs.ita.am/vacancies #Operations #Mid #Postgresql