Staff MSSQL Database Developer – (SQL Performance Tuning Expert) (Bangkok based)

About Agoda

Agoda is an online travel booking platform for accommodation, flights, and more. We build and deploy cutting edge technology that connects travelers with more than 2.5 million accommodations globally. Based in Asia and part of Booking Holdings, our 4,000+ talents coming from 90+ different nationalities foster a work environment rich in diversity, creativity, and collaboration. We innovate through a culture of experimentation and ownership, enabling our customers to experience the world.

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 queries, stored procedures, and functions for MSSQL to support various requirements.
• Administrating, Proactive and re-active monitoring database servers to provide 24 x 7 uptime and availability across multiple datacenters
• Deploy database changes and first line database support
• Conduct database code reviews to ensure quality, efficiency, and adherence to best practices.
• Diagnose and resolve performance issues, including queries, indexing, and execution plan analysis for MSSQL.
• Transfer and migrate data from various sources to MSSQL, 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 features of MSSQL to enhance database performance and reliability.

What you'll Need to Succeed:

• Minimum 7 years of hands-on experience with MSSQL database development and administration. 
• Bachelor's degree in computer science, computer engineering, or a related field. 
• Proficient in database design and ER Diagrams, with advanced knowledge in writing complex SQL queries, stored procedures, and functions. 
• Proven experience with Database Monitoring, Proactive and re-active 
• Strong knowledge of High Availability database technology, including Clustering, Database Mirroring, Replication, Log shipping 
• Extensive expertise in advanced 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. 
• Ability to participate in on-call rotation. 

It's Great if you have:

• MSSQL certification or proficiency in other database engines, such as PostgreSQL Top of Form 
• 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)