Staff MSSQL Database Developer – (SQL Performance Tuning Expert) (Bangkok based)
atAgoda Services Co., Ltd.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 a global network of 4.7M hotels and holiday properties worldwide, plus flights, activities, and more. Based in Asia and part of Booking Holdings, our 7,100+ employees representing 95+ nationalities in 27 markets 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.
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)
Equal Opportunity Employer
At Agoda, we pride ourselves on being a company represented by people of all different backgrounds and orientations. We prioritize attracting diverse talent and cultivating an inclusive environment that encourages collaboration and innovation. Employment at Agoda is based solely on a person's merit and qualifications. We are committed to providing equal employment opportunity regardless of sex, age, race, color, national origin, religion, marital status, pregnancy, sexual orientation, gender identity, disability, citizenship, veteran or military status, and other legally protected characteristics.
We will keep your application on file so that we can consider you for future vacancies and you can always ask to have your details removed from the file. For more details please read our privacy policy.
To all recruitment agencies: Agoda does not accept third party resumes. Please do not send resumes to our jobs alias, Agoda employees or any other organization location. Agoda is not responsible for any fees related to unsolicited resumes.
Experience required
- 7 years
Salary
- Negotiable
Job function
- IT / Programming
Job type
- Full-time
Company overview
Agoda is transforming travel for millions of customers across the globe. Headquartered in Asia, Agoda is one of the world’s largest online travel accommodation platforms. Founded in 2005 and now part of Booking Holdings (Nasdaq: BKNG), Agoda has a network of over 2,000,000 vacation rentals and ho ... Read more
Why join us: The Agoda Thailand offices are staffed by a team of multi-national professionals. We are expanding our business around the world and are looking for dynamic people to help the company grow. Agoda is located in the heart of Bangkok in the Offices at Central World, and offer huge career opportunities ... Read more
Benefits
- Five-day work week
- Flexible working hours
- Employee discount
- Gym membership
- Job training
- Paid holidays
- Performance bonus
- Overtime pay
- Health Insurance
- Maternity leave