Database Administrator (SQL Server)

- Administer, maintain, develop, and implement policies and procedures for database security and integrity - Design and implement data models, database designs, and table maintenance codes - Resolve database performance, capacity, replication, and distributed data issues - Manage SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) effectively - Implement high availability and disaster recovery solutions using clustering, database mirroring, log shipping, and AlwaysOn replication - Perform database performance tuning and diagnostics using SQL Profiler, Extended Events, and Database Engine Tuning Advisor - Write and optimise T-SQL code, including views, functions, stored procedures, and triggers - Handle backup recovery, index design, and analysis - Upgrade and migrate SQL Server instances/databases as needed - Monitor system health and performance, ensuring high levels of availability and security - Analyse, troubleshoot, and correct database issues in real-time - Collaborate with developers for query tuning and schema refinement - Document changes and automate regular processes for efficiency - Work in a controlled access environment, adhering to industry baselines - Familiarity with ITIL service management processes (Change, Release, Problem, and Incident Management) is a plus - Engage with various teams and stakeholders, showcasing strong communication skills