PostgreSQL Database Engineer (Junior/Middle) ID39991

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.

WHY JOIN US

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

ABOUT THE ROLE

Join our team as a PostgreSQL Database Engineer and make a real impact! You’ll design and optimize scalable databases, ensure top-notch performance, and collaborate with engineers, QA, and DevOps to keep our systems running smoothly. This is a hands-on role where your expertise in SQL, data integrity, and database optimization will directly shape our product. Work remotely with a global team and help us build reliable, high-performance systems that power our growth.

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;
- Experience in data modeling, creating queries, functions, and ETL code;
- 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);
- Willingness to work with 6–7 hours of overlap with US Central Time.

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.

PERKS AND BENEFITS

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