Job Description
Job description
About the role
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.
You will be responsible for
• 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.
You will need
• 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
What’s in it for you
We’re all about the little helps. That’s why we give our wonderful colleagues bags of benefits. Including wellbeing services, an award-winning pension scheme and much, much more, our colleague reward package keeps on giving. And helps make every day a little better for you and your family. These include but are not limited to:
• Annual bonus scheme of up to 20% of base salary
• Holiday starting at 25 days plus a personal day (plus Bank holidays)
• Buy holiday salary sacrifice scheme (for salaried roles)
• Private medical insurance
• Retirement savings plan - save between 4% and 7.5% and Tesco will match your contribution
• Life Assurance - 5 x contractual pay
• 26 weeks maternity and adoption leave (after 1 years’ service) at full pay, followed by 13 weeks of Statutory Maternity Pay or Statutory Adoption Pay, we also offer 4 weeks fully paid paternity leave
• The right to request flexible working from your first day with us
• Free 24/7 virtual GP service, Employee Assistance Programme (EAP) for you and your family, free access to a range of experts to support your mental wellbeing
• A Colleague Clubcard for you & a family member (after 3 months of service), giving you access to lots of discounts in-store & online
• Great colleague deals and discounts, saving you money on everyday purchases, eating out and utility bills for the home
• Access to our colleague networks providing a space for colleagues to come together from a range of backgrounds. For more information about our colleague networks please click here
• Opportunities to get on - take advantage of our ongoing learning opportunities and award-winning training, to help you achieve the job and career you want
Click Here to read more about the full range of benefits we have available for our colleagues
About us
A 50-50 joint venture between Tesco and VMO2 that was established back in 2003, Tesco Mobile has gone from strength to strength as we’ve launched into new services and markets. With more than 5 million customers, we’re the largest mobile virtual network operator in the UK. We’re proud to have an inclusive culture that’s uniquely Tesco Mobile, with a strong sense of community, plus all the benefits of working for one of the shareholders.
We care for human connection and we keep our customers at the heart of everything we do, which is why we’ve embraced the Agile way of working. Agile is more than just a methodology – it’s a liberating journey that puts customers and purpose first. It empowers us to self-organise, collaborate, co-create and rapidly inspect and adapt everything we do – allowing us to respond at pace to our customers’ needs. It encourages variety of thought and enables us to thrive, both individually and collectively.
We are proud to have an inclusive culture at Tesco where everyone truly feels able to be themselves. At Tesco, we not only celebrate diversity, but recognise the value and opportunity it brings. We're committed to creating a workplace where differences are valued, and make sure that all colleagues are given the same opportunities. We’re proud to have been accredited Disability Confident Leader and we’re committed to providing a fully inclusive and accessible recruitment process. For further information on the accessibility support we can offer, please click here.
We’re a big business and we can offer a range of diverse full-time & part-time working patterns across our many business areas, which means that we can find something that works for you. We work in a more blended pattern - combining office and remote working. Our offices will continue to be where we connect, collaborate and innovate. If you are applying internally, please speak to the Hiring Manager about how this can work for you - Everyone is welcome at Tesco.
About the role
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.
You will be responsible for
• 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.
You will need
• 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
What’s in it for you
We’re all about the little helps. That’s why we give our wonderful colleagues bags of benefits. Including wellbeing services, an award-winning pension scheme and much, much more, our colleague reward package keeps on giving. And helps make every day a little better for you and your family. These include but are not limited to:
• Annual bonus scheme of up to 20% of base salary
• Holiday starting at 25 days plus a personal day (plus Bank holidays)
• Buy holiday salary sacrifice scheme (for salaried roles)
• Private medical insurance
• Retirement savings plan - save between 4% and 7.5% and Tesco will match your contribution
• Life Assurance - 5 x contractual pay
• 26 weeks maternity and adoption leave (after 1 years’ service) at full pay, followed by 13 weeks of Statutory Maternity Pay or Statutory Adoption Pay, we also offer 4 weeks fully paid paternity leave
• The right to request flexible working from your first day with us
• Free 24/7 virtual GP service, Employee Assistance Programme (EAP) for you and your family, free access to a range of experts to support your mental wellbeing
• A Colleague Clubcard for you & a family member (after 3 months of service), giving you access to lots of discounts in-store & online
• Great colleague deals and discounts, saving you money on everyday purchases, eating out and utility bills for the home
• Access to our colleague networks providing a space for colleagues to come together from a range of backgrounds. For more information about our colleague networks please click here
• Opportunities to get on - take advantage of our ongoing learning opportunities and award-winning training, to help you achieve the job and career you want
Click Here to read more about the full range of benefits we have available for our colleagues
About us
A 50-50 joint venture between Tesco and VMO2 that was established back in 2003, Tesco Mobile has gone from strength to strength as we’ve launched into new services and markets. With more than 5 million customers, we’re the largest mobile virtual network operator in the UK. We’re proud to have an inclusive culture that’s uniquely Tesco Mobile, with a strong sense of community, plus all the benefits of working for one of the shareholders.
We care for human connection and we keep our customers at the heart of everything we do, which is why we’ve embraced the Agile way of working. Agile is more than just a methodology – it’s a liberating journey that puts customers and purpose first. It empowers us to self-organise, collaborate, co-create and rapidly inspect and adapt everything we do – allowing us to respond at pace to our customers’ needs. It encourages variety of thought and enables us to thrive, both individually and collectively.
We are proud to have an inclusive culture at Tesco where everyone truly feels able to be themselves. At Tesco, we not only celebrate diversity, but recognise the value and opportunity it brings. We're committed to creating a workplace where differences are valued, and make sure that all colleagues are given the same opportunities. We’re proud to have been accredited Disability Confident Leader and we’re committed to providing a fully inclusive and accessible recruitment process. For further information on the accessibility support we can offer, please click here.
We’re a big business and we can offer a range of diverse full-time & part-time working patterns across our many business areas, which means that we can find something that works for you. We work in a more blended pattern - combining office and remote working. Our offices will continue to be where we connect, collaborate and innovate. If you are applying internally, please speak to the Hiring Manager about how this can work for you - Everyone is welcome at Tesco.
💡 Quick Summary
Seeking a career-building opportunity? The SQL Database Administrator - Tesco Mobile position is now open for candidates interested in the Database Administrator sector. This role in England offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
