Software Engineer (PostgreSQL) - Remote work | REF#299255

BairesDev; Mexico; Remote; MXN 1,527,000 - 2,290,000; Full time

Benefits offered by this job

100% remote work

USD compensation

Hardware provided

Flexible hours

Parental leaves and holidays

Global Top 1% of talent

Mentorship & career growth

Job summary

BairesDev is a fully remote software company delivering technology solutions for global clients. We are seeking a Software Engineer specializing in PostgreSQL to design and develop custom extensions, optimize queries, and contribute to PostgreSQL internals.

You will work on challenging data architectures and high-availability systems from anywhere. Ideal candidates have 4+ years of software engineering with PostgreSQL, PL/pgSQL, storage engines, and performance tuning, plus strong English.

Qualifications

• 4+ years of software engineering with a focus on database systems and PostgreSQL.
• Proven 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 architectural and functional needs.
• Optimize complex queries and database schemas for performance and efficiency.
• Contribute to PostgreSQL internals and low-level optimizations for reliability and throughput.
• Develop and maintain stored procedures and triggers using PL/pgSQL for data logic.
• Troubleshoot and resolve deep-seated database performance bottlenecks and challenges.

Skills

PostgreSQL

PL/pgSQL

Query optimization

Performance tuning

PostgreSQL internals

Tools

Extensions development

Job description

At BairesDev®, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley.

Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant impact worldwide.

When you apply for this position, you're taking the first step in a process that goes beyond the ordinary. We aim to align your passions and skills with our vacancies, setting you on a path to exceptional career development and success.

Software Engineer (PostgreSQL) at BairesDev

What You’ll Do

• 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.

What We Are Looking For

• 4+ years of experience in Software Engineering with a focus on database systems and PostgreSQL.
• Proven 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.

How we do make your work (and your life) easier:

• 100% remote work (from anywhere).
• Excellent compensation in USD or your local currency if preferred
• Hardware and software setup for you to work from home.
• Flexible hours: create your own schedule.
• Paid parental leaves, vacations, and national holidays.
• Innovative and multicultural work environment: collaborate and learn from the global Top 1% of talent.
• Supportive environment with mentorship, promotions, skill development, and diverse growth opportunities.

Join a global team where your unique talents can truly thrive and make a significant impact!