Senior DB Engineer: Elasticsearch, Cassandra & PostgreSQL

TSED UNIPESSOAL; Porto; On-site; EUR 70,000 - 100,000; Full time

Job summary

Blip, a Flutter Entertainment company, seeks a Senior Database Engineer to optimize and scale our distributed database estate (Elasticsearch, Cassandra, PostgreSQL) across US, UK and Portugal. You will design scalable Elasticsearch clusters, tune queries, manage backups, and collaborate with DevOps and software engineers to ensure 24x7 availability.

The role requires 5+ years in database engineering, deep NoSQL/SQL expertise, and strong scripting in Python or Shell.

Qualifications

• 5+ years’ experience as a Database Engineer or similar role.
• In-depth knowledge of NoSQL and SQL clustered databases (Cassandra, Elasticsearch, PostgreSQL).
• Expertise in Elasticsearch is required as well as a background in Cassandra.
• Design and implement scalable Elasticsearch clusters to support high-traffic, data-intensive applications.
• Monitor, troubleshoot, and tune Elasticsearch performance, including query optimization, shard management, and cluster scaling.
• Develop and maintain indexing strategies, mappings, and search schemas that optimize performance.
• Ensure data security and compliance by managing access control, encryption, and data retention policies.
• Evaluate and implement new technologies and best practices to enhance data reliability and scalability.
• Background in data modelling, database design and performance optimization.
• Knowledge of Linux (Amazon Linux and Rocky are used here);
• Shell Scripting (essential), Python (extremely good to have), Java (good to have);
• Knowledge of AWS technologies and cloud-based CLIs;
• Experience with diagnostic log aggregation software such as DataDog;
• Experience working with automation software such as Ansible;
• Ability to define and implement replication and redundancy policies;
• Experience working with a high concurrency/transactional/available systems;

Responsibilities

• Elasticsearch Design and Tuning – Optimize indexes, sharding, and document modeling;
• Database Administration (e.g., Cassandra, Elasticsearch, PostgreSQL);
• Review of existing implementation and development of new implementations as needed;
• Installation and Configuration management;
• Availability Planning – Systems need to be available 24x7;
• Monitoring and Alerting;
• Infrastructure Planning and Sizing – decide when it is preferable to add a node to a cluster versus increase the resources of an existing node;
• Query Tuning;
• Planning and Troubleshooting – collaborate with engineers, DevOps and network engineers;
• Automation – write programs/scripts to avoid repetitive tasks;
• Coach and mentor other engineers to implement high-quality solutions;
• Participate in on-call support rotation.

Skills

Elasticsearch

Cassandra

PostgreSQL

NoSQL databases

SQL databases

Linux

Python

Shell scripting

AWS

DataDog

Tools

Ansible

Docker

Kubernetes

AWS CLI

Job description

Blip, a Flutter Entertainment company, seeks a Senior Database Engineer to optimize and scale our distributed database estate (Elasticsearch, Cassandra, PostgreSQL) across US, UK and Portugal. You will design scalable Elasticsearch clusters, tune queries, manage backups, and collaborate with DevOps and software engineers to ensure 24x7 availability.

The role requires 5+ years in database engineering, deep NoSQL/SQL expertise, and strong scripting in Python or Shell.