Period
to 25 June 2018

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 25 June 2018 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK
6 months to
25 Jun 2018
Same period 2017 Same period 2016
Rank 896 960 962
Rank change year-on-year +64 +2 -40
Permanent jobs citing OLTP 290 224 341
As % of all permanent IT jobs advertised in the UK 0.17% 0.13% 0.17%
As % of the Database & Business Intelligence category 0.54% 0.42% 0.56%
Number of salaries quoted 242 154 233
UK median annual salary £53,750 £55,000 £52,500
Median salary % change year-on-year -2.27% +4.76% -
10th Percentile £33,750 £33,863 £32,500
90th Percentile £85,000 £82,125 £77,350
UK excluding London median annual salary £42,500 £50,000 £45,000
% change year-on-year -15.00% +11.11% -

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 53,268 53,240 61,038
As % of all permanent IT jobs advertised in the UK 30.61% 30.74% 30.46%
Number of salaries quoted 43,560 45,002 51,996
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £29,500 £28,750
90th Percentile £80,000 £77,500 £75,000
UK excluding London median annual salary £45,000 £42,500 £41,000
% change year-on-year +5.88% +3.66% +2.50%

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 25 June 2018.

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 25 June 2018. 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 +48 248 £55,000 - 28
UK excluding London +28 163 £42,500 -15.00% 12
London +8 123 £65,000 - 18
South East -17 45 £42,500 -19.05% 2
Scotland +3 38 £37,500 -40.00% 2
East of England +8 27 £60,000 +41.18% 2
North of England +45 23 £57,500 -11.54% 3
Midlands 0 23 £50,000 +13.64% 2
North West +11 21 £57,500 -23.33% 3
East Midlands -5 16 £50,000 +40.85% 1
West Midlands +21 7 £34,000 -36.74% 1
South West -8 7 £42,500 +30.77% 1
Yorkshire +32 2 £56,250 +4.65%

