Database Developer

JR United Kingdom; Poole; On-site; GBP 40,000 - 70,000; Full time

Job summary

A forward-thinking company is seeking an experienced SQL Database Administrator to support and maintain a large-scale data warehouse environment. This role involves managing high volumes of structured data, developing ETL pipelines, and collaborating with stakeholders to deliver custom reports. The ideal candidate will have strong expertise in SQL Server and a passion for data integrity. Join this innovative firm to be part of a dynamic team that values diversity and is committed to making a positive impact on society.

Benefits

Life Assurance

5% annual bonus

Pension Scheme

Health Cash Plan

Dental Benefits

Annual Leave

Sick Pay

Qualifications

• Proven experience with Microsoft SQL Server and data warehousing.
• Ability to develop and support ETL pipelines and reporting systems.

Responsibilities

• Support and maintain a large-scale data warehouse environment.
• Collaborate with support teams to resolve complex data issues.

Skills

SQL Server

Data Warehousing

SSIS

ETL Development

Data Integrity

Agile Development

Education

Bachelor's Degree in Computer Science or related field

Tools

Visual Studio

JIRA

GitLab

Job description

Social network you want to login/join with:

At Peregrine, we’re always seeking Specialist Talent that have the ideal mix of skills, experience, and attitude, to place with our vast array of clients. From Project Change Professionals in large government organisations to Software Developers in the private sector – we are always in search of the best talent to place, now.

How Specialist Talent Works:

At Peregrine, we find the best talent for our clients. Unlike traditional contractors, where you are hired by the client, you remain a permanent employee of Peregrine, with access to all our standard benefits:

• A Permanent Position in a Market-Leading Workforce Solutions company
• Life Assurance
• 5% annual bonus
• Pension Scheme – Employer matched to 5%
• Voluntary Benefits – Health Cash Plan, Dental, Will Writing etc
• Annual Leave – 23 days rising to 27 with length of service
• Sick Pay – Increasing with length of service

The Role:

We are looking for an experienced SQL Database Administrator.

Key Responsibilities:

• Support and maintain a large-scale data warehouse environment, handling high volumes of structured data.
• Manage and process incoming data streams from external sources (e.g. cameras and monitoring systems).
• Develop and support server-side data processing workflows to ensure timely and accurate data ingestion.
• Collaborate with 2nd and 3rd line support teams, providing expertise on complex data-related issues.
• Maintain and optimise the central database infrastructure, ensuring performance, reliability, and scalability.
• Work closely with stakeholders to deliver custom reports and analytics, particularly for transport and public sector clients (e.g. TfL).
• Ensure data integrity, transformation, and storage aligns with business and regulatory requirements.
• Participate in long-standing, enterprise-level projects requiring consistent support and system knowledge.
• Troubleshoot data warehouse and integration issues and implement enhancements for improved performance and reliability.
• Contribute to the design, development, and maintenance of ETL pipelines and reporting systems.

Requirements:

• Microsoft SQL Server Database deployed on-premise and in the cloud.
• Always On replication to a secondary DR host.
• Ability to produce Maintenance scripts to archive, partition, compress, purge, encrypt data.
• SQL Server Integration Services (SSIS) development which transfers data from several MySQL databases to the SQL Server
• Support for SQL Server Reporting Services (SSRS) development and migration towards Power BI.
• Use of Visual Studio for development and deployment of Solution to Developer, System Test and Production Environments.
• Ability to upgrade versions of Microsoft products in line with security upgrades
• Agile development using JIRA and GitLab for storage of all changes.
• Provide support for costings for storage estimates and CPU requirements for on-going work and new bids.
• Ability to provide documentation for design and deployment instructions for 2ndline support to perform
• Experience working in a fast-paced environment and able to work to SLA’s.

About us:

At Peregrine, we see beyond the immediate and look to the horizon. We build lasting, meaningful partnerships with our clients, and deliver flexible solutions for every resourcing need, both now and in the future. Together, we help our clients to engage, develop and harness the skills they need to achieve and grow the workforce they want.

Our culture:

At Peregrine we embrace fresh ideas, and we love learning fast. Our solutions are trusted and established, so we have the confidence of knowing we have a solid foundation. We rely on openness and honesty, and we’re always ready to help each other out. And we believe that our work can benefit society – whether it’s finding the digital talent of the future or being a driver for social mobility.

Our commitment to diversity:

At Peregrine, we’re proudly committed to championing diversity and inclusion, with company-wide initiatives to drive greater social mobility and reduce our environmental impact. Our teams represent a huge breadth of cultures, languages, and ethnicities, and over 20 different nationalities. We also employ candidates from a range of educational and socioeconomic backgrounds. Our partnerships with numerous charities ensure that we can stay well-informed and continue to improve our practices for the future. It reflects in the way we recruit for our clients as we assist them in becoming more diverse.