Database Administrator

WMJobs; Birmingham; Hybrid; GBP 45,000 - 60,000; Full time

Benefits offered by this job

Local Government Pension Scheme

28 days paid annual leave

Discounted gym membership

Healthcare plans

Interest-free financing through SmartTech

Gym Discount

Eye Care

Job summary

A public sector organization in Birmingham is seeking a Database Administrator to manage and secure their database systems. Responsibilities include optimizing performance, implementing security measures, and developing backup strategies. Candidates should have proven SQL Server management experience and strong problem-solving skills. This role offers a competitive benefits package including local government pension and 28 days annual leave.

Qualifications

• Proven experience in managing SQL Server databases in a production environment.
• Deep knowledge of SQL Server database administration including design and maintenance.
• Experience with writing complex SQL queries and stored procedures.
• Knowledge of database security best practices and implementation.
• Certifications in SQL Server administration or in progress.

Responsibilities

• Manage and optimize database infrastructure for security and performance.
• Develop and implement robust backup and recovery plans.
• Streamline routine database tasks through automation.
• Develop and test disaster recovery plans.
• Automate routine tasks to improve reliability and efficiency.
• Plan hardware and storage to accommodate growth.
• Manage ETL processes for data integration.
• Collaborate with developers to design database schemas.
• Work with stakeholders on change delivery using databases.

Skills

SQL Server management

Complex SQL queries

Database security best practices

Troubleshooting

Backup and recovery strategies

Troubleshooting

Education

SQL Server administration certification (or in progress)

Job description

Database Administrator

West Midlands Combined Authority (WMCA) is seeking a Database Administrator to safeguard the performance, integrity, and security of our database systems. In this critical role you will manage and optimise our database infrastructure, ensuring data is stored accurately, readily accessible, and protected against loss or unauthorised access. You will 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.

What You Will Be Doing

• Design and manage comprehensive backup and recovery strategies to safeguard data integrity and ensure business continuity for on‑premises and cloud‑based databases.
• Implement robust security protocols to protect databases from unauthorised 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.
• Develop and test disaster recovery plans to ensure 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.
• Predict future database growth and plan 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.
• Collaborate 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

• Proven experience in managing SQL Server databases in a production environment.
• Deep knowledge of SQL Server database administration, including database design, installation, configuration, and maintenance.
• Strong experience as a DBA with proficiency 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

16 Summer Lane, Birmingham, B19 3SD – at least two days a week spent in the office.

How to Apply

• Create a Careers Account, register with name, email address, and password.
• Build your profile – upload your CV.
• Write your supporting statement – address each essential criterion.
• Submit your application – click submit.

Salary And Benefits

We advertise salary ranges, with new appointments typically starting at the lowest salary point. Benefits include:

• Local Government Pension Scheme.
• Shared Cost Additional Voluntary Contribution scheme.
• 28 days paid annual leave + statutory days.
• EV car benefit scheme.
• Healthcare plans.
• Discounted gym membership, mortgage advice.
• Option to buy a bicycle (including e‑bikes, adapted pedal cycles).
• Three days of paid volunteer leave.
• Interest‑free financing through SmartTech.
• Discounted shopping with over 2,000 retailers.
• Boundless unlocks to UK attractions and discounts.
• Eye Care Scheme – free eye test and glasses contribution.

Why join WMCA

WMCA is laser‑focused on improving the West Midlands – bringing economic growth, jobs, homes and better journeys. We value people and place, working with partners to direct funding where it matters most.

Creating an Inclusive Workplace

We are a recognised Inclusive Top 50 Employer, hold diversity accreditations, and are a Disability Confident Employer. We encourage all eligible applicants to apply.