Role: Database Administrator (DBA) (full or part time) Division: Assessment & Qualifications Delivery Location: Rotherham or London, UK. Hybrid-working About Pearson We have more than 20,000 employees that deliver our products and services in nearly 200 countries, all working towards a common purpose – to help everyone achieve their potential through learning. We do that by providing high quality, digital content and learning experiences, as well as assessments and qualifications that help people build their skills and grow with the world around them. From world-class assessment to virtual learning and beyond – we create the products and services that help tens of millions of people reach their goals each year. And we make sure our products fit with our key sustainability targets – to make learning accessible to everyone, to lead responsibly, and to give the next generation the skills they need to shape a better world. Our success and ability to help people achieve their potential depends upon us being able to grow with, and adapt to, the rapidly changing learning market. That’s why our digital-first strategy puts consumers at the heart of everything we do, enabling us to deliver the best products and learning outcomes to more people than ever before. Pearson is listed on both the London and New York Stock Exchanges (LON: PSON; NYSE: PSO). 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. About You This would suit a 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 Strong Knowledge of MS SQL from 2005 to 2019 Performance and tuning of databases Developing, managing and testing backup and disaster recovery strategies; Guaranteeing the ability to be able to recover production databases Implementing performance improvements and tuning of the 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 Knowledge of Policy Based Management for SQL Server Knowledge of Data at Rest Encryption Automating routine administration tasks 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 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 Some knowledge of deployments to a Cloud environment Any knowledge of Data Migration Services could be an advantage Understanding of a DevOps environment with daily collaborations Experience of knowledge transfer to BAU support teams Liaising with the team to ensure systems are robust, user friendly, stable and effective 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 Collaboration with globally distributed 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 ITIL AWS Exposure Aurora RDS Oracle Awareness of IaaS, PaaS and SaaS Cloud Compute Accounting Data Migration Services Experience working with observability tools, such as Grafana 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
Source ⇲
Reed.co.uk - job search results
