Period
to 22 March 2019

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

Online Transaction Processing (OLTP)
UK
6 months to
22 Mar 2019
Same period 2018 Same period 2017
Rank 972 965 919
Rank change year-on-year -7 -46 +43
Permanent jobs citing OLTP 137 238 284
As % of all permanent IT jobs advertised in the UK 0.092% 0.14% 0.16%
As % of the Database & Business Intelligence category 0.32% 0.44% 0.54%
Number of salaries quoted 99 203 207
UK median annual salary £62,500 £52,500 £55,000
Median salary % change year-on-year +19.05% -4.55% -
10th Percentile £36,250 £33,750 £37,500
90th Percentile £92,500 £84,750 £80,000
UK excluding London median annual salary £52,000 £45,000 £52,500
% change year-on-year +15.56% -14.29% +5.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 with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 42,571 53,837 52,365
As % of all permanent IT jobs advertised in the UK 28.48% 30.62% 30.39%
Number of salaries quoted 35,030 45,028 44,668
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,250 £30,250 £29,500
90th Percentile £85,000 £78,750 £76,250
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +2.20%

OLTP
Job Vacancy Trend

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

Job vacancy trend for OLTP in the UK

OLTP
Salary Trend

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

Salary trend for OLTP in the UK

OLTP
Salary Histogram

The salary distribution of IT jobs citing OLTP over the 6 months to 22 March 2019.

Salary histogram for OLTP in the UK

OLTP
Top 13 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the UK over the 6 months to 22 March 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
England -11 125 £62,500 +19.05% 12
London +29 77 £67,500 +10.20% 3
UK excluding London -14 59 £52,000 +15.56% 9
Midlands +7 18 £70,000 +40.00% 1
South East +31 16 £52,000 +22.35% 1
East Midlands +13 13 £70,000 +40.00% 1
North of England +34 10 £53,500 -2.73% 4
Scotland +10 9 £42,500 -
North West +13 7 £56,250 +2.27% 1
West Midlands +41 5 £75,000 +120.59%
East of England +41 4 - - 2
Yorkshire +32 3 £38,875 -29.32% 3
Wales - 2 £34,500 -

For the 6 months to 22 March 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 with a requirement for OLTP.

1 84 (61.31%) SQL Server
2 82 (59.85%) SQL
3 79 (57.66%) Data Warehouse
4 60 (43.80%) SQL Server Integration Services
5 57 (41.61%) SQL Server Reporting Services
6 55 (40.15%) Agile Software Development
7 52 (37.96%) Business Intelligence
8 49 (35.77%) Microsoft Azure
9 46 (33.58%) Microsoft
10 43 (31.39%) T-SQL
11 41 (29.93%) OLAP
12 40 (29.20%) Data Modelling
12 40 (29.20%) Finance
13 37 (27.01%) SQL Server Analysis Services
14 35 (25.55%) Python
14 35 (25.55%) Oracle
15 33 (24.09%) ETL
15 33 (24.09%) Performance Tuning
16 32 (23.36%) Java
17 29 (21.17%) Power BI
18 25 (18.25%) Amazon AWS
19 24 (17.52%) C#
19 24 (17.52%) .NET
20 23 (16.79%) Degree
21 22 (16.06%) Visualisation
21 22 (16.06%) Tableau
21 22 (16.06%) Big Data
21 22 (16.06%) Kafka
22 21 (15.33%) R
22 21 (15.33%) PaaS

