Further Particulars
This document includes information about the role for which you are applying and the information you will need to provide with the application.
1. Role details
Vacancy reference: 11614
Job title: Database Administrator
Reports to: Leading Database Administrator
Salary: £31,342 to £37,394
Terms and conditions: Academic Related & Support Staff
Grade: 7
Duration of post: Permanent
Working hours: 37
Location: Walton Hall
Closing date: Midday 5 November 2015 Type of application form accepted: Full version with covering letter Number of referees required: 3
2. Summary of duties Responsibilities:
The role will initially be positioned as a trainee role allow the holder of the role to grow and develop the following responsibilities:
Capacity planning and design of IT database environments
Physical database design based on information provided by application development teams
Ensuring that IT Development database standards are followed
Database expert providing advice and guidance to IT Analysts and Developers Investigating database performance problems and recommending remedial action Main Duties:
The role will initially be positioned as a trainee role allow the holder of the role to grow and develop to support the following duties:
Installing and upgrading database software
Allocating system storage and planning future storage requirements for database systems
To work with IT developers to design database structures that support their applications
Implement and modify database structures
To develop, document, communicate, and enforce database standards
To conduct research on database technologies in support of IT Development goals and commitments, and recommend technologies that will increase cost effectiveness and flexibility
To provide database consulting expertise, direction, and assistance to IT Development technical staff
Applying suitable security controls within the database environment Ensuring compliance with database license agreements
Controlling and monitoring user access to the database Monitoring and optimizing the performance of the database Planning for backup and recovery of database information
2. Person specification
E=Essential D=Desirable
Method of
Assessment
1. EDUCATION AND TRAINING
Degree or equivalent professional qualification. D AF 2. EXPERIENCE
Recent practical experience within a team which has: Managed Oracle databases and servers and been
responsible for database performance, performance tuning and problem resolution.
Managed backups and recovery of databases.
Experience of development practices e.g. Waterfall/Agile D
D D Has experience of designing databases that are used by at least 1000 users.
D AF, I, R
Has experience of data integration between Oracle and SQLServer and/or Ingres databases.
D AF, I, R
Experience of designing and building Oracle procedures/functions/triggers with PL/SQL.
D AF, I, R
Experience of technical training of individuals. D AF, I, R
3. KNOWLEDGE/SKILLS Knowledge of:
The installation of the Oracle DBMS software (10g or 11g). The continuing configuration and administration of the Oracle DBMS software (10g or 11g).
D D
AF, I, R
Knowledge of UNIX/Linux operating system including shell scripting.
D AF, I, R
Systematic, logical approach to database design, management, monitoring and problem investigation.
E I
Ability to address the requirements of the business by identifying suitable Oracle technology which will benefit the organisation.
D I
Ability to produce design specifications that meet user requirements.
D I
Can provide accurate and appropriate documentation for systems.
E I, R
Knowledge of Oracle ASM, Data Guard and RAC. D AF, I, R
4. PERSONAL QUALITIES AND ABILITIES
Organisation and planning skills to manage own work within the constraints of team and project plans.
E AF, I, R
Ability to act on own initiative but also be a good team member.
E AF, I, R
Ability to communicate technical knowledge to team members.
E AF, I
Keenness to learn new programming and technical skills. D AF, I Ability to produce clear written reports and contribute to
informal and formal discussions and presentations at meetings and workshops.
E AF, I
Interested in appropriate use of technology to solve
business problems. D I, R
Key: AF= Application form; I = Interview; T = Test, R=Reference 4. Role specific requirements e.g. Shift working
arrangements after appropriate training has been completed.
5. About the unit/department
INFORMATION ABOUT INFORMATION TECHNOLOGY (IT)
Information Technology provides and supports all central University IT services and is responsible for the institution's Technical Infrastructure. In addition to this service and support provision, it develops systems to support the business requirements of the organisation.
The system development function in Information Technology is responsible for the development and maintenance of the University's key operational applications. The main systems support Student and Customer Administration, Course Development and Production, Finance and Staff. Teams of Analysts and Developers are responsible for developing and maintaining systems for particular business areas. There are also specialised teams responsible for Data Administration and Systems Architecture. While much of the software is developed in-house, there are a number of packages. These include applications from the Siebel Customer Relationship Management suite,
EMC Documentum’s Content Management as well as Finance Ledger, Payroll and Stock Control packages. In-house developed software includes transactional websites to provide self service facilities for students and staff; information websites; decision support; workflow and student and staff records management.
The Higher Education sector in England has undergone dramatic change in the past three years as institutions adjust to reductions in state funding for teaching and as students bear more of the cost of their education. As well as these cost drivers, the entry of more private providers to the sector and the increasing consumer power of high fee-paying students will put a premium on service delivery and cost efficiency. In turn, this will throw emphasis on the development of robust, efficient, enterprise-scale IT systems to increase efficiency and customer choice.
6. How to obtain more information about the role or application process
If you would like to discuss the particulars of this role before making an application please contact: Stephen Savage on (01908) 653394, email: Stephen.savage@open.ac.uk
If you have any questions regarding the application process please contact Glyn Bailey on (01908) 653285 or email IT-Recruitment@open.ac.uk
7. Where to send completed applications
Please ensure that your application form and CV reaches the University by: Midday 5 November 2015
E-mail your application to: IT-Recruitment@open.ac.uk Or, Post it to:
Name/Job title: Mrs G Bailey / Recruitment Coordinator Department/Unit: Information Technology
Address: Berrill Building Level 2 South Walton Hall
Milton Keynes Post Code: MK7 6AA
8. Selection process and date of interview
The interview panel will be chaired by: Stephen Savage Head of Data Centre Technologies
The other members of the interview panel are Laurence Breeze, Leading Developer -Team Leader, and 1 or 2 other panel members to be confirmed.
Interview date is to be agreed.
We will let you know as soon as possible after the closing date whether you have been shortlisted for interview. Further details on the selection process will also be sent to shortlisted candidates.