Pearson Database Administrator (DBA) in Rotherham, United Kingdom
Role: Database Administrator (DBA) (full or part time)
Division: Assessment & Qualifications Delivery
Location: Rotherham or London, UK. Hybrid-working
About UK Assessment & Qualifications
We are responsible for the delivery of nearly 4 million examination results per annum, including A-Level, GCSE, BTEC and T-levels for students in UK and International centres. Our in-house systems process every learner from registration to marking and certification, in a highly regulated business. We currently operate a hybrid estate of predominantly bespoke systems, with an ongoing strategic transformation programme to migrate from on-prem to cloud based, cost effective, scalable and resilient services.
About the Job
The main purpose of this role is to provide core database administration services to systems using SQL Server. This includes proactive monitoring and management of the database environment along with reactive response to customer / user initiated calls. This role will interact with the project and development teams through design and testing but will have primary focus on production database administration so as to monitor, measure and tune these core systems in line with the demands of the business. The role will require the ability to deploy Data Migration Service (DMS) technologies to ensure data is available for future state cloud services.
The DBA team have responsibility for the data held in the core systems making up the Enterprise, ensuring it is well maintained, audited, secure and delivers to business needs. Process, control, quality, audit ability and security of this data in line with standards is paramount.
This would suit an experienced DBA with a strong technical background, who is proficient in Microsoft SQL Server, with an established history of working with Agile teams.
Key Skills & Experience
Knowledge of MS SQL from 2005 to 2019
Implementing performance improvements and tuning of databases.
Liaising with the teams to ensure systems are robust, stable and effective.
Manage and testing backup and disaster recovery strategies; Guaranteeing the ability to be able to recover production databases.
Deployment of the database component for applications, services and micro services.
Pro-active system and capacity monitoring.
Ensuring security and data integrity is maintained and improved where possible while maintaining a high level of system availability.
Some knowledge of Policy Based Management for SQL Server.
Exposure to Data at Rest Encryption.
Automating routine administration tasks.
Liaising with project managers and developers regarding requirements for new systems and/or extensions to existing systems and providing guidance with SQL queries and best practices.
Implementing alerting to provide advanced warning of major problems.
Supporting Test and Development Systems.
Producing and maintaining operational and technical documentation.
Understanding of SDLC in Agile environments.
Ability to produce ad-hoc reports as required.
An established history of working with agile teams.
Familiarity with the design and implementation of fault tolerant and secure data infrastructure, in line with best practices.
Security processes to deliver effective IT security & compliance in line with CISO requirements.
How to collaborate with globally distributed teams.
Some knowledge of deployments to a cloud environment
Any knowledge of Data Migration Services would be an advantage.
Experience of knowledge transfer to BAU support teams
Previous experience of collaborating with co-workers on root cause analysis for incident and problem post-mortems
Superb communication skills: written and verbal
Desirable Skills & Experience
SQL Reporting Services
Awareness of IaaS, PaaS and SaaS
Cloud Compute Accounting
Data Migration Services
Experience working with observability tools, such as Grafana
To become the subject expert for MS SQL.
Understanding and experience of leading / managing technology products
The role is aligned to either our Rotherham or central London offices. Our Rotherham office is located at Junction 1 of the M18, making it commutable from Sheffield, Leeds, Doncaster, Derby or Nottingham.
We have worked from home throughout the pandemic, but will adopt hybrid working once national restrictions are lifted; for this role that means visiting your base office no more than once a week with the possibility of occasional travel to other Pearson sites, however, adjustments to this due to personal circumstances & preferences are possible.
We work a 37.5 hour week, with all our team free to flex their day around our core hours, which are Monday to Friday, 10 to 4 GMT/BST. School runs, etc can be accommodated. Other flexible working patterns can be considered, including part-time working and non-traditional hours. As we regularly work with global teams, particularly in India and the US, there may be the occasional need to accommodate meetings outside of core hours.
For this role there is a requirement to support 24/7/365 on-call operations.
We actively encourage our staff to participate in at least 40 hours of training a year, and offer relevant AWS training and certification as part of this role.
Your benefits and rewards
Here at Pearson we offer a range of benefits, which include:
25 Days annual leave (increasing by 1 day with every year of continuous service up to 30 days); annual leave trading, +/- 5 days
Private Pension plan scheme where we pay in double what you contribute, up to 16% depending on your age
Life, private medical and dental care insurance options, plus free eye tests
Stock/share purchase options
Maternity, paternity, and family care leave as well as flexible working policies
An employee wellbeing assistance programme
Cycle to work program, volunteering days, gym membership concessions in selected office locations, along with retail and leisure discounts
Diversity and Inclusion at Pearson
Pearson is delighted to be committed to the Race Charter and have pledged to ACT ON to support a more inclusive workplace for all our employees. We are confirmed by Stonewall in the Top 100 LGBTQ+ Employers in the UK, and received 100% on the Human Rights Campaign Foundation’s Corporate Equality (CEI) Index for 2020, a primary driving force for LGBTQ workplace inclusion. We are on the Disability Equality Index, Bloomberg Gender Equality Index, have achieved Investors in People Gold, and are a Working Mums Top Employer and Age Positive employer.
Organization: Assessment & Qualifications
Req ID: 4392