Senior Database Engineer: MariaDB to PostgreSQL Migration Lead

Improving

México

Remote

MXN 800,000 - 1,300,000

Full time

3 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Improving is seeking a Senior Database Engineer to own and modernize our relational database environment behind a large industrial software platform. You will lead the MariaDB to PostgreSQL migration, optimize SQL, and ensure high availability and data integrity across production databases.

You will collaborate with application engineers and architect scalable solutions, implementing monitoring, backups, and recovery plans in a cloud-enabled environment. LATAM operations experience is a plus.

Qualifications

Proven experience migrating production databases between MariaDB/MySQL and PostgreSQL.
Strong SQL, indexing, and query optimization abilities.
Experience with high-volume, highly concurrent workloads.
Experience with AWS or cloud environments.
Ability to plan cutovers, rollbacks, backups, and recovery.
Good problem-solving and production troubleshooting skills.

Responsibilities

Own performance, reliability, and health of two production database environments.
Lead MariaDB-to-PostgreSQL migration end to end: architecture, plan, execute, validate, cutover, rollback.
Analyze and optimize SQL, execution plans, indexes, and schemas.
Diagnose locking, blocking, deadlocks, and contention.
Tune performance for high-volume and parallel workloads.
Monitor CPU, memory, storage I/O, connections, and overall resource utilization.
Set performance baselines and validate improvements.
Ensure data integrity through migration validation and reconciliation processes.
Put monitoring, backup, recovery, and capacity planning in place.
Collaborate with application engineers on DB-facing issues.