Analyst, Database and Big Data Administration
Melco Resorts & Entertainment Taipa, Macau S.A.R.
Hospitality · 10,001+ employees
About the role
The analyst will provide 24x7 support for database, ETL, and data warehouse operations, including monitoring, patch management, and performance tuning. They are also responsible for automating housekeeping tasks, deploying databases across environments, and ensuring compliance with ITIL and security standards.
What they look for
Requirements
Candidates must have at least 2 years of hands-on experience in enterprise database administration with proficiency in MS SQL, MongoDB, or MySQL. A bachelor's degree is required, along with strong problem-solving skills and the ability to work in a high-pressure environment.
Full description
REQ15073 Analyst, Database and Big Data Administration (Open)
POSITION SUMMARY:
The successful candidate will work as a part of system operations team to perform daily database, data interface/ETL and data warehouse support of the company’s global IT operations.
PRIMARY RESPONSIBILITIES:
- Provide Enterprise IT 24x7 database, data interface/ETL and data warehouse operations support
- Perform daily monitoring, analysis, patch management and administration on databases, data interface/ETL and data warehouse.
- Work with different IT teammates to ensure optimal performance and minimal database issues.
- Automate database and data warehouse housekeeping and monitoring, including capacity management/planning, backup and job scheduling.
- Set up and deploy databases in Development, UAT, and Production environment.
- Assist application support specialist and developers for troubleshooting and performance tuning.
- Prepare and update relevant documentation for installation, configuration and administration of the databases, data interface/ETL and data warehouse.
- Maintain High-Availability and Disaster Recovery on database, data interface/ETL and data warehouse platform.
- Enforce database standards, guidelines and operational policies and procedures in accordance to SOX/ISO20000/ISO27001/ITIL standards
QUALIFICATIONS:
Experience
- 2+ years hands-on experience in enterprise database environment e.g. MS SQL, MongoDB, and MySQL database administration and/or development.
- Possess good working knowledge of Window, Linux, Unix, SQL.
- Knowledge and hands-on experience on enterprise cloud environment and virtualization technology will be an advantage, e.g. AWS, Azure, Google Cloud Platform, VMWare etc.
- Experience on supporting enterprise data integration platform and business intelligence analytics tool will be a definite advantage, e.g. YellowBrick, Tableau, and Power BI etc.
- Gaming industry exposure will be an advantage.
Education
- Bachelor's Degree or equivalent relevant qualifications
- Microsoft DBA certifications, or equivalent will be an advantage
Skills / Competencies
- Good problem-solving, interpersonal and analytical skills
- Able to work under pressure and tight schedule, independently and proactively
- Able to communicate with English