OLTP
Co-occurring IT Skills 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 15 (10.95%) Apache Spark
2 14 (10.22%) SharePoint
3 7 (5.11%) Apache
4 5 (3.65%) Apache Pig
5 3 (2.19%) Elasticsearch
5 3 (2.19%) Oracle Workflow
5 3 (2.19%) Tomcat
5 3 (2.19%) WebLogic
6 2 (1.46%) Apache Solr
6 2 (1.46%) Jupyter
7 1 (0.73%) IIS
7 1 (0.73%) Oracle SOA Suite
Applications
1 16 (11.68%) Microsoft Excel
2 2 (1.46%) SPSS
3 1 (0.73%) Microsoft Office
3 1 (0.73%) Microsoft PowerPoint
3 1 (0.73%) MS Visio
Business Applications
1 1 (0.73%) Oracle AML
Cloud Services
1 49 (35.77%) Microsoft Azure
2 25 (18.25%) Amazon AWS
3 21 (15.33%) PaaS
4 16 (11.68%) SaaS
5 9 (6.57%) Azure Data Factory
6 7 (5.11%) Amazon EMR
6 7 (5.11%) Amazon S3
6 7 (5.11%) Cloud Computing
7 4 (2.92%) GitHub
8 3 (2.19%) Office 365
9 2 (1.46%) Apigee
9 2 (1.46%) Azure Active Directory
9 2 (1.46%) Azure Machine Learning
9 2 (1.46%) Boomi
9 2 (1.46%) Data Lake Analytics
9 2 (1.46%) IaaS
9 2 (1.46%) iPaaS
Communications & Networking
1 10 (7.30%) Firewall
2 8 (5.84%) Internet
3 2 (1.46%) PPP
Database & Business Intelligence
1 84 (61.31%) SQL Server
2 79 (57.66%) Data Warehouse
3 60 (43.80%) SQL Server Integration Services
4 57 (41.61%) SQL Server Reporting Services
5 41 (29.93%) OLAP
6 37 (27.01%) SQL Server Analysis Services
7 29 (21.17%) Power BI
8 22 (16.06%) Big Data
9 19 (13.87%) NoSQL
10 16 (11.68%) Apache Hive
10 16 (11.68%) Hadoop
10 16 (11.68%) MySQL
11 15 (10.95%) MongoDB
11 15 (10.95%) Relational Database
12 13 (9.49%) HBase
12 13 (9.49%) Impala
12 13 (9.49%) SQL Server 2008
13 12 (8.76%) Oracle Database
13 12 (8.76%) Oracle OLAP
14 10 (7.30%) SQL Server 2012
Development Applications
1 9 (6.57%) Cucumber
1 9 (6.57%) Gradle
2 4 (2.92%) ERwin
3 3 (2.19%) ER Studio
4 2 (1.46%) Git (software)
4 2 (1.46%) Jenkins
4 2 (1.46%) Maven
4 2 (1.46%) Subversion
4 2 (1.46%) Team Foundation Server
4 2 (1.46%) Visual Studio Team System
5 1 (0.73%) PowerDesigner
5 1 (0.73%) SQL Server Management Studio (SSMS)
General
1 40 (29.20%) Finance
2 19 (13.87%) Retail
3 18 (13.14%) Banking
4 12 (8.76%) Investment Banking
5 9 (6.57%) Advertising
6 8 (5.84%) Retail Banking
7 7 (5.11%) Marketing
8 4 (2.92%) Law
9 3 (2.19%) Spanish Language
10 2 (1.46%) Billing
11 1 (0.73%) Pharmaceutical
Job Titles
1 50 (36.50%) Developer
2 22 (16.06%) Architect
3 20 (14.60%) SQL Developer
4 18 (13.14%) DBA
5 14 (10.22%) Business Intelligence Consultant
5 14 (10.22%) Business Intelligence Developer
5 14 (10.22%) Consultant
5 14 (10.22%) Data Architect
5 14 (10.22%) Microsoft BI Consultant
5 14 (10.22%) Microsoft Consultant
6 13 (9.49%) Senior Developer
6 13 (9.49%) SQL DBA
7 11 (8.03%) Analyst
8 10 (7.30%) Oracle Developer
9 9 (6.57%) Data Engineer
9 9 (6.57%) Disaster Recovery Analyst
10 8 (5.84%) Senior Data Engineer
10 8 (5.84%) SQL Server DBA
10 8 (5.84%) SSIS Developer
10 8 (5.84%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 24 (17.52%) .NET
2 22 (16.06%) Kafka
3 9 (6.57%) MDX
3 9 (6.57%) RESTful
3 9 (6.57%) Spring Boot
4 7 (5.11%) LAMP
5 6 (4.38%) XML
6 5 (3.65%) Spring
6 5 (3.65%) Web Services
7 4 (2.92%) Apache NiFi
7 4 (2.92%) HTML
8 3 (2.19%) J2EE
8 3 (2.19%) Spark Streaming
9 2 (1.46%) Anaconda
9 2 (1.46%) Apache Tez
9 2 (1.46%) ASP.NET
9 2 (1.46%) OpenID
9 2 (1.46%) SAML
9 2 (1.46%) Spring Cloud
9 2 (1.46%) TensorFlow
Miscellaneous
1 18 (13.14%) Analytical Skills
2 13 (9.49%) Greenfield Project
3 11 (8.03%) N-Tier
4 8 (5.84%) Data Centre
4 8 (5.84%) Data Structures
5 7 (5.11%) Management Information System
6 6 (4.38%) Clustering
6 6 (4.38%) Public Cloud
7 5 (3.65%) HACMP
8 3 (2.19%) Mainframe
8 3 (2.19%) Replication
9 2 (1.46%) Cloud Native
9 2 (1.46%) Driving Licence
9 2 (1.46%) PMI
9 2 (1.46%) Virtual Team
10 1 (0.73%) Client/Server
10 1 (0.73%) Enterprise Software
10 1 (0.73%) Fintech
10 1 (0.73%) Private Cloud
10 1 (0.73%) User Experience
Operating Systems
1 18 (13.14%) Unix
2 17 (12.41%) Linux
3 14 (10.22%) Windows
4 13 (9.49%) Windows Server
5 7 (5.11%) Solaris
6 6 (4.38%) AIX
7 5 (3.65%) Red Hat Enterprise Linux
Processes & Methodologies
1 55 (40.15%) Agile Software Development
2 52 (37.96%) Business Intelligence
3 40 (29.20%) Data Modelling
4 33 (24.09%) ETL
4 33 (24.09%) Performance Tuning
5 22 (16.06%) Visualisation
6 19 (13.87%) Analytics
7 18 (13.14%) High Availability
8 15 (10.95%) Data Analytics
8 15 (10.95%) Machine Learning
9 14 (10.22%) Computer Science
9 14 (10.22%) Migration
9 14 (10.22%) Problem-Solving
9 14 (10.22%) Software Engineering
9 14 (10.22%) Technical Leadership
10 13 (9.49%) Mentoring
11 12 (8.76%) Data Science
11 12 (8.76%) Microservices
11 12 (8.76%) SDLC
11 12 (8.76%) SOA
Programming Languages
1 82 (59.85%) SQL
2 43 (31.39%) T-SQL
3 35 (25.55%) Python
4 32 (23.36%) Java
5 24 (17.52%) C#
6 21 (15.33%) R
7 18 (13.14%) PL/SQL
8 14 (10.22%) PowerShell
9 10 (7.30%) Shell Script
10 7 (5.11%) Perl
11 5 (3.65%) PHP
12 3 (2.19%) Data Analysis Expressions (DAX)
12 3 (2.19%) JavaScript
12 3 (2.19%) Scala
13 2 (1.46%) Bash Shell
13 2 (1.46%) C++
13 2 (1.46%) Ruby
13 2 (1.46%) VB.NET
13 2 (1.46%) VBA
14 1 (0.73%) Data Mining Extensions (DMX)
Qualifications
1 23 (16.79%) Degree
2 19 (13.87%) Security Cleared
3 5 (3.65%) Computer Science Degree
3 5 (3.65%) SC Cleared
4 2 (1.46%) AWS Certification
4 2 (1.46%) CEH
4 2 (1.46%) PMI Certification
4 2 (1.46%) TOGAF Certification
5 1 (0.73%) Microsoft Certification
Quality Assurance & Compliance
1 11 (8.03%) GDPR
2 5 (3.65%) QA
3 4 (2.92%) Data Quality
4 3 (2.19%) SLA
System Software
1 13 (9.49%) Apache Flume
1 13 (9.49%) HDFS
2 9 (6.57%) Docker
3 8 (5.84%) Virtual Machines
4 6 (4.38%) Oracle RAC
5 5 (3.65%) GPFS
5 5 (3.65%) VMware Infrastructure
6 3 (2.19%) Apache ZooKeeper
7 2 (1.46%) Active Directory
Systems Management
1 7 (5.11%) Hadoop YARN
2 3 (2.19%) Oozie
3 2 (1.46%) Ambari
3 2 (1.46%) Ansible
3 2 (1.46%) Opscode Chef
3 2 (1.46%) Puppet
3 2 (1.46%) Salt
4 1 (0.73%) WSUS
Vendors
1 46 (33.58%) Microsoft
2 35 (25.55%) Oracle
3 22 (16.06%) Tableau
4 13 (9.49%) Informatica
5 10 (7.30%) Cloudera
6 8 (5.84%) Intel
6 8 (5.84%) Teradata
7 7 (5.11%) Talend
8 5 (3.65%) NetApp
8 5 (3.65%) VMware
9 4 (2.92%) Databricks
9 4 (2.92%) SAP
10 3 (2.19%) Hortonworks
10 3 (2.19%) MapR
10 3 (2.19%) MuleSoft
11 2 (1.46%) Alteryx
11 2 (1.46%) Aspera
11 2 (1.46%) Axway
11 2 (1.46%) Jitterbit
11 2 (1.46%) Signiant