Period
to 20 August 2019

The following table provides summary statistics for permanent job vacancies advertised in England 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 20 August 2019 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK > England
6 months to
20 Aug 2019
Same period 2018 Same period 2017
Rank 925 912 946
Rank change year-on-year -13 +34 -49
Permanent jobs citing OLTP 132 239 238
As % of all permanent IT jobs advertised in England 0.10% 0.15% 0.14%
As % of the Database & Business Intelligence category 0.37% 0.50% 0.47%
Number of salaries quoted 115 192 160
England median annual salary £67,500 £57,500 £53,750
Median salary % change year-on-year +17.39% +6.98% +7.50%
10th Percentile £46,250 £36,250 £31,250
90th Percentile £85,000 £85,000 £80,000
UK median annual salary £65,000 £52,500 £55,000
% change year-on-year +23.81% -4.55% +10.00%

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 England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 35,596 47,391 50,362
As % of all permanent IT jobs advertised in England 27.17% 30.03% 30.46%
Number of salaries quoted 29,498 38,753 42,341
England median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,589 £31,250 £30,000
90th Percentile £86,250 £82,500 £77,500
UK median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% -

OLTP
Job Vacancy Trend in England

Job postings citing OLTP as a percentage of all IT jobs advertised in England.

Job vacancy trend for OLTP in England

OLTP
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP in England.

Salary trend for OLTP in England

OLTP
Salary Histogram in England

The salary distribution of IT jobs citing OLTP in England over the 6 months to 20 August 2019.

Salary histogram for OLTP in England

OLTP
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the England region over the 6 months to 20 August 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
London +45 83 £72,500 +11.54% 5
Midlands +34 15 £37,050 -24.39% 5
South East +7 15 £70,000 +64.71% 2
West Midlands +31 11 £37,050 -7.38% 2
North of England +3 10 £47,500 -13.64% 4
East of England +50 8 £52,500 -20.45% 1
North West -1 6 £50,000 -9.09% 3
East Midlands +22 4 £38,000 -33.91% 3
Yorkshire - 4 £42,000 - 1
South West -2 1 £67,500 +54.29% 1
OLTP
UK

For the 6 months to 20 August 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 England region with a requirement for OLTP.

1 94 (71.21%) SQL
1 94 (71.21%) SQL Server
2 78 (59.09%) Data Warehouse
3 72 (54.55%) Microsoft
4 63 (47.73%) Business Intelligence
5 60 (45.45%) SQL Server Integration Services
6 54 (40.91%) T-SQL
7 51 (38.64%) SQL Server Reporting Services
8 49 (37.12%) Agile Software Development
9 48 (36.36%) Finance
9 48 (36.36%) Microsoft Azure
10 45 (34.09%) Amazon AWS
11 44 (33.33%) OLAP
12 38 (28.79%) Data Modelling
13 35 (26.52%) ETL
13 35 (26.52%) Power BI
13 35 (26.52%) Power Platform
14 34 (25.76%) SQL Server Analysis Services
15 33 (25.00%) Performance Tuning
16 32 (24.24%) Analytics
17 31 (23.48%) Data Integration
18 28 (21.21%) Data Architecture
18 28 (21.21%) NoSQL
18 28 (21.21%) PostgreSQL
19 27 (20.45%) Unix
20 25 (18.94%) Oracle
20 25 (18.94%) Big Data
21 24 (18.18%) Data Analysis
21 24 (18.18%) SDLC
22 21 (15.91%) Windows

