Job Profile (To be attached to the relevant Grade Profile document)
Core job informationJob Title / Database Administrator
Dept./School/Inst. / IT Services / Section/Centre/Unit / Applications
Career Family / Professional / Grade / G5
Working hours per week / Normally 35 hours, on average. (Extended hours to reflect the introduction of a 24/7 cover to be confirmed after negotiation with Trade Unions) / Appointment period / Permanent
Reports to (job title) / Senior DBA / Current location / Mile End Campus with flexibility to work at all QM sites
Job purpose (Why does the job exist? What is it there to achieve or deliver?)
The Technical Application Support team provides in-depth technical support for the academic applications, corporate systems and student systems. Within the Technical Application Support Team is the DBA team; providing operational database services to the College.
Key responsibilities of the DBA team include database performance tuning, capacity planning, data migration, security access, upgrades, patching and related tasks. Some of the key success factors for this role include:
· Working within the ITIL framework for installing, upgrading, patching and testing databases belonging to enterprise applications.
· Developing strong relationships across all teams for support and development of enterprise applications
· Identifying emerging technology trends and making recommendations for their adoption.
· Rigorously ensuring security of enterprise applications and data.
The Database Administrator provides database and data warehousing services for all enterprise applications within the College. In particular, the needs of users should be met by fully understanding and exploiting the systems capabilities, understanding the business needs of users, providing effective training and documentation and the provision of day-to-day database support.
· Apply specialist expertise to support and continually improve database and data warehouse service to defined Service Levels Agreements (SLAs) and Key Performance Indicators (KPIs).
· In consultation with the Senior DBA, review performance and utility of enterprise application database and data warehouse service.
· Deliver a high performance, customer focused, quality driven service.
· Manage/monitor allocated resources (people and finance) to deliver to agreed targets and timescales, using industry best practice methodologies to deliver value.
Knowledge, Skills & Experience (work experience, qualifications, specialist training, key skills, disposition)
Requirements / All Essential unless indicated by ‘D’ which is Desirable
Qualifications / Degree and/or professional qualification in IT subject or significant practical experience in relevant area.
Project Management qualification e.g. Prince 2, MSP, PMP qualified or demonstrable experience of project management.
ITIL foundation qualified or demonstrate management and operational experience using appropriate best practice framework.
Oracle (OCA) or Microsoft SQL Server (MCSA/MCTS) /
D
D
Experience / Experience of Database Administration with Oracle, SQL Server or MySQL at enterprise level
Experience in troubleshooting and resolving database problems
Experience in performance tuning and optimization, using native monitoring and troubleshooting tools
Experience with backups, restores and recovery methods
Experience in implementing operational automation using scripts
Demonstrate successful delivery of high quality, customer focused IT service in a complex and diverse, multi-site environment, optimising use of resources (people and finance), delivering value and conforming to industry best practice and audit requirements
Effective use of management information to deliver continuous service and customer satisfaction improvements.
Knowledge, skills & abilities / Delivers solution focused, reliable and resilient databases to support current/ future customer and business requirements.
Uses technical expertise and knowledge to provide authoritative knowledge and advice and contribute to policy and process improvements.
Demonstrates knowledge and implementation of databases for supporting research, teaching, learning and business activities.
Proven planning, communication, interpersonal and organising skills.
Successful delivery of customer and quality focused IT services with detailed knowledge of current developments and industry best practice methodologies in specialist area.
Excellent analytical and problem solving skills, seeking cost effective solutions, managing resources to suit changing priorities.
Attitude & disposition / A commitment to continually improve customer experience, delivering service level agreements (SLAs) and key performance indicators (KPIs).
Resilient and flexible with an innovative, solutions focused approach, able to operate at all levels.
Confident delivering varied priorities, to achieve successful implementation, contributing to Department goals.
Delivers continuous improvement, challenges what and how things are done, learning from success as well as mistakes.
Self-motivated and willingness to learn.
Other circumstances / Ability to work flexibly as necessary, to deliver SLAs & KPIs
Main Duties and Responsibilities of the Role
Accountable to the Senior DBA for delivering a customer focused, robust, reliable, responsive and secure, high quality IT service, specifically but not exclusively:
· Delivery to defined Service Level Agreements
· Using the Investors in People Framework to prioritise and manage own work; provide support and guidance to build specialist skills within IT Services.
· Use technical expertise to create innovative solutions that address complex technical and business challenges.
· Analyse cost of services for accuracy of charging and delivery of a cost effective, competitive service.
· Plan, prioritise resources, manage risk and deliver business benefits in own work area, on time and within budget.
· Monitor technical and staff resources, using industry best practice to deliver value for money.
· Manage relevant documentation, develop a plan to ensure continuous improvement and planned change control.
· Use industry best practice to facilitate policy, process and procedural improvements.
· Provide advice on the analysis and interpretation of data; produce regular performance reports to contribute to informed decision making and continuous improvement.
· Represent work area internally and externally to ensure appropriate representation and build upon specialist/sector knowledge.
· Other duties which are commensurate with the grade as may from time to time be required.
· Deputise when required for the Senior DBA.
Working Environment (knowledge of special working practices, breadth of management skill required, customer impact, responsibility, efficiency)
Customer focused planning, organising and communication skills, working in partnership with colleagues to deliver high quality services now and in the future.
Apply specialist expertise and judgement to respond to and resolve customer requests/incidents/ problems to comply with service level agreements, professional standards, industry best practice, regulations and codes of practice.
Generate original ideas and innovative solutions utilising in depth specialist knowledge and advice.
Minimise duplication and rework; recycle/dispose of waste; contribute to achievement of carbon emission targets that are specific to IT Services. Manage a working environment that reflects a professional IT Service.
Actions will influence the experience of IT within the College.
Freedom to Act & Decision Making (depth of control, supervision received, use of judgement & initiative, analytical ability)
Apply depth of specialist knowledge and expertise to provide College wide advice and guidance to customers.
Monitor performance, provide advice on the analysis and interpretation of data and information; recommend changes to deliver continuous service and customer satisfaction improvements.
Plan and prioritise resources, manage risk, ensuring plans contribute to delivery of the IT Strategy.
Manage specialist activities and innovative solutions to facilitate major service/policy/operational changes to enhance and maximise College wide service quality, efficiency and continuity.
Communication & Networking (liaison with others, type and level of communications)
Provide specialist advice and expertise; contribute to committees and external networks, demonstrating integrity and commitment to the College’s strategic goals.
Good organisation and communication skills required to deliver services that are multi-site based and delivered locally across partner boundaries.
Monitor performance metrics, share success and recommend corrective action.
Work with senior managers to balance needs of individual customer and best interests of whole College community.
Finance/Resource Management (budgeting, forecasting)
Monitor resources (people, financial and technical) in line with the College policies and procedures, seeking efficiency, opportunities for improvement and value for money.
Contribute to resource and budget planning.
People Management (supervisory responsibility, human relations skills)
Maintain clear customer service standards and expectations to continually improve the IT customer experience.
Mentor and encourage partnership working within IT Services and across the College.
Provide guidance, share specialist knowledge and expertise to support development of colleagues in IT Services.
This job description sets out the duties of the post at the time it was drawn up. Such duties may vary from time to time without changing the general character of the duties or level of responsibility entailed. Such variations are a common occurrence and cannot of themselves justify a reconsideration of the grading of the post.
Organisation ChartConfirmation Section
Job profile content agreed by:
Jobholder signature / Print nameExt No: / Date:
Line Manager/Supervisor signature / Print name
Ext No: / Date:
Head of Department/Director of Institute signature / Print name
Ext No: / Date:
Comments: