Database Engineer

Database Engineer
Job Description Summary
We are currently seeking a Database Engineer to join our Digital Driving School team based in Cardiff.
The team are dedicated to redeveloping and supporting the Driving Schools technical systems. As part of the Driving School’s tech team, you will be ensuring that our data infrastructure is optimised to deliver fast responses to end-users, our data is secure, we can meet our RTO & RPO targets, work with the Development to team to ensure that production code is of the highest standard and help plan for the future as we build and scale-up a data warehouse to deliver analytics, insight and reporting to the Driving School and wider organisation.
If you are looking to be challenged in a fast-paced environment delivering high quality data for one of the UK’s most recognisable brands we’d love to hear from you.

Responsibilities
• Eyes On. Design and build database performance and automation tools. These tools should
enhance and augment our incumbent security, availability, monitoring and alerting systems to ensure that our database platforms are always available when needed.
• Fine Grain. Own The AA Driving Schools database platforms, have a low-level and detailed
understanding of what data is stored in our data platforms, where is coming from and where it flows to. Ensure that the data we store complies to the GDPR be holding what we need for as long as we need it.
• Always Prepared. Develop, manage, and regularly test back-up and disaster recovery plans in line
with The AA Driving Schools RTO and RPO.
• Gatekeeper. Ensure that anyone who accesses our data platforms has the right level of access
through the creation and enforcement of database policies, procedures, and standards.
• Single source of truth. Working as part of the Data Engineering team, assist in the design and
delivery of a new data warehouse that will encapsulate the end-to-end process of data acquisition,
integration, storage, and presentation of the organisations data.
• On the move. Create, amend, and enhance our data abstraction layer which comprises of a suite
of ETL scripts and SSIS packages that handle upstream and downstream data feeds to satisfy real-
time, historical and data streaming requirements.
• Keep it clean. Ensure that our data is kept at the highest possible level of quality and is easily
accessible for business stakeholders and end-users. Build and maintain data test suites that ensure
that data integrated into our data platforms is of the highest quality and ‘bad’ data is ringfenced.

• You’re not on your own. Collaborate with the wider tech team and other business functions like
architecture, infrastructure, security, and external partners to ensure that best practice is followed, and business requirements are met when designing and implementing new systems, processes or
 procedures.
• Always improving. Ensure that we are always doing things the best way with continual code and service improvements. Take what is going on data sphere to own and suggest improvements to the way the Data Engineering and Tech team work as well as taking part in the development of more junior members of the team.

AA code
• Think Impact
• Own It
• Push For Better
• Back Each Other
Health and safety requirements
Conduct yourself, and carry out work, to ensure compliance with the Company’s Health, Safety and
Environmental Policies.

Conduct Rules
Under the Senior Managers and Certification Regime (SM&CR), the jobholder must abide by the following conduct rules:
First Tier – Individual Conduct Rules
Rule 1. You must act with integrity
Rule 2. You must act with due care, skill and diligence
Rule 3. You must be open and cooperative with the FCA, the PRA and other regulators
Rule 4. You must pay due regard to the interests of customers and treat them fairly.
Rule 5. You must observe proper standards of market conduct

The Individual
We're looking for someone to fit into our hardworking semi-remote team. In return, we offer plenty of flexibility with a great culture and team blend. You will collaborate closely with the wider tech team drawing and contributing to the team knowledge, taking part if desired in our wide-ranging team social events.
As a core member of our team, you will be required to hit the ground running and have a passion for data and are a master of SQL. You should have a strong interest in working with the latest technologies and strive to continuously learn and develop both technically and interpersonally.
Our team is passionate about delivering sustainable systems that can be flexible to the business needs as they change over time. Our technology platform (a mix of AWS, Azure and Dedicated) is always evolving and driven by the team; we’re seeking an individual who can help us evolve our architecture and
development our practices.

Capability, Knowledge and Experience:

Essential
• 4+ years’ experience as a Database Engineer, Database Administration or Database Management type role.
• Significant demonstratable experience with T-SQL Development
• Significant experience designing and implementing database best practices around security, standardisation, availability, fault-tolerance, monitoring, alerting and performance optimisation.
• Proven experience in mentoring team members in evolving SQL Server best practices.
• Good knowledge of using data partitioning, index tuning, stats, query store and execution plans to improve database throughput and performance
• Proven Knowledge of Security Management, adherence to Compliance and Governance guidelines for PII / GDPR
• Good knowledge and understanding of data engineering and data platforms (On-Prem, Azure etc)
• Good knowledge or hands-on experience with data integration tools, or experience with ETL/ELT pipelining
• Good knowledge or hands-on experience working in an agile way, and an understanding of the role of the Data Engineering team within these ways of working. Experience of supporting tools, such as Jira or Monday.com, would be advantageous.
• Good knowledge of database design, documentation, and coding concepts
• Experience with regular database Performance and Capacity Management
• Demonstrates the ability to develop strong and trusted relationships with key stakeholders to support and enable strategic business goals.

• Experience with Documenting relevant database design and processes

Desirable
• Knowledge of tabular data modelling within SSAS
• Knowledge of Data Warehouse structures and design ustilising Kimball methdology
• Experience working with third party APIs through integration tools.
• Azure database offerings
• AWS and Azure NoSQL
• Rudimentary experience of MariaDB
• Power Automate
• PowerBI administration
• SSIS desirable
• Azure Data Platforms ( ADF, Synapse, DataBricks )
• An understanding of the migration of legacy on-premise data platforms to cloud services (Azure or AWS)
• Exprience working with Developers, Testers and Service Owners to assess design and ensure adherence to databases standards and regulatory compliance
• Knowledge of the Microsoft Power Platform (PowerApps & PowerBI) and how it interacts with our data platforms

Education and Qualifications:
• Equivalent experience or appropriate degree
The duties listed are not exhaustive. Additional hours of work may be required, as determined by the needs of the business. Managers and staff may be required to undertake additional duties, responsibilities and projects as appropriate.
We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age.