Senior DB Engineer: Elasticsearch, Cassandra & PostgreSQL

TSED UNIPESSOAL

Porto

Presencial

EUR 70 000 - 100 000

Tempo integral

Há 6 dias

Torna-te num dos primeiros candidatos

Recebe mais respostas dos empregadores

Envia um currículo específico para a oferta em poucos minutos.

Resumo da oferta

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.

Qualificações

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;

Responsabilidades

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.