PostgreSQL Database Engineer (Junior/Middle) ID38138

AgileEngine, LLC.; Puebla de Zaragoza; Hybrid; MXN 250,000 - 450,000; Full time

Benefits offered by this job

Professional growth

Competitive USD-based compensation

Flextime

Job summary

AgileEngine, LLC. in Puebla, Mexico, seeks a Database Engineer with PostgreSQL expertise to design schemas, tune performance, and ensure data integrity in a fast-growing environment.

You will collaborate with engineers, QA, and DevOps, support data migrations, and help set best practices. Fluency in English and independent ownership are valued; flexible work options include remote or on-site.

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

Database design

CI/CD for databases

Communication in English

Independent worker

Tools

Docker

Kubernetes

sqitch

dbt

Job description

Puebla (Heroica Puebla), Mexico | Posted on 07/10/2025

AgileEngine is an Inc. 5000 company that creates award-winning software for Fortune 500 brands and trailblazing startups across 17+ industries. We rank among the leaders in areas like application development and AI/ML, and our people-first culture has earned us multiple Best Place to Work awards.

If you're looking for a place to grow, make an impact, and work with people who care, we'd love to meet you!

WHAT YOU WILL DO

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

MUST HAVES

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

NICE TO HAVES

• Experience with other database systems (e.g., MySQL, MongoDB);
• Familiarity with cloud services like AWS RDS or GCP Cloud SQL;
• Knowledge of data migration techniques;
• Experience supporting backend services written in Java or other modern backend stacks;
• Exposure to DevOps practices (e.g., Docker, Kubernetes);
• Experience with these technologies: sqitch, pgtaps, dbt, metaplane, AWS glue.

THE BENEFITS OF JOINING US

• Professional growth: Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps.
• Competitive compensation: We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities.
• A selection of exciting projects: Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands.
• Flextime: Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office – whatever makes you the happiest and most productive.