PostgreSQL Database Engineer (Junior/Middle) Job Description We are seeking an experienced PostgreSQL Database Engineer to join our team at AgileEngine. As a member of our database engineering team, you will design and implement efficient PostgreSQL schemas to support product features and scalability. You will be responsible for maintaining and tuning database performance, ensuring high availability and responsiveness. You will collaborate with engineers, QA, and DevOps to streamline data flow and reliability. Key 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. Requirements: - +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; - Able 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 Have: - 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. 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.