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
Tesco has become a market leader by doing the little things that really matter for our customers and colleagues.
It’s part of what makes Tesco such a great place to work, and we’re proud to have been accredited as one of Britain’s Top Employers again this year.
We're the UK's number one retailer and we pride ourselves on offering a great shopping experience. We are passionate about our food, merchandise and services and will always try to get things right for our customers.
But did you know we also offer great job opportunities? With stores, distribution centres and offices across the UK, and a vast variety of roles, we are always looking for people who have a hunger to work with customers and colleagues across our exciting business.
We believe in treating each other with respect and giving everyone an equal opportunity to get on. It's our people that make the difference every day - helping us make a difference for our customers
Should you be successful in your application, your offer will be subject to and conditional upon you providing your bank account details before your agreed start date.
For more information about us please visit
Proud member of the Disability Confident employer scheme
Disability Confident
About Disability Confident
A Disability Confident employer will generally offer an interview to any applicant that declares they have a disability and meets the minimum criteria for the job as defined by the employer. It is important to note that in certain recruitment situations such as high-volume, seasonal and high-peak times, the employer may wish to limit the overall numbers of interviews offered to both disabled people and non-disabled people. For more details please go to Disability Confident .