Senior DB Architect: PostgreSQL, ClickHouse & Snowflake

Amelco Limited

Warszawa

On-site

PLN 180,000 - 300,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Amelco Limited is seeking a senior database engineer to manage a hybrid data stack across PostgreSQL Live Trading and analytics engines. You will own CDC pipelines, schema evolution, and cross-engine data movement in a fast-paced environment.

The role requires expert PostgreSQL tuning, ClickHouse clustering, Snowflake administration, AWS, Linux, and automation with Python or Ansible. You will monitor costs and collaborate with engineers to deliver scalable data solutions for trading and gaming

Qualifications

Expert-level knowledge of PostgreSQL (Performance tuning, vacuuming, indexing).
Hands-on experience with ClickHouse (managing clusters, MergeTree engines, and tuning for high-concurrency).
Proficiency in Snowflake administration (RBAC, Warehouse sizing, Snowpipe, and Task management).
Experience with AWS (specifically RDS and Aurora).

Responsibilities

Multi-Engine Management: Administer a hybrid database environment, ensuring seamless data flow between PostgreSQL (Live Trading) and ClickHouse/Snowflake (Analytics).
Data Movement & ETL: Own the reliability of CDC pipelines that stream data from production Postgres instances into the analytical layer.
Schema Evolution: Manage schema changes across different engines, ensuring that transactional data models translate effectively into columnar formats for analytics.
Monitoring & Cost Governance: Implement unified observability for the entire stack. Specifically, monitor Snowflake credit usage and ClickHouse resource utilisation to ensure peak ROI.
Automation: Use Python, Bash and/or Ansible to automate routine maintenance tasks, deployments and monitoring services.