Period
to 22 June 2018

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

Online Transaction Processing (OLTP)
UK > England
6 months to
22 Jun 2018
Same period 2017 Same period 2016
Rank 897 935 918
Rank change year-on-year +38 -17 -4
Permanent jobs citing OLTP 248 219 321
As % of all permanent IT jobs advertised in England 0.15% 0.13% 0.17%
As % of the Database & Business Intelligence category 0.50% 0.44% 0.56%
Number of salaries quoted 201 149 225
England median annual salary £55,000 £55,000 £52,500
Median salary % change year-on-year - +4.76% -2.78%
10th Percentile £36,250 £33,600 £35,000
90th Percentile £85,000 £81,250 £76,050
UK median annual salary £53,750 £55,000 £52,500
% change year-on-year -2.27% +4.76% +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 advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 49,824 49,722 57,685
As % of all permanent IT jobs advertised in England 30.70% 30.55% 30.51%
Number of salaries quoted 40,961 42,473 49,767
England median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £29,750 £28,750
90th Percentile £81,250 £77,500 £75,000
UK median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +5.56%

OLTP
Job Vacancy Trend in England

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

Job vacancy trend for OLTP in England

OLTP
Salary Trend in England

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

Salary trend for OLTP in England

OLTP
Salary Histogram in England

The salary distribution of IT jobs citing OLTP in England over the 6 months to 22 June 2018.

Salary histogram for OLTP in England

OLTP
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the England region over the 6 months to 22 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
London +33 123 £65,000 - 17
South East +2 45 £42,500 -19.05% 2
East of England +14 26 £55,000 +29.41% 2
Midlands -1 24 £50,000 +13.64% 2
North of England +21 23 £57,500 -11.54% 3
North West +24 20 £61,250 -18.33% 3
East Midlands +2 16 £50,000 +40.85% 1
West Midlands +18 8 £34,000 -36.74% 1
South West -2 7 £42,500 +30.77% 1
Yorkshire +21 3 £55,000 +2.33%
OLTP
UK

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

1 192 (77.42%) SQL
2 149 (60.08%) SQL Server
3 146 (58.87%) SQL Server Integration Services
4 143 (57.66%) OLAP
5 137 (55.24%) Business Intelligence
6 128 (51.61%) SQL Server Reporting Services
7 125 (50.40%) Microsoft
8 110 (44.35%) Data Warehouse
9 106 (42.74%) ETL
10 101 (40.73%) SQL Server Analysis Services
11 96 (38.71%) Agile Software Development
12 79 (31.85%) T-SQL
13 76 (30.65%) Data Modelling
14 72 (29.03%) Microsoft Azure
15 69 (27.82%) Finance
16 67 (27.02%) Power BI
17 63 (25.40%) C#
18 58 (23.39%) Oracle
19 57 (22.98%) Performance Tuning
20 55 (22.18%) .NET
21 44 (17.74%) Advertising
21 44 (17.74%) Data Architecture
22 42 (16.94%) WPF
22 42 (16.94%) MySQL
23 36 (14.52%) Oracle OLAP
24 35 (14.11%) Degree
24 35 (14.11%) Banking
24 35 (14.11%) Data Integration
25 34 (13.71%) SDLC
25 34 (13.71%) Problem-Solving

