Purpose of role

We have an exciting opportunity for a Senior SQL Server DBA/Engineer with strong database administration and engineering skills to join a team of highly skilled DBAs who are responsible for managing the SQL Server database estate.

The team are responsible for the day-to-day support and administration of the full SQL Server technology stack including engineering and all SQL Server database related projects. The role involves working closely with other Infrastructure teams as well as developers and end users. This role also offers the opportunity for exposure Azure and to DevOps aligned methods of automation, real time monitoring and metrics collections using latest Open-Source toolsets; Ansible, Grafana, Prometheus and InfluxDB. 

 

Specific responsibilities

The specific responsibilities of the role include:

• Administering and managing the SQL Server Database estate.
• Collaborating with peers in the other technology teams to find the best solutions for Man Group.
• Show a willingness to learn about the technologies in this area.
• Ensure the rollout of a standards-based estate using relevant configuration management tools.
• Capacity planning of the Physical and Virtual Database Server estate.
• Ensuring high availability of the infrastructure and minimising the duration and impact of any outages.
• Maintaining a consistently high level of service delivery for incidents, requests and changes.
• Providing database support and advice to other Infrastructure teams as well as developers and end users.
• Maintain database security standards across the SQL Server database estate.
• Participate in an on-call support rota.

 

Essential Experience

 

• Willingness and ability to innovate. 
• Good communication skills with end users and fellow IT staff members.
• Deep knowledge of SQL Server 2012 to 2022
• Advanced scripting skills in Python, PowerShell, and T-SQL.
•  Experience in setting up and administering AlwaysOn and Mirroring
• Experience of configuring and setting up clustering, Availability Groups and Database mirroring.
• Experience and ability to demonstrate performance diagnosis and tuning techniques in the whole working stack; Database internals, OS, Storage and Networks
•  Proven ability to automate builds and repetitive tasks
•  Flexibility to broaden and develop skills in any area as required.
• The ability to prioritise projects and tasks.

 

Desirable Experience

 

• At least 5 years SQL Server database administration and engineering experience.
•  Exposure to alternative database technologies, including Open-Source RDBMS (e.g., PostgreSQL) and NoSQL databases (e.g., MongoDB).
•  Experience with offsite cloud offerings and installations for example Azure or AWS.
•  Development and interpretation of systematic performance monitoring and metrics
•  A desire to learn and understand more about the Business environment in which you work.