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 3 months to 22 June 2017 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK / England
3 months to
22 Jun 2017
Same period 2016 Same period 2015
Rank 753 737 749
Rank change year-on-year -16 +12  
Permanent jobs citing OLTP 102 170 209
As % of all permanent IT jobs advertised in England 0.12% 0.18% 0.20%
As % of the Database & Business Intelligence category 0.40% 0.61% 0.61%
Number of salaries quoted 62 120 136
Median salary £50,000 £50,000 £54,501
Median salary % change year-on-year - -8.25%  
90% offered a salary of more than £32,500 £40,000 £32,000
10% offered a salary of more than £65,000 £77,050 £72,500
UK excluding London median salary £45,250 £45,000 £45,000
% change year-on-year +0.55% -  

OLTP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in England with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
England
Permanent job vacancies with a requirement for database and business intelligence skills 25623 27832 34123
As % of all permanent IT job vacancies advertised in England 30.70% 30.03% 32.81%
Number of salaries quoted 21797 24070 29111
Median salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26%  
90% offered a salary of more than £32,500 £32,500 £32,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

OLTP
Job Vacancy Trend in England

The job posting trend of jobs advertised in England citing OLTP as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

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 3 months to 22 June 2017.

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 3 months to 22 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London -20 43 £60,000 +4.34% 8
South East +23 16 £55,000 +10.00% 1
East Midlands +29 13 £35,250 -31.21%
East of England +12 13 £41,250 -31.25% 4
South West +5 7 £32,500 -18.75% 1
West Midlands +14 4 £56,250 +25.00% 1
North West - 3 £70,750 - 2
Yorkshire -3 2 £65,000 -8.77% 2
OLTP
UK

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

