PostgreSQL and ClickHouse Database Administrator

Responsibilities

• 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.
• Troubleshoot production incidents, performance degradation, replication failures, failed jobs, and other database issues, including root-cause analysis and corrective actions.
• Support controlled database schema, configuration, and production changes in coordination with application and development teams, and maintain relevant technical and operational documentation.
• Support the Bank’s OLTP → CDC → Kafka → OLAP/ClickHouse architecture, including CDC, data streaming, ingestion, data consistency, monitoring, failure handling, and operational troubleshooting.
• Collaborate with Data Engineering and EDM teams to ensure reliable data flows between transactional and analytical environments, while maintaining clear database-platform administration responsibilities.

Languages