ClickHouse Automation & Infrastructure Engineer

Requirements

Primary Skills Clickhouse Object Storage Docker K8S Linux Version Control

Proficient in Shell Scripting Python Ansible Automation SQL

Experience using REST APIs to integrate 3rd party tools and provide seamless end to end automation using Ansible

Confluence and building comprehensive documentation for solutions created

Responsibilities

Engineer production grade Clickhouse Opensource environment using Docker and Kubernetes in on premises hsbc environment

Enable HA Replication and Disaster Recovery capabilities for Clickhouse

Setup security guardrails for Clickhouse LDAPAD SSL User Access Management etc

Implement Performance tuning and Optimization techniques in Clickhouse

Integrate Clickhouse with external storage systems like S3

Implement Data Ingest methods into Clickhouse

Provide support for Clickhouse Production environment issues

Maintain system operational helpdesk documentation Support procedures development specifications User FAQs

Conform to the defined Development standards Legal Compliance and SOX controls

Collaboration with Technical Business teams

Strong communication documentation and problemsolving skills technical and nontechnical

Skills

Mandatory Skills : API/Microservices RestAssured Testing, Docker, MySQL, Python, Shell Scripting