Sr. Database Engineer

Improving; México; Remote; MXN 800,000 - 1,300,000; Full time

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.

Skills

MariaDB/MySQL (production)

PostgreSQL

SQL optimization

Indexing

Schema design

Transactions & concurrency

Performance debugging

AWS / Cloud

Migration planning

Cutover & rollback

Tools

SQL execution plans

Job description

Improving is committed to building a great place to work by cultivating an environment that fosters professional and personal relationships. We value open communication, personal growth, and shared rewards, which result in sustainable success.

Voted "best place to work" numerous times, Improving strives to create and maintain a culture that exemplifies teamwork, excellence, and fun! We believe this kind of culture encourages both the inspiration and the motivation to achieve amazing things.

Job Type: Full-Time

Location: LATAM

Country: Mexico, Central America, South America

We are seeking a Senior Database Engineer to own and modernize the relational database environment behind a large industrial software platform. Your main objective will be leading the migration of two production MariaDB databases to PostgreSQL, while improving performance, concurrency, and reliability along the way.

What You'll Do

• Own the performance, reliability, and technical health of two production database environments.
• Lead the MariaDB-to-PostgreSQL migration end to end: architecture, planning, execution, validation, cutover, and rollback.
• Analyze and optimize SQL, execution plans, indexes, schemas, and database configuration.
• Diagnose and resolve locking, blocking, deadlocks, and transaction contention.
• Tune performance for high-volume application and highly parallel processing workloads.
• Monitor CPU, memory, storage I/O, connections, and overall resource utilization.
• Set performance baselines and validate improvements through measurement.
• Protect data integrity through migration validation and reconciliation processes.
• Put monitoring, backup, recovery, and capacity planning practices in place.
• Partner with application engineers on database-facing issues, owning everything from the SQL/query boundary inward.

What You'll Bring

• Strong production experience with MariaDB/MySQL and/or PostgreSQL (experience with both is a strong plus).
• A proven track record migrating production relational databases between platforms.
• Advanced SQL, query optimization, and execution-plan analysis skills.
• Deep knowledge of indexing, schema design, transactions, and concurrency.
• Experience with large datasets, including tables with millions of records.
• Experience diagnosing performance through system, session, connection, and query metrics.
• Experience designing cutover, rollback, backup, and recovery strategies.
• Experience running databases in AWS or a comparable cloud environment.
• Strong production troubleshooting and analytical skills.
• Nice to have: experience migrating large production systems specifically to PostgreSQL, working with highly concurrent processing databases, and database automation and schema versioning.

Improving welcomes people from all backgrounds and walks of life, and this is reflected in our largely diverse community of Improvers. Improving is proud to be an equal opportunity employer and is committed to providing equal opportunities for all employees and applicants. Improving recruits, hires, trains, promotes, compensates, and administers all personnel actions without regard to race, color, religion, sex, sex stereotyping, pregnancy (which includes pregnancy, childbirth, and medical conditions related to pregnancy, childbirth, or breastfeeding), gender, gender identity, gender expression, national origin, age, mental or physical disability, ancestry, medical condition, marital status, military or veteran status, citizenship status, sexual orientation, genetic information, or any other status protected by applicable law.

About Improving

Improving is a modern digital services company dedicated to positively changing the perception of the IT professional. We offer innovative solutions through consulting, software development, and training to help thousands of our clients achieve new heights in a competitive and ever-changing market.

As our company continues to grow, we are looking for enthusiastic thought leaders to join our team. Improving has a unique mix of passionate professionals who strive to grow and thrive in new ways. We are committed to establishing and maintaining an inclusive culture that allows all Improvers to bring their authentic selves to work each day. This is why we work hard to build inclusion and diversity in our workplace, so we can all do amazing things and succeed together.