Junior DBA

Pardoe Wray have been retained by Family Fund, a charitable organisation who provide financial support to the families of disabled or seriously ill children.
The role below is an indication of where they believe the skills / experience of the successful candidate will lead too. We are looking for candidates who have the experince to develop into this role. Someone with good SQL skills and a keen interest in Azure.
Purpose of Job:
This role is responsible for the maintenance and support of database systems across the organisation. Support the administration and optimisation of MS SQL and Azure SQL databases and associated technologies, ensuring data security, quality, and efficient operation. Contribute to the design of database architectures, data warehousing, and change control processes within an agile project environment.
Duties and responsibilities:
Database Management and Administration:
· Support the management and administration of multiple MS SQL databases and Azure SQL databases.
· Assist in the design and administration of Azure SQL databases that underpin key business systems.
· Support the management and oversight of the data warehouse and all associated data flows.
Azure Ecosystem Management:
· Assist in the administration and functioning of Azure Logic Apps and Azure Data Factory.
· Support the seamless data integration and flow within the Azure ecosystem.
Security and Administration:
· Follow and maintain robust security measures for all databases and associated systems.
· Carry out regular administrative tasks to support the optimal functioning of databases.
· Monitor the database system to ensure optimal performance.
· Conduct regular system checks, updates, and maintenance routines to prevent potential issues.
· Ensure that all configuration and code meet standards, and that quality processes are followed, including use of deployment, version control and information security best practices.
· Contribute to occasional out of hour’s maintenance and support.
· Identify areas for improvement and support the development of business cases for potential new systems, services, or developments.
· Support the business continuity and disaster recovery plans across the organisation for the database systems and support in ensuring that these are regularly tested.
· Support in maintaining the organisation’s Systems Register detailing critical systems used by the Group, and identify, analyse, and manage risks associated with those systems.
· Support the maintenance of complex system integrations.
Database Architecture:
· Support the design and implementation of database architecture that aligns with organisational needs and goals.
· Ensure the scalability and performance of databases through regular monitoring and optimisation.
Change Control Processes:
· Participate in the change control processes.
· Provide input and recommendations to ensure efficient and effective change management.
Agile Project Management:
· Collaborate with cross-functional teams in an agile project environment.
· Participate in regular sprints, stand-ups, and retrospectives.
· Support the delivery of changes and new developments in line with requirements and specifications provided by the project team.
· Act as a subject matter expert in the change management process.
· Support the ongoing continuous improvement programme.
· Support the development of the systems architecture.
· Support the planning process for project work requiring changes or new developments relating to database architecture.
· Ensure that all changes and developments are carried out in line with best practice and in accordance with the organisations information security policies.
· Support in maintaining robust development and test environments.
· Support in making critical decisions on system design and proactively offer recommendations on improvements.
· Support in ensuring project timelines are adhered to where appropriate.
· Support the strategy discussions within the team, across the organisation and with 3rd party support partners.
Documentation:
· Create and maintain comprehensive database documentation.
· Ensure that all processes, changes, and configurations are well-documented.
Data Quality:
· Monitor and ensure the accuracy and quality of data across all databases.
· Implement measures to rectify any data inconsistencies or inaccuracies.
Issue Resolution
· Identify, troubleshoot, and resolve data and database related issues within SLAs.
· Escalate complex issues to the appropriate teams or 3rd party support partners for further investigation and resolution.
· Support junior members of the team with issue resolution where required.
Training
· Attend and contribute to training sessions for new users within the ICT team.
· Support in the development and maintenance of user manuals, guides, and FAQs to assist users in maximising the platform's capabilities.
· Where opportunities arise, offer leadership and mentoring to junior members of the team with regard to developing their understanding of the system and following best practice.
Collaboration
· Collaborate with teams within ICT and across the organisation to implement system updates, integrations, or modifications.
· Act as a liaison between end-users and 3rd party support partners for any required support or updates.
Reporting
· Track and report on common issues, user feedback, and system performance to the management team.
· Recommend system improvements or additional training based on recurring issues or user feedback.
Continuous Learning
· Stay updated with the latest updates, features, and best practices.
· Attend relevant training and workshops to enhance knowledge and skills

---