Database Developer

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

Job summary

A market-leading workforce solutions company is seeking an experienced SQL Database Administrator to support and maintain their large-scale data warehouse. The role involves managing data streams, optimizing central database infrastructure, and ensuring data integrity while collaborating with teams to deliver analytics. The ideal candidate will have strong SQL Server skills and experience in a fast-paced environment.

Benefits

Life Assurance

Annual Leave – 23 days rising to 27

Pension Scheme

Voluntary Benefits

Sick Pay – Increasing with length of service

Qualifications

• Experience with Microsoft SQL Server Database deployed on-premise and in the cloud.
• Ability to produce maintenance scripts for data management.
• Experience working in fast-paced environments.

Responsibilities

• Support and maintain a large-scale data warehouse environment.
• Manage and process incoming data streams from external sources.
• Develop and support server-side data processing workflows.

Skills

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

Agile Development

Data Integrity

ETL Pipelines

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.
• 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.