Junior PostgreSQL Database Engineer — Flexible, Remote

AgileEngine, LLC.; Santiago de Querétaro; On-site; MXN 600,000 - 900,000; Full time

Benefits offered by this job

Flextime

Work from home

Office flexibility

Education budget

Professional growth

Job summary

AgileEngine, LLC seeks a Database Engineer specializing in PostgreSQL to design and implement scalable schemas, tune performance, and ensure high availability. You will collaborate with engineering, QA, and DevOps to streamline data flow and reliability.

The role requires 2+ years in database engineering, strong SQL skills, data integrity, backups, replication, and CI/CD for database changes. You will support data migrations and contribute to best practices while communicating effectively in

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 Tuning

Indexing

Query Optimization

Schema Design

Data Integrity

Backups

Replication

CI/CD

English

Tools

Docker

Kubernetes

sqitch

pgtaps

dbt

metaplane

AWS Glue

Job description

AgileEngine, LLC seeks a Database Engineer specializing in PostgreSQL to design and implement scalable schemas, tune performance, and ensure high availability. You will collaborate with engineering, QA, and DevOps to streamline data flow and reliability.

The role requires 2+ years in database engineering, strong SQL skills, data integrity, backups, replication, and CI/CD for database changes. You will support data migrations and contribute to best practices while communicating effectively in