Database Administrator

• Provide full administration of SQL Server across on-premises VMware and Azure Cloud environments
• Install, configure, patch and maintain SQL Server instances and databases
• Automate repetitive database administration work
• Develop, review and optimise stored procedures, queries and indexes and resolve performance issues
• Manage backup, restore, security, access controls and database health
• Act as a technical escalation point and work with vendors on complex issues
• Complete morning production checks covering system health, overnight jobs, monitoring and alerts
• Monitor database platforms using Redgate SQL Monitor and Azure Monitor and refine alerting thresholds
• Participate in daily cross-team stand-ups and track work through Azure DevOps boards
• Handle ITSM incidents, BAU tasks and service requests through delivery
• Own incidents as DRI, including triage, resolution, root-cause analysis and blameless post-mortems
• Automate alert management and resolve database incidents through closure
• Raise, document and implement changes under client governance, including presenting at CAB
• Apply data protection controls for PII data and participate in DPIA processes
• Communicate with technical and business stakeholders throughout incidents and changes
• Remove repetitive toil using PowerShell/dbatools, T-SQL, SQL Agent/Elastic Jobs and ADO pipelines
• Build runbooks and self-healing remediation for recurring alerts
• Integrate database changes into CI/CD using Redgate or SSDT with release validation
• Support project work alongside BAU and contribute to the client change portfolio and roadmap
• Support Dynamics case and claims data flows using Azure Data Factory pipelines
• Assist with Azure Synapse, ETL and batch processing
• Advise on reliability, cost and security for database workloads, including VMware-to-Azure migrations
• Apply least-privilege, auditing and encryption standards
• Maintain documentation, runbooks, procedures and provisioning records in Confluence