Software Developer ID46604

AgileEngine, LLC; A distancia; MXN 1,266,000 - 1,628,000; Jornada completa

Descripción de la vacante

A leading software development company in Mexico is looking for a skilled database engineer to design and implement high-performing PostgreSQL-based solutions. The role requires deep expertise in PostgreSQL internals, JPA, and Spring Framework, with at least 4 years of professional experience. Candidates will work collaboratively with engineering teams to enhance performance and reliability while adhering to best practices in data management. Join a company that values growth, innovation, and a people-first culture.

Formación

• 4+ years of professional experience in relevant fields.
• Deep understanding of PostgreSQL internals and optimization.
• Strong expertise in Spring Framework and relevant technologies.

Responsabilidades

• Design and implement scalable PostgreSQL-based database solutions.
• Work independently on projects and ensure quality compliance.
• Collaborate with teams to optimize performance and integration.

Conocimientos

PostgreSQL internals

Performance tuning

Spring Framework

Microservices

Business-level English

Herramientas

JPA

Hibernate ORM

Kubernetes

Descripción del empleo

What you will do

• Design and implement scalable and high-performing PostgreSQL-based database solutions;
• Evaluate and improve the performance, reliability, and efficiency of existing data structures and access patterns;
• Collaborate with backend engineering teams to optimize Spring Data JPA framework usage and SQL query performance;
• Drive best practices around database schema design, indexing strategies, and partitioning;
• Ensure proper integration of Spring-based applications with the data layer for optimal performance;
• Proactively identify architectural bottlenecks and implement long-term solutions;
• Participate in code and architecture reviews to uphold high standards for data interaction layers;
• Create documentation and guidelines to enable consistent and maintainable data access strategies;
• Stay ahead of emerging database technologies and evaluate their relevance for the platform;
• Work independently on projects and be responsible for complying with time and quality specifications;
• Work during EST working hours (at least till noon EST).

Must haves

• 4+ years of professional experience;
• Deep understanding of PostgreSQL internals, performance tuning, and optimization;
• Deep understanding of JPA and Hibernate ORM, experience with performance tuning techniques for Java web applications;
• Strong expertise in Spring Framework;
• Solid grasp of SQL query optimization, index usage, and data modeling best practices;
• Comfortable analyzing query plans, tuning long-running transactions, and eliminating performance bottlenecks;
• Ability to work across teams and communicate complex architectural ideas clearly;
• Solid understanding and experience with Microservices;
• Understanding of Kubernetes;
• Business-level English is required.

Nice to haves

• Familiarity with distributed systems and cloud-native database architecture;
• Experience with caching strategies (e.g., Redis, Memcached);
• Knowledge of DevOps or CI/CD integration for database environments;
• Experience with monitoring and observability tools like Prometheus, Grafana, Grafana Tempo;
• Proven ability to understand the big picture and quickly comprehend complex relationships in dynamic organizations;
• Enthusiasm for acting as a team player especially when it comes to cross-functional teams paired with a passion for working independently, assuming holistic responsibility for a project;
• Structured and meticulous working style, willing to learn new things.

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!