Job ID 335149
IT Database Analyst who will be responsible for providing strategic leadership and management with data, assessment and examinations to drive the use of data and provide analytics for informed decision-making in order to raise standards across the school.
The IT Database Analyst will work under the Network Manager and have a key role in ensuring the expansion and development of data as a whole including backups, resilience, and archiving.
The main responsibilities include managing, supporting and continuously improving the strategic databases and underlying infrastructure for the school's Management Information System (iSAMS) and other SQL databases, producing SSRS reports, maintaining iSAMS and other management information system databases, ensuring back-ups are taken and verified as valid, designing, testing, producing, and deploying detailed SSRS reports from iSAMS and other SQL databases, monitoring data quality, creating and supporting interfaces among MIS systems and with other 3rd party School systems, liaising with stakeholders to capture their requirements and provide both end-user and technical support for the various databases used, specifically iSAMS.
The candidate should have specialist knowledge of MSSQL Server including infrastructure, backup/restore, availability management, performance tuning & query optimization, and capacity planning.
The candidate should also have good general knowledge of IT including Active Directory, DNS, DHCP, Microsoft Exchange, web technologies, scripting, general computing hardware, and software.
They should also keep up to date with technologies related to data management and analytics as well as school guidance on data requirements and compliance, be confident and able to work closely with IT colleagues, keep them up to date on projects and issues, communicate well, and be able to explain complex information to non-specialists. Finally, the candidate should be a team player and work closely with IT colleagues, teaching and teaching support staff, pupils, foreign language assistants, examinations officers, and other stakeholders