Job summary
If you have experience in administering PostgreSQL databases, are passionate about delivering highly available and scalable digital solutions and are interested in a role that can make a difference, the NHS Business Services Authority (NHSBSA) have the opportunity for you!
If you are highly motivated, have significant recent practical experience with the administration and supporting of PostgreSQL databases, preferably within an AWS environment, then you have what this role needs! You will be working alongside the team of database engineers and platform engineers to ensure the estate of PostgreSQL databases used across the organization are delivered and support to a high standard. You will be responsible for delivering, supporting, and continually enhancing the PostgreSQL solutions within the AWS estate which form an integral part of the provision of NHSBSA services. You will need to be driven, innovative and work with a high degree of autonomy.
What do we offer?
- 27 days leave (increasing with length of service) plus 8 bank holidays
- Flexible working (we are happy to discuss options such as compressed hours)
- Flexi time
- Hybrid working model (we are currently working largely remotely)
- Career development
- Active wellbeing and inclusion networks
- Excellent pension
- NHS Car lease scheme
- Access to a wide range of benefits and high street discounts!
Main duties of the job
Perform a comprehensive set of database administrative activities in relation to the PostgreSQL databases within AWS (including RDS instances) using pgAdmin
Design, create support, and maintain PostgreSQL databases across development, testing and production environments. Perform on-going performance tuning of the PostgreSQL databases to ensure availability and scalability of services Configure and manage monitoring of the PostgreSQL databases Analysis of highly complex issues and troubleshooting of problems related to the PostgreSQL databases Perform capacity and scalability planning across the PostgreSQL estate Evaluate releases of PostgreSQL database software and tools, including third party and open-source products, to ensure that the NHSBSA is running products that are most appropriate to the business needs. Plan and perform PostgreSQL database software upgrades (potentially out of hours) ensuring minimal impact to the business. Provide technical support and training for more junior platform colleagues and non-platform staff in the use of PostgreSQL databases Use initiative to make decisions on complex technical matters and make recommendations to influence key decisions Examine, recommend, and implement changes to procedures, policies and services to improve customer service Produce time and resource estimates to contribute to the planning process
Develop proactive relationships with key stakeholders and other delivery teams
About us
At the NHS Business Services Authority (NHSBSA) we deliver a range of essential national services to NHS organisations and contractors, patients and the public.
You may already be using some of our services. Do you have a prescription pre-payment certificate? Perhaps you found this vacancy through NHS Jobs? We're behind these, and much more.
Being one of the UK's Best Big Companies to work for, our values are to be Collaborative, Adventurous, Reliable and Energetic. We CARE about what we do and support each other in achieving our objectives.
Our people are the heart of our organisation. We strive to ensure they feel trusted, valued and empowered. We're passionate about nurturing and developing people. When you join us, we want you to grow, and we offer many opportunities for you to do that.
We welcome applications from people of all backgrounds. With wellbeing and inclusion central to our ethos, our BAME, Disability and Neurodiversity, LGBTQ+, Armed Forces and Women's networks help our colleagues to be their authentic selves at work.
At the NHSBSA we value and respect the diversity of our colleagues and are committed to being a flexible employer. We are proud to offer flexible working opportunities. Whether you're interested in hybrid working, working from home, flexible hours or job sharing, apply today and we can discuss available options with you at the interview stage.
We are the NHS delivering for the NHS.
Job description
Job responsibilities
In this role, you are accountable for:
- Responsible for the creation and maintenance of all NHSBSA databases required for development, testing, education and production
- Responsible for the design and development of scalable high availability database solutions for major business application
- Plans and implements database backup and recovery strategies for NHSBSA business critical
- Performs on-going tuning of the database instances, highly complex analysis of root cause issues and troubleshooting of problems related to the databases and database infrastructure.
- Responsible for the capacity planning for creating and maintaining the databases to align with business
- Analyses statistical information and advises infrastructure suppliers on optimal storage configurations for database throughput and standardisation
- Responsible for the install, configure and test new versions of the RDBMS (Relational database management systems).
- Control migrations of database changes through the development life
- Designs, implements and enforces security for all of the NHSBSA
- Analysis performance statistics and perform database re-organisations as required to maintain/ improve performance and ensure maximum availability of the business critical databases.
- Analyses, interprets and presents highly complex technical information from various sources about complex subjects to influence key
- Perform reviews on the design of database resident code to ensure the NHSBSA standards are being
- Evaluates releases of database software and tools, including third party products to ensure that the NHSBSA is running products that are most appropriate to the business need.
- Plan and perform database software upgrades (out of hours) ensuring minimal impact to the business.
Further details can be found in the Job Description and person specification.
#LI-Hybrid
Job description
Job responsibilities
In this role, you are accountable for:
- Responsible for the creation and maintenance of all NHSBSA databases required for development, testing, education and production
- Responsible for the design and development of scalable high availability database solutions for major business application
- Plans and implements database backup and recovery strategies for NHSBSA business critical
- Performs on-going tuning of the database instances, highly complex analysis of root cause issues and troubleshooting of problems related to the databases and database infrastructure.
- Responsible for the capacity planning for creating and maintaining the databases to align with business
- Analyses statistical information and advises infrastructure suppliers on optimal storage configurations for database throughput and standardisation
- Responsible for the install, configure and test new versions of the RDBMS (Relational database management systems).
- Control migrations of database changes through the development life
- Designs, implements and enforces security for all of the NHSBSA
- Analysis performance statistics and perform database re-organisations as required to maintain/ improve performance and ensure maximum availability of the business critical databases.
- Analyses, interprets and presents highly complex technical information from various sources about complex subjects to influence key
- Perform reviews on the design of database resident code to ensure the NHSBSA standards are being
- Evaluates releases of database software and tools, including third party products to ensure that the NHSBSA is running products that are most appropriate to the business need.
- Plan and perform database software upgrades (out of hours) ensuring minimal impact to the business.
Further details can be found in the Job Description and person specification.
#LI-Hybrid
Person Specification
Qualifications
Essential
- oSignificant recent relevant practical experience as a Database Administrator utilising Oracle, MS SQL Server, or Postgres
- oIT related degree plus significant Database Administrator experience at a senior level.
Desirable
- oOracle 10g,11g or 12c database certification
- oMicrosoft SQL Server certification
- oPostgres certification
- oIT related Masters degree
Personal Qualities, Knowledge and Skills
Essential
- oExcellent team player, positive attitude, tenacious, co-operative, flexible, hard working. Shows initiative. Professional attitude.
- oCan travel which may involve some overnight stays. From time to time, may be required to work in different locations, generally within Newcastle or Fleetwood.
- oAbility to influence IT and lead others in the development of knowledge, ideas and work practice relating to database technologies.
- oIs approachable and demonstrates the strategic values of the NHSBSA
- oParticipate in partnership working with third party suppliers.
- oCommunicates with individuals and groups about difficult or highly complex matters at all levels and both technical and non-technical audiences.
- oProactive and personally motivated
- oSelf-aware, flexible and adaptable
- oAccurate with attention to detail.
- oCommitment to continuing professional development.
- Ability to perform the following: oAbsorb and apply new technical/business concepts effectively. oCritically analyse available alternatives of standards, methods, tools and applications in relation to database technologies and make correct choices of alternatives, identifying new and emerging technologies where appropriate. oAbility to gather, analyse, interpret and report on information and knowledge, related to ideas and concepts in relation to database administration to influence key decisions. oDemonstrate creativity and innovation in applying IT and business solutions for the benefit of the user. oDemonstrate analytical and systematic approach and efficient use of resources in resolving highly complex and difficult problems. oTake initiative to keep personal skills up to date. Develop others' knowledge & practice in area of work. oContribute to the policies and strategy of the organisations IT function. oAttention to detail oStrong SQL/TSQL skills oSQL/TSQL Tuning oShell Scripting oPowershell oUNIX - Linux/Solaris
- Experience in one or more of the following: o Oracle 9i/11G/12C database administration and support oMS SQL Server database administration and Postgres database administration
Desirable
- oOracle Exadata
- oDatabase administration in a cloud environment
- oZfs architecture
- oSAN storage performance metrics
- oHigh availability technologies
- oAnalysis Services, Integration Services, or Reporting Services
- oRMAN
- oFor Oracle - Proactive monitoring using OEM 12c
- oFor Postgres - Administration using pgAdmin
- oFor Postgres - Proactive monitoring using DataDog and / or Grafana
Experience
Essential
- oSignificant recent Oracle/ MS SQL Server / Postgres RDBMS experience with oBackup and Recovery design and implementation oProactive monitoring design and implementation oCapacity management oSecurity oSoftware installation and patching oRMAN oOEM 12c oData Guard opgAdmin
- oExperience of working with partitioned data structures
- oProgramming skills within a database environment. The individual will have strong unix/linux/windows scripting language skills: oshell programming oSQL oPL/SQL oTSQL oPowershell
Desirable
- oExperience of Oracle Exadata configurations
- oExperience of administration of PostgresSQL installations (self-installed or AWS RDS)
- oExperience of Cloud Computing database administration
Person Specification
Qualifications
Essential
- oSignificant recent relevant practical experience as a Database Administrator utilising Oracle, MS SQL Server, or Postgres
- oIT related degree plus significant Database Administrator experience at a senior level.
Desirable
- oOracle 10g,11g or 12c database certification
- oMicrosoft SQL Server certification
- oPostgres certification
- oIT related Masters degree
Personal Qualities, Knowledge and Skills
Essential
- oExcellent team player, positive attitude, tenacious, co-operative, flexible, hard working. Shows initiative. Professional attitude.
- oCan travel which may involve some overnight stays. From time to time, may be required to work in different locations, generally within Newcastle or Fleetwood.
- oAbility to influence IT and lead others in the development of knowledge, ideas and work practice relating to database technologies.
- oIs approachable and demonstrates the strategic values of the NHSBSA
- oParticipate in partnership working with third party suppliers.
- oCommunicates with individuals and groups about difficult or highly complex matters at all levels and both technical and non-technical audiences.
- oProactive and personally motivated
- oSelf-aware, flexible and adaptable
- oAccurate with attention to detail.
- oCommitment to continuing professional development.
- Ability to perform the following: oAbsorb and apply new technical/business concepts effectively. oCritically analyse available alternatives of standards, methods, tools and applications in relation to database technologies and make correct choices of alternatives, identifying new and emerging technologies where appropriate. oAbility to gather, analyse, interpret and report on information and knowledge, related to ideas and concepts in relation to database administration to influence key decisions. oDemonstrate creativity and innovation in applying IT and business solutions for the benefit of the user. oDemonstrate analytical and systematic approach and efficient use of resources in resolving highly complex and difficult problems. oTake initiative to keep personal skills up to date. Develop others' knowledge & practice in area of work. oContribute to the policies and strategy of the organisations IT function. oAttention to detail oStrong SQL/TSQL skills oSQL/TSQL Tuning oShell Scripting oPowershell oUNIX - Linux/Solaris
- Experience in one or more of the following: o Oracle 9i/11G/12C database administration and support oMS SQL Server database administration and Postgres database administration
Desirable
- oOracle Exadata
- oDatabase administration in a cloud environment
- oZfs architecture
- oSAN storage performance metrics
- oHigh availability technologies
- oAnalysis Services, Integration Services, or Reporting Services
- oRMAN
- oFor Oracle - Proactive monitoring using OEM 12c
- oFor Postgres - Administration using pgAdmin
- oFor Postgres - Proactive monitoring using DataDog and / or Grafana
Experience
Essential
- oSignificant recent Oracle/ MS SQL Server / Postgres RDBMS experience with oBackup and Recovery design and implementation oProactive monitoring design and implementation oCapacity management oSecurity oSoftware installation and patching oRMAN oOEM 12c oData Guard opgAdmin
- oExperience of working with partitioned data structures
- oProgramming skills within a database environment. The individual will have strong unix/linux/windows scripting language skills: oshell programming oSQL oPL/SQL oTSQL oPowershell
Desirable
- oExperience of Oracle Exadata configurations
- oExperience of administration of PostgresSQL installations (self-installed or AWS RDS)
- oExperience of Cloud Computing database administration
Additional information
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).
