Senior Database Engineer Maria DB & PostgreSQL

Responsibilities

Strong production experience with MariaDB/MySQL and PostgreSQL.

Demonstrated experience migrating production relational databases between platforms, preferably MariaDB/MySQL to PostgreSQL.

Advanced SQL, query optimization, and execution-plan analysis skills.

Strong experience with indexing, schema design, transactions, locking, and concurrency.

Experience supporting large relational datasets with tables containing millions of records.

Experience diagnosing performance using CPU, memory, I/O, session, connection, and query metrics.

Experience developing migration, validation, cutover, rollback, backup, and recovery strategies.

Experience supporting databases in AWS or comparable cloud environments.

Strong production troubleshooting and analytical skills.

Own the performance, reliability, and technical health of both production database environments.

Lead the MariaDB-to-PostgreSQL migration, including architecture, planning, execution, validation, cutover, and rollback.

Analyze and optimize SQL, execution plans, indexes, schemas, and database configuration.

Diagnose locking, blocking, deadlocks, transaction contention, and other concurrency issues.

Optimize database performance for high-volume application and highly parallel processing workloads.

Monitor CPU, memory, storage I/O, connections, transactions, and overall database resource utilization.

Establish performance baselines and validate improvements through measurement.

Maintain data integrity and develop migration validation and reconciliation processes.

Establish monitoring, backup, recovery, capacity planning, and operational practices.

Partner with application engineers on database-facing issues while owning behavior from the SQL/query boundary inward.

Nice to have

• Experience migrating large production systems to PostgreSQL

-Experience with highly concurrent operational or processing databases

Benefits

• Contrato a largo plazo.

100% Remoto.

Vacaciones y PTOs.

Posibilidad de recibir 2 bonos al año.

2 revisiones salariales al año.

Clases de inglés.

Equipamiento Apple.

Plataforma de cursos en linea.

Budget para compra de libros.

Budget para compra de materiales de trabajo.

Mucho más..

Contrato a largo plazo.

100% Remoto.

Vacaciones y PTOs.

Posibilidad de recibir 2 bonos al año.

2 revisiones salariales al año.

Clases de inglés.

Equipamiento Apple.

Plataforma de cursos en linea.

Budget para compra de libros.

Budget para compra de materiales de trabajo.

Mucho más..

We are seeking a Senior Database Engineer to own and modernize the relational database environment supporting a large industrial software platform. The environment includes two production MariaDB databases: a primary application database supporting complex asset, inspection, visualization, and operational workflows, and an operational database supporting highly concurrent file and data-processing workflows. Both support large, data-intensive workloads. A primary objective is to lead the migration of both databases from MariaDB to PostgreSQL while improving performance, concurrency, reliability, and operational support.