Database Subject Matter Expert (SME) – Microsoft SQL Server
Salary: RM 8,500 – RM 12,750 per month
About the role
The Database Subject Matter Expert (SME) is responsible for the administration, maintenance, optimization, and support of Microsoft SQL Server platforms across cloud and on-premises environments. The role serves as the technical authority for database services, ensuring high levels of availability, performance, security, and resilience for business-critical systems.
Key responsibilities
Administer, monitor, and maintain Microsoft SQL Server databases across enterprise environments.
Ensure database availability, performance, capacity, security, and operational stability.
Design, implement, and support high-availability and disaster recovery solutions, including Always On Availability Groups, clustering, replication, and backup/recovery strategies.
Perform database performance analysis and optimization, including query tuning, indexing strategies, and execution plan review.
Lead database upgrade, migration, patching, and modernization initiatives.
Implement and maintain database security controls, access management, encryption, and compliance requirements.
Develop and maintain automation scripts and operational processes using T-SQL and PowerShell.
Troubleshoot and resolve complex database incidents and conduct root cause analysis for recurring issues.
Collaborate with application, infrastructure, and cloud teams to deliver reliable and scalable database services.
Provide Level 3 support for production environments and participate in major incident management activities.
About you
Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related discipline.
Minimum 10 years of experience in Microsoft SQL Server database administration.
Proven experience supporting enterprise-scale database environments across cloud and on-premises platforms.
Strong expertise in Microsoft SQL Server (2016/2019/2022), Azure SQL Database and Azure SQL Managed Instance, database performance tuning and optimization, high availability and disaster recovery solutions, backup, recovery, and data protection strategies, and T-SQL and PowerShell scripting.
Sound understanding of database security, access controls, encryption, and compliance requirements.
Excellent analytical, problem-solving, and stakeholder management skills.
Microsoft certifications such as DP-300, AZ-104, or AZ-305 (preferred).
Experience with Azure Monitor, Log Analytics, Azure Arc, and Infrastructure as Code (Terraform or Bicep) (preferred).
Familiarity with ITIL-based service management practices (preferred).