Job Vacancy Trend Salary Trend Salary Histogram Job Locations Skill Sets
Period
to 11 December 2019

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 11 December 2019 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK > UK excluding London
6 months to
11 Dec 2019		 Same period 2018 Same period 2017
Rank 726 782 795
Rank change year-on-year +56 +13 -81
Permanent jobs citing OLTP 72 101 138
As % of all permanent IT jobs advertised in the UK excluding London 0.095% 0.11% 0.14%
As % of the Database & Business Intelligence category 0.36% 0.40% 0.44%
Number of salaries quoted 58 74 116
UK excluding London median annual salary £53,750 £52,000 £45,000
Median salary % change year-on-year +3.37% +15.56% -10.00%
10th Percentile £35,000 £35,000 £27,000
90th Percentile £78,250 £71,250 £70,000
UK median annual salary £70,000 £55,000 £50,000
% change year-on-year +27.27% +10.00% -3.29%

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 19,748 25,059 31,398
As % of all permanent IT jobs advertised in the UK excluding London 26.05% 28.16% 31.05%
Number of salaries quoted 16,361 20,630 26,425
UK excluding London median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -
10th Percentile £29,750 £28,750 £27,500
90th Percentile £67,500 £68,750 £62,500
UK median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% -

OLTP
Job Vacancy Trend in the UK excluding London

Job postings citing OLTP as a percentage 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

This chart provides the 3-month moving average for salaries quoted in permanent IT 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

The salary distribution of IT jobs citing OLTP in the UK excluding London over the 6 months to 11 December 2019.

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 11 December 2019. 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
East of England +82 27 £75,000 +11.11% 1
South East +35 21 £58,750 +6.82% 4
Midlands +27 15 £37,426 -21.62%
West Midlands +37 8 £37,050 -7.38%
Scotland +24 7 £52,500 +30.84% 6
East Midlands +6 7 £92,500 +92.71%
North West +12 1 - -
South West +8 1 £67,500 +33.66% 1
North of England +8 1 - -
OLTP
UK

For the 6 months to 11 December 2019, 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 48 (66.67%) SQL
2 47 (65.28%) SQL Server
2 47 (65.28%) Data Warehouse
3 39 (54.17%) Microsoft
4 35 (48.61%) Azure
5 31 (43.06%) OLAP
6 30 (41.67%) AWS
6 30 (41.67%) Agile Software Development
7 28 (38.89%) Linux
8 24 (33.33%) ETL
8 24 (33.33%) Business Intelligence
8 24 (33.33%) Analytical Skills
9 23 (31.94%) T-SQL
10 21 (29.17%) PostgreSQL
11 19 (26.39%) Python
11 19 (26.39%) Data Modelling
11 19 (26.39%) SDLC
11 19 (26.39%) Big Data
12 18 (25.00%) Enterprise Data Warehouse
13 17 (23.61%) Data Integration
14 16 (22.22%) Statistics
14 16 (22.22%) SLA
14 16 (22.22%) Disaster Recovery
14 16 (22.22%) SQL Server 2016
15 15 (20.83%) Performance Optimisation
15 15 (20.83%) Task Automation
15 15 (20.83%) Data Engineering
15 15 (20.83%) Root Cause Analysis
15 15 (20.83%) Replication
15 15 (20.83%) Foglight

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:

