Database Administrator (DBA) – SQL

ITCAN PTE. LIMITED; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

ITCAN PTE. LIMITED is seeking a Database Administrator/Engineer in Singapore to install, configure, and optimize Microsoft SQL Server environments. You will monitor health, perform backups, and troubleshoot performance issues while implementing HA/DR strategies and security policies.

The role involves regular migrations, patching, and automation using T-SQL and PowerShell, with collaboration across IT and development teams. On-call support is required as part of the duties.

Qualifications

• Strong hands-on experience with Microsoft SQL Server.
• Proficient in T-SQL and SQL query optimization.
• Experience with SSMS and database maintenance plans.
• Knowledge of HA/DR solutions and database security.

Responsibilities

• Install, configure, maintain, and upgrade Microsoft SQL Server databases.
• Monitor performance, availability, capacity, and health of databases.
• Perform regular backup, restore, and recovery activities.
• Troubleshoot performance issues, blocking, deadlocks, and connectivity problems.
• Optimize SQL queries and perform performance tuning.
• Manage indexes, procedures, views, functions, and jobs.
• Configure and maintain HA/DR solutions, including Always On and failover
• Support Always On Availability Groups, Failover Clustering, Log Shipping, and Replication.
• Manage database users, roles, permissions, and security policies.
• Perform migrations, patching, upgrades, and server refresh activities.
• Monitor storage, growth, CPU, memory, and utilization.
• Develop scripts using T-SQL/PowerShell for automation.
• Perform root-cause analysis and implement preventive measures.
• Collaborate with application, infrastructure, development, and support teams.
• Provide production database support and participate in on-call after-hours.

Skills

SQL Server

T-SQL

PowerShell scripting

Performance tuning

SSMS

Tools

Azure SQL Database / Azure SQL Managed Instance / AWS RDS for SQL Server

Job description

Job Responsibilities

• Install, configure, maintain, and upgrade Microsoft SQL Server databases.

• Monitor database performance, availability, capacity, and overall health.

• Perform regular database backup, restore, and recovery activities.

• Troubleshoot database performance issues, blocking, deadlocks, failed jobs, and connectivity problems.

• Perform SQL query optimization and performance tuning.

• Manage indexes, statistics, stored procedures, views, functions, and database jobs.

• Configure and maintain SQL Server High Availability (HA) and Disaster Recovery (DR) solutions.

• Support technologies such as Always On Availability Groups, Failover Clustering, Log Shipping, and Replication.

• Manage database users, roles, permissions, authentication, and security policies.

• Perform database migration, patching, version upgrades, and server refresh activities.

• Monitor disk space, database growth, transaction logs, CPU, memory, and database utilization.

• Develop and maintain scripts using T-SQL/PowerShell for database administration and automation.

• Perform root-cause analysis for database incidents and implement preventive measures.

• Work closely with application, infrastructure, development, and support teams.

• Provide production database support and participate in on-call / after-hours support when required.

• Maintain database documentation, operational procedures, and change records.

Technical Skills

• Strong hands-on experience with Microsoft SQL Server.

• Strong knowledge of T-SQL and SQL query optimization.

• Experience with SQL Server Management Studio (SSMS).

• Good understanding of database architecture, indexing, execution plans, locking, blocking, and deadlocks.

• Experience with backup, recovery, HA and DR solutions.

• Knowledge of SQL Server Agent, maintenance plans, monitoring, and alerting.

• Experience with database security and access management.

• Exposure to PowerShell scripting and database automation is preferred.

• Knowledge of Azure SQL Database / Azure SQL Managed Instance / AWS RDS for SQL Server is an advantage.