Description
At Agoda, we bridge the world through travel. Our story began in 2005, and today we are part of Booking Holdings, with a diverse team of over 7,000 people from 90 countries.
We are looking for an internship student who is interested in learning how we manage database infrastructure for 1000+ database servers with milliseconds response time and more than 99.9999% uptime of MSSQL Server Databases.
In this role, you will be involved in database design, data managing, and database development with automated database Continuous Integration/Continuous Delivery (CI/CD) pipelines. You will learn how to build docker images for product development teams to use in their development life cycle.
Responsibilities:
- Build database docker in different engines to provide for developers to use in their development
- Develop database SQL code with quality and performance optimization
- Set up, migrate, and re-architect Agoda's production database to support business growth
- Proactively monitor to detect unusual behavior on production databases, such as high query resource usage, unusual database traffic, database server capacity, and coordinate with the Engineering team to optimize query performance before it affects user experience
- Research and implement automation tools to help reduce human time on a daily basis, such as installation and upgrade tools, database deployment tools, anomaly detection, etc.
Requirements:
- B.Sc. in Computer Science / Information Systems / Computer Engineering or related field
- Understand database design concepts, ER diagrams, and ability to write SQL queries
- Love to solve problems with good analysis skills and always try to make things better
- Familiar with relational and/or non-relational databases
- Excellent English written and verbal communication
Nice to have:
- Knowledge about database high availability or query performance tuning
- Knowledge in Docker or Kubernetes
- Practical knowledge with database management, Windows, PowerShell, Linux, and shell scripting
- Proficient in Python