Application Platforms
1 14 (19.44%) Apache Spark
Applications
1 1 (1.39%) Microsoft Excel
Business Applications
1 3 (4.17%) OPENHousing
Cloud Services
1 35 (48.61%) Azure
2 30 (41.67%) AWS
3 8 (11.11%) Power Platform
4 2 (2.78%) Azure Data Factory
4 2 (2.78%) OpenShift
5 1 (1.39%) Amazon S3
5 1 (1.39%) Azure Stack
5 1 (1.39%) GCP
5 1 (1.39%) PaaS
5 1 (1.39%) Serverless
Communications & Networking
1 3 (4.17%) Internet
2 2 (2.78%) LAN
2 2 (2.78%) WAN
3 1 (1.39%) ZigBee
Database & Business Intelligence
1 47 (65.28%) Data Warehouse
1 47 (65.28%) SQL Server
2 31 (43.06%) OLAP
3 21 (29.17%) PostgreSQL
4 19 (26.39%) Big Data
5 18 (25.00%) Enterprise Data Warehouse
6 16 (22.22%) SQL Server 2016
7 15 (20.83%) Hadoop
8 14 (19.44%) Apache Hive
8 14 (19.44%) Relational Database
9 13 (18.06%) Apache Kudu
9 13 (18.06%) Impala
10 10 (13.89%) NoSQL
11 9 (12.50%) SQL Server Integration Services
11 9 (12.50%) SQL Server Reporting Services
12 8 (11.11%) Power BI
12 8 (11.11%) SQL Server Analysis Services
13 6 (8.33%) Oracle Database
14 5 (6.94%) Amazon Redshift
14 5 (6.94%) MySQL
Development Applications
1 2 (2.78%) Visual Studio
2 1 (1.39%) Team Foundation Server
General
1 9 (12.50%) Finance
2 4 (5.56%) Retail
3 3 (4.17%) Automotive
3 3 (4.17%) Social Housing
4 2 (2.78%) Public Sector
Job Titles
1 35 (48.61%) DBA
2 22 (30.56%) Administrator
3 19 (26.39%) Architect
4 18 (25.00%) SQL DBA
5 13 (18.06%) Data Architect
5 13 (18.06%) Developer
6 10 (13.89%) Hadoop Architect
6 10 (13.89%) SQL Server DBA
7 8 (11.11%) SQL Developer
8 7 (9.72%) Technical Architect
9 5 (6.94%) AWS Administrator
9 5 (6.94%) Azure Administrator
9 5 (6.94%) Business Developer
9 5 (6.94%) Business Intelligence Developer
9 5 (6.94%) Cloud Architect
10 4 (5.56%) Big Data Architect
10 4 (5.56%) Business Intelligence Architect
10 4 (5.56%) Web Administrator
11 3 (4.17%) Enterprise Architect
11 3 (4.17%) Lead Architect
Libraries, Frameworks & Software Standards
1 15 (20.83%) Web Services
2 13 (18.06%) Kafka
3 7 (9.72%) .NET
4 1 (1.39%) Apache Beam
4 1 (1.39%) COM
4 1 (1.39%) JSON
4 1 (1.39%) MDX
4 1 (1.39%) Pandas
4 1 (1.39%) SciPy
4 1 (1.39%) XML
Miscellaneous
1 24 (33.33%) Analytical Skills
2 15 (20.83%) Replication
3 4 (5.56%) Data Structures
4 3 (4.17%) Public Cloud
4 3 (4.17%) Self-Motivation
5 1 (1.39%) Data Centre
5 1 (1.39%) Driving Licence
5 1 (1.39%) Management Information System
5 1 (1.39%) Smart Energy
5 1 (1.39%) Smart Meter
Operating Systems
1 28 (38.89%) Linux
2 15 (20.83%) Unix
3 3 (4.17%) Solaris
4 2 (2.78%) Windows
4 2 (2.78%) Windows Server
Processes & Methodologies
1 30 (41.67%) Agile Software Development
2 24 (33.33%) Business Intelligence
2 24 (33.33%) ETL
3 19 (26.39%) Data Modelling
3 19 (26.39%) SDLC
4 17 (23.61%) Data Integration
5 16 (22.22%) Disaster Recovery
5 16 (22.22%) Statistics
6 15 (20.83%) Data Engineering
6 15 (20.83%) Data Protection
6 15 (20.83%) E-Commerce
6 15 (20.83%) ITIL
6 15 (20.83%) Performance Optimisation
6 15 (20.83%) Problem Management
6 15 (20.83%) Root Cause Analysis
6 15 (20.83%) Task Automation
7 14 (19.44%) Logical Data Model
7 14 (19.44%) Physical Data Model
8 13 (18.06%) Conceptual Models
8 13 (18.06%) Stakeholder Management
Programming Languages
1 48 (66.67%) SQL
2 23 (31.94%) T-SQL
3 19 (26.39%) Python
4 13 (18.06%) Shell Script
5 6 (8.33%) Java
6 3 (4.17%) PL/SQL
7 2 (2.78%) Data Analysis Expressions (DAX)
8 1 (1.39%) C#
8 1 (1.39%) PowerShell
8 1 (1.39%) Scala
Qualifications
1 7 (9.72%) Degree
2 2 (2.78%) Microsoft Certification
Quality Assurance & Compliance
1 16 (22.22%) SLA
2 8 (11.11%) GDPR
3 6 (8.33%) Data Quality
4 3 (4.17%) Sarbanes-Oxley
5 2 (2.78%) QA
System Software
1 13 (18.06%) Apache Flume
2 10 (13.89%) HDFS
3 2 (2.78%) Docker
4 1 (1.39%) Hyper-V
4 1 (1.39%) VMware Infrastructure
Systems Management
1 15 (20.83%) Foglight
1 15 (20.83%) LiteSpeed
2 13 (18.06%) Oozie
3 10 (13.89%) SCOM
4 2 (2.78%) Kubernetes
5 1 (1.39%) NetBackup
Vendors
1 39 (54.17%) Microsoft
2 13 (18.06%) Oracle
3 7 (9.72%) Cloudera
4 4 (5.56%) Tableau
5 3 (4.17%) Capita
5 3 (4.17%) Sun
6 2 (2.78%) Informatica
6 2 (2.78%) InterSystems
7 1 (1.39%) Google
7 1 (1.39%) RedGate
7 1 (1.39%) VMware