Period
to 15 January 2021

The following table provides summary statistics for permanent job vacancies advertised in the UK excluding London with a requirement for OLTP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLTP over the 6 months to 15 January 2021 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK > UK excluding London
6 months to
15 Jan 2021
Same period 2020 Same period 2019
Rank 560 695 776
Rank change year-on-year +135 +81 +17
Permanent jobs citing OLTP 19 94 90
As % of all permanent jobs advertised in the UK excluding London 0.054% 0.13% 0.11%
As % of the Database & Business Intelligence category 0.20% 0.50% 0.38%
Number of salaries quoted 22 77 64
Median annual salary £53,000 £60,000 £52,250
Median salary % change year-on-year -11.67% +14.83% +16.11%
10th Percentile £35,750 £35,000 £36,250
90th Percentile £62,000 £77,500 £72,125
UK median annual salary £52,000 £70,000 £57,500
% change year-on-year -25.71% +21.74% +9.52%

OLTP is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the UK excluding London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK excluding London
Permanent vacancies with a requirement for database or business intelligence skills 9,638 18,670 23,932
As % of all permanent IT jobs advertised in the UK excluding London 27.31% 26.11% 28.30%
Number of salaries quoted 8,079 15,530 19,848
Median annual salary £49,000 £45,000 £45,000
Median salary % change year-on-year +8.89% - +5.88%
10th Percentile £32,000 £29,250 £28,750
90th Percentile £70,000 £68,000 £70,000
UK median annual salary £55,000 £52,500 £52,500
% change year-on-year +4.76% - +9.38%

OLTP
Job Vacancy Trend in the UK excluding London

Job postings citing OLTP as a proportion of all IT jobs advertised in the UK excluding London.

Job vacancy trend for OLTP in the UK excluding London

OLTP
Salary Trend in the UK excluding London

3-month moving average salary quoted in jobs citing OLTP in the UK excluding London.

Salary trend for OLTP in the UK excluding London

OLTP
Salary Histogram in the UK excluding London

Salary distribution for jobs citing OLTP in the UK excluding London over the 6 months to 15 January 2021.

Salary histogram for OLTP in the UK excluding London

OLTP
Job Locations in the UK excluding London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the UK excluding London region over the 6 months to 15 January 2021. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Midlands +84 9 £52,500 +41.70% 1
North of England +102 6 £42,500 -15.00% 1
North West +88 5 £40,000 -20.00%
West Midlands +78 5 £60,250 +67.19% 1
South East +136 4 £54,000 -8.09% 2
East Midlands +56 4 £50,000 -45.95%
Yorkshire - 1 £45,000 - 1
OLTP
UK

For the 6 months to 15 January 2021, IT jobs citing OLTP also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the UK excluding London region with a requirement for OLTP.

1 16 (84.21%) SQL
2 15 (78.95%) SQL Server
3 13 (68.42%) Business Intelligence
4 10 (52.63%) T-SQL
5 9 (47.37%) SQL Server Reporting Services
5 9 (47.37%) Data Modelling
6 8 (42.11%) OLAP
6 8 (42.11%) Agile Software Development
7 7 (36.84%) Azure
8 6 (31.58%) .NET
8 6 (31.58%) C#
8 6 (31.58%) Data Warehouse
9 5 (26.32%) Performance Monitoring
9 5 (26.32%) Microsoft
9 5 (26.32%) ETL
9 5 (26.32%) SQL Server Integration Services
10 4 (21.05%) Data Analysis
10 4 (21.05%) NUnit
10 4 (21.05%) Telerik
10 4 (21.05%) Moq
10 4 (21.05%) ADO.NET
10 4 (21.05%) ASP.NET
10 4 (21.05%) Visual Studio
10 4 (21.05%) SLA
10 4 (21.05%) MVC
10 4 (21.05%) Power BI
10 4 (21.05%) DevOps
10 4 (21.05%) Security Patching
10 4 (21.05%) Ninject
10 4 (21.05%) ASP.NET MVC

