Job Title

At Peregrine, were 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 companyLife Assurance5% annual bonusPension Scheme Employer matched to 5%Voluntary Benefits Health Cash Plan, Dental, Will Writing etcAnnual Leave 23 days rising to 27 with length of serviceSick Pay Increasing with length of serviceThe 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 upgradesAgile 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 performExperience working in a fast-paced environment and able to work to SLAs.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 were always ready to help each other out. And we believe that our work can benefit society whether its finding the digital talent of the future or being a driver for social mobility. Our commitment to diversity: At Peregrine, were 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.