About This Role
This database administration role focuses on managing and maintaining MSSQL database environments, providing L2+ support, and ensuring high availability and disaster recovery. The position suits a database engineer with strong experience in SQL Server administration and performance tuning.
Responsibilities
- Manage and maintain MSSQL database environments (SQL Server 2016/2019/2022)
- Perform database installations, upgrades, migrations, and decommissioning activities
- Configure and maintain database security, backup, restore, and recovery procedures
- Manage database users, roles, permissions, linked servers, SQL Agent jobs, and maintenance jobs
- Monitor database availability, storage, performance, and overall health
- Support SQL Server hosted on cloud platforms such as AWS EC2 and SQL Server on Azure VM
- Provide L2+ support for database-related incidents and service requests
- Troubleshoot complex database issues and performance bottlenecks
- Investigate blocking, deadlocks, connectivity issues, job failures, backup failures, disk space issues, and database corruption alerts
- Collaborate with application teams, infrastructure teams, cloud teams, and vendors for issue resolution
- Participate in on-call rotation for critical database support
- Support DR drills, failover testing, and recovery validation
- Perform incident analysis, root cause analysis, and provide technical recommendations
- Conduct database health checks and performance tuning
- Optimise SQL queries, indexes, execution plans, statistics, and database configurations
- Analyse wait statistics, Query Store data, expensive queries, I/O latency, CPU usage, memory pressure, and tempdb contention
- Implement and maintain high availability and disaster recovery solutions
- Perform capacity planning and resource management
- Review database growth trends and provide recommendations for archiving, partitioning, storage planning, and scalability
- Implement and maintain monitoring and alerting for performance, availability, capacity, backup status, and SQL Agent jobs
- Develop automation using T-SQL, PowerShell, or other scripting tools to improve operational efficiency
- Maintain database documentation and ensure compliance with security policies and industry standards
- Support database audits, compliance, vulnerability management, access reviews, and remediation activities
- Prepare technical reports, health check findings, incident summaries, and recommendations
- Support change management activities, including risk assessment, implementation planning, validation, and rollback planning