OLTP
Co-occurring IT Skills in the UK excluding London by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Business Applications
1 3 (15.79%) SAP IS-U
Cloud Services
1 7 (36.84%) Azure
2 4 (21.05%) Power Platform
3 3 (15.79%) Azure Data Factory
4 1 (5.26%) AWS
4 1 (5.26%) Azure Stack
4 1 (5.26%) Cloud Computing
4 1 (5.26%) IaaS
4 1 (5.26%) PaaS
Communications & Networking
1 2 (10.53%) LAN
1 2 (10.53%) WAN
Database & Business Intelligence
1 15 (78.95%) SQL Server
2 9 (47.37%) SQL Server Reporting Services
3 8 (42.11%) OLAP
4 6 (31.58%) Data Warehouse
5 5 (26.32%) SQL Server Integration Services
6 4 (21.05%) Power BI
6 4 (21.05%) SQL Server 2012
7 3 (15.79%) Azure SQL Data Warehouse
7 3 (15.79%) Big Data
7 3 (15.79%) Data Lake
7 3 (15.79%) IBM InfoSphere
7 3 (15.79%) RDBMS
7 3 (15.79%) Relational Database
7 3 (15.79%) SAP BW
8 2 (10.53%) Microsoft Analysis Services
8 2 (10.53%) SQL Server Analysis Services
9 1 (5.26%) Azure SQL Database
9 1 (5.26%) Cosmos DB
9 1 (5.26%) NoSQL
9 1 (5.26%) Tableau
Development Applications
1 4 (21.05%) Moq
1 4 (21.05%) NUnit
1 4 (21.05%) Visual Studio
2 3 (15.79%) ERwin
3 2 (10.53%) Git (software)
3 2 (10.53%) Visual Studio Code
4 1 (5.26%) GitLab
Job Titles
1 10 (52.63%) Developer
1 10 (52.63%) SQL Developer
2 6 (31.58%) Senior Developer
2 6 (31.58%) Senior SQL Developer
2 6 (31.58%) SQL Server Developer
3 4 (21.05%) Data Engineer
3 4 (21.05%) DBA
3 4 (21.05%) Senior SQL Server Developer
4 3 (15.79%) .NET Developer
4 3 (15.79%) Architect
4 3 (15.79%) Data Architect
4 3 (15.79%) Senior .NET Developer
5 2 (10.53%) Junior
6 1 (5.26%) Analyst
6 1 (5.26%) Consultant
6 1 (5.26%) Data Analyst
6 1 (5.26%) Database Developer
6 1 (5.26%) Junior Developer
6 1 (5.26%) Microsoft Consultant
6 1 (5.26%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 6 (31.58%) .NET
2 4 (21.05%) .NET Core
2 4 (21.05%) ADO.NET
2 4 (21.05%) ASP.NET
2 4 (21.05%) ASP.NET MVC
2 4 (21.05%) Ninject
Miscellaneous
1 3 (15.79%) Data Structures
2 1 (5.26%) Self-Motivation
Operating Systems
1 1 (5.26%) Linux
Processes & Methodologies
1 13 (68.42%) Business Intelligence
2 9 (47.37%) Data Modelling
3 8 (42.11%) Agile Software Development
4 5 (26.32%) ETL
4 5 (26.32%) Performance Monitoring
5 4 (21.05%) Capacity Management
5 4 (21.05%) Data Analysis
5 4 (21.05%) Data Governance
5 4 (21.05%) DevOps
5 4 (21.05%) MVC
5 4 (21.05%) Security Patching
6 3 (15.79%) Data Architecture
6 3 (15.79%) Inmon Methodology
6 3 (15.79%) Kimball Methodology
6 3 (15.79%) Logical Data Model
6 3 (15.79%) Physical Data Model
6 3 (15.79%) RAD
6 3 (15.79%) Waterfall
7 2 (10.53%) Database Tuning
7 2 (10.53%) Performance Optimisation
Programming Languages
1 16 (84.21%) SQL
2 10 (52.63%) T-SQL
3 6 (31.58%) C#
4 1 (5.26%) Python
Quality Assurance & Compliance
1 4 (21.05%) SLA
Vendors
1 5 (26.32%) Microsoft
2 4 (21.05%) Telerik
3 3 (15.79%) IBM
3 3 (15.79%) SAP
4 2 (10.53%) RedGate
5 1 (5.26%) Databricks
5 1 (5.26%) Google