System Operations Engineer (Database Administrator)
Resorts World Sentosa
Job Description
Role Responsibilities:
We are seeking a highly skilled and detail-oriented SQL Server Database Administrator (DBA) with Cloud expertise to join our IT team. This role is responsible for managing, optimizing, and securing SQL Server databases across on-premises and cloud environments. You will ensure high availability, performance tuning, disaster recovery, and compliance for mission-critical applications.
The position involves working with hybrid architectures, implementing automation, and supporting data services that enable business continuity and innovation.
Database Administration & MaintenanceInstall, configure, and maintain SQL Server instances (2014/2016/2019/2022) across on-prem and Cloud environments.Perform database health checks, capacity planning, and performance tuning for OLTP and OLAP workloads.Manage backup and recovery strategies, ensuring RPO/RTO compliance.Monitor and maintain indexes, statistics, and query optimization for high-performance systems.
Cloud & Hybrid Database Infrastructure:Administer Cloud databases e.g. Azure SQL Database, Azure Managed Instances, and SQL Server on Azure VMs.Implement high availability and disaster recovery (HADR) solutions using Always On Availability Groups, Failover Clustering, and Azure Site Recovery/cloud-native DR tools.Support migration projects from on-prem SQL Server to Azure using tools like Azure Data Migration Service.
Multi-RDBMS Support:Provide basic administration and troubleshooting for Oracle, MySQL, PostgreSQL, MariaDB (and exposure to NoSQL like MongoDB/Cassandra is a plus).Participate in cross-platform database projects and ensure interoperability in hybrid environments.
Automation & Monitoring:Develop and maintain automation scripts using PowerShell, T-SQL, Python, or Azure CLI for routine DBA tasks.Implement proactive monitoring using SQL Server native tools, Azure Monitor, and third-party solutions.Troubleshoot and resolve database-related incidents, ensuring minimal downtime.
Security & Compliance:Enforce database security best practices, including encryption (TDE), auditing, and role-based access control.Ensure strict adherence to company-specific security and compliance policies, including mandatory audits.Follow all organizational policies and procedures consistently in daily operations.Manage patching and vulnerability remediation for all supported database platforms.Ensure compliance with data protection regulations, including safeguarding Personally Identifiable Information (PII) and meeting PDPA (Personal Data Protection Act) requirements.
Collaboration & DocumentationWork closely with application teams, infrastructure teams, and cloud architects to align database solutions with business needs.Maintain detailed documentation of database configurations, procedures, and operational guidelines.
Role Requirements:
Required Qualifications:Minimum 5 years of experience as a SQL Server DBA in enterprise environments.Strong knowledge of SQL Server architecture, performance tuning, and troubleshooting.Hands-on experience with cloud databases.Prior experience with Azure SQL Database, managed Instances, and Azure VM-based SQL Servers will be advantageous.Hands-on experience with multiple RDBMS platforms (Oracle, MySQL, PostgreSQL, MariaDB) and NoSQL systems (MongoDB, Cassandra).Familiarity with backup/restore strategies, HADR solutions, and replication technologies.Proficiency in T-SQL scripting and PowerShell automation.Any of the following qualifications/experiences will be an advantage:Prior experience with data migration to cloud.Knowledge of Azure Data Factory, Synapse Analytics, and related services.Certifications: Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: Azure Solutions Architect, or MCSA: SQL Server.
Skills:Strong attention to detail and commitment to uptimeAbility to work calmly under pressure and during major events or peak resort hoursClear written and verbal communication for working with technical and non-technical teamsFlexible schedule availability including potential weekend, evening, or on-call rotations