For the 6 months to 25 June 2018, 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 224 (77.24%) SQL
2 153 (52.76%) SQL Server Integration Services
3 150 (51.72%) SQL Server
4 144 (49.66%) OLAP
5 140 (48.28%) Business Intelligence
6 133 (45.86%) Microsoft
7 126 (43.45%) SQL Server Reporting Services
8 118 (40.69%) Data Warehouse
9 106 (36.55%) ETL
10 100 (34.48%) SQL Server Analysis Services
11 97 (33.45%) Agile Software Development
12 87 (30.00%) Oracle
13 79 (27.24%) T-SQL
14 77 (26.55%) Data Modelling
15 75 (25.86%) Microsoft Azure
16 73 (25.17%) Finance
17 69 (23.79%) Java
18 66 (22.76%) Power BI
19 63 (21.72%) C#
20 59 (20.34%) Performance Tuning
21 55 (18.97%) .NET
22 53 (18.28%) PL/SQL
23 45 (15.52%) MySQL
24 44 (15.17%) Data Architecture
25 43 (14.83%) Advertising
26 42 (14.48%) TDD
26 42 (14.48%) WPF
27 41 (14.14%) Analytics
28 37 (12.76%) Big Data
29 36 (12.41%) Degree

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 18 (6.21%) Apache Spark
2 14 (4.83%) Elasticsearch
3 8 (2.76%) Oracle Application Server
4 7 (2.41%) SAS
5 5 (1.72%) Apache
6 3 (1.03%) Apache Solr
7 2 (0.69%) Apache Pig
7 2 (0.69%) JBoss
8 1 (0.34%) Oracle Workflow
8 1 (0.34%) Tomcat
8 1 (0.34%) WebLogic
Applications
1 13 (4.48%) MS Visio
2 6 (2.07%) Microsoft Excel
2 6 (2.07%) Microsoft Office
3 1 (0.34%) Spreadsheet
Business Applications
1 2 (0.69%) Adobe Campaign
2 1 (0.34%) Remedy ITSM
Cloud Services
1 75 (25.86%) Microsoft Azure
2 26 (8.97%) Amazon AWS
3 10 (3.45%) SaaS
4 4 (1.38%) Azure Data Factory
5 3 (1.03%) PaaS
6 2 (0.69%) Amazon S3
6 2 (0.69%) Data Lake Analytics
6 2 (0.69%) IaaS
Communications & Networking
1 7 (2.41%) DNS
1 7 (2.41%) HTTP
2 6 (2.07%) SAN
3 4 (1.38%) SSL
4 2 (0.69%) MPLS
4 2 (0.69%) SMS
4 2 (0.69%) VPLS
4 2 (0.69%) Wireless
Database & Business Intelligence
1 153 (52.76%) SQL Server Integration Services
2 150 (51.72%) SQL Server
3 144 (49.66%) OLAP
4 126 (43.45%) SQL Server Reporting Services
5 118 (40.69%) Data Warehouse
6 100 (34.48%) SQL Server Analysis Services
7 66 (22.76%) Power BI
8 45 (15.52%) MySQL
9 37 (12.76%) Big Data
10 36 (12.41%) Oracle OLAP
11 34 (11.72%) NoSQL
12 32 (11.03%) SQL Server 2012
13 31 (10.69%) Relational Database
14 27 (9.31%) Hadoop
15 25 (8.62%) MongoDB
16 23 (7.93%) Oracle Database
16 23 (7.93%) SQL Server 2016
17 20 (6.90%) Snowflake Schema
18 18 (6.21%) Azure SQL Database
18 18 (6.21%) SQL Server 2008
Development Applications
1 28 (9.66%) SQL Server Management Studio (SSMS)
2 26 (8.97%) ERwin
3 23 (7.93%) Team Foundation Server
3 23 (7.93%) Visual Studio
4 12 (4.14%) Git (software)
5 9 (3.10%) ER Studio
6 8 (2.76%) Visual Studio Team System
7 7 (2.41%) JIRA
8 4 (1.38%) Cucumber
8 4 (1.38%) Gradle
8 4 (1.38%) Jenkins
9 3 (1.03%) TeamCity
10 2 (0.69%) Oracle Forms
11 1 (0.34%) Subversion
11 1 (0.34%) TestRail
General
1 73 (25.17%) Finance
2 43 (14.83%) Advertising
3 35 (12.07%) Banking
4 13 (4.48%) Retail Banking
5 12 (4.14%) Games
6 9 (3.10%) Retail
7 7 (2.41%) Investment Banking
8 6 (2.07%) Front Office
9 5 (1.72%) Marketing
10 4 (1.38%) Billing
10 4 (1.38%) International Banking
10 4 (1.38%) Law
11 3 (1.03%) Back Office
11 3 (1.03%) Pharmaceutical
11 3 (1.03%) Publishing
12 2 (0.69%) Dutch Language
12 2 (0.69%) French Language
12 2 (0.69%) German Language
12 2 (0.69%) Italian Language
12 2 (0.69%) Retail Finance
Job Titles
1 148 (51.03%) Developer
2 63 (21.72%) Architect
3 47 (16.21%) Data Architect
4 46 (15.86%) DBA
5 39 (13.45%) SQL Developer
6 30 (10.34%) SQL DBA
7 26 (8.97%) Business Intelligence Developer
7 26 (8.97%) Software Developer
8 19 (6.55%) Senior Developer
8 19 (6.55%) SSIS Developer
9 17 (5.86%) Data Warehouse Developer
9 17 (5.86%) Solutions Architect
10 16 (5.52%) Java Developer
10 16 (5.52%) SQL Server Developer
10 16 (5.52%) SSRS Developer
11 15 (5.17%) Business Intelligence Architect
11 15 (5.17%) SQL Server DBA
12 13 (4.48%) Analyst
12 13 (4.48%) Data Engineer
12 13 (4.48%) Senior SQL Developer
Libraries, Frameworks & Software Standards
1 55 (18.97%) .NET
2 42 (14.48%) WPF
3 29 (10.00%) Web Services
4 25 (8.62%) XML
5 14 (4.83%) JSON
5 14 (4.83%) MDX
6 12 (4.14%) REST
7 11 (3.79%) Kafka
8 8 (2.76%) SOAP
9 7 (2.41%) Oracle GoldenGate
10 4 (1.38%) AngularJS
10 4 (1.38%) ASP.NET
10 4 (1.38%) Middleware
10 4 (1.38%) RabbitMQ
10 4 (1.38%) RESTful
10 4 (1.38%) Spring Boot
11 3 (1.03%) ASP.NET Web API
11 3 (1.03%) LDAP
12 2 (0.69%) ASP.NET MVC
12 2 (0.69%) Spark Streaming
Miscellaneous
1 34 (11.72%) User Experience
2 29 (10.00%) Analytical Skills
3 28 (9.66%) Computer Science
4 24 (8.28%) Replication
5 17 (5.86%) Clustering
6 16 (5.52%) Hybrid Cloud
7 11 (3.79%) Fintech
8 9 (3.10%) Data Structures
9 8 (2.76%) Mainframe
10 6 (2.07%) Self-Motivation
11 5 (1.72%) Data Protection Act
11 5 (1.72%) Management Information System
11 5 (1.72%) Reference Data
11 5 (1.72%) Tandem
12 4 (1.38%) Contactless
12 4 (1.38%) Data Centre
12 4 (1.38%) EMV
12 4 (1.38%) EPoS
12 4 (1.38%) N-Tier
12 4 (1.38%) Taxonomies
Operating Systems
1 36 (12.41%) Linux
2 30 (10.34%) Windows
3 18 (6.21%) Unix
4 11 (3.79%) Windows Server
5 9 (3.10%) CentOS
6 5 (1.72%) Red Hat Enterprise Linux
7 4 (1.38%) Debian
7 4 (1.38%) Ubuntu
8 3 (1.03%) Oracle Linux
8 3 (1.03%) SUSE
9 2 (0.69%) Solaris
Processes & Methodologies
1 140 (48.28%) Business Intelligence
2 106 (36.55%) ETL
3 97 (33.45%) Agile Software Development
4 77 (26.55%) Data Modelling
5 59 (20.34%) Performance Tuning
6 44 (15.17%) Data Architecture
7 42 (14.48%) TDD
8 41 (14.14%) Analytics
9 34 (11.72%) BDD
9 34 (11.72%) Data Integration
9 34 (11.72%) Migration
9 34 (11.72%) Problem-Solving
9 34 (11.72%) SDLC
10 30 (10.34%) Logical Data Model
11 28 (9.66%) Continuous Integration
11 28 (9.66%) Data Analysis
11 28 (9.66%) Scrum
11 28 (9.66%) Software Delivery
12 27 (9.31%) Physical Data Model
13 24 (8.28%) Data Strategy
Programming Languages
1 224 (77.24%) SQL
2 79 (27.24%) T-SQL
3 69 (23.79%) Java
4 63 (21.72%) C#
5 53 (18.28%) PL/SQL
6 30 (10.34%) PowerShell
7 12 (4.14%) Perl
7 12 (4.14%) Python
8 8 (2.76%) C++
9 7 (2.41%) Bash Shell
10 6 (2.07%) JavaScript
11 5 (1.72%) Korn
12 4 (1.38%) C
12 4 (1.38%) PHP
12 4 (1.38%) Ruby
12 4 (1.38%) VB
13 3 (1.03%) Shell Script
14 2 (0.69%) Scala
14 2 (0.69%) VB6
14 2 (0.69%) VBA
Qualifications
1 36 (12.41%) Degree
2 16 (5.52%) Computer Science Degree
3 5 (1.72%) Microsoft Certification
4 4 (1.38%) MCSE
5 2 (0.69%) MCITP
5 2 (0.69%) RHCE
5 2 (0.69%) RHCSA
5 2 (0.69%) TOGAF Certification
6 1 (0.34%) ISTQB
6 1 (0.34%) Master's Degree
6 1 (0.34%) MCP
Quality Assurance & Compliance
1 11 (3.79%) Data Quality
1 11 (3.79%) GDPR
2 5 (1.72%) PCI DSS
3 4 (1.38%) PSD2
4 1 (0.34%) QA
System Software
1 10 (3.45%) Docker
2 6 (2.07%) Oracle RAC
3 5 (1.72%) Apache Flume
4 3 (1.03%) HDFS
4 3 (1.03%) Virtual Machines
5 2 (0.69%) Apache ZooKeeper
6 1 (0.34%) Microsoft App-V
6 1 (0.34%) VMware Infrastructure
Systems Management
1 10 (3.45%) Puppet
2 7 (2.41%) Ansible
2 7 (2.41%) Opscode Chef
3 6 (2.07%) Data Guard
4 4 (1.38%) Terraform
5 3 (1.03%) HP Quality Center
5 3 (1.03%) Oozie
5 3 (1.03%) Oracle Enterprise Manager
5 3 (1.03%) Salt
6 2 (0.69%) SQL Sentry
7 1 (0.34%) Failover Clustering
7 1 (0.34%) Galera Cluster
7 1 (0.34%) Netcool
7 1 (0.34%) OpenView
7 1 (0.34%) Tivoli
Vendors
1 133 (45.86%) Microsoft
2 87 (30.00%) Oracle
3 30 (10.34%) Tableau
4 19 (6.55%) Informatica
5 13 (4.48%) Siebel
6 12 (4.14%) MicroStrategy
6 12 (4.14%) Netezza
6 12 (4.14%) Talend
7 9 (3.10%) Red Hat
8 7 (2.41%) Cloudera
9 6 (2.07%) Cognos
9 6 (2.07%) IBM
10 4 (1.38%) Apple
10 4 (1.38%) PayPal
10 4 (1.38%) SAP
11 3 (1.03%) Hortonworks
11 3 (1.03%) HP
12 2 (0.69%) CA
12 2 (0.69%) MapR
12 2 (0.69%) Percona