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

Posted 9 Days Ago
Be an Early Applicant
Office, Machaze, Manica
Senior level
Software • Travel
The Role
As a Senior Database Developer/DBA at Agoda, you will be responsible for designing efficient database architectures, writing optimized queries and stored procedures for MSSQL and PostgreSQL, administering database servers for 24/7 availability, and deploying database changes while supporting product teams.
Summary Generated by Built In

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)

#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 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.

Top Skills

Mssql
Postgres
The Company
9,211 Employees
On-site Workplace

What We Do

Agoda is transforming travel for millions of customers across the globe. Headquartered in Asia, Agoda is one of the world’s largest online travel platforms. Founded in 2005 and now part of Booking Holdings (Nasdaq:BKNG), Agoda has a network of over 2,900,000 properties worldwide. Our web and mobile products provide a first-rate reservation service in 38 languages that uniquely combines local knowledge and local connections to provide the best deals for business and leisure travelers. Agoda employs over 7,000 professionals from 90 nationalities in locations around the globe. In every department – from engineering to customer experience – we provide an environment rich with creativity, collaboration, and experimentation, and the tools to work faster and smarter. At Agoda, we believe our people are our strength. We work hard and have fun, and we choose people who are dedicated to making things great. For properties seeking partnership with Agoda, visit https://connect.agoda.com

Similar Jobs

Flow Traders Logo Flow Traders

Core Data Engineer

Fintech • Financial Services
Office, Machaze, Manica, MOZ
626 Employees
3 Locations
2337 Employees
Office, Machaze, Manica, MOZ
9211 Employees

Similar Companies Hiring

Jobba Trade Technologies, Inc. Thumbnail
Software • Professional Services • Productivity • Information Technology • Cloud
Chicago, IL
45 Employees
RunPod Thumbnail
Software • Infrastructure as a Service (IaaS) • Cloud • Artificial Intelligence
Charlotte, North Carolina
53 Employees
Hedra Thumbnail
Software • News + Entertainment • Marketing Tech • Generative AI • Enterprise Web • Digital Media • Consumer Web
San Francisco, CA
14 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account