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

Online Transaction Processing (OLTP)
UK > England
6 months to
25 Sep 2018
Same period 2017 Same period 2016
Rank 897 908 869
Rank change year-on-year +11 -39 -25
Permanent jobs citing OLTP 236 247 356
As % of all permanent IT jobs advertised in England 0.15% 0.15% 0.20%
As % of the Database & Business Intelligence category 0.51% 0.49% 0.66%
Number of salaries quoted 183 168 257
England median annual salary £55,000 £50,000 £50,000
Median salary % change year-on-year +10.00% - -9.09%
10th Percentile £37,500 £30,500 £35,000
90th Percentile £77,500 £80,375 £77,700
UK median annual salary £52,500 £50,000 £50,000
% change year-on-year +5.00% - -4.76%

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 46,410 50,408 53,700
As % of all permanent IT jobs advertised in England 29.70% 30.42% 29.73%
Number of salaries quoted 38,009 41,900 46,303
England median annual salary £50,000 £49,000 £47,500
Median salary % change year-on-year +2.04% +3.16% +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £83,750 £77,500 £76,250
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 25 September 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 25 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
London +22 105 £62,500 +4.17% 14
North of England +42 40 £52,500 -4.55% 1
North West +38 40 £52,500 +5.00% 1
South East +19 37 £48,750 -7.14% 6
East of England +21 25 £66,000 +65.00% 2
Midlands 0 21 £48,000 +36.17% 4
East Midlands -6 14 £57,500 +63.12% 2
West Midlands +26 7 £40,000 -23.81% 2
South West +3 6 £47,750 +46.92%
OLTP
UK

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

