Share this Job

Database Administrator

Date: 08-Apr-2021

Location: SLOUGH, GB

Company: Telefonica S.A.

 

Tesco Mobile is the UK’s largest mobile virtual network operator (MVNO) with over 5 million customers.  We have a unique position in the market as we benefit from the powerful combination of Tesco’s leading retail estate and massive customer base and O2’s network with 99% UK population coverage. We’ve been a Which? Recommended Provider for 9 years running. In 2018 we were awarded "Best Pay Monthly Network", “Best Network for Customer Service", “Best Value Pay Monthly” and "High Street Retailer of the Year" at the uSwitch Awards.

 

About the team

 

The Data Platforms team is the fulcrum point for data within Tesco Mobile, sourcing data from multiple sources and making it available to various teams / systems / third parties around the business for BI / CRM and various BSS systems
 

The team manages multiple data platforms, among them the core Insight database, an Azure/Databricks analytics platform, an operational data store in Azure supporting APIs and a platform supporting the data generated by a real-time billing system.

In support of the business’ long-term strategic ambition to become a leader in data-driven modelling and decision-making it has a vital role to play in all activities the business undertakes.
 

About the role

 

The Data Platforms team is primarily concerned with sourcing, managing and providing data. The data comprehensively records customer interactions with the business and helps Tesco Mobile deliver industry-leading customer experience as well as the ability to be innovative and profitable.

 

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.
 

Key Responsibilities

 

•    SQL server database administration using SQL server 2012/ 2017/ 2019
•    Installation and configuration of SQL Server Instances
•    Upgrading Instances to the latest versions
•    Creating Test, Pre-Prod and Prod environments
•    Creating a coherent strategy for productionising environments
•    Database housekeeping - maintaining and enhancing the performance of existing databases and ensuring databases are highly available
•    DR testing
•    Working with the Data Platforms Security Admin to ensure Data security and integrity:


•    All database patching is up to date

•    Access control is properly managed, and all database access is audited
•    Adhering to best practices in securely storing, backing up, and archiving data
•    Ensuring PII data is encrypted and access restricted 
•    Monitoring databases and related systems to ensure optimised performance

•    Documenting - requirements capture, database design, and configuration
•    Maintaining Database Technology Roadmaps
•    Working with third-parties and vendors to raise support tickets
•    Keeping abreast of developments and best practices in database engineering

 

Key Skills/Experience

 

Essential
•    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 tools e.g. SQL profiler
•    SSIS, SSRS
•    PowerShell
•    Experience of configuring MS SQL for high availability and Disaster Recovery using SQL Clustering, Mirroring and Always-On Availability Groups
•    Practical experience in monitoring and tuning a database to provide a highly available service
•    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
•    Ability to collaborate and work effectively in a team
•    Strong organizational skills and attention to detail
•    Exceptional problem-solving and critical thinking skills
•    Display The O2 Values


Desired
•    ITIL Certification, understanding of ITIL service management framework
•    Microsoft Certifications
•    Azure knowledge

Location: Slough

Application Closing Date: Wednesday 21st April 2021

 

Salary and Benefits

 

We’re looking to pay a great compensation package (depending on experience) for this position. We also offer plenty of extras to sweeten the deal, which could include things like bonuses, life assurance cover, health care and lots of flexible benefits.  

 

Also, every employee has their personal development supported with a LinkedIn learning account; plus other role specific learning available through our award-winning digital learning platform - O2 Campus. 

 

We also believe a great work-life balance is important, so we’re open to considering flexible working arrangements. Like to know more, feel free to raise it.  

 

Join us and we’ll encourage you to be bold every day. So take a deep breath, your career is about to go to exciting new places. 

 

If you have any questions around the role then please email ResourceTUK@o2.com who will be happy to help.