Senior Database Administrator (MSSQL – Performance tuning expert)

Full Time
2 weeks ago

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  In Agoda, we have 800+ MSSQL instances across 5 data centers which have 7 nines uptime to serve customers, affiliates, and Agoda employee users around the world.

We have been working on a big scale of fast & safe database CI/CD pipeline with involved 1,000+ Engineers in IT department and it leads to having new 50-100 store procedures deployment on production every day.

As Senior DBA, you will have a big challenge & opportunity to help define, standardized, and provide the best practice of T-SQL query performance to make sure query performance is optimized to run all apps and databases together efficiently. In This Role, You’ll Get to

  • Administrating, Proactive and re-active monitoring of 600 database servers (SQL and No-SQL) in order to provide 24 x 7 uptime and availability across multiple datacenters
  • Troubleshooting and Performance tuning data engine.
  • Deploy database changes  and first line database support
  • Communicating and reviewing database solutions, technical, applications with Operations Staff and external entities to ensure scalability, integrity and security of database.

Requirements:

  • Bachelor or Master Degree in computer science or any related fields.
  • Understand database design, ER Diagram and structured query language (SQL)
  • Ability to learn new data engine technology such as MS SQL Server, Cassandra, Elastic Search, Kafka or Aerospike.
  • Experience with Database High Availability technology such as Clustering, Database Mirroring, Replication, Log shipping is a plus.
  • Experience with Database Monitoring, Proactive and re-active is a plus.
  • Ability to learn quickly and adapt to new environments well.
  • Be able to work under pressure and to deadlines.
  • Be the team player with good interpersonal and communication skills
  • Be able to attend on-call rotation

Highly desirable advantages skills:

  • Candidate who has MS SQL Server ,Vertica , ORACLE, DB2 , Sybase, Elastic Search or Kafka experience will be considered

#telaviv #jerusalem #LI-SK1 #IT #ENG #4 #LI-PS4 #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 #prague #Brno #Ostrava #cairo #alexandria #giza #estonia #paris #berlin #munich #hamburg #stuttgart #cologne #frankfurt #budapest #bali #dublin #telaviv #milan #rome #venice #florence #naples #turin #palermo #bologna #osaka #malta #amsterdam #oslo #warsaw #krakow #alrayyan #riyadh #jeddah #mecca #medina #singapore #seoul #barcelona #madrid #stockholm #zurich #taipei #tainan #taichung #kaohsiung #bangkok #Phuket #istanbul #london #manchester #liverpool #edinburgh #hcmc #hanoi #lodz #wroclaw #poznan #katowice #rio #salvador #newdelhi #bangalore #bandung #yokohama #nagoya #okinawa #fukuoka #jerusalem #IT #4 #LI-RS1 #bangalore #delhi #hyderabad #pune #singapore #beijing #shanghai #shenzhen #tokyo #seoul #hongkong #taipei #kualalumpur #jakarta #hochiminh #hochiminhcity #manila #instanbul #makati #dubai #riyadh #gurgaon #noida

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.