Khurram Rafiq

Principal Technical Specialist at NHS Digital

• United Kingdom
• My current job since April 2014

Role: I have been working as Database Lead operations, providing DBA operational and strategical support and working on migrating databases across to AZURE with Mix of SQL 2008R2 and 2016 using Always on HADR and Hybrid solution.

Key Activities
• Providing support to key architecture decision across NHS.UK domain
• Managing team of database professional (Senior technical specialists)
• Databases Administration as per standard approved procedures
• SQL Server database Migration planning and implementation to Azure 2012 and 2016
• PowerShell script writing for centralized deployment and DBA administration
• OS patching and SQL server patching co-ordination and implementation
• Reviewing standards and best practices
• Data feed implementation and executions on regular basis to keep NHS.UK DB up-to-date
• Reviewing new database architecture for databases for improved performance and simplicity
• Administrating Mirroring, Log shipping across clustered environments
• Performance monitoring and troubleshooting of cluster environments using latest tools
• Reviewing daily DBA administration tasks and suggestion to automate process
• Database auditing planning, implementation and monitoring
• Scalearc Load DB load balance and caching software implementation and administration