Staff DB Engineer: Data Architecture for High-Load MariaDB

Prime Insights; Polska; In loco; PLN 320.000 - 520.000; Tempo pieno

Vantaggi offerti da questo lavoro

Competitive salary

Regular salary reviews

International team collaboration

Growth opportunities and AI enablement

Descrizione del lavoro

Prime Insights is seeking a Staff Database Engineer to own the Data area within Core Engineering. You will manage MariaDB production clusters, design scalable data architectures, and ensure reliable data flows across transactional and analytics stores for millions of users.

You’ll work with ClickHouse, dbt, Airbyte, and CDC pipelines, implementing governance, backups, and performance optimizations. You will partner with the CTO and global engineering teams to tackle high-scale data challenges

Competenze

• 4+ years of production database experience, incl. MariaDB/MySQL under high load.
• Proven ability to design and run replication topologies and handle hard failovers.
• Ability to read and explain query plans, indexes, and schema design to engineers.
• Hands-on production ClickHouse experience, with schema design and tuning.
• Proactive mindset for incident prevention and root-cause analysis.
• Strong scripting skills in Bash, Python, or Go; fluent English communication.

Mansioni

• Own Production MariaDB replication topologies, health, upgrades and tuning.
• Build monitoring and alerts for slow queries, replication lag, and storage growth.
• Review and optimize queries, indexes and schema designs with teams.
• Own backups, point-in-time recoveries, and disaster recovery for data safety
• Define data architecture for MariaDB, ClickHouse, and pipelines.
• Design and maintain dbt models transforming raw data into stable tables.
• Manage CDC, Airbyte connectors, and data pipelines to ClickHouse.
• Set governance standards for migrations, cataloging, and lineage.

Conoscenze

Production databases

MariaDB / MySQL DBA

Query plan analysis

ClickHouse expertise

Scripting (Bash/Python/Go)

English communication

Strumenti

dbt

OpenMetadata

DataHub

Kafka

Descrizione del lavoro

Prime Insights is seeking a Staff Database Engineer to own the Data area within Core Engineering. You will manage MariaDB production clusters, design scalable data architectures, and ensure reliable data flows across transactional and analytics stores for millions of users.

You’ll work with ClickHouse, dbt, Airbyte, and CDC pipelines, implementing governance, backups, and performance optimizations. You will partner with the CTO and global engineering teams to tackle high-scale data challenges