Database Administrator

Job Introduction
Join WMCA as a Database Administrator and play a pivotal role in safeguarding the performance, integrity, and security of our database systems. In this critical position, you will manage and optimise our database infrastructure, ensuring data is stored accurately, readily accessible, and protected against loss or unauthorised access. Working closely with Technology & Insight teams, you’ll design, monitor, and troubleshoot databases, implement robust backup and recovery strategies, and support the technical development of new and existing systems across on-premises and cloud platforms. This is an opportunity to make a real impact by delivering resilient, high-performing solutions that underpin the organisation’s digital transformation and service excellence.

**Please note, this is a 12 month Fixed Term Contract.**

**What you will be doing.**

- Design and manage comprehensive backup and recovery strategies to safeguard data integrity and ensure business continuity in the event of system failures or disasters for on-prem and cloud-based databases.
- Implement robust security protocols to protect databases from unauthorized access and breaches. Configure user roles, permissions, and encryption, and proactively monitor for suspicious activity.
- Conduct regular performance reviews, analyse query efficiency, and optimise indexing and database structures to ensure peak performance.
- Developing and testing disaster recovery plans to ensure that the database can be quickly restored in the event of a catastrophic failure.
- Streamline routine tasks such as backups, monitoring, and maintenance through automation, reducing risk and increasing operational efficiency.
- Predicting future database growth and planning for the necessary hardware and storage resources to accommodate that growth.
- Manage ETL (Extract, Transform, Load) processes to ensure accurate and efficient integration of data from diverse sources, supporting analytics and decision-making across the organisation.
- Collaborating with developers and other stakeholders to design and develop database schemas, tables, and other structures that meet the needs of the organisation.
- Work with architects, project managers and other key stakeholders on the design and delivery of change work utilising databases.

**What’s essential.**

- Familiarity with industry best practices and emerging trends in SQL Server database administration.
- Understanding of relational database management systems and their principles.
- Proven experience in managing SQL Server databases in a production environment.
- Strong experience as a DBA.
- In-depth knowledge of SQL Server database administration, including database design, installation, configuration, and maintenance.
- Broad knowledge of different database technologies and the appropriate use of them.
- Proficient in writing complex SQL queries, stored procedures, triggers, and functions.
- Knowledge of database security best practices and the ability to implement and enforce security measures.
- Strong problem-solving and troubleshooting skills.
- Either hold or be working towards a certification in SQL Server administration

**Location.**

The location for this role is 16 Summer Lane, Birmingham, B19 3SD with at least 2 days a week spent in the office.

**How to apply**.

- **Build your Profile.**Upload your CV to help populate your career and education details.
- **Write your Supporting Statement.**Make sure to address each of the required essential criteria.

**Anonymised Applications.**

Your uploaded CV won’t be visible after submission. Our process is anonymised, and **only the information in your profile is used for shortlisting**. Be thorough in each section. It’s your chance to showcase your skills and experience.

**Using Artificial Intelligence (AI)**

Applications that rely too heavily on AI may be rejected during shortlisting. For help on how to write a supporting statement, please visit the **FAQs** section of our careers site.

**Reasonable adjustments.**

**Salary and benefits.**

We offer a comprehensive benefits package that includes:

- Local Government Pension Scheme (**one of the most generous pension schemes in the UK**).
- **Shared Cost Additional Voluntary Contribution**scheme where you can build an additional pot of money alongside your pension with contributions exempt from Income Tax and National Insurance contributions (NICs).
- **28 days** paid annual leave (with an option to purchase more) + Statutory days.
- **EV car benefit scheme**
- **Healthcare plans.**
- Discounted **gym membership, will writing,**and** mortgage advice.**
- An option to **buy a bicycle**, including e-bikes and adapted pedal cycles, at a discounted rate.
- **3 days** of paid leave each year to **volunteer**.
- **Interest-free financing** through SmartTech to buy the latest technology
- **Discounted shopping** with over 2,000 big-name retailers, and more. You can now also obtain a **Costco**membership thr