Database Administrator

Primary Work Location: People's Partnership - Manhattan Building, Crawley

Description:

Database Administrator

About People’s Partnership:
At the heart of our not-for-profit organisation is a commitment and a motivation to make the future-saving experience a simple one for our members. We champion fairness and simplicity, not profit-chasing. Imagine a financial adventure where everyone's a winner, fuelled by our exceptional service and brought to life by the fantastic individuals who work for us. We're a diverse employer with a flexible, hybrid working approach, ensuring everyone gets the opportunity to come to work and be the best version of themselves.

What you'll be doing:

1. Develop and maintain an effective IT Database function that supports the needs of the group's activities, including the integration and management of cloud-based database solutions across all Azure platforms, including PaaS, IaaS, and SaaS.
2. Provide effective access to corporate data while ensuring the security and integrity of data items and their control environment.
3. Installation, upgrading, configuring, administering, monitoring, troubleshooting, and securing production, test, replication, and cluster servers for MS SQL Server.
4. Administer large complex databases, including High Availability Disaster Recovery (HADR), security management, job creation, alerts, SQL mail management, and using tools such as NT Performance Monitor, SQL Query Analyzer, Extended Events, SQL Profiler, and third-party tools (Redgate and SolarWinds).
5. Manage and maintain databases across all Azure platforms, ensuring performance, availability, and assisting in monitoring failovers across Azure systems.
6. Implement automated backup strategies, manage point-in-time recovery for on-premises databases and across all Azure platforms, and control backups and recovery of databases and associated software.
7. Use tools like Azure Monitor, SQL Insights, and Redgate to track database health, optimise performance, and monitor databases both in Azure and on-premises, addressing any issues promptly.

What we’re looking for:

1. 5 years’ experience in Microsoft SQL environments. Database design and optimisation.
2. Azure SQL knowledge and Microsoft Certification.
3. SQL Server database experience version 2016, 2019 and 2022.
4. SQL Troubleshoot and root cause analysis.
5. TSQL.
6. MS SQL Clustering.

What you can expect from us:

1. Generous pension contributions with an employer contribution of up to 14%.
2. Real living wage.
3. Income protection, critical illness cover & death in service insurance.
4. Employee healthcare.
5. Parental and adoption leave.
6. Learning & development opportunities and study support.
7. Travel season ticket loans.
8. Subsidised restaurant in our Crawley office.
9. Volunteering days and charity payroll giving.
10. Onsite gym.
11. Ride-to-Work scheme.
12. Social clubs and events.

You can learn more about how we support our employees on our website.

Disability Statement:
People's Partnership is an equal opportunities employer. We believe everyone has the right to be treated fairly, with dignity and respect. We are committed to treating all our people (and all who apply for a role at People's Partnership) equally and enabling them to perform at their best and demonstrate what they have to offer. We are a disability committed employer, please let us know if you need any reasonable adjustments made to our recruitment process (application, selection assessments where relevant, and interview) to enable you to show us the best “you”.