OLTP
Co-occurring IT Skills in England 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 17 (6.85%) Apache Spark
2 14 (5.65%) Elasticsearch
3 8 (3.23%) Oracle Application Server
4 7 (2.82%) SAS
5 5 (2.02%) Apache
6 3 (1.21%) Apache Solr
7 2 (0.81%) Apache Pig
7 2 (0.81%) JBoss
8 1 (0.40%) Oracle Workflow
8 1 (0.40%) Tomcat
8 1 (0.40%) WebLogic
Applications
1 13 (5.24%) MS Visio
2 6 (2.42%) Microsoft Excel
2 6 (2.42%) Microsoft Office
3 1 (0.40%) Spreadsheet
Business Applications
1 2 (0.81%) Adobe Campaign
2 1 (0.40%) Remedy ITSM
Cloud Services
1 72 (29.03%) Microsoft Azure
2 23 (9.27%) Amazon AWS
3 6 (2.42%) SaaS
4 4 (1.61%) Azure Data Factory
5 3 (1.21%) PaaS
6 2 (0.81%) Amazon S3
6 2 (0.81%) Data Lake Analytics
6 2 (0.81%) IaaS
Communications & Networking
1 7 (2.82%) DNS
1 7 (2.82%) HTTP
2 6 (2.42%) SAN
3 4 (1.61%) SSL
4 2 (0.81%) MPLS
4 2 (0.81%) SMS
4 2 (0.81%) VPLS
4 2 (0.81%) Wireless
Database & Business Intelligence
1 149 (60.08%) SQL Server
2 146 (58.87%) SQL Server Integration Services
3 143 (57.66%) OLAP
4 128 (51.61%) SQL Server Reporting Services
5 110 (44.35%) Data Warehouse
6 101 (40.73%) SQL Server Analysis Services
7 67 (27.02%) Power BI
8 42 (16.94%) MySQL
9 36 (14.52%) Oracle OLAP
10 33 (13.31%) NoSQL
11 31 (12.50%) SQL Server 2012
12 28 (11.29%) Big Data
13 27 (10.89%) Relational Database
14 26 (10.48%) Hadoop
15 23 (9.27%) Oracle Database
15 23 (9.27%) SQL Server 2016
16 21 (8.47%) MongoDB
16 21 (8.47%) Snowflake Schema
17 18 (7.26%) Azure SQL Database
18 17 (6.85%) Apache Cassandra
Development Applications
1 29 (11.69%) SQL Server Management Studio (SSMS)
2 26 (10.48%) ERwin
3 23 (9.27%) Team Foundation Server
3 23 (9.27%) Visual Studio
4 12 (4.84%) Git (software)
5 9 (3.63%) ER Studio
6 8 (3.23%) Visual Studio Team System
7 7 (2.82%) JIRA
8 4 (1.61%) Cucumber
8 4 (1.61%) Gradle
8 4 (1.61%) Jenkins
9 3 (1.21%) TeamCity
10 2 (0.81%) Oracle Forms
11 1 (0.40%) Subversion
11 1 (0.40%) TestRail
General
1 69 (27.82%) Finance
2 44 (17.74%) Advertising
3 35 (14.11%) Banking
4 13 (5.24%) Retail Banking
5 12 (4.84%) Games
6 9 (3.63%) Retail
7 7 (2.82%) Investment Banking
8 6 (2.42%) Front Office
9 5 (2.02%) Marketing
10 4 (1.61%) Billing
10 4 (1.61%) International Banking
10 4 (1.61%) Law
11 3 (1.21%) Back Office
11 3 (1.21%) Pharmaceutical
11 3 (1.21%) Publishing
12 2 (0.81%) Dutch Language
12 2 (0.81%) French Language
12 2 (0.81%) German Language
12 2 (0.81%) Italian Language
12 2 (0.81%) Retail Finance
Job Titles
1 115 (46.37%) Developer
2 63 (25.40%) Architect
3 46 (18.55%) Data Architect
4 45 (18.15%) DBA
5 40 (16.13%) SQL Developer
6 29 (11.69%) SQL DBA
7 26 (10.48%) Business Intelligence Developer
8 19 (7.66%) Senior Developer
8 19 (7.66%) SSIS Developer
9 17 (6.85%) Solutions Architect
9 17 (6.85%) SQL Server Developer
10 16 (6.45%) Java Developer
10 16 (6.45%) SSRS Developer
11 15 (6.05%) Business Intelligence Architect
11 15 (6.05%) SQL Server DBA
12 13 (5.24%) Analyst
12 13 (5.24%) Data Engineer
12 13 (5.24%) Senior SQL Developer
13 11 (4.44%) Administrator
13 11 (4.44%) Oracle Developer
Libraries, Frameworks & Software Standards
1 55 (22.18%) .NET
2 42 (16.94%) WPF
3 29 (11.69%) Web Services
4 25 (10.08%) XML
5 14 (5.65%) JSON
5 14 (5.65%) MDX
6 12 (4.84%) REST
7 11 (4.44%) Kafka
8 8 (3.23%) SOAP
9 7 (2.82%) Oracle GoldenGate
10 4 (1.61%) AngularJS
10 4 (1.61%) ASP.NET
10 4 (1.61%) Middleware
10 4 (1.61%) RabbitMQ
10 4 (1.61%) RESTful
10 4 (1.61%) Spring Boot
11 3 (1.21%) ASP.NET Web API
12 2 (0.81%) ASP.NET MVC
12 2 (0.81%) COM
12 2 (0.81%) Spark Streaming
Miscellaneous
1 29 (11.69%) Analytical Skills
2 24 (9.68%) Computer Science
3 20 (8.06%) Replication
4 17 (6.85%) Clustering
5 16 (6.45%) Hybrid Cloud
6 9 (3.63%) Data Structures
7 8 (3.23%) Mainframe
8 7 (2.82%) Fintech
9 6 (2.42%) Self-Motivation
10 5 (2.02%) Data Protection Act
10 5 (2.02%) Reference Data
10 5 (2.02%) Tandem
11 4 (1.61%) Contactless
11 4 (1.61%) Data Centre
11 4 (1.61%) EMV
11 4 (1.61%) EPoS
11 4 (1.61%) N-Tier
11 4 (1.61%) Taxonomies
12 3 (1.21%) FlexPod
12 3 (1.21%) VxBlock/Vblock
Operating Systems
1 32 (12.90%) Linux
2 26 (10.48%) Windows
3 18 (7.26%) Unix
4 11 (4.44%) Windows Server
5 5 (2.02%) CentOS
5 5 (2.02%) Red Hat Enterprise Linux
6 3 (1.21%) Oracle Linux
6 3 (1.21%) SUSE
7 2 (0.81%) Solaris
Processes & Methodologies
1 137 (55.24%) Business Intelligence
2 106 (42.74%) ETL
3 96 (38.71%) Agile Software Development
4 76 (30.65%) Data Modelling
5 57 (22.98%) Performance Tuning
6 44 (17.74%) Data Architecture
7 35 (14.11%) Data Integration
8 34 (13.71%) Problem-Solving
8 34 (13.71%) SDLC
9 31 (12.50%) Migration
10 30 (12.10%) Logical Data Model
11 29 (11.69%) Analytics
12 28 (11.29%) Continuous Integration
12 28 (11.29%) Data Analysis
13 27 (10.89%) Physical Data Model
13 27 (10.89%) Scrum
14 24 (9.68%) Data Strategy
15 22 (8.87%) Release Management
16 20 (8.06%) Data Development
16 20 (8.06%) SQL Optimisation
Programming Languages
1 192 (77.42%) SQL
2 79 (31.85%) T-SQL
3 63 (25.40%) C#
4 31 (12.50%) Java
5 30 (12.10%) PowerShell
6 25 (10.08%) PL/SQL
7 8 (3.23%) Perl
7 8 (3.23%) Python
8 6 (2.42%) JavaScript
9 4 (1.61%) C++
9 4 (1.61%) VB
10 3 (1.21%) Bash Shell
10 3 (1.21%) Shell Script
11 2 (0.81%) Scala
11 2 (0.81%) VB6
11 2 (0.81%) VBA
12 1 (0.40%) Groovy
12 1 (0.40%) Korn
12 1 (0.40%) VB.NET
12 1 (0.40%) VBScript
Qualifications
1 35 (14.11%) Degree
2 16 (6.45%) Computer Science Degree
3 4 (1.61%) MCSE
3 4 (1.61%) Microsoft Certification
4 2 (0.81%) MCITP
4 2 (0.81%) RHCE
4 2 (0.81%) RHCSA
4 2 (0.81%) TOGAF Certification
5 1 (0.40%) ISTQB
5 1 (0.40%) Master's Degree
5 1 (0.40%) MCP
Quality Assurance & Compliance
1 11 (4.44%) Data Quality
2 7 (2.82%) GDPR
3 5 (2.02%) PCI DSS
4 4 (1.61%) PSD2
5 1 (0.40%) QA
System Software
1 10 (4.03%) Docker
2 6 (2.42%) Oracle RAC
3 5 (2.02%) Apache Flume
4 3 (1.21%) HDFS
5 2 (0.81%) Apache ZooKeeper
6 1 (0.40%) Microsoft App-V
6 1 (0.40%) VMware Infrastructure
Systems Management
1 7 (2.82%) Puppet
2 6 (2.42%) Data Guard
3 4 (1.61%) Ansible
3 4 (1.61%) Opscode Chef
3 4 (1.61%) Terraform
4 3 (1.21%) HP Quality Center
4 3 (1.21%) Oozie
5 2 (0.81%) Oracle Enterprise Manager
5 2 (0.81%) SQL Sentry
6 1 (0.40%) Failover Clustering
6 1 (0.40%) Galera Cluster
6 1 (0.40%) Netcool
6 1 (0.40%) OpenView
6 1 (0.40%) Tivoli
Vendors
1 125 (50.40%) Microsoft
2 58 (23.39%) Oracle
3 22 (8.87%) Tableau
4 13 (5.24%) Siebel
5 11 (4.44%) Informatica
6 7 (2.82%) Cloudera
7 6 (2.42%) Cognos
7 6 (2.42%) IBM
8 5 (2.02%) Red Hat
9 4 (1.61%) Apple
9 4 (1.61%) MicroStrategy
9 4 (1.61%) Netezza
9 4 (1.61%) PayPal
9 4 (1.61%) SAP
9 4 (1.61%) Talend
10 3 (1.21%) Hortonworks
10 3 (1.21%) HP
11 2 (0.81%) Adobe
11 2 (0.81%) CA
11 2 (0.81%) Sun