PostgreSQL Database Engineer (Junior/Middle) ID38138

AgileEngine, LLC.; Rosarito; Híbrido; MXN 1 086 000 - 1 629 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Professional growth

Competitive USD compensation

Exciting projects

Flextime

Resumo da oferta

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.

Qualificações

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

Responsabilidades

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

Conhecimentos

PostgreSQL

SQL performance tuning

Query optimization

Schema design

CI/CD practices

Data integrity

Backups & replication

English communication

Ferramentas

sqitch

pgtaps

dbt

metaplane

AWS Glue

Descrição da oferta de emprego

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.