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

Online Transaction Processing (OLTP)
UK
6 months to
22 Sep 2018
Same period 2017 Same period 2016
Rank 891 940 883
Rank change year-on-year +49 -57 -23
Permanent jobs citing OLTP 266 252 377
As % of all permanent IT jobs advertised in the UK 0.16% 0.14% 0.19%
As % of the Database & Business Intelligence category 0.54% 0.47% 0.65%
Number of salaries quoted 213 171 271
UK median annual salary £52,500 £50,000 £50,000
Median salary % change year-on-year +5.00% - -4.76%
10th Percentile £33,750 £31,250 £32,500
90th Percentile £76,000 £80,000 £77,500
UK excluding London median annual salary £47,500 £42,500 £50,000
% change year-on-year +11.76% -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 49,463 54,014 57,723
As % of all permanent IT jobs advertised in the UK 29.71% 30.57% 29.76%
Number of salaries quoted 40,346 44,477 49,194
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £82,500 £77,500 £75,250
UK excluding London median annual salary £45,000 £42,500 £41,500
% change year-on-year +5.88% +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 22 September 2018.

Salary histogram for OLTP in the UK

OLTP
Top 12 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 September 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 +32 234 £55,000 +10.00% 25
UK excluding London +48 158 £47,500 +11.76% 11
London +22 105 £62,500 +4.17% 14
North of England +51 40 £52,500 -4.55% 1
North West +42 40 £52,500 +5.00% 1
South East +26 36 £47,500 -9.52% 6
Scotland +26 31 £37,500 -
East of England +3 25 £66,000 +65.00%
Midlands +12 20 £48,000 +36.17% 4
East Midlands -14 13 £57,500 +63.12% 3
West Midlands +33 7 £40,000 -23.81% 1
South West +11 6 £47,750 +46.92%

