This project demands expert MS SQL skills, and we are looking for the right person to join us at this incredibly exciting time as we move to new ways of working, from manual deployments to automation pipelines, from monolithic systems to containerization.
Job Responsibilities
1. Provide Specialist level SQL technical knowledge within the Platform team. You will be the SME in your chosen technology field, whilst also appreciating and contributing to the allied technology stack we support.
2. Participate in the day-to-day workload of the team, utilising Agile methodologies such as Kanban and Scrum.
3. Automate the lifecycle management of SQL DBs, including provisioning, configuration, patching, and decommissioning.
4. Multi-Environment support on MS SQL.
5. Technical SME feeding into an Agile Project delivery artifact such as Scrum meetings, HLDs, LLDs and configuration documentation.
6. Conduct training sessions or workshops to share automation knowledge and best practices with other teams and departments.
7. Develop and maintain standards, technical and user documentation.
Experience Required
1. Advanced MS SQL Backup & Recovery, disaster recovery skills including testing recoverability, and recommending improvements for 24/7 system availability.
2. Implement MS SQL High availability & clustering solutions, standby databases (hot/cold) including on-site and cross-site replication.
3. MS SQL DB Performance tuning & bottlenecks identification.
4. MS SQL Monitoring using SolarWinds, Aria for Operations, and home-grown scripts.
5. Manage MS SQL database security, permissions, user access control (groups & roles), authentication, auditing, and vulnerability.
6. MS SQL Migration strategy, data migration, upgrades, release & version management, fixes & patching.
7. Capacity management overall reporting, MS SQL object storage management, system resources.
8. MS SQL Identify & Automate tasks with scripts.
The ideal candidate will have a strong background in MS SQL performing DB build.
Please apply to the advert for more information.
#J-18808-Ljbffr