Senior Database Developer – (Product Support Team - PostgreSQL) (Bangkok based)

Get to Know our Team:

The Data department oversees all of Agoda’s data-related requirements. Our ultimate goal is to enable and increase the use of data in the company through creative approaches and the implementation of powerful resources such as operational and analytical databases, queue systems, BI tools, and data science technology. We hire the brightest minds from around the world to take on this challenge and equip them with the knowledge and tools that contribute to their personal growth and success while supporting our company’s culture of diversity and experimentation. The role the Data team plays at Agoda is critical as business users, product managers, engineers, and many others rely on us to empower their decision making. We are equally dedicated to our customers by improving their search experience with faster results and protecting them from any fraudulent activities. Data is interesting only when you have enough of it, and we have plenty. This is what drives up the challenge as part of the Data department, but also the reward.

The Opportunity:

As a member of the Database Development team, you will engage in database design, data management, and database development, all integrated with automated Continuous Integration/Continuous Delivery (CI/CD) pipelines. We work in close coordination with product teams, ensuring to offer support and solutions that uphold technical excellence and fulfill business needs.

In this Role, you'll get to:

• Design efficient, scalable, and maintainable database architectures, schemas and tables
• Write optimized PostgreSQL queries, SPs and functions to support various requirements
• Conduct database code review to ensure quality, efficiency, and adherence to best practices
• Diagnose and resolve performance issues, including queries, indexing and execution plan analysis
• Transfer and migrate data from various sources to PostgreSQL, ensuring data integrity and optimizing performance
• Collaborate with development teams for seamless database integration
• Utilize automated database CI/CD pipelines to streamline the development process
• Leverage advanced PostgreSQL features to enhance database performance and reliability

What you'll Need to Succeed:

• Minimum 4 years of hands-on experience with PostgreSQL database development and administration
• Bachelor's degree in computer science, computer engineering or a related field
• Proficient in database design, ER Diagram with advanced knowledge in writing complex SQL queries, stored procedures, and functions
• Demonstrated expertise in query optimization and analyzing execution plans
• Ability to prioritize tasks and work under pressure to meet deadlines
• Collaborative team player with good interpersonal and communication skills
• Be able to attend on-call rotation

It's Great if you have:

• PostgreSQL certification is a plus
• Experience with GitLab version control systems and containerization with Docker
• Familiarity with Agile development methodologies
• Familiarity with NoSQL databases and concepts for handling unstructured data

This position is based in Bangkok, Thailand (Relocation Provided)