1 165 (75.34%) SQL
2 122 (55.71%) SQL Server
3 121 (55.25%) OLAP
4 91 (41.55%) ETL
5 83 (37.90%) Oracle
6 81 (36.99%) Data Warehouse
7 76 (34.70%) SQL Server Integration Services
8 74 (33.79%) Performance Tuning
9 72 (32.88%) Business Intelligence
10 69 (31.51%) MySQL
11 66 (30.14%) Microsoft
12 64 (29.22%) SQL Server Reporting Services
13 60 (27.40%) T-SQL
14 59 (26.94%) SQL Server Analysis Services
15 44 (20.09%) Analytical Skills
16 43 (19.63%) PL/SQL
16 43 (19.63%) Oracle OLAP
16 43 (19.63%) Agile Software Development
17 40 (18.26%) Linux
17 40 (18.26%) Disaster Recovery
18 38 (17.35%) Oracle Database
19 36 (16.44%) Replication
20 35 (15.98%) ITIL
20 35 (15.98%) Relational Database
21 34 (15.53%) Degree
22 32 (14.61%) Data Modelling
22 32 (14.61%) SQL Server 2008
23 31 (14.16%) Java
24 30 (13.70%) Unix
24 30 (13.70%) SQL Server 2012

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 9 (4.11%) IIS
2 8 (3.65%) Apache Spark
3 7 (3.20%) Apache
3 7 (3.20%) SharePoint
3 7 (3.20%) Tomcat
4 5 (2.28%) Oracle Service Bus
5 4 (1.83%) Cloud Foundry
5 4 (1.83%) Elasticsearch
5 4 (1.83%) GemFire
6 3 (1.37%) JBoss
6 3 (1.37%) WebLogic
7 1 (0.46%) Apache Pig
7 1 (0.46%) Apache Solr
7 1 (0.46%) OpenStack
7 1 (0.46%) Oracle SOA Suite
Applications
1 5 (2.28%) Microsoft Excel
2 4 (1.83%) MS Visio
Business Applications
1 4 (1.83%) SAP CO
1 4 (1.83%) SAP FI
1 4 (1.83%) SAP FI/CO
1 4 (1.83%) SAP FSCM
1 4 (1.83%) SAP MM
1 4 (1.83%) SAP PS
1 4 (1.83%) SAP SD
2 1 (0.46%) Cognos Business Intelligence
2 1 (0.46%) Dynamics CRM
2 1 (0.46%) FastStats
Cloud Services
1 22 (10.05%) Microsoft Azure
2 15 (6.85%) Amazon AWS
3 12 (5.48%) Cloud Computing
4 11 (5.02%) GitHub
5 7 (3.20%) PaaS
6 6 (2.74%) IaaS
7 3 (1.37%) Azure Data Factory
7 3 (1.37%) Google Cloud Platform
7 3 (1.37%) SaaS
8 1 (0.46%) Data Lake Analytics
8 1 (0.46%) Datadog
8 1 (0.46%) Slack
Communications & Networking
1 10 (4.57%) Intranet
1 10 (4.57%) SAN
2 5 (2.28%) Fibre Channel
3 4 (1.83%) Extranet
3 4 (1.83%) Wireless
4 2 (0.91%) Internet
Database & Business Intelligence
1 122 (55.71%) SQL Server
2 121 (55.25%) OLAP
3 81 (36.99%) Data Warehouse
4 76 (34.70%) SQL Server Integration Services
5 69 (31.51%) MySQL
6 64 (29.22%) SQL Server Reporting Services
7 59 (26.94%) SQL Server Analysis Services
8 43 (19.63%) Oracle OLAP
9 38 (17.35%) Oracle Database
10 35 (15.98%) Relational Database
11 32 (14.61%) SQL Server 2008
12 30 (13.70%) SQL Server 2012
13 26 (11.87%) SQL Server 2014
14 23 (10.50%) DB2
15 22 (10.05%) RDBMS
16 21 (9.59%) Hadoop
16 21 (9.59%) NoSQL
17 20 (9.13%) Data Mining
17 20 (9.13%) Oracle ODI
18 17 (7.76%) Big Data
Development Applications
1 20 (9.13%) Team Foundation Server
2 15 (6.85%) JIRA
2 15 (6.85%) Visual Studio
3 7 (3.20%) Git (software)
4 5 (2.28%) Jenkins
4 5 (2.28%) Talend Open Studio
4 5 (2.28%) tSQLt
5 4 (1.83%) Eclipse
5 4 (1.83%) Gradle
5 4 (1.83%) JUnit
5 4 (1.83%) Oracle Forms
6 1 (0.46%) ERwin
6 1 (0.46%) git-flow
6 1 (0.46%) MagicDraw
6 1 (0.46%) Octopus Deploy
General
1 23 (10.50%) Finance
2 15 (6.85%) Advertising
3 12 (5.48%) Retail
4 4 (1.83%) Pharmaceutical
5 3 (1.37%) Banking
6 1 (0.46%) Automotive
6 1 (0.46%) Games
6 1 (0.46%) Investment Banking
6 1 (0.46%) Marketing
6 1 (0.46%) Wholesale Banking
Job Titles
1 89 (40.64%) Developer
2 51 (23.29%) DBA
3 41 (18.72%) SQL Developer
4 35 (15.98%) SQL DBA
5 33 (15.07%) Administrator
6 30 (13.70%) Architect
7 27 (12.33%) Analyst
7 27 (12.33%) SQL Server DBA
8 23 (10.50%) Business Intelligence Developer
8 23 (10.50%) Oracle Developer
9 21 (9.59%) SQL Analyst
10 18 (8.22%) C++ Developer
11 17 (7.76%) Data Analyst
11 17 (7.76%) SQL Data Analyst
12 15 (6.85%) Technical Architect
13 14 (6.39%) SQL BI Developer
13 14 (6.39%) Unix Developer
14 12 (5.48%) Business Intelligence Analyst
14 12 (5.48%) Data Warehouse Developer
14 12 (5.48%) Lead Architect
Libraries, Frameworks & Software Standards
1 21 (9.59%) STL
2 19 (8.68%) .NET
3 17 (7.76%) Oracle GoldenGate
3 17 (7.76%) Web Services
4 15 (6.85%) XML
5 14 (6.39%) HTML
6 9 (4.11%) MDX
7 8 (3.65%) ASP.NET
8 7 (3.20%) Boost C++ Libraries
8 7 (3.20%) Middleware
9 6 (2.74%) ASP.NET MVC
10 5 (2.28%) WinForms
11 4 (1.83%) COM
11 4 (1.83%) J2EE
11 4 (1.83%) JSON
11 4 (1.83%) Kafka
11 4 (1.83%) Spring
11 4 (1.83%) Spring Batch
11 4 (1.83%) Spring Boot
11 4 (1.83%) Spring Integration
Miscellaneous
1 44 (20.09%) Analytical Skills
2 36 (16.44%) Replication
3 23 (10.50%) Computer Science
4 17 (7.76%) Fintech
5 16 (7.31%) Clustering
6 7 (3.20%) Equities
6 7 (3.20%) Fixed Income
7 6 (2.74%) Foreign Exchange (FX)
7 6 (2.74%) Management Information System
8 5 (2.28%) EMC VMAX
9 4 (1.83%) Linux Command Line
9 4 (1.83%) PDA
9 4 (1.83%) Virtual Team
10 3 (1.37%) Data Protection Act
10 3 (1.37%) PKI
11 2 (0.91%) Blog
11 2 (0.91%) Enterprise Software
12 1 (0.46%) Data Structures
12 1 (0.46%) Public Cloud
12 1 (0.46%) Reference Data
Operating Systems
1 40 (18.26%) Linux
2 30 (13.70%) Unix
3 25 (11.42%) Windows
4 13 (5.94%) Windows Server 2008
4 13 (5.94%) Windows Server 2012
5 10 (4.57%) Red Hat Enterprise Linux
6 7 (3.20%) Windows Server
7 5 (2.28%) Solaris
8 2 (0.91%) Ubuntu
9 1 (0.46%) Windows NT
Processes & Methodologies
1 91 (41.55%) ETL
2 74 (33.79%) Performance Tuning
3 72 (32.88%) Business Intelligence
4 43 (19.63%) Agile Software Development
5 40 (18.26%) Disaster Recovery
6 35 (15.98%) ITIL
7 32 (14.61%) Data Modelling
8 29 (13.24%) High Availability
9 26 (11.87%) Kimball Methodology
10 24 (10.96%) ETL Development
11 22 (10.05%) Dimensional Modelling
12 17 (7.76%) UML
13 16 (7.31%) Change Management
13 16 (7.31%) E-Commerce
13 16 (7.31%) Performance Monitoring
13 16 (7.31%) Scrum
13 16 (7.31%) Unit Testing
14 15 (6.85%) OO
15 14 (6.39%) Data Transformation
15 14 (6.39%) Database Tuning
Programming Languages
1 165 (75.34%) SQL
2 60 (27.40%) T-SQL
3 43 (19.63%) PL/SQL
4 31 (14.16%) Java
5 22 (10.05%) C++
6 14 (6.39%) C#
7 10 (4.57%) PowerShell
8 9 (4.11%) Shell Script
9 6 (2.74%) ABAP
9 6 (2.74%) JavaScript
10 5 (2.28%) Python
10 5 (2.28%) VB.NET
11 4 (1.83%) VB
11 4 (1.83%) VB6
11 4 (1.83%) VBScript
12 2 (0.91%) PHP
12 2 (0.91%) R
13 1 (0.46%) Bash Shell
13 1 (0.46%) Data Analysis Expressions (DAX)
13 1 (0.46%) SPARQL
Qualifications
1 34 (15.53%) Degree
2 14 (6.39%) Microsoft Certification
3 6 (2.74%) Oracle Certification
4 5 (2.28%) SC Cleared
4 5 (2.28%) Security Cleared
5 4 (1.83%) MCITP
6 2 (0.91%) MCSE
7 1 (0.46%) Computer Science Degree
Quality Assurance & Compliance
1 20 (9.13%) QA
2 15 (6.85%) Data Quality
3 3 (1.37%) PCI DSS
4 2 (0.91%) GDPR
5 1 (0.46%) Sarbanes-Oxley
5 1 (0.46%) SLA
System Software
1 11 (5.02%) Oracle RAC
2 6 (2.74%) Active Directory
3 5 (2.28%) GlusterFS
3 5 (2.28%) Veritas Cluster Server
4 4 (1.83%) Apache ZooKeeper
4 4 (1.83%) HDFS
5 2 (0.91%) Virtual Machines
6 1 (0.46%) KVM
6 1 (0.46%) VMware Infrastructure
Systems Management
1 8 (3.65%) Oracle Enterprise Manager
2 6 (2.74%) NetBackup
2 6 (2.74%) Red Hat Satellite
3 5 (2.28%) Enterprise Manager Cloud Control
3 5 (2.28%) Oracle RMAN
3 5 (2.28%) Oracle ZFS
3 5 (2.28%) Veritas Storage Foundation
4 4 (1.83%) Ansible
5 3 (1.37%) Tivoli
6 2 (0.91%) Failover Clustering
6 2 (0.91%) Microsoft Clustering
6 2 (0.91%) Puppet
7 1 (0.46%) Cobbler
7 1 (0.46%) Kibana
7 1 (0.46%) Opscode Chef
7 1 (0.46%) Perfmon
7 1 (0.46%) PowerCLI
7 1 (0.46%) Rundeck
7 1 (0.46%) Systems Management Server (SMS)
7 1 (0.46%) ZABBIX
Vendors
1 83 (37.90%) Oracle
2 66 (30.14%) Microsoft
3 10 (4.57%) Cognos
3 10 (4.57%) Red Hat
4 7 (3.20%) Vertica
5 6 (2.74%) Brocade
5 6 (2.74%) RedGate
5 6 (2.74%) SAP
5 6 (2.74%) SolarWinds
5 6 (2.74%) Tableau
5 6 (2.74%) Veritas
6 5 (2.28%) EMC
6 5 (2.28%) Informatica
6 5 (2.28%) Intel
6 5 (2.28%) StorageTek
6 5 (2.28%) Sun
6 5 (2.28%) Talend
7 4 (1.83%) Google
7 4 (1.83%) IBM
7 4 (1.83%) Jaspersoft
South East London
Client Server
Salary: £35k to £50k + benefits
Posted: 8 hours ago
Colchester
Nigel Frank International
Salary: £35000 - £45000 per annum + Benefits
Posted: 2 days ago
Manchester, Lancashire
Harvey Nash plc
Posted: Yesterday
Preston, Lancashire
Oscar
Salary: £25000 - £40000 per annum
Posted: 7 hours ago
City, London
onezeero.
Salary: £65000 per annum
Posted: 3 days ago
Bath, Avon
Optima Connections
Salary: From £30,000 to £35,000 per annum + Benefits
Posted: 3 days ago
West London
Michael Bailey Associates
Salary: Market Rates
Posted: 2 days ago
London
Franklin Bates
Salary: From £50,000 to £60,000 per annum
Posted: 3 days ago
Luton
TUI Group Careers
Salary: Competitive
Posted: 3 days ago
Colchester
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits, Pension
Posted: 7 days ago
Brighton
Nigel Frank International
Salary: £70000 per annum + Pension, Health, Bonus
Posted: 10 days ago
West London
Profile 29 Limited
Salary: From £80,000 to £100,000 per annum + benefits
Posted: 2 days ago
Coventry, West Midlands (County)
Complete Tech Limited
Salary: From £50,000 to £60,000 per annum
Posted: 5 days ago
Bradford, West Yorkshire
Candour Solutions
Salary: From £60,000 to £70,000 per annum plus outstanding benefits
Posted: 2 days ago
London
Client Server
Salary: £35000 - £50000 per annum + benefits
Posted: 8 days ago
Luton
TUI Group Careers
Salary: Competitive
Posted: 13 days ago
Bradford, West Yorkshire
Candour Solutions
Salary: Excellent plus outstanding benefits
Posted: 6 days ago
London
Client Server
Salary: £35k to £50k + benefits
Posted: 15 days ago
London
Client Server
Salary: £35k to £50k + benefits
Posted: 22 days ago