SQL Database Administrator - Tesco Mobile
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:
Our vision at Tesco is to become every customer's favourite way to shop, whether they are at home or out on the move. Our core purpose is 'Serving our customers, communities and planet a little better every day'. Serving means more than a transactional relationship with our customers. It means acting as a responsible and sustainable business for all stakeholders, for the communities we are part of and for the planet.
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 a big business with diverse working patterns and many business areas which means that we can find something that works for you. Everyone is welcome at Tesco.
We have recently announced that we will be moving towards a more blended working week – combining office and remote working. Our offices will continue to be where we connect, collaborate and innovate. Please talk to us to about how this can work for you.
NOTE: Should you be successful in your application, your offer will be subject to and conditional upon you providing your bank account details on your agreed start date.
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 visit https://www.tesco-careers.com/accessibility