OLTP
Co-occurring IT Skills in England 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 7 (5.30%) Apache Pig
2 3 (2.27%) Apache Spark
2 3 (2.27%) SharePoint
3 1 (0.76%) Confluence
3 1 (0.76%) Elasticsearch
Applications
1 3 (2.27%) Microsoft Excel
Business Applications
1 3 (2.27%) OPENHousing
Cloud Services
1 48 (36.36%) Microsoft Azure
2 45 (34.09%) Amazon AWS
3 35 (26.52%) Power Platform
4 21 (15.91%) Azure Data Factory
5 13 (9.85%) Google Cloud Platform
6 6 (4.55%) Azure Stack
6 6 (4.55%) PaaS
7 5 (3.79%) Cloud Computing
8 3 (2.27%) Boomi
8 3 (2.27%) Serverless
9 1 (0.76%) IaaS
9 1 (0.76%) SaaS
Communications & Networking
1 5 (3.79%) SAN
2 2 (1.52%) LAN
2 2 (1.52%) WAN
3 1 (0.76%) Kerberos
Database & Business Intelligence
1 94 (71.21%) SQL Server
2 78 (59.09%) Data Warehouse
3 60 (45.45%) SQL Server Integration Services
4 51 (38.64%) SQL Server Reporting Services
5 44 (33.33%) OLAP
6 35 (26.52%) Power BI
7 34 (25.76%) SQL Server Analysis Services
8 28 (21.21%) NoSQL
8 28 (21.21%) PostgreSQL
9 25 (18.94%) Big Data
10 19 (14.39%) SQL Server 2012
10 19 (14.39%) SQL Server 2016
11 17 (12.88%) Amazon Aurora
11 17 (12.88%) Relational Database
12 16 (12.12%) Data Lake
12 16 (12.12%) Hadoop
13 13 (9.85%) Amazon RDS
13 13 (9.85%) Azure SQL Data Warehouse
14 12 (9.09%) Couchbase
15 11 (8.33%) Sqoop
Development Applications
1 19 (14.39%) ER Studio
1 19 (14.39%) ERwin
1 19 (14.39%) PowerDesigner
2 5 (3.79%) Visual Studio
3 2 (1.52%) JIRA
4 1 (0.76%) Artifactory
4 1 (0.76%) Cucumber
4 1 (0.76%) Git (software)
4 1 (0.76%) Gradle
4 1 (0.76%) Jenkins
4 1 (0.76%) Maven
4 1 (0.76%) Sonatype Nexus
General
1 48 (36.36%) Finance
2 13 (9.85%) Banking
3 12 (9.09%) Advertising
4 7 (5.30%) Investment Banking
4 7 (5.30%) Retail
5 5 (3.79%) Law
6 3 (2.27%) Public Sector
6 3 (2.27%) Social Housing
7 1 (0.76%) Games
7 1 (0.76%) Retail Banking
Job Titles
1 43 (32.58%) Developer
2 40 (30.30%) DBA
3 32 (24.24%) Business Intelligence Developer
4 28 (21.21%) SQL DBA
5 26 (19.70%) Architect
6 25 (18.94%) Senior Developer
7 22 (16.67%) Senior Business Intelligence Developer
8 16 (12.12%) Data Architect
9 15 (11.36%) Administrator
10 13 (9.85%) Business Developer
11 11 (8.33%) SQL Server DBA
12 7 (5.30%) Data Engineer
13 6 (4.55%) Database Engineer
13 6 (4.55%) Solutions Architect
13 6 (4.55%) SQL Developer
14 5 (3.79%) Consultant
14 5 (3.79%) Oracle Developer
14 5 (3.79%) Senior Data Engineer
15 4 (3.03%) Azure Developer
15 4 (3.03%) Database Developer
Libraries, Frameworks & Software Standards
1 12 (9.09%) .NET
2 7 (5.30%) MDX
3 5 (3.79%) Web Services
4 3 (2.27%) Kafka
5 2 (1.52%) XML
6 1 (0.76%) JSON
6 1 (0.76%) RESTful
6 1 (0.76%) Spark Streaming
6 1 (0.76%) Spring Boot
Miscellaneous
1 19 (14.39%) Analytical Skills
2 18 (13.64%) Replication
3 11 (8.33%) Greenfield Project
4 8 (6.06%) Clustering
5 7 (5.30%) Cloud Native
6 4 (3.03%) Data Centre
7 2 (1.52%) Management Information System
8 1 (0.76%) CMDB
8 1 (0.76%) Data Structures
8 1 (0.76%) Online Games
8 1 (0.76%) Public Cloud
8 1 (0.76%) Reinsurance
Operating Systems
1 27 (20.45%) Unix
2 21 (15.91%) Windows
3 12 (9.09%) Linux
4 3 (2.27%) Solaris
5 1 (0.76%) Windows Server
Processes & Methodologies
1 63 (47.73%) Business Intelligence
2 49 (37.12%) Agile Software Development
3 38 (28.79%) Data Modelling
4 35 (26.52%) ETL
5 33 (25.00%) Performance Tuning
6 32 (24.24%) Analytics
7 31 (23.48%) Data Integration
8 28 (21.21%) Data Architecture
9 24 (18.18%) Data Analysis
9 24 (18.18%) SDLC
10 17 (12.88%) Kimball Methodology
11 16 (12.12%) E-Commerce
11 16 (12.12%) High Availability
12 15 (11.36%) Visualisation
13 14 (10.61%) DevOps
13 14 (10.61%) Problem-Solving
14 13 (9.85%) Microservices
14 13 (9.85%) Migration
15 12 (9.09%) Disaster Recovery
16 11 (8.33%) Data Visualisation
Programming Languages
1 94 (71.21%) SQL
2 54 (40.91%) T-SQL
3 15 (11.36%) PL/SQL
4 8 (6.06%) Python
5 6 (4.55%) C#
6 5 (3.79%) Perl
7 4 (3.03%) Data Analysis Expressions (DAX)
7 4 (3.03%) Shell Script
7 4 (3.03%) VB.NET
8 3 (2.27%) R
9 2 (1.52%) Java
9 2 (1.52%) PowerShell
9 2 (1.52%) VBA
10 1 (0.76%) Data Mining Extensions (DMX)
10 1 (0.76%) Scala
10 1 (0.76%) VBScript
Qualifications
1 14 (10.61%) Degree
2 5 (3.79%) Master's Degree
3 4 (3.03%) Computer Science Degree
3 4 (3.03%) Microsoft Certification
3 4 (3.03%) Security Cleared
4 3 (2.27%) SC Cleared
5 2 (1.52%) MCSE
6 1 (0.76%) MCDBA
6 1 (0.76%) MCT
Quality Assurance & Compliance
1 6 (4.55%) GDPR
1 6 (4.55%) SLA
2 5 (3.79%) Data Quality
System Software
1 10 (7.58%) Apache Flume
2 5 (3.79%) Oracle RAC
3 4 (3.03%) Docker
4 3 (2.27%) HDFS
5 1 (0.76%) Apache ZooKeeper
5 1 (0.76%) Hyper-V
5 1 (0.76%) Oracle Clusterware
5 1 (0.76%) VMware Infrastructure
Systems Management
1 5 (3.79%) Foglight
1 5 (3.79%) LiteSpeed
2 3 (2.27%) Kubernetes
2 3 (2.27%) Oozie
3 2 (1.52%) Data Guard
3 2 (1.52%) Oracle RMAN
3 2 (1.52%) SCOM
4 1 (0.76%) Ansible
4 1 (0.76%) Enterprise Manager Cloud Control
4 1 (0.76%) Hadoop YARN
4 1 (0.76%) Microsoft Data Protection Manager
4 1 (0.76%) NetBackup
4 1 (0.76%) SCDPM
Vendors
1 72 (54.55%) Microsoft
2 25 (18.94%) Oracle
3 16 (12.12%) Google
4 14 (10.61%) Databricks
5 12 (9.09%) MuleSoft
5 12 (9.09%) Tableau
6 9 (6.82%) Teradata
7 7 (5.30%) Informatica
8 6 (4.55%) MicroStrategy
8 6 (4.55%) SAP
9 5 (3.79%) Cognos
9 5 (3.79%) IBM
10 3 (2.27%) Capita
10 3 (2.27%) Dell
10 3 (2.27%) SnapLogic
11 2 (1.52%) Cadence
11 2 (1.52%) MapR
11 2 (1.52%) RedGate
12 1 (0.76%) Cloudera
12 1 (0.76%) VMware