The Information and Communication Technology (ICT) team comprises the Corporate Information Systems, IT Service Support, IT Service Management, Network, and Systems teams.
This role sits within the Corporate Information Systems team who provide services to staff and students across the University sites. This team is responsible for data integration, development and technical application support. The team are currently working on centralising the University data integration across systems and reviewing approaches and this post will assist with this.
The primary responsibility of this role will be to work in collaboration with key departments such as Registry Services, Facilities, Finance and Human Resources in order to maintain, develop and integrate various information systems critical to the University's business processes. This work will utilise the post holder's MS SQL skills to provide database support and integration processes between these systems. The role will also include the development of new databases to support development of web based applications as well as some technical application support for the University business and service critical systems. The University uses market-leading software and regularly has new acquisitions to deploy and implement.
The role will offer training for Microsoft SQL Server, which could lead to Microsoft Certification for the successful candidate. This will include: MS SQL Server Administration, MS SQL Server Querying and Programming, MS SQL Server Integration Services. There will be many opportunities to put your learning into practice.
Closing date: Tuesday 25 Apr 2017
Reference number: ICT1702 - 3247
- Job details
- Band 6 - £25,298 - £31,076 with opportunity to progress to £33,943
- As soon as possible
- Responsible to
- Corporate Information Systems Manager
- Responsible for
- Interview date
The University has set out a set of values within its strategic plan that describe the culture and ethos of the organisation. These values are;
• Intellectual openness
• Desire to learn
• Best practice
• Equality of opportunity, inclusion and diversity
• Working with partners and the community
• Social responsibility
• Continuous professional development and the evaluation of practice
These values underpin the expectations, or standards, that the University has of its staff. This means that all employed within the organisation will be expected to;
• Make a high quality professional contribution
• Have an appreciation of the culture of the organisation and of the role of colleagues in all parts of the University
• Act with integrity, honesty, fairness and without discrimination
• Be explicit and straightforward in their dealings with colleagues, students and other clients
• Be committed to their own personal and others’ professional development by seeking new knowledge and skills to enhance individual and organisational performance.
These standards are included in every job description. Applicants will be expected to provide evidence of how they have addressed these in their past experience, and how they intend to continue to do so if their application is successful.
In order to make these expectations clearer for each type of role, there are defined ‘professional behaviours’ included in each person specification and the selection process will include opportunities for applicants to demonstrate these behaviours.
- Main duties
1 To undertake responsibility (alongside a similar post) for the integration work between business critical information systems including timetabling, financial services, student record systems, HR, facilities management and others to ensure accuracy and consistency of data across systems.
2 To proactively maintain, upgrade and monitor the University’s MS SQL Server databases.
3 To monitor the performance of MS SQL databases to be proactive is assessing potential issues.
4 To provide creative advice and planning on technological solutions for data management.
5 To undertake responsibility for the implementation and subsequent support of specific projects with respect to MS SQL databases.
6 To be involved in the design, implementation and maintenance of a centralised system for data integration across University systems.
7 To be involved in all aspects of database technical developments, administration and maintenance of ICT supported information systems working as a member of the Corporate Information Systems team.
8 To provide technical support for business and service critical applications.
9 To document all key ICT information and project work to a high level of accuracy for compliance with ICT standards.
10 To occasionally work weekends, evenings and early mornings in order to carry out installations, maintenance and other systems related duties and provide out of hours support for key events.
11 To assist more generally in providing support to students and staff users in respect of their problems and queries in using University systems supported by the ICT team.
12 To investigate, evaluate and implement new technologies in order to further advance ICT services for both students and staff.
13 To complete any other appropriate duties as specified by the Manager for Corporate Information Systems.
*Maintain personal and professional development to meet the changing demands of the job; participate in appropriate training activities and encourage and support staff in their development and training.
*Take steps to ensure and enhance personal health, safety and well being and that of other staff and students.
*Carry out these duties in a manner that promotes equality of opportunity and supports diversity and inclusion, and takes into account the University's commitment to environmentally sustainable ways of working.
- Person specification
Please provide evidence of how you meet each of the essential criteria.
1 Ability to communicate confidently and clearly with a wide range of people both orally and in writing. Ability to communicate complex or detailed technical information clearly and accurately in the most appropriate format to individuals or groups who may have varying levels of technical knowledge.
2 Excellent interpersonal skills with the ability to establish and maintain good working relationships with other members of staff across teams and with external organisations.
3 Excellent organisational skills including the ability to manage own workload, prioritise effectively and work to deadlines.
4 Detail-oriented with a strong commitment to quality control.
5 A creative approach to problem solving and a flexible approach for dealing with varied tasks
6 Be able to work effectively as part of a team.
1. Higher qualification (e.g. MSc, BSc, HND) in IT, Computer Science, or a related field, or equivalent minimum 2 years work experience that demonstrates a high level of technical understanding and implementation skills.
2. Knowledge of MS SQL Server skills including SQL, stored procedures and SQL Agent jobs.
3. Interest in data integration between disparate information systems and how this helps to improve business processes.
4. The ability to plan and carry out upgrades to MS SQL working with a Corporate Information Systems colleague, application suppliers and University Service departments.
5. Knowledge of relational database design
6 Experience of recent development activities and keen to expand knowledge in this area.
1 Knowledge of some of the following: SSRS, SSIS, SSAS.
2 Working knowledge of PowerShell.
Applications from Non EEA Workers:
Prospective applicants are advised to ensure that they are eligible to work in the UK without restriction.Prospective applicants in points-based system immigration routes should assess their circumstances against the published criteria, which are set out on the GOV.UK website at www.gov.uk/browse/visas-immigration.
Visit www.naric.org.uk/visasandnationality for more information on how you can use a qualification from outside the UK to meet the requirements of the immigration rules.
Unspent convictions, cautions and bind-overs
The University is strongly committed to the fair treatment of its staff and potential staff, regardless of race, gender, religion, sexual orientation, responsibility for dependants, age, physical/mental disability or offending background.
In line with the University's policy on the Recruitment of People with a Criminal Record, shortlisted candidates are required to provide information of any unspent convictions, cautions and bind-overs. Applicants are advised to seek independent advice if there is any doubt about the status of a previous conviction, caution or bind-over. Disclosures will only be considered at the point when an offer of employment is made. The existence of a criminal record will not in itself prevent you from gaining employment.
This is a description of the job as it is presently constituted. This job description is intended to enable a flexible approach to be offered working across the University as required. It is subject to review and amendment in the light of changing needs of the University and to provide appropriate development opportunities. Members of staff are expected to participate fully in discussions about changing requirements and it is the University's aim to reach agreement to reasonable change. If agreement is not possible, it reserves the right to require changes to the job description after consultation with the individual concerned.