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

Online Transaction Processing (OLTP)
UK
6 months to
26 Sep 2017
Same period 2016 Same period 2015
Rank 927 873 827
Rank change year-on-year -54 -46 -37
Permanent jobs citing OLTP 256 374 495
As % of all permanent IT jobs advertised in the UK 0.14% 0.19% 0.23%
As % of the Database & Business Intelligence category 0.47% 0.65% 0.71%
Number of salaries quoted 172 268 347
UK median annual salary £50,000 £50,000 £52,500
Median salary % change year-on-year - -4.76% +5.00%
10th Percentile £29,000 £32,500 £34,500
90th Percentile £80,000 £77,500 £73,750
UK excluding London median annual salary £42,500 £50,000 £46,250
% change year-on-year -15.00% +8.11% +2.78%

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 54291 57344 69496
As % of all permanent IT jobs advertised in the UK 30.60% 29.75% 31.72%
Number of salaries quoted 44668 48856 58726
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +1.12%
10th Percentile £30,000 £28,750 £27,500
90th Percentile £77,500 £76,000 £73,750
UK excluding London median annual salary £42,500 £41,500 £40,000
% change year-on-year +2.41% +3.75% -

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 26 September 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 26 September 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 -55 251 £50,000 - 8
UK excluding London -51 130 £42,500 -15.00% 4
London -21 122 £60,000 +9.09% 4
Midlands +28 41 £35,250 -9.03%
East of England +33 34 £40,000 -
East Midlands +46 32 £35,250 +5.22%
South East -16 26 £52,500 +5.00% 3
North of England -26 16 £55,000 -13.73%
South West -19 10 £32,500 -35.00% 1
West Midlands +18 9 £52,500 +16.67%
North West -17 9 £50,000 -4.76%
Yorkshire +3 7 £67,500 -15.09%
Scotland -13 3 £42,500 -5.56%

For the 6 months to 26 September 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 198 (77.34%) SQL
2 162 (63.28%) SQL Server
3 143 (55.86%) OLAP
4 120 (46.88%) ETL
5 114 (44.53%) Data Warehouse
6 112 (43.75%) Oracle
7 100 (39.06%) MySQL
8 95 (37.11%) Microsoft
9 87 (33.98%) Business Intelligence
10 85 (33.20%) Performance Tuning
11 80 (31.25%) SQL Server Integration Services
12 73 (28.52%) T-SQL
13 72 (28.13%) SQL Server Analysis Services
14 68 (26.56%) SQL Server Reporting Services
15 66 (25.78%) Java
16 65 (25.39%) PL/SQL
17 62 (24.22%) Oracle Database
18 54 (21.09%) Agile Software Development
18 54 (21.09%) Oracle OLAP
19 52 (20.31%) Finance
20 51 (19.92%) Linux
21 50 (19.53%) Degree
22 45 (17.58%) C#
22 45 (17.58%) ETL Development
23 43 (16.80%) Kimball Methodology
23 43 (16.80%) DB2
24 40 (15.63%) .NET
24 40 (15.63%) Dimensional Modelling
24 40 (15.63%) Analytical Skills
25 39 (15.23%) SQL Server 2008

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 16 (6.25%) Elasticsearch
2 8 (3.13%) Apache Spark
3 5 (1.95%) Apache
4 2 (0.78%) Cloud Foundry
4 2 (0.78%) GemFire
4 2 (0.78%) SharePoint
4 2 (0.78%) Tomcat
5 1 (0.39%) OpenStack
5 1 (0.39%) Oracle SOA Suite
5 1 (0.39%) SharePoint 2013
5 1 (0.39%) WebLogic
Applications
1 12 (4.69%) Microsoft Excel
1 12 (4.69%) MS Visio
2 2 (0.78%) Microsoft PowerPoint
3 1 (0.39%) S-PLUS
Business Applications
1 2 (0.78%) Dynamics CRM
1 2 (0.78%) SAP CO
1 2 (0.78%) SAP FI
1 2 (0.78%) SAP FI/CO
1 2 (0.78%) SAP FSCM
1 2 (0.78%) SAP MM
1 2 (0.78%) SAP PS
1 2 (0.78%) SAP SD
2 1 (0.39%) Cognos Business Intelligence
2 1 (0.39%) Oracle Applications
Cloud Services
1 39 (15.23%) Amazon AWS
2 33 (12.89%) Microsoft Azure
3 12 (4.69%) GitHub
4 5 (1.95%) Google Cloud Platform
5 2 (0.78%) PaaS
5 2 (0.78%) Slack
6 1 (0.39%) Amazon EMR
6 1 (0.39%) Amazon S3
6 1 (0.39%) Data Lake Analytics
6 1 (0.39%) Datadog
6 1 (0.39%) IaaS
6 1 (0.39%) Office 365
6 1 (0.39%) SaaS
Communications & Networking
1 17 (6.64%) Wireless
2 9 (3.52%) SAN
3 6 (2.34%) Extranet
3 6 (2.34%) Intranet
4 4 (1.56%) Fibre Channel
5 3 (1.17%) DNS
5 3 (1.17%) Firewall
6 2 (0.78%) HTTP
6 2 (0.78%) Internet
7 1 (0.39%) NAS
Database & Business Intelligence
1 162 (63.28%) SQL Server
2 143 (55.86%) OLAP
3 114 (44.53%) Data Warehouse
4 100 (39.06%) MySQL
5 80 (31.25%) SQL Server Integration Services
6 72 (28.13%) SQL Server Analysis Services
7 68 (26.56%) SQL Server Reporting Services
8 62 (24.22%) Oracle Database
9 54 (21.09%) Oracle OLAP
10 43 (16.80%) DB2
11 39 (15.23%) SQL Server 2008
12 38 (14.84%) MongoDB
13 35 (13.67%) NoSQL
13 35 (13.67%) Relational Database
14 30 (11.72%) Oracle ODI
15 28 (10.94%) SQL Server 2014
16 26 (10.16%) OLAP Cube
17 22 (8.59%) Apache Cassandra
17 22 (8.59%) SQL Server 2016
18 21 (8.20%) SQL Server 2012
Development Applications
1 20 (7.81%) Team Foundation Server
2 19 (7.42%) JIRA
3 18 (7.03%) Git (software)
4 17 (6.64%) Jenkins
4 17 (6.64%) Oracle Forms
5 11 (4.30%) SQL Server Management Studio (SSMS)
6 8 (3.13%) tSQLt
6 8 (3.13%) Visual Studio
7 7 (2.73%) Octopus Deploy
8 2 (0.78%) Eclipse
8 2 (0.78%) Gradle
8 2 (0.78%) JUnit
9 1 (0.39%) Talend Open Studio
9 1 (0.39%) TeamCity
General
1 52 (20.31%) Finance
2 25 (9.77%) Advertising
2 25 (9.77%) Retail
3 21 (8.20%) Banking
4 16 (6.25%) Pharmaceutical
5 11 (4.30%) Investment Banking
6 4 (1.56%) Law
7 3 (1.17%) Retail Banking
8 1 (0.39%) International Banking
8 1 (0.39%) Legal
Job Titles
1 120 (46.88%) Developer
2 48 (18.75%) SQL Developer
3 42 (16.41%) DBA
4 32 (12.50%) Oracle Developer
5 31 (12.11%) Business Intelligence Developer
6 30 (11.72%) Analyst
6 30 (11.72%) SQL DBA
7 26 (10.16%) Administrator
7 26 (10.16%) SQL Server DBA
8 23 (8.98%) Data Warehouse Developer
9 22 (8.59%) Oracle Data Warehouse Developer
10 19 (7.42%) Architect
11 17 (6.64%) ETL Developer
11 17 (6.64%) SQL Analyst
11 17 (6.64%) SQL BI Developer
12 16 (6.25%) C# Developer
13 13 (5.08%) Business Intelligence Analyst
14 12 (4.69%) C# Software Developer
14 12 (4.69%) SSIS Developer
15 11 (4.30%) MySQL DBA
Libraries, Frameworks & Software Standards
1 40 (15.63%) .NET
2 36 (14.06%) Web Services
3 30 (11.72%) Oracle GoldenGate
4 28 (10.94%) XML
5 21 (8.20%) ASP.NET
5 21 (8.20%) ASP.NET MVC
6 20 (7.81%) HTML
6 20 (7.81%) MDX
7 19 (7.42%) WinForms
8 16 (6.25%) COM
9 12 (4.69%) STL
10 9 (3.52%) WPF
11 8 (3.13%) AngularJS
12 6 (2.34%) RESTful
13 5 (1.95%) JSON
13 5 (1.95%) Kafka
14 3 (1.17%) Java EE
14 3 (1.17%) Middleware
14 3 (1.17%) Velocity
15 2 (0.78%) Spring
Miscellaneous
1 40 (15.63%) Analytical Skills
2 35 (13.67%) Computer Science
3 33 (12.89%) Replication
4 17 (6.64%) Fintech
4 17 (6.64%) PDA
5 9 (3.52%) Foreign Exchange (FX)
6 8 (3.13%) Life Science
7 5 (1.95%) Clustering
8 4 (1.56%) EMC VMAX
8 4 (1.56%) Linux Command Line
9 3 (1.17%) Data Protection Act
10 2 (0.78%) Data Centre
10 2 (0.78%) Derivative
10 2 (0.78%) HACMP
10 2 (0.78%) Mainframe
10 2 (0.78%) N-Tier
10 2 (0.78%) OTC Derivatives
10 2 (0.78%) Public Cloud
10 2 (0.78%) Reference Data
10 2 (0.78%) Virtual Team
Operating Systems
1 51 (19.92%) Linux
2 34 (13.28%) Unix
3 30 (11.72%) Windows
4 11 (4.30%) Red Hat Enterprise Linux
5 8 (3.13%) Solaris
6 4 (1.56%) Ubuntu
7 2 (0.78%) AIX
7 2 (0.78%) Windows Server
8 1 (0.39%) Windows 7
8 1 (0.39%) Windows Server 2008
Processes & Methodologies
1 120 (46.88%) ETL
2 87 (33.98%) Business Intelligence
3 85 (33.20%) Performance Tuning
4 54 (21.09%) Agile Software Development
5 45 (17.58%) ETL Development
6 43 (16.80%) Kimball Methodology
7 40 (15.63%) Dimensional Modelling
8 39 (15.23%) ITIL
9 36 (14.06%) Data Modelling
10 30 (11.72%) Data Transformation
11 29 (11.33%) Disaster Recovery
12 26 (10.16%) Software Engineering
13 24 (9.38%) Database Tuning
14 23 (8.98%) E-Commerce
15 21 (8.20%) MVC
15 21 (8.20%) Scrum
16 20 (7.81%) Continuous Improvement
16 20 (7.81%) High Availability
17 17 (6.64%) Kanban
17 17 (6.64%) UML
Programming Languages
1 198 (77.34%) SQL
2 73 (28.52%) T-SQL
3 66 (25.78%) Java
4 65 (25.39%) PL/SQL
5 45 (17.58%) C#
6 21 (8.20%) C++
7 19 (7.42%) JavaScript
7 19 (7.42%) PowerShell
8 16 (6.25%) VB
8 16 (6.25%) VB6
9 11 (4.30%) Python
10 8 (3.13%) Data Analysis Expressions (DAX)
10 8 (3.13%) VB.NET
10 8 (3.13%) VBScript
11 6 (2.34%) Shell Script
12 3 (1.17%) C
12 3 (1.17%) PHP
13 2 (0.78%) ABAP
13 2 (0.78%) Bash Shell
14 1 (0.39%) R
Qualifications
1 50 (19.53%) Degree
2 20 (7.81%) Computer Science Degree
3 16 (6.25%) Microsoft Certification
4 10 (3.91%) Oracle Certification
5 7 (2.73%) MCITP
5 7 (2.73%) MCSE
6 2 (0.78%) Linux+ Certification
7 1 (0.39%) OCP
Quality Assurance & Compliance
1 23 (8.98%) QA
2 18 (7.03%) Data Quality
3 3 (1.17%) GDPR
4 2 (0.78%) PMO
4 2 (0.78%) SLA
5 1 (0.39%) PCI DSS
5 1 (0.39%) Sarbanes-Oxley
System Software
1 12 (4.69%) Oracle RAC
2 4 (1.56%) GlusterFS
2 4 (1.56%) Veritas Cluster Server
2 4 (1.56%) Virtual Machines
2 4 (1.56%) VMware Infrastructure
3 3 (1.17%) Apache Flume
3 3 (1.17%) HDFS
4 2 (0.78%) Active Directory
4 2 (0.78%) Apache ZooKeeper
4 2 (0.78%) GPFS
5 1 (0.39%) Docker
5 1 (0.39%) KVM
5 1 (0.39%) Microsoft App-V
Systems Management
1 18 (7.03%) Ansible
2 10 (3.91%) Perfmon
3 7 (2.73%) NetBackup
3 7 (2.73%) Red Hat Satellite
4 5 (1.95%) Microsoft Clustering
5 4 (1.56%) Failover Clustering
5 4 (1.56%) Oracle ZFS
5 4 (1.56%) Veritas Storage Foundation
6 2 (0.78%) Oracle Enterprise Manager
6 2 (0.78%) Oracle RMAN
7 1 (0.39%) Cobbler
7 1 (0.39%) Hadoop YARN
7 1 (0.39%) Kibana
7 1 (0.39%) Kubernetes
7 1 (0.39%) Nagios
7 1 (0.39%) OpenView
7 1 (0.39%) Opscode Chef
7 1 (0.39%) Rundeck
7 1 (0.39%) Systems Management Server (SMS)
7 1 (0.39%) Tivoli
Vendors
1 112 (43.75%) Oracle
2 95 (37.11%) Microsoft
3 15 (5.86%) RedGate
4 10 (3.91%) Red Hat
5 8 (3.13%) Tableau
6 7 (2.73%) Veritas
7 5 (1.95%) Brocade
7 5 (1.95%) Google
7 5 (1.95%) Sun
8 4 (1.56%) EMC
8 4 (1.56%) StorageTek
8 4 (1.56%) VMware
9 3 (1.17%) Cognos
9 3 (1.17%) NetApp
10 2 (0.78%) Cloudera
10 2 (0.78%) IBM
10 2 (0.78%) Intel
10 2 (0.78%) SAP
10 2 (0.78%) Sybase
11 1 (0.39%) Dynatrace