Database Administrator - Manchester, United Kingdom - Car Finance 247

Car Finance 247

Verified Company

Manchester, United Kingdom

2 weeks ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

About The Role:

Here at CarFinance 247 an exciting opportunity has arisen and we are recruiting for a Database Administrator to join our Data Team.

As the Database Administrator, you will work primarily with both on premise Microsoft SQL Server and Azure SQL Database.

You will cover all areas of database administration, from backups, server configuration and integrity checking, through performance monitoring, alerting and tuning, to code reviews, schema design and ownership of the database CI pipeline.

Responsibilities Include:

-
Performance Monitoring and Alerting:

Ensuring that performance thresholds are maintained;
Creating and maintaining alerting channels for critical issues (slack);

-
Backups, High Availability & Integrity checks:

Ensuring that the Carfinance 247 backup strategy is implemented and maintained;
Ensuring that Availability Groups are healthy and performant;

-
Performance Tuning:

Provide advice and consultation to the development team to ensure production code is performant;
Review indexing strategy and ensure that these are maintained;

-
Security:

Provide and monitor access to data based on a minimum rights best practise;

-
CI and Code Reviews:

Own and monitor the CI pipeline for SSDT based deployments;
Perform code reviews in GIT for database schema and code changes;

-
Research and development:

Taking regular R&D days to keep abreast of the latest developments;
Prototyping alternative solutions and new products.

About You:

Essential:

T-SQL
Backup and Restores;
Security;
Performance tuning and SQL Server internals;

Desirable:

Experience working with CI tools and source control (GIT);
High Availability (Always On Groups);
Powershell;
VMWare & running SQL Server on virtual machines;
Change Data Capture (CDC) experience;
Azure;

About Us:

Subsidised Onsite Parking
A great working environment with free fruit and juice bars
Birthday off
Onsite Gym
Free transport to and from piccadilly station
Free Barista bar serving teas and coffees
Excellent career progression

About Us

At CarFinance 247 our determination and strong team culture have helped us become the number one online car finance broker in the UK.

We're one of the UK's fastest growing privately owned businesses, having ranked in the Sunday Times Fast Track 100 for each of the last four years.

CarFinance 247 is an award-winning business just outside of Manchester City Centre. We create personalised and high quality customer experiences driven by outstanding tech, streamlined process and most importantly, amazing people.

Over the next 12 months we have exciting upcoming projects to cement our position as market leaders in every aspect of our business and that journey starts with attracting the best talent.