1 191 (80.93%) SQL
2 137 (58.05%) SQL Server
3 119 (50.42%) Data Warehouse
4 116 (49.15%) SQL Server Integration Services
5 105 (44.49%) Microsoft
6 98 (41.53%) Business Intelligence
7 94 (39.83%) OLAP
8 90 (38.14%) Agile Software Development
9 86 (36.44%) SQL Server Reporting Services
10 81 (34.32%) T-SQL
11 76 (32.20%) ETL
12 72 (30.51%) Performance Tuning
13 65 (27.54%) Oracle
14 62 (26.27%) Data Modelling
15 60 (25.42%) Relational Database
16 56 (23.73%) Degree
16 56 (23.73%) SQL Server Analysis Services
17 52 (22.03%) Finance
18 45 (19.07%) ITIL
18 45 (19.07%) SQL Server 2012
18 45 (19.07%) MongoDB
19 42 (17.80%) Big Data
20 41 (17.37%) NoSQL
20 41 (17.37%) Power BI
21 40 (16.95%) MySQL
21 40 (16.95%) SQL Server 2014
22 38 (16.10%) Linux
22 38 (16.10%) Oracle OLAP
22 38 (16.10%) Hadoop
22 38 (16.10%) Microsoft Azure

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 28 (11.86%) Apache Spark
2 9 (3.81%) SAS
3 8 (3.39%) Oracle Application Server
4 7 (2.97%) Apache
5 5 (2.12%) Apache Pig
6 2 (0.85%) Cloud Foundry
6 2 (0.85%) GemFire
6 2 (0.85%) Tomcat
7 1 (0.42%) OpenStack
7 1 (0.42%) Oracle Workflow
7 1 (0.42%) WebLogic
Applications
1 16 (6.78%) MS Visio
2 10 (4.24%) Microsoft Excel
3 3 (1.27%) Microsoft Office
3 3 (1.27%) Microsoft PowerPoint
4 1 (0.42%) Spreadsheet
Business Applications
1 6 (2.54%) Oracle EBS
1 6 (2.54%) Oracle Retail
2 2 (0.85%) SAP Business One
Cloud Services
1 38 (16.10%) Microsoft Azure
2 16 (6.78%) Amazon AWS
3 8 (3.39%) PaaS
4 4 (1.69%) Azure Data Factory
4 4 (1.69%) GitHub
4 4 (1.69%) IaaS
4 4 (1.69%) SaaS
5 2 (0.85%) Amazon S3
6 1 (0.42%) Data Lake Analytics
Communications & Networking
1 9 (3.81%) SAN
2 6 (2.54%) DNS
3 5 (2.12%) Firewall
3 5 (2.12%) HTTP
3 5 (2.12%) Internet
4 2 (0.85%) SMS
5 1 (0.42%) MPLS
5 1 (0.42%) VPLS
Database & Business Intelligence
1 137 (58.05%) SQL Server
2 119 (50.42%) Data Warehouse
3 116 (49.15%) SQL Server Integration Services
4 94 (39.83%) OLAP
5 86 (36.44%) SQL Server Reporting Services
6 60 (25.42%) Relational Database
7 56 (23.73%) SQL Server Analysis Services
8 45 (19.07%) MongoDB
8 45 (19.07%) SQL Server 2012
9 42 (17.80%) Big Data
10 41 (17.37%) NoSQL
10 41 (17.37%) Power BI
11 40 (16.95%) MySQL
11 40 (16.95%) SQL Server 2014
12 38 (16.10%) Hadoop
12 38 (16.10%) Oracle OLAP
13 34 (14.41%) Oracle Database
14 30 (12.71%) SQL Server 2008
15 26 (11.02%) Apache Hive
16 24 (10.17%) Impala
Development Applications
1 18 (7.63%) ERwin
2 17 (7.20%) Visual Studio
3 13 (5.51%) Gradle
4 12 (5.08%) Git (software)
5 11 (4.66%) Cucumber
5 11 (4.66%) SQL Server Management Studio (SSMS)
5 11 (4.66%) Team Foundation Server
6 9 (3.81%) JIRA
7 6 (2.54%) Oracle APEX
7 6 (2.54%) PVCS
7 6 (2.54%) Toad
8 4 (1.69%) Visual Studio Team System
9 3 (1.27%) ER Studio
9 3 (1.27%) Jenkins
10 2 (0.85%) Eclipse
10 2 (0.85%) JUnit
11 1 (0.42%) Subversion
11 1 (0.42%) TestRail
General
1 52 (22.03%) Finance
2 21 (8.90%) Advertising
3 16 (6.78%) Banking
3 16 (6.78%) Games
4 15 (6.36%) Retail Banking
5 9 (3.81%) Retail
6 6 (2.54%) Publishing
7 5 (2.12%) Back Office
7 5 (2.12%) Corporate Banking
7 5 (2.12%) Financial Institution
8 4 (1.69%) Marketing
9 3 (1.27%) Front Office
9 3 (1.27%) Investment Banking
10 1 (0.42%) Automotive
10 1 (0.42%) International Banking
10 1 (0.42%) Pharmaceutical
10 1 (0.42%) Retail Finance
Job Titles
1 77 (32.63%) Developer
2 58 (24.58%) DBA
3 48 (20.34%) Architect
4 41 (17.37%) SQL DBA
5 39 (16.53%) Data Architect
6 32 (13.56%) Administrator
7 21 (8.90%) Business Intelligence Architect
8 19 (8.05%) Oracle Developer
9 16 (6.78%) Data Warehouse Developer
10 14 (5.93%) Business Intelligence Developer
10 14 (5.93%) Oracle Data Warehouse Developer
10 14 (5.93%) SQL Developer
11 13 (5.51%) Analyst
11 13 (5.51%) Senior Developer
11 13 (5.51%) Software Engineer
12 12 (5.08%) Data Engineer
13 11 (4.66%) SQL Server DBA
14 10 (4.24%) Solutions Architect
14 10 (4.24%) SSIS Developer
14 10 (4.24%) SSRS Developer
Libraries, Frameworks & Software Standards
1 33 (13.98%) Web Services
2 31 (13.14%) .NET
3 27 (11.44%) XML
4 24 (10.17%) JSON
5 20 (8.47%) Kafka
5 20 (8.47%) WPF
6 14 (5.93%) Oracle GoldenGate
6 14 (5.93%) Spring Boot
7 11 (4.66%) RESTful
8 7 (2.97%) Spark Streaming
9 6 (2.54%) RabbitMQ
10 5 (2.12%) MDX
11 3 (1.27%) Middleware
12 2 (0.85%) J2EE
12 2 (0.85%) Spring
12 2 (0.85%) Spring Batch
12 2 (0.85%) Spring Integration
13 1 (0.42%) ASP.NET
13 1 (0.42%) LDAP
13 1 (0.42%) SAML
Miscellaneous
1 22 (9.32%) Analytical Skills
2 19 (8.05%) Replication
3 15 (6.36%) Clustering
3 15 (6.36%) Computer Science
4 12 (5.08%) Greenfield Project
5 11 (4.66%) Hybrid Cloud
6 10 (4.24%) Data Centre
7 8 (3.39%) Reference Data
8 7 (2.97%) Data Structures
8 7 (2.97%) Enterprise Software
8 7 (2.97%) Tandem
9 6 (2.54%) N-Tier
10 5 (2.12%) Fintech
10 5 (2.12%) Mainframe
11 4 (1.69%) Management Information System
11 4 (1.69%) Online Games
12 3 (1.27%) Data Protection Act
12 3 (1.27%) Grid Computing
12 3 (1.27%) HACMP
12 3 (1.27%) VxBlock/Vblock
Operating Systems
1 38 (16.10%) Linux
2 26 (11.02%) Unix
3 25 (10.59%) Windows
4 17 (7.20%) Windows Server
5 8 (3.39%) Red Hat Enterprise Linux
6 4 (1.69%) Solaris
7 3 (1.27%) AIX
7 3 (1.27%) Oracle Linux
7 3 (1.27%) SUSE
8 2 (0.85%) CentOS
9 1 (0.42%) Debian
Processes & Methodologies
1 98 (41.53%) Business Intelligence
2 90 (38.14%) Agile Software Development
3 76 (32.20%) ETL
4 72 (30.51%) Performance Tuning
5 62 (26.27%) Data Modelling
6 45 (19.07%) ITIL
7 34 (14.41%) Problem-Solving
8 30 (12.71%) Data Management
8 30 (12.71%) Scrum
9 29 (12.29%) Data Architecture
9 29 (12.29%) Data Integration
10 28 (11.86%) Dimensional Modelling
11 27 (11.44%) Continuous Integration
11 27 (11.44%) Data Analysis
11 27 (11.44%) IT Strategy
11 27 (11.44%) SDLC
12 25 (10.59%) Migration
12 25 (10.59%) Server Building
13 23 (9.75%) Analytics
14 21 (8.90%) Kimball Methodology
Programming Languages
1 191 (80.93%) SQL
2 81 (34.32%) T-SQL
3 36 (15.25%) PL/SQL
4 33 (13.98%) Java
5 28 (11.86%) C#
6 12 (5.08%) Python
7 10 (4.24%) PowerShell
7 10 (4.24%) Shell Script
8 5 (2.12%) Scala
9 4 (1.69%) Bash Shell
9 4 (1.69%) Perl
10 1 (0.42%) Data Analysis Expressions (DAX)
10 1 (0.42%) Java 8
10 1 (0.42%) Korn
Qualifications
1 56 (23.73%) Degree
2 30 (12.71%) Microsoft Certification
3 5 (2.12%) MCSE
4 4 (1.69%) Computer Science Degree
5 3 (1.27%) MCITP
5 3 (1.27%) RHCE
5 3 (1.27%) RHCSA
6 1 (0.42%) ISTQB
6 1 (0.42%) MCP
6 1 (0.42%) TOGAF Certification
Quality Assurance & Compliance
1 8 (3.39%) QA
2 6 (2.54%) Data Quality
3 4 (1.69%) PMO
4 3 (1.27%) GDPR
5 1 (0.42%) PCI DSS
System Software
1 13 (5.51%) Docker
2 9 (3.81%) HDFS
3 8 (3.39%) Apache Flume
4 7 (2.97%) Apache ZooKeeper
4 7 (2.97%) Oracle RAC
5 6 (2.54%) Virtual Machines
6 5 (2.12%) VMware Infrastructure
7 3 (1.27%) GPFS
8 1 (0.42%) Microsoft App-V
Systems Management
1 8 (3.39%) Data Guard
2 4 (1.69%) Terraform
3 3 (1.27%) HP Quality Center
3 3 (1.27%) Oozie
3 3 (1.27%) Oracle Enterprise Manager
4 2 (0.85%) Ansible
4 2 (0.85%) Consul
4 2 (0.85%) Kubernetes
4 2 (0.85%) Puppet
4 2 (0.85%) SQL Sentry
5 1 (0.42%) Nagios
5 1 (0.42%) OpenView
5 1 (0.42%) Opscode Chef
5 1 (0.42%) Tivoli
Vendors
1 105 (44.49%) Microsoft
2 65 (27.54%) Oracle
3 23 (9.75%) Tableau
4 12 (5.08%) SAP
5 11 (4.66%) Siebel
6 10 (4.24%) Cloudera
7 6 (2.54%) Hortonworks
7 6 (2.54%) Informatica
7 6 (2.54%) Red Hat
8 5 (2.12%) EXASOL
8 5 (2.12%) IBM
8 5 (2.12%) Intel
8 5 (2.12%) MapR
8 5 (2.12%) Teradata
8 5 (2.12%) VMware
9 4 (1.69%) Cognos
9 4 (1.69%) MicroStrategy
9 4 (1.69%) Netezza
9 4 (1.69%) Talend
10 3 (1.27%) NetApp