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 & Maintenance
- Install, 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 & Documentation
- Work 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 uptime
- Ability to work calmly under pressure and during major events or peak resort hours
- Clear written and verbal communication for working with technical and non-technical teams
- Flexible schedule availability including potential weekend, evening, or on-call rotations
