Lead DBA

Job responsibilities

Specialist Skills1. Provide hands-on leadership and working within a multidisciplinary scrum team and interdisciplinary team of DevOps andMiddleware specialists including mentoring, quality assurance processes and standards;2. Accountable for the design, development and maintenance of all NHSBSA databases required for development, testing,education and production usage.3. Accountable for the design and development of scalable high availability database solutions for major business applications.4. Accountable for planning and implementation of database backup and recovery strategies for business critical systems.5. Design and implementation of database administration housekeeping policies to ensure continuity of system availability andrecovery of functionality.6. Design, implements and enforces security for all of the NHSBSA databases.7. Evaluates releases of database software and tools to ensure that the NHSBSA is running products that are most appropriate tothe business need.8. Accountable for the evaluation, install, configure and test new versions of the relational database management systems.9. Taking a leading role to identify and share good practices, through leading and directing relevant communities of practice to driveadoption of design standards, trends and patterns.

Staff Management10. The general management of activities and standards of staff within professional disciplines across multidisciplinary teams.11.Enabling the performance of others, including objectives setting fully aligned to departmental and organisational objectives andgoals, and the development and motivation of staff to achieve them.12. Mentoring staff and advising on career paths to encourage pro-active development of skills and capabilities.13.Conducting meaningful appraisals and 1-1s, identifying and meeting development needs, implementing, monitoring, evaluatingand reporting on the impact and success of implemented training plans14.Receive and act upon and where possible resolve a range of escalations including staffing, disciplinary procedures, resourcingbusiness and technical, to secure satisfactory outcomes. Where unable to resolve, providing sufficient detail, escalate to theappropriate levels within the organisations, within agreed policies, procedures and processes to ensure appropriate resolution.15.Undertake recruitment and selection in line with organisational processes, and participate in the implementation and delivery ofinitiatives to secure suitable resources, increase skills levels and develop talent pools to meet the changing needs of thebusiness landscape.16.Provide feedback to support and encourage teams and individuals to develop thinking and independently work through issues, toreach solutions based outcomes. Leading by example by seeking, providing and implementing individual feedback to improveways of working and own performance.17. Provide specialist training and advice to staff on database functionality, SQL, tuning, standards etc.

Knowledge Management18.Keeping abreast of technological and maintain an excellent understanding of the use of technology in delivering businessobjectives.19.Identify and support opportunities for the team to further develop their skills to meet the changing needs of the business Takingownership for decision making within own area, seeking support and feedback to develop well thought out solutions, processesand work as required, and in conjunction with agreed procedures.20.Maintain own knowledge and expertise at the forefront of sector knowledge. Investigate research and development to supportfuture business needs. Develop an understanding of emerging technologies and business opportunities.

Financial Management21. Responsibility for contributing to budget management processes in accordance with NHSBSAs policies, standing orders,financial regulations and legislative requirements.22. Contribute to and prepare proposals for change including producing necessary estimates, mandates and business cases withinthe technology department.23. Monitoring budget spend and resource estimates against projects, and change initiatives

Relationship Management24.Identify opportunities, engaging and fostering relationships and partnership working within the organisation, and with thirdparties, to identify and deliver value to the organisation25.Working collaboratively with respective "Line Managers" to identify, implement and support team and individual development.Information Management26.Implement, monitor and report on a number of areas including agreed service levels, KPI's and standards within team andanomalies understood and reports generated and delivered to agreed frequency, methods and processes.27.Monitoring, reviewing accuracy and authorising a number of activities including financial claims, leave requests and timesheetsubmissions at both team and individual level to both assure accuracy and to inform forward planning and resourcemanagement.

Delivery Management28.Managing staff workload and completing own assigned tasks, to a high quality and within agreed timelines. Deliveringcontinuous improvements to enhance own and business areas; co-ordinating and delivery of work across multiple strands suchas continuous improvement, project related work, and operational tasks, and escalating issues at appropriate times.29.Preparing plans to enable the delivery and management of projects and programmes undertaken by the team. Providingoperational direction in the preparation of plans to deliver systems and service across the organisation.30. Preparing resource estimates and financial costing for a broad range of complex allocated work packages to assist the long termplanning process and determination of resource requirements for inclusion in capital business cases.31.Manage and implement database strategies, standards, practices and policies across the team, ensuring and monitoring thetimely delivery of business objectives within budget through the management of projects and programmes.32. Evaluate releases of database software and tools, including third party products to ensure that the NHSBSA is running productsthat are most appropriate to the business need.33.Providing feedback on functional and non-functional requirements to ensure the overall needs of the business are met from anICT perspective

34. Participating in procurement processes for hardware and software. Reviewing functional requirements and providing non-functionalrequirements to ensure the overall needs of the business are met from an ICT perspective

Personal Qualities, Knowledge and Skills

Essential

• 1.Business change, rationalisation and transformation
• 2.Evaluation of data from multiple sources to inform decision making
• 3.Oracle 9i/11G/12C database administration and support
• 4.MS SQL Server database administration
• 5.Proactive monitoring using OEM 12c
• 6.Strong SQL/TSQL skills
• 7.SQL/TSQL Tuning
• 8.RMAN
• 9.Shell Scripting
• 10.Powershell
• 11.UNIX - Linux/Solaris
• 12.On-going professional development

Desirable

• 1.Oracle Exadata
• 2.Database administration in a cloud environment
• 3.Zfs architecture
• 4.SAN storage performance metrics
• 5.High availability technologies
• 6.Analysis Services, Integration Services, or Reporting Services

Experience

Essential

• Experienced at 1.Significant recent Oracle/ MS SQL Server RDBMS experience with a.Database Administration b.Backup and Recovery design and implementation c.Proactive monitoring design and implementation d.Capacity management e.Security f.Software installation and patching g.RMAN h.OEM 12c i.Data Guard
• 2.Experience of working with partitioned data structures
• 3.Programming skills within a database environment. The individual will have strong unix/linux/windows scripting language skills: a.shell programming b.SQL c.PL/SQL d.TSQL e.Powershell
• 4.Ongoing Continuous Professional Development
• 5.Engaging and building relationships with a range of stakeholders to support delivery of business outcomes
• 6.Identifying non- functional and ensure they are captured and implemented as part of a project.
• 7.Translating business requirements to meet and achieve business needs at project and programme level
• 8.Analysing digital / web services in a fast paced environment.
• 9.Open source and cloud technologies and their sourcing.

Desirable

• 1.Working within a scrum teams, and experience creating user stories.
• 2.Interpreting strategy and translate emerging trends and technologies which might impact or benefit the organisation.
• 3.Experience of Oracle Exadata configurations
• 4.Experience of administration of PostgresSQL installations
• 5.Experience of Cloud Computing database administration

Qualifications

Essential

• 1.Degree calibre with relevant in-depth knowledge of the subject matter
• OR 2.Significant practical experience as a Database Administrator utilising Oracle, MS SQL Server.

Desirable

• 1.Master's Degree or equivalent Post Graduate qualification.
• 2.Oracle 10g,11g or 12c database certification
• 3.Microsoft SQL Server certification

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).