Period
to 24 November 2017

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 24 November 2017 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 948 849 836
Rank change year-on-year -99 -13 -48
Permanent jobs citing OLTP 263 380 509
As % of all permanent IT jobs advertised in the UK 0.15% 0.20% 0.23%
As % of the Database & Business Intelligence category 0.48% 0.68% 0.74%
Number of salaries quoted 197 273 349
UK median annual salary £50,000 £50,000 £54,500
Median salary % change year-on-year - -8.26% +9.00%
10th Percentile £31,250 £33,250 £35,000
90th Percentile £81,750 £71,050 £75,250
UK excluding London median annual salary £45,000 £50,000 £50,000
% change year-on-year -10.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 54460 56137 68974
As % of all permanent IT jobs advertised in the UK 30.23% 29.67% 31.53%
Number of salaries quoted 44807 47978 58120
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £29,000 £28,250
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

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 24 November 2017.

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 24 November 2017. 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 -53 257 £50,000 - 15
UK excluding London -52 136 £45,000 -10.00% 5
London -12 124 £60,000 +4.35% 10
Midlands +43 49 £50,000 +33.33% 2
East Midlands +39 38 £50,000 +42.86%
East of England +13 30 £40,000 -20.00% 1
South East -17 29 £45,000 -14.29%
North of England +4 15 £55,000 +4.76% 1
West Midlands +19 11 £37,500 -25.00% 2
South West +3 9 £32,500 -35.00% 1
North West -28 8 £50,000 -4.76% 1
Yorkshire +22 7 £67,500 -15.63%
Scotland -17 4 £42,500 -6.59%

For the 6 months to 24 November 2017, IT jobs citing OLTP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for OLTP.

1 196 (74.52%) SQL
2 167 (63.50%) SQL Server
3 132 (50.19%) OLAP
4 111 (42.21%) Data Warehouse
4 111 (42.21%) ETL
5 110 (41.83%) Microsoft
6 109 (41.44%) Oracle
7 90 (34.22%) Business Intelligence
8 85 (32.32%) Performance Tuning
9 84 (31.94%) MySQL
9 84 (31.94%) SQL Server Integration Services
10 83 (31.56%) T-SQL
11 75 (28.52%) SQL Server Reporting Services
12 73 (27.76%) SQL Server Analysis Services
13 69 (26.24%) Agile Software Development
14 67 (25.48%) Java
15 65 (24.71%) Finance
16 61 (23.19%) Oracle Database
17 57 (21.67%) PL/SQL
18 55 (20.91%) C#
19 52 (19.77%) Linux
20 50 (19.01%) .NET
21 49 (18.63%) Oracle OLAP
22 46 (17.49%) Degree
22 46 (17.49%) MongoDB
23 44 (16.73%) NoSQL
23 44 (16.73%) Amazon AWS
23 44 (16.73%) Kimball Methodology
24 41 (15.59%) Microsoft Azure
25 40 (15.21%) Web Services

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 24 (9.13%) Elasticsearch
2 7 (2.66%) Apache Spark
3 5 (1.90%) SharePoint
4 4 (1.52%) Apache
4 4 (1.52%) SharePoint 2013
5 1 (0.38%) Oracle SOA Suite
5 1 (0.38%) Tomcat
5 1 (0.38%) WebLogic
Applications
1 13 (4.94%) MS Visio
2 11 (4.18%) Microsoft Excel
3 4 (1.52%) Microsoft PowerPoint
4 1 (0.38%) S-PLUS
Business Applications
1 2 (0.76%) Dynamics CRM
2 1 (0.38%) Oracle Applications
2 1 (0.38%) Remedy ITSM
Cloud Services
1 44 (16.73%) Amazon AWS
2 41 (15.59%) Microsoft Azure
3 9 (3.42%) GitHub
4 2 (0.76%) Amazon EMR
4 2 (0.76%) Amazon S3
4 2 (0.76%) Google Cloud Platform
5 1 (0.38%) Office 365
5 1 (0.38%) Slack
Communications & Networking
1 21 (7.98%) Wireless
2 8 (3.04%) SAN
3 6 (2.28%) Extranet
3 6 (2.28%) Intranet
4 5 (1.90%) DNS
4 5 (1.90%) Firewall
5 4 (1.52%) HTTP
5 4 (1.52%) Internet
6 2 (0.76%) Fibre Channel
6 2 (0.76%) MPLS
6 2 (0.76%) NAS
6 2 (0.76%) SMS
6 2 (0.76%) VPLS
Database & Business Intelligence
1 167 (63.50%) SQL Server
2 132 (50.19%) OLAP
3 111 (42.21%) Data Warehouse
4 84 (31.94%) MySQL
4 84 (31.94%) SQL Server Integration Services
5 75 (28.52%) SQL Server Reporting Services
6 73 (27.76%) SQL Server Analysis Services
7 61 (23.19%) Oracle Database
8 49 (18.63%) Oracle OLAP
9 46 (17.49%) MongoDB
10 44 (16.73%) NoSQL
11 36 (13.69%) Relational Database
12 35 (13.31%) SQL Server 2008
13 34 (12.93%) DB2
14 31 (11.79%) Apache Cassandra
14 31 (11.79%) SQL Server 2014
15 27 (10.27%) Oracle ODI
16 26 (9.89%) Power BI
17 25 (9.51%) SQL Server 2016
18 22 (8.37%) OLAP Cube
Development Applications
1 25 (9.51%) Team Foundation Server
2 21 (7.98%) Oracle Forms
3 17 (6.46%) Git (software)
3 17 (6.46%) Jenkins
4 15 (5.70%) SQL Server Management Studio (SSMS)
5 13 (4.94%) JIRA
6 8 (3.04%) tSQLt
6 8 (3.04%) Visual Studio
7 7 (2.66%) Octopus Deploy
8 2 (0.76%) Talend Open Studio
9 1 (0.38%) ERwin
9 1 (0.38%) TeamCity
General
1 65 (24.71%) Finance
2 33 (12.55%) Advertising
3 32 (12.17%) Banking
4 23 (8.75%) Pharmaceutical
5 21 (7.98%) Retail
6 14 (5.32%) Retail Banking
7 11 (4.18%) Investment Banking
8 4 (1.52%) Law
9 2 (0.76%) Retail Finance
9 2 (0.76%) Telecoms
10 1 (0.38%) Electronics
10 1 (0.38%) General Ledger
10 1 (0.38%) International Banking
10 1 (0.38%) Legal
Job Titles
1 124 (47.15%) Developer
2 51 (19.39%) DBA
3 50 (19.01%) SQL Developer
4 36 (13.69%) SQL DBA
5 29 (11.03%) Oracle Developer
6 26 (9.89%) Business Intelligence Developer
6 26 (9.89%) SQL Server DBA
7 23 (8.75%) Administrator
7 23 (8.75%) Architect
7 23 (8.75%) Data Warehouse Developer
7 23 (8.75%) Oracle Data Warehouse Developer
8 21 (7.98%) C# Developer
9 19 (7.22%) Analyst
10 17 (6.46%) C# Software Developer
11 15 (5.70%) ETL Developer
12 13 (4.94%) SQL BI Developer
13 12 (4.56%) Solutions Architect
13 12 (4.56%) SQL Server Developer
14 11 (4.18%) Junior
14 11 (4.18%) MySQL DBA
Libraries, Frameworks & Software Standards
1 50 (19.01%) .NET
2 40 (15.21%) Web Services
3 33 (12.55%) XML
4 31 (11.79%) Oracle GoldenGate
5 28 (10.65%) ASP.NET
6 25 (9.51%) ASP.NET MVC
7 23 (8.75%) WinForms
8 19 (7.22%) COM
9 18 (6.84%) MDX
10 17 (6.46%) WPF
11 16 (6.08%) HTML
12 9 (3.42%) JSON
13 7 (2.66%) AngularJS
13 7 (2.66%) STL
14 6 (2.28%) RESTful
15 4 (1.52%) Kafka
16 3 (1.14%) Velocity
17 2 (0.76%) ASP.NET Web API
17 2 (0.76%) WCF
18 1 (0.38%) D3.js
Miscellaneous
1 38 (14.45%) Replication
2 36 (13.69%) Computer Science
3 27 (10.27%) Analytical Skills
4 21 (7.98%) PDA
5 14 (5.32%) Fintech
6 13 (4.94%) Life Science
7 8 (3.04%) Clustering
8 6 (2.28%) Foreign Exchange (FX)
9 5 (1.90%) N-Tier
10 4 (1.52%) Data Centre
10 4 (1.52%) HACMP
10 4 (1.52%) Mainframe
11 3 (1.14%) Data Protection Act
12 2 (0.76%) Data Structures
12 2 (0.76%) Derivative
12 2 (0.76%) EMC VMAX
12 2 (0.76%) Linux Command Line
12 2 (0.76%) OTC Derivatives
12 2 (0.76%) Reference Data
13 1 (0.38%) Mobile Payment
Operating Systems
1 52 (19.77%) Linux
2 38 (14.45%) Windows
3 35 (13.31%) Unix
4 9 (3.42%) Red Hat Enterprise Linux
4 9 (3.42%) Solaris
5 4 (1.52%) AIX
5 4 (1.52%) Ubuntu
5 4 (1.52%) Windows Server
6 1 (0.38%) Windows 7
6 1 (0.38%) Windows Server 2008
Processes & Methodologies
1 111 (42.21%) ETL
2 90 (34.22%) Business Intelligence
3 85 (32.32%) Performance Tuning
4 69 (26.24%) Agile Software Development
5 44 (16.73%) Kimball Methodology
6 39 (14.83%) ETL Development
7 36 (13.69%) Data Modelling
7 36 (13.69%) Dimensional Modelling
8 34 (12.93%) Software Engineering
9 30 (11.41%) Database Tuning
10 28 (10.65%) Data Transformation
11 27 (10.27%) Disaster Recovery
12 26 (9.89%) ITIL
13 25 (9.51%) High Availability
13 25 (9.51%) MVC
14 24 (9.13%) Scrum
15 22 (8.37%) E-Commerce
16 18 (6.84%) Continuous Improvement
16 18 (6.84%) DevOps
16 18 (6.84%) Machine Learning
Programming Languages
1 196 (74.52%) SQL
2 83 (31.56%) T-SQL
3 67 (25.48%) Java
4 57 (21.67%) PL/SQL
5 55 (20.91%) C#
6 25 (9.51%) JavaScript
7 21 (7.98%) PowerShell
8 20 (7.60%) C++
9 19 (7.22%) VB
9 19 (7.22%) VB6
10 12 (4.56%) Python
11 10 (3.80%) Shell Script
12 8 (3.04%) Data Analysis Expressions (DAX)
13 5 (1.90%) VB.NET
13 5 (1.90%) VBScript
14 3 (1.14%) Bash Shell
14 3 (1.14%) C
14 3 (1.14%) PHP
15 2 (0.76%) VBA
16 1 (0.38%) Perl
Qualifications
1 46 (17.49%) Degree
2 27 (10.27%) Computer Science Degree
3 12 (4.56%) Microsoft Certification
4 7 (2.66%) MCITP
4 7 (2.66%) MCSE
4 7 (2.66%) Oracle Certification
5 2 (0.76%) Linux+ Certification
6 1 (0.38%) OCP
6 1 (0.38%) PhD
Quality Assurance & Compliance
1 15 (5.70%) QA
2 13 (4.94%) Data Quality
3 4 (1.52%) GDPR
3 4 (1.52%) PMO
4 2 (0.76%) SLA
System Software
1 13 (4.94%) Oracle RAC
2 5 (1.90%) VMware Infrastructure
3 4 (1.52%) Apache Flume
3 4 (1.52%) GPFS
3 4 (1.52%) Virtual Machines
4 2 (0.76%) Active Directory
4 2 (0.76%) Docker
4 2 (0.76%) GlusterFS
4 2 (0.76%) HDFS
4 2 (0.76%) Veritas Cluster Server
5 1 (0.38%) Microsoft App-V
Systems Management
1 19 (7.22%) Ansible
2 10 (3.80%) Perfmon
3 5 (1.90%) Microsoft Clustering
3 5 (1.90%) NetBackup
3 5 (1.90%) Red Hat Satellite
4 4 (1.52%) Failover Clustering
5 2 (0.76%) Hadoop YARN
5 2 (0.76%) Kubernetes
5 2 (0.76%) Oracle Enterprise Manager
5 2 (0.76%) Oracle RMAN
5 2 (0.76%) Oracle ZFS
5 2 (0.76%) Systems Management Server (SMS)
5 2 (0.76%) Veritas Storage Foundation
6 1 (0.38%) Netcool
6 1 (0.38%) OpenView
6 1 (0.38%) Opscode Chef
6 1 (0.38%) SCCM
6 1 (0.38%) Tivoli
Vendors
1 110 (41.83%) Microsoft
2 109 (41.44%) Oracle
3 15 (5.70%) RedGate
4 8 (3.04%) Tableau
5 6 (2.28%) NetApp
5 6 (2.28%) Red Hat
6 5 (1.90%) Veritas
6 5 (1.90%) VMware
7 4 (1.52%) Intel
7 4 (1.52%) Sun
8 3 (1.14%) EMC
8 3 (1.14%) EXASOL
9 2 (0.76%) Cloudera
9 2 (0.76%) Google
9 2 (0.76%) IBM
9 2 (0.76%) Informatica
9 2 (0.76%) StorageTek
9 2 (0.76%) Talend
9 2 (0.76%) Teradata
9 2 (0.76%) TSYS