Senior Database Engineer Maria DB & PostgreSQL
- Remote (anywhere)
- Full-time
- Software engineering
- Posted recently
You’ll apply on Improving’s own site.
About the role
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.
Responsibilities
- 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.
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.
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…