Posted 24 days ago
Description
Based in: City of London, Shoreditch/Hybrid
About Amelco UK Ltd
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
- 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.
- Pension Scheme: Amelco matches up to 7% contributions of your base salary. You will automatically be entered at 4%.
- Staff Benefits Scheme: access to the staff benefits portal after successful completion of a 4-month probation period.
- Yearly discretionary bonus scheme and pay reviews
- Opportunity to travel and visit our office in Poland and Hungary
