Junior PostgreSQL Engineer — Grow, Flex Time & Impact

AgileEngine, LLC.; Rosarito; Hybrid; MXN 1,086,000 - 1,629,000; Full time

Benefits offered by this job

Professional growth

Competitive USD compensation

Exciting projects

Flextime

Job summary

AgileEngine is seeking a Database Engineer to design and optimize PostgreSQL schemas, ensuring scalable and reliable data platforms across environments.

The role focuses on SQL performance tuning, indexing strategies, and data integrity, with opportunities to collaborate across engineering, QA, and DevOps. Hybrid work options are available, with a strong emphasis on best practices and scalable data systems.

Qualifications

• 2+ years of experience in database engineering with a focus on PostgreSQL.
• Proven experience in designing, maintaining, and optimizing complex relational database systems.
• Strong knowledge of SQL performance tuning, indexing strategies, and query optimization.
• Experience with schema design for scalable and maintainable systems.
• Ability to work independently, take ownership of tasks, and deliver with minimal supervision.
• Solid understanding of data integrity, backups, and replication strategies.
• Familiarity with CI/CD practices in relation to database change management.
• Excellent communication skills in English (verbal and written).

Responsibilities

• Design and implement efficient PostgreSQL schemas to support product features and scalability;
• Maintain and tune database performance, ensuring high availability and responsiveness;
• Collaborate with engineers, QA, and DevOps to streamline data flow and reliability;
• Monitor, troubleshoot, and resolve database-related issues;
• Support data integration and migration efforts across environments;
• Contribute to establishing best practices and maintaining high coding standards for data integrity and reliability.

Skills

PostgreSQL

SQL performance tuning

Query optimization

Schema design

CI/CD practices

Data integrity

Backups & replication

English communication

Tools

sqitch

pgtaps

dbt

metaplane

AWS Glue

Job description

AgileEngine is seeking a Database Engineer to design and optimize PostgreSQL schemas, ensuring scalable and reliable data platforms across environments.

The role focuses on SQL performance tuning, indexing strategies, and data integrity, with opportunities to collaborate across engineering, QA, and DevOps. Hybrid work options are available, with a strong emphasis on best practices and scalable data systems.