MS SQL DBA

ENCORA TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

A leading technology firm in Singapore is seeking a Database Administrator to maintain and optimize their MS SQL Server environments. The ideal candidate will have experience in installing, configuring, and administering SQL Server, along with a strong understanding of database security and compliance. Responsibilities include performance tuning, backup and recovery strategies, and scripting automation. This role demands strong analytical, communication skills, and the ability to work in a team.

Qualifications

• Good knowledge in database platforms such as MS SQL and Oracle.
• Familiarity with Big Data technologies like Hadoop and NoSQL.
• Minimum one year of experience in database administration.

Responsibilities

• Install, configure, and maintain SQL Server on Windows platforms.
• Optimize database performance and troubleshoot issues.
• Develop automation scripts for maintenance tasks.

Skills

Database Administration

Performance Optimization

Security Compliance

Automation Scripting

Analytical Skills

Education

Degree/Diploma in Computer Science, Computing, Electrical Engineering, or IT

Tools

MS SQL Server 2016/2019/2022

PowerShell

Python

Backup tools (NetBackup, CommVault)

Job description

Responsibilities:

• Database Administration
  • Install, configure, and maintain Microsoft SQL Server (2016/2019/2022) on Windows platforms.
  • Manage database storage structures, users, roles, and access privileges.
  • Perform routine database maintenance, patching, and performance tuning.
  • Implement and maintain backup and recovery strategies using SQL Server native tools.
• High Availability & Replication
  • Configure and maintain SQL Server AlwaysOn Availability Groups for high availability and read-scale solutions.
  • Manage SQL Server Failover Cluster Instances (FCI), including cluster setup, node management, and failover testing.
• Performance & Optimization
  • Analyze and tune SQL queries, indexes, and database performance parameters.
  • Troubleshoot slow-running queries and application performance issues.
  • Use Query Store, Extended Events (MSSQL) for performance diagnostics.
• Security & Compliance
  • Enforce database security policies, encryption, and audit mechanisms.
  • Ensure compliance with data governance and industry standards (e.g., MAS TRM, ISO 27001).
  • Apply regular patches and perform vulnerability remediation activities.
• Monitoring & Automation
  • Set up proactive database monitoring and alerting using tools such as SQL Server Management Studio, and third-party monitoring platforms.
  • Develop scripts for automation of maintenance, monitoring, and reporting tasks (using Shell, PowerShell, or Python).
• Disaster Recovery & Documentation
  • Conduct periodic DR drills and validate failover/failback processes.
  • Maintain comprehensive documentation for database architecture, configurations, and operational procedures.
  • Participate in 24x7 on-call rotation and incident response.

Required skills and qualifications:

• Degree/Diploma in Computer Science, Computing, Electrical Engineering, IT or equivalent.
• Good knowledge in one or more of the following platforms and technologies:
  • a. Database (e.g. MS SQL and Oracle)
  • b. Big Data (e.g. Hadoop, NoSQL, Hive, Sqoop, Cloudera)
  • c. Database Activity Monitoring (e.g. Imperva, Guardium, Data Sunrise)
• Good knowledge of Windows platform and Linux platform such as Red Hat and Oracle Linux.
• At least one (1) year experience in installing, configuring or administrating Relational databases, Big data platforms or Database Activity Monitoring tools.
  • Hands-on experience with SQL Server AlwaysOn Availability Groups and Failover Cluster Instances.
  • Proven experience in both Windows environments.

Technical Skills:

• MS SQL Server 2016/2019/2022 (SSMS, SSIS, SSRS, AlwaysOn, FCI).
• Scripting: Shell, PowerShell, Python (for automation).
• Backup tools (NetBackup, CommVault, or equivalent).
• Strong understanding of networking, storage, and OS fundamentals for database performance optimization.

Soft Skills:

• Strong analytical and troubleshooting skills.
• Excellent communication and documentation ability.
• Team-oriented, with experience working in multi-vendor and cross-platform environments.
• Ability to prioritize and manage multiple tasks under pressure.

Preferred skills and qualifications:

• Oracle and/or MS SQL certifications.
• Windows and/or Linux certifications.
• ITIL Foundation.