Remote PostgreSQL Engineer: Optimize, Extend & Scale Data

BairesDev; Mexico; On-site; PHP 5,474,000 - 9,124,000; Full time

Benefits offered by this job

Remote work

Home office setup provided

Flexible hours

Paid parental leave

Vacations and national holidays

Job summary

BairesDev, a leading technology company, is seeking a Software Engineer specializing in PostgreSQL to join a global, remote-first team. You will optimize performance and extend core data infrastructure while collaborating with diverse engineers around the world.

In this role you will design extensions, refine queries, and implement advanced data logic using PL/pgSQL, contributing to scalable and reliable systems for complex data requirements.

Qualifications

• 4+ years of experience in Software Engineering with a focus on database systems and PostgreSQL.
• Expertise in developing and optimizing PostgreSQL extensions and PL/pgSQL.
• Deep understanding of PostgreSQL internals, including storage engines and query planning.
• Hands-on experience with advanced query optimization and performance tuning at scale.
• Advanced proficiency in English.

Responsibilities

• Design and develop custom PostgreSQL extensions to meet specific architectural and functional needs.
• Optimize complex queries and database schemas to ensure maximum performance and resource efficiency.
• Contribute to PostgreSQL internals and low-level optimizations to improve system reliability and throughput.
• Develop and maintain sophisticated stored procedures and triggers using PL/pgSQL for advanced data logic.
• Troubleshoot and resolve deep-seated database performance bottlenecks and architectural challenges.

Skills

Database systems

Query optimization

PostgreSQL internals

English proficiency

Tools

PostgreSQL

PL/pgSQL

Job description

BairesDev, a leading technology company, is seeking a Software Engineer specializing in PostgreSQL to join a global, remote-first team. You will optimize performance and extend core data infrastructure while collaborating with diverse engineers around the world.

In this role you will design extensions, refine queries, and implement advanced data logic using PL/pgSQL, contributing to scalable and reliable systems for complex data requirements.