Database Administrator

Amelco Limited; Warszawa; On-site; PLN 180,000 - 300,000; Full time

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.

Skills

PostgreSQL

ClickHouse

Snowflake

AWS

Linux/Unix

Bash

Python

Ansible

Prometheus

Grafana

CloudWatch

Education

AWS Certified Database

Postgres Professional

Tools

Prometheus

Grafana

CloudWatch

Terraform

Kubernetes

Job description

We are a leading gaming and gambling solution software provider with a strong presence in the USA, UK, and Europe. Through partnerships with global gaming companies, we build cutting-edge technical platforms across sportsbooks, lottery, casino, virtual gaming, and financial trading.

Our vision is to shape the future of gaming by transforming operations into intelligent, data-driven solutions that deliver exceptional customer experiences and create sustainable value for all stakeholders. We believe in teamwork, knowledge sharing, and transparency with accountability.

Technical Stack

Our data ecosystem is built for massive scale and diverse query patterns:

• Primary Transactional: PostgreSQL (Self-managed on EC2/K8s and AWS RDS/Aurora).
• Real-Time Analytics: ClickHouse (used for sub-second telemetry, high-throughput event logging, and real-time trading dashboards).
• Data Warehousing: Snowflake (our central source of truth for cross-team BI, regulatory reporting, and historical trend analysis).
• Orchestration: Kubernetes (EKS), Terraform, Ansible and on-prem.

Key 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.

Technical Requirements & Experience

• 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).
• Proficiency in Linux/Unix administration and shell scripting.
• Knowledge of monitoring tools (e.g., Prometheus, Grafana, CloudWatch).
• Knowledge of the betting or financial trading industry.
• Relevant certifications (AWS Certified Database, Postgres Professional).

Soft Skills

• Problem Solver: You enjoy "under the hood" troubleshooting and RCA (Root Cause Analysis).
• Calm Under Pressure: Ability to handle high-stakes production incidents effectively.
• Communicator: Can translate complex technical database issues to non-technical stakeholders.
• Team Player: Enthusiastic about knowledge sharing and mentoring others.