For the 6 months to 22 September 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 216 (81.20%) SQL
2 137 (51.50%) SQL Server
3 126 (47.37%) Data Warehouse
4 123 (46.24%) SQL Server Integration Services
5 111 (41.73%) Microsoft
6 98 (36.84%) Business Intelligence
7 95 (35.71%) OLAP
8 92 (34.59%) Agile Software Development
9 90 (33.83%) Oracle
10 86 (32.33%) SQL Server Reporting Services
11 79 (29.70%) T-SQL
12 77 (28.95%) ETL
13 74 (27.82%) Performance Tuning
14 63 (23.68%) Java
15 62 (23.31%) Data Modelling
16 61 (22.93%) PL/SQL
17 60 (22.56%) Relational Database
18 58 (21.80%) SQL Server Analysis Services
19 53 (19.92%) Degree
20 50 (18.80%) Finance
21 49 (18.42%) Big Data
22 47 (17.67%) SQL Server 2012
23 46 (17.29%) ITIL
24 45 (16.92%) MongoDB
25 42 (15.79%) SQL Server 2014
26 41 (15.41%) Power BI
26 41 (15.41%) NoSQL
26 41 (15.41%) TDD
27 40 (15.04%) MySQL
28 38 (14.29%) Oracle OLAP

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 28 (10.53%) Apache Spark
2 9 (3.38%) SAS
3 8 (3.01%) Apache
3 8 (3.01%) Oracle Application Server
4 5 (1.88%) Apache Pig
5 2 (0.75%) Cloud Foundry
5 2 (0.75%) GemFire
5 2 (0.75%) Tomcat
6 1 (0.38%) IIS
6 1 (0.38%) OpenStack
6 1 (0.38%) Oracle Workflow
6 1 (0.38%) WebLogic
Applications
1 16 (6.02%) MS Visio
2 10 (3.76%) Microsoft Excel
3 3 (1.13%) Microsoft Office
3 3 (1.13%) Microsoft PowerPoint
4 1 (0.38%) Spreadsheet
Business Applications
1 6 (2.26%) Oracle EBS
1 6 (2.26%) Oracle Retail
2 2 (0.75%) SAP Business One
Cloud Services
1 37 (13.91%) Microsoft Azure
2 16 (6.02%) Amazon AWS
3 8 (3.01%) PaaS
4 4 (1.50%) Azure Data Factory
4 4 (1.50%) GitHub
4 4 (1.50%) IaaS
4 4 (1.50%) SaaS
5 2 (0.75%) Amazon S3
6 1 (0.38%) Data Lake Analytics
6 1 (0.38%) Office 365
Communications & Networking
1 9 (3.38%) SAN
2 6 (2.26%) DNS
3 5 (1.88%) Firewall
3 5 (1.88%) HTTP
3 5 (1.88%) Internet
4 2 (0.75%) SMS
5 1 (0.38%) MPLS
5 1 (0.38%) VPLS
Database & Business Intelligence
1 137 (51.50%) SQL Server
2 126 (47.37%) Data Warehouse
3 123 (46.24%) SQL Server Integration Services
4 95 (35.71%) OLAP
5 86 (32.33%) SQL Server Reporting Services
6 60 (22.56%) Relational Database
7 58 (21.80%) SQL Server Analysis Services
8 49 (18.42%) Big Data
9 47 (17.67%) SQL Server 2012
10 45 (16.92%) MongoDB
11 42 (15.79%) SQL Server 2014
12 41 (15.41%) NoSQL
12 41 (15.41%) Power BI
13 40 (15.04%) MySQL
14 38 (14.29%) Hadoop
14 38 (14.29%) Oracle OLAP
15 34 (12.78%) Oracle Database
16 30 (11.28%) SQL Server 2008
17 26 (9.77%) Apache Hive
18 24 (9.02%) Impala
Development Applications
1 18 (6.77%) ERwin
1 18 (6.77%) Visual Studio
2 12 (4.51%) Git (software)
2 12 (4.51%) Gradle
2 12 (4.51%) Team Foundation Server
3 11 (4.14%) SQL Server Management Studio (SSMS)
4 10 (3.76%) Cucumber
5 9 (3.38%) JIRA
6 6 (2.26%) Oracle APEX
6 6 (2.26%) PVCS
6 6 (2.26%) Toad
7 4 (1.50%) Visual Studio Team System
8 3 (1.13%) ER Studio
8 3 (1.13%) Jenkins
9 2 (0.75%) Eclipse
9 2 (0.75%) JUnit
10 1 (0.38%) Subversion
10 1 (0.38%) TestRail
General
1 50 (18.80%) Finance
2 21 (7.89%) Advertising
3 16 (6.02%) Banking
3 16 (6.02%) Games
4 14 (5.26%) Retail Banking
5 9 (3.38%) Retail
6 6 (2.26%) Publishing
7 5 (1.88%) Back Office
7 5 (1.88%) Corporate Banking
7 5 (1.88%) Financial Institution
8 4 (1.50%) Marketing
9 3 (1.13%) Front Office
9 3 (1.13%) Investment Banking
10 1 (0.38%) Automotive
10 1 (0.38%) International Banking
10 1 (0.38%) Pharmaceutical
10 1 (0.38%) Retail Finance
Job Titles
1 109 (40.98%) Developer
2 57 (21.43%) DBA
3 48 (18.05%) Architect
4 39 (14.66%) Data Architect
4 39 (14.66%) SQL DBA
5 33 (12.41%) Administrator
6 24 (9.02%) Software Developer
7 23 (8.65%) Data Warehouse Developer
8 21 (7.89%) Business Intelligence Architect
9 19 (7.14%) Oracle Developer
10 14 (5.26%) Business Intelligence Developer
10 14 (5.26%) Oracle Data Warehouse Developer
10 14 (5.26%) SQL Developer
11 13 (4.89%) Analyst
11 13 (4.89%) Senior Developer
11 13 (4.89%) Software Engineer
12 12 (4.51%) Data Engineer
13 11 (4.14%) SSIS Developer
14 10 (3.76%) Solutions Architect
14 10 (3.76%) SSRS Developer
Libraries, Frameworks & Software Standards
1 33 (12.41%) Web Services
2 29 (10.90%) .NET
3 27 (10.15%) XML
4 24 (9.02%) JSON
5 20 (7.52%) WPF
6 19 (7.14%) Kafka
7 14 (5.26%) Oracle GoldenGate
8 13 (4.89%) Spring Boot
9 10 (3.76%) RESTful
10 7 (2.63%) Spark Streaming
11 6 (2.26%) RabbitMQ
12 5 (1.88%) MDX
13 3 (1.13%) Middleware
14 2 (0.75%) J2EE
14 2 (0.75%) Spring
14 2 (0.75%) Spring Batch
14 2 (0.75%) Spring Integration
15 1 (0.38%) ASP.NET
15 1 (0.38%) LDAP
15 1 (0.38%) REST
Miscellaneous
1 32 (12.03%) User Experience
2 22 (8.27%) Analytical Skills
3 20 (7.52%) Replication
4 15 (5.64%) Clustering
5 14 (5.26%) Computer Science
6 11 (4.14%) Hybrid Cloud
7 10 (3.76%) Data Centre
7 10 (3.76%) Greenfield Project
8 8 (3.01%) Reference Data
9 7 (2.63%) Data Structures
9 7 (2.63%) Enterprise Software
9 7 (2.63%) Tandem
10 6 (2.26%) N-Tier
11 5 (1.88%) Fintech
11 5 (1.88%) Mainframe
12 4 (1.50%) Management Information System
12 4 (1.50%) Online Games
13 3 (1.13%) Data Protection Act
13 3 (1.13%) Grid Computing
13 3 (1.13%) HACMP
Operating Systems
1 38 (14.29%) Linux
2 26 (9.77%) Unix
3 23 (8.65%) Windows
4 15 (5.64%) Windows Server
5 8 (3.01%) Red Hat Enterprise Linux
6 4 (1.50%) Solaris
7 3 (1.13%) AIX
7 3 (1.13%) Oracle Linux
7 3 (1.13%) SUSE
8 2 (0.75%) CentOS
9 1 (0.38%) Debian
Processes & Methodologies
1 98 (36.84%) Business Intelligence
2 92 (34.59%) Agile Software Development
3 77 (28.95%) ETL
4 74 (27.82%) Performance Tuning
5 62 (23.31%) Data Modelling
6 46 (17.29%) ITIL
7 41 (15.41%) TDD
8 33 (12.41%) BDD
8 33 (12.41%) Problem-Solving
9 30 (11.28%) Analytics
9 30 (11.28%) Data Architecture
9 30 (11.28%) Scrum
10 29 (10.90%) Data Integration
11 28 (10.53%) Continuous Integration
11 28 (10.53%) Data Management
11 28 (10.53%) Dimensional Modelling
11 28 (10.53%) SDLC
12 27 (10.15%) Data Analysis
12 27 (10.15%) IT Strategy
13 25 (9.40%) Server Building
Programming Languages
1 216 (81.20%) SQL
2 79 (29.70%) T-SQL
3 63 (23.68%) Java
4 61 (22.93%) PL/SQL
5 28 (10.53%) C#
6 12 (4.51%) Python
7 10 (3.76%) Shell Script
8 8 (3.01%) PowerShell
9 5 (1.88%) Scala
10 4 (1.50%) Bash Shell
10 4 (1.50%) Perl
11 1 (0.38%) Data Analysis Expressions (DAX)
11 1 (0.38%) Java 8
11 1 (0.38%) Korn
Qualifications
1 53 (19.92%) Degree
2 30 (11.28%) Microsoft Certification
3 5 (1.88%) MCSE
4 4 (1.50%) Computer Science Degree
5 3 (1.13%) MCITP
5 3 (1.13%) RHCE
5 3 (1.13%) RHCSA
6 1 (0.38%) ISTQB
6 1 (0.38%) MCP
6 1 (0.38%) TOGAF Certification
Quality Assurance & Compliance
1 8 (3.01%) QA
2 6 (2.26%) Data Quality
3 4 (1.50%) PMO
4 3 (1.13%) GDPR
5 1 (0.38%) PCI DSS
System Software
1 12 (4.51%) Docker
2 9 (3.38%) HDFS
3 8 (3.01%) Apache Flume
4 7 (2.63%) Apache ZooKeeper
4 7 (2.63%) Oracle RAC
5 5 (1.88%) VMware Infrastructure
6 4 (1.50%) Virtual Machines
7 3 (1.13%) GPFS
8 1 (0.38%) Microsoft App-V
Systems Management
1 8 (3.01%) Data Guard
2 4 (1.50%) Terraform
3 3 (1.13%) HP Quality Center
3 3 (1.13%) Oozie
3 3 (1.13%) Oracle Enterprise Manager
4 2 (0.75%) Ansible
4 2 (0.75%) Consul
4 2 (0.75%) Kubernetes
4 2 (0.75%) Puppet
4 2 (0.75%) SQL Sentry
5 1 (0.38%) Nagios
5 1 (0.38%) OpenView
5 1 (0.38%) Opscode Chef
5 1 (0.38%) Tivoli
Vendors
1 111 (41.73%) Microsoft
2 90 (33.83%) Oracle
3 30 (11.28%) Tableau
4 13 (4.89%) Informatica
5 12 (4.51%) SAP
5 12 (4.51%) Siebel
6 11 (4.14%) MicroStrategy
6 11 (4.14%) Netezza
6 11 (4.14%) Talend
7 10 (3.76%) Cloudera
8 6 (2.26%) Hortonworks
8 6 (2.26%) Red Hat
9 5 (1.88%) EXASOL
9 5 (1.88%) IBM
9 5 (1.88%) Intel
9 5 (1.88%) MapR
9 5 (1.88%) Teradata
9 5 (1.88%) VMware
10 4 (1.50%) Cognos
11 3 (1.13%) NetApp