Production SQL Server DBA - High Availability & DR Expert

Krisvconsulting Services Pte Ltd; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Job summary

Krisvconsulting Services Pte Ltd is seeking a Microsoft SQL Server Production DBA to manage and optimize SQL Server databases across Production, UAT, and Training environments. The role involves installation, configuration, patching, and upgrades to maintain stable systems, along with monitoring and troubleshooting performance issues.

The ideal candidate has hands-on experience with AlwaysOn Availability Groups, clustering, replication, and robust backup/DR strategies to meet strict RPO/RTO

Qualifications

• 4–7 years of experience in Microsoft SQL Server Database Administration.

Responsibilities

• Manage and maintain Microsoft SQL Server databases across Production, UAT, and Training environments.
• Perform SQL Server installation, configuration, patching, and upgrades to ensure stable database environments.
• Monitor database health and performance, troubleshooting blocking, deadlocks, and long-running queries.
• Configure and manage High Availability solutions such as AlwaysOn Availability Groups, clustering, and transactional replication.
• Implement and manage backup, restore, and disaster recovery strategies to meet RPO and RTO requirements.
• Support data migration, database refreshes, and import/export operations across different environments.
• Manage SQL Server security, including logins, roles, permissions, and database auditing policies.
• Maintain SQL Server Agent jobs, database maintenance plans, and automation scripts for routine operational tasks.

Skills

4–7 years experience

Microsoft SQL Server (2016/2017/2019/2

Tools

SSIS

SQL Server Agent

BCP

Import Wizard

Azure SQL

AWS RDS

Job description

Krisvconsulting Services Pte Ltd is seeking a Microsoft SQL Server Production DBA to manage and optimize SQL Server databases across Production, UAT, and Training environments. The role involves installation, configuration, patching, and upgrades to maintain stable systems, along with monitoring and troubleshooting performance issues.

The ideal candidate has hands-on experience with AlwaysOn Availability Groups, clustering, replication, and robust backup/DR strategies to meet strict RPO/RTO