Senior SQL Database Administrator - Sunderland, United Kingdom - Gentoo

Gentoo

Verified Company

Sunderland, United Kingdom

2 weeks ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

About the role:

Gentoo is a values-led, charitable organisation that provides more than 60,000 people in Sunderland with a place they can call home.

We have a clear vision and a social purpose. We believe that everyone has the right to live in a good quality home that they can afford.

We are currently recruiting for a Senior SQL Database Administrator to join the Technology team, based in our head office in Doxford Park, Sunderland.

The role is offered on a hybrid working basis; a blend of office and home working, therefore you must be able commute to our Sunderland offices daily if required.

This is an exciting and rewarding role within a forward-thinking team who are always looking at innovative ways of delivering fantastic solutions within the business and evolving the sector at large.

Reporting to the Solutions Development Manager, the Senior SQL Database Administrator will work alongside business intelligence, database and systems developers.

This role requires expertise in database management systems (design, implementation, maintenance, and performance optimisation), data modelling, and awareness of integration technologies to ensure the seamless flow of data across disparate systems.

The position requires collaboration with cross-functional teams to ensure the reliability, security and scalability of the database infrastructure.

Database Design and Development

Design and implement SQL database schemas, tables, views, and stored procedures based on business requirements.
Develop and optimise SQL queries to extract, transform, and load data efficiently.
Ensure database performance, security, scalability and reliability.
Actively contribute to improvements and migrations both with on-premises and cloud technologies.

Data Modelling

Collaborate with stakeholders to analyse data requirements and design logical and physical data models.
Implement data modelling best practices to ensure data integrity, security, consistency, and usability.
Translate business needs into technical specifications for database structures.

Integration Development

Data Governance

Work within established data governance policies, standards, and procedures to ensure data quality, security, and compliance with regulatory requirements (e.g. GDPR).
Implement data access controls, encryption mechanisms, and audit trails to protect sensitive information.

High Availability and Disaster Recover

Configure and maintain high availability solutions such as SQL Server AlwaysOn Availability Groups, database mirroring, and clustering to minimize downtime and ensure business continuity.

Develop and test database backup and recovery procedures to recover data in the event of system failures, disasters, or data corruption.

Performance Optimisation

Identify and address performance bottlenecks, query optimisation opportunities, and scalability challenges in database systems and integration processes.
Monitor system performance metrics and fine-tune configurations for optimal throughput and responsiveness.

What we are looking for:

Bachelor's degree (or equivalent) in Computer Science, Information Technology, or related field.
Proven experience in database administration and data engineering roles.
Proficiency with Azure and SQL Server administration and programming of on-premises and cloud database solutions. Experience of similar technologies desirable (e.g., MySQL, Progress).
Experience with ETL tools and processes (e.g., Informatica, Talend, SSIS, Azure Data Factory).
Experience with version control systems (GitHub, Bitbucket).
Knowledge of data governance frameworks, security controls, and regulatory compliance requirements.
Experience of working in IT, including experience of delivering 2nd or 3rd line support
Certifications such as Microsoft Certified Database Administrator, Oracle Certified Professional would be ideal,

Microsoft Certified:
Azure Data Engineer Associate are a desirable.

Some of our great benefits include:30 days annual leave (plus bank holidays)
12.30 pm finish on a Fridays
Flexible and hybrid working.
Free Health Cash Plan, with cashback for dental, optical, physio, wellbeing therapies and more, with some free child cover.
Access to private healthcare through the Health Cash Plan.
Competitive Aviva pension scheme - Gentoo will contribute up to 10% based on your personal contribution.
Salary sacrifice electric vehicle scheme
Enhanced family-friendly leave
Car mileage allowance if you use your personal vehicle for business purposes.
Life assurance cover to the value of 3 times your annual salary.

Closing date:

07/04/2024

We're a housing association that provides more than 60,000 people in Sunderland with a place they can call home.

We're a values-driven organisation, with a clear vision, a social purpose and a commitment to investing in people, place and property.

We believe everyone has the right to live in a good quality home they can afford and invest millions of pounds every year in keeping our