Job Description

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 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 ITIL AWS Exposure RDS Awareness of IaaS, PaaS and SaaS Cloud Compute Accounting Data Migration Services Experience working with observability tools, such as Grafana Understanding and experience of leading / managing technology products To become the subject expert for MS SQL. 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 Annual Bonus 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

foundit