Senior Database Developer

**About Agoda**

Agoda is an online travel booking platform for accommodations, flights, and more. We build and deploy cutting-edge technology that connects travelers with more than 3.6 million accommodations globally. Based in Asia and part of Booking Holdings, our 6,000+ employees representing 90+ nationalities foster a work environment rich in diversity, creativity, and collaboration. We innovate through a culture of experimentation and ownership, enhancing the ability for our customers to experience the world.

**Our Purpose - **Bridging the World Through Travel**

We believe travel allows people to enjoy, learn and experience more of the amazing world we live in. It brings individuals and cultures closer together, fostering empathy, understanding and happiness.
We are a skillful, driven and diverse team from across the globe, united by a passion to make an impact. Harnessing our innovative technologies and strong partnerships, we aim to make travel easy and rewarding for everyone.

**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)**

sanfrancisco #sanjose #losangeles #sandiego #oakland #denver #miami #orlando #atlanta #chicago #boston #detroit #newyork #portland #philadelphia #dallas #houston #austin #seattle #sydney #melbourne #perth #toronto #vancouver #montreal #shanghai #beijing #shenzhen #prague #Brno #Ostrava #cairo #alexandria #giza #estonia #paris #berlin #munich #hamburg #stuttgart #cologne #frankfurt #hongkong #budapest #jakarta #bali #dublin #telaviv #milan #rome #tokyo #osaka #kualalumpur #amsterdam #oslo #manila #warsaw #krakow #bucharest #moscow #saintpetersburg #capetown #johannesburg #seoul #barcelona #madrid #stockholm #zurich #taipei #bangkok #Phuket #istanbul #london #manchester #liverpool #edinburgh #kiev #hcmc #hanoi #wroclaw #poznan #katowice #rio #salvador #IT #ENG #4 #LI-NP1 #IT #4 #5 #LI-Hybrid

**Equal Opportunity