Database Administrator (DBA) – SQL

Sep 28, 2026 3 views

ITCAN PTE. LIMITED Database Administrator (DBA) – SQL

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.

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.

Skills