As one of our SQL DBAs within the Run and Operate chapter, you will be helping the team manage the data platforms environment in a secure and optimised manner. As a member of the team, you will be tasked with supporting the current database instances and providing resilient database solutions to the various challenges that arise using SQL Server and related technologies on a Windows platform. The successful candidate will in the long-term help migrate solutions from on-prem to Azure. The role will include validation of planned changes to ensure that they comply with best practice and will also involve working with the Tesco Mobile Cyber Security Team. Be a team player – live the Tesco Mobile values. SQL server database administration using SQL server 2017/2019. Configuration of SQL Server Instances. Upgrading Instances to the latest versions (currently we are migrating all our SQL server 2012 databases to SQL Server 2019) Creating Test, Pre-Prod and Prod environments. Contributing to creating a coherent strategy for productionising environments. Database housekeeping - working with the team in maintaining and enhancing the performance of existing databases and ensuring databases are highly available. Monitoring databases and related systems to ensure optimized performance. Providing guidance and assistance to Data Engineers and Data Analysts with their SQL and performance issues. Database access management. Database patching and DR testing. Adhering to best practices in securely storing, backing up, and archiving data. Documenting - requirements capture, database design, and configuration. Working with third parties and vendors to raise support tickets and Changes. Support the migration to public cloud-based infrastructure and services (Azure). Keeping abreast of developments and best practices in database engineering. Experience in database administration in SQL Server (SQL 2012, SQL 2017, SQL 2019). Experience of writing T-SQL, including stored procedures, tables, triggers etc. Knowledge of SQL Server tools e.g. SQL profiler. SSIS (from an administration perspective). PowerShell Experience of configuring MS SQL for high availability and Disaster Recovery using SQL Clustering and Always-On Availability Groups Practical experience in monitoring and tuning databases. Understanding of database encryption. Understanding of GDPR and management of data. Ability to resolve data related problems. Ability to communicate with both technical and non-technical people, effectively and constructively. LI-AF2 LI-Hybrid