The table below looks at the statistics for OLTP skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited OLTP over the 3 months to 26 February 2017 with a comparison to the same period over the previous 2 years.

3 months to
26 Feb 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
UK
Rank 712 794 752
Rank change year-on-year
+82 -42
Permanent jobs citing OLTP 140 155 198
As % of all permanent IT jobs located in the UK 0.17% 0.15% 0.19%
As % of the Database & Business Intelligence category 0.55% 0.48% 0.59%
Number of salaries quoted 104 109 144
Median salary £57,500 £52,500 £50,000
Median salary % change year-on-year
+9.52% +5.00%
90% offered a salary of more than £40,300 £35,000 £38,950
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £52,500 £47,500 £45,000
% change year-on-year
+10.52% +5.55%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
25271 32329 33321
As % of all permanent IT jobs located in the UK 30.46% 31.57% 31.26%
Number of salaries quoted 21501 27404 28485
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £72,500 £70,000 £70,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLTP
Jobs Demand Trend

The demand trend of job ads citing OLTP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLTP Jobs Demand Trend in the UK

OLTP
Salary Trend

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

OLTP Salary Trend in the UK

OLTP
Salary Histogram

This chart provides a salary histogram for IT jobs citing OLTP over the 3 months to 26 February 2017 within the UK.

OLTP Salary Histogram in the UK

OLTP
Top 30 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 3 months to 26 February 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
England +81 133 £57,500 +4.54% 17
London +57 58 £65,000 +18.18% 11
South East +94 47 £52,500 - 1
East of England +42 13 £50,000 -9.09% 3
Surrey +61 10 £55,000 +12.82%
West Sussex +17 10 £52,500 +5.00%
Guildford - 10 £55,000 -
City of London +34 8 £70,000 +21.73% 3
Kent +24 7 £65,000 +18.18%
Berkshire - 7 £52,500 - 1
Suffolk - 6 £42,500 -
Ipswich - 6 £42,500 -
Reading - 6 - - 1
Glasgow +27 5 £62,500 +56.25%
Scotland +21 5 £62,500 +56.25%
Nottingham +9 5 £77,500 -
East Midlands +5 5 £77,500 +29.16%
Nottinghamshire -2 5 £77,500 -
West End - 5 £60,000 -
Buckinghamshire +22 4 £41,500 -
Hertfordshire +12 4 £30,000 -45.45%
Milton Keynes +5 4 £41,500 -
West Yorkshire +32 3 £42,500 -32.00%
Yorkshire +29 3 £42,500 -32.00% 1
West Midlands +24 3 £52,500 +47.88% 1
North West -11 3 £56,500 +18.94%
Essex - 3 £55,000 - 3
Hatfield +28 2 £50,000 -
Bradford +6 2 - -
Staffordshire -1 2 £52,500 +47.88% 1

OLTP
Top 30 Related IT Skills

For the 6 months to 26 February 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 256 (80.76%) SQL
2 201 (63.41%) SQL Server
3 166 (52.37%) OLAP
4 135 (42.59%) Microsoft
5 126 (39.75%) SQL Server Integration Services
6 125 (39.43%) Business Intelligence
7 123 (38.80%) Performance Tuning
8 120 (37.85%) SQL Server Reporting Services
9 118 (37.22%) Oracle
10 116 (36.59%) Data Warehouse
11 99 (31.23%) T-SQL
12 96 (30.28%) Agile Software Development
13 90 (28.39%) SQL Server Analysis Services
14 87 (27.44%) ETL
15 76 (23.97%) MySQL
16 71 (22.40%) Oracle OLAP
17 65 (20.50%) Disaster Recovery
18 64 (20.19%) Linux
19 58 (18.30%) SQL Server 2008
20 56 (17.67%) Analytical Skills
21 55 (17.35%) MS Excel
22 54 (17.03%) NoSQL
23 49 (15.46%) Finance
24 47 (14.83%) Windows
24 47 (14.83%) PL/SQL
25 46 (14.51%) Replication
25 46 (14.51%) Hadoop
25 46 (14.51%) Relational Database
26 43 (13.56%) High Availability
26 43 (13.56%) Big Data

OLTP
Top Related 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 27 (8.52%) IIS
2 17 (5.36%) Apache
3 16 (5.05%) Tomcat
4 15 (4.73%) Oracle Coherence
4 15 (4.73%) Oracle HTTP Server
4 15 (4.73%) WebSphere
5 14 (4.42%) SharePoint
6 12 (3.79%) Apache Pig
7 5 (1.58%) Jupyter
7 5 (1.58%) Oracle Service Bus
8 4 (1.26%) Oracle SOA Suite
9 2 (0.63%) Apache Solr
9 2 (0.63%) Apache Spark
10 1 (0.32%) JBoss
10 1 (0.32%) WebLogic
Applications
1 55 (17.35%) MS Excel
2 3 (0.95%) MS Visio
Business Applications
1 6 (1.89%) FastStats
2 2 (0.63%) Cognos TM1
3 1 (0.32%) Dynamics AX
3 1 (0.32%) Dynamics CRM
3 1 (0.32%) Dynamics NAV
3 1 (0.32%) OPENHousing
Cloud Services
1 33 (10.41%) Microsoft Azure
2 31 (9.78%) Amazon AWS
3 20 (6.31%) GitHub
4 10 (3.15%) IaaS
4 10 (3.15%) PaaS
5 7 (2.21%) Cloud Computing
6 5 (1.58%) Amazon S3
7 3 (0.95%) Google Cloud Platform
7 3 (0.95%) SaaS
Communications & Networking
1 34 (10.73%) SAN
2 24 (7.57%) Fibre Channel
3 16 (5.05%) LAN
3 16 (5.05%) WAN
4 15 (4.73%) FCoE
4 15 (4.73%) HTTP
4 15 (4.73%) iSCSI
4 15 (4.73%) Multicast
4 15 (4.73%) NAS
5 9 (2.84%) Intranet
6 2 (0.63%) Extranet
6 2 (0.63%) Internet
6 2 (0.63%) VoIP
7 1 (0.32%) LDAP
7 1 (0.32%) PABX
7 1 (0.32%) Wi-Fi
Database & Business Intelligence
1 201 (63.41%) SQL Server
2 166 (52.37%) OLAP
3 126 (39.75%) SQL Server Integration Services
4 120 (37.85%) SQL Server Reporting Services
5 116 (36.59%) Data Warehouse
6 90 (28.39%) SQL Server Analysis Services
7 76 (23.97%) MySQL
8 71 (22.40%) Oracle OLAP
9 58 (18.30%) SQL Server 2008
10 54 (17.03%) NoSQL
11 46 (14.51%) Hadoop
11 46 (14.51%) Relational Database
12 43 (13.56%) Big Data
13 41 (12.93%) SQL Server 2012
14 38 (11.99%) Power BI
15 37 (11.67%) RDBMS
16 28 (8.83%) Microsoft Analysis Services
17 25 (7.89%) Oracle Database
17 25 (7.89%) SQL Server 2014
18 23 (7.26%) SQL Server 2005
Development Applications
1 42 (13.25%) JIRA
2 32 (10.09%) Team Foundation Server
3 19 (5.99%) Talend Open Studio
4 11 (3.47%) Visual Studio
5 10 (3.15%) ERwin
5 10 (3.15%) Jenkins
6 9 (2.84%) Vagrant
7 8 (2.52%) Cucumber
8 7 (2.21%) Git (software)
8 7 (2.21%) git-flow
8 7 (2.21%) MagicDraw
9 5 (1.58%) Oracle APEX
9 5 (1.58%) VSS/SourceSafe
10 1 (0.32%) FitNesse
10 1 (0.32%) JBehave
10 1 (0.32%) TeamCity
General
1 49 (15.46%) Finance
2 13 (4.10%) Advertising
3 10 (3.15%) Retail
4 8 (2.52%) Banking
5 6 (1.89%) Games
6 5 (1.58%) Back Office
7 4 (1.26%) General Ledger
7 4 (1.26%) Marketing
8 3 (0.95%) Manufacturing
8 3 (0.95%) Pharmaceutical
8 3 (0.95%) Telecoms
9 1 (0.32%) Automotive
9 1 (0.32%) German Language
9 1 (0.32%) Investment Banking
9 1 (0.32%) Law
9 1 (0.32%) Wholesale Banking
Job Titles
1 131 (41.32%) Developer
2 92 (29.02%) DBA
3 81 (25.55%) SQL Developer
4 76 (23.97%) SQL DBA
5 52 (16.40%) SQL Server DBA
6 39 (12.30%) Architect
7 38 (11.99%) Administrator
8 27 (8.52%) Oracle Developer
9 25 (7.89%) ETL Developer
10 24 (7.57%) C++ Developer
11 22 (6.94%) Analyst
12 21 (6.62%) Senior DBA
13 18 (5.68%) SQL Server Developer
14 17 (5.36%) Business Intelligence Developer
14 17 (5.36%) Infrastructure Architect
14 17 (5.36%) Lead Architect
14 17 (5.36%) SSIS Developer
15 16 (5.05%) Database Developer
15 16 (5.05%) Unix Developer
16 15 (4.73%) NoSQL Developer
Libraries, Frameworks & Software Standards
1 36 (11.36%) Web Services
2 33 (10.41%) .NET
3 30 (9.46%) STL
4 18 (5.68%) XML
5 17 (5.36%) Middleware
6 14 (4.42%) Boost C++ Libraries
7 12 (3.79%) ASP.NET
7 12 (3.79%) MDX
8 7 (2.21%) REST
8 7 (2.21%) SOAP
9 6 (1.89%) .NET Framework
10 5 (1.58%) Ajax
10 5 (1.58%) HTML
10 5 (1.58%) Oracle GoldenGate
11 4 (1.26%) ASP.NET MVC
11 4 (1.26%) CSS
11 4 (1.26%) XHTML
11 4 (1.26%) XML Schema
12 3 (0.95%) Entity Framework
12 3 (0.95%) RESTful
Miscellaneous
1 56 (17.67%) Analytical Skills
2 46 (14.51%) Replication
3 38 (11.99%) Computer Science
4 33 (10.41%) Clustering
5 21 (6.62%) Fintech
6 18 (5.68%) Management Information System
7 14 (4.42%) Equities
7 14 (4.42%) Fixed Income
8 12 (3.79%) Enterprise Software
9 8 (2.52%) EMC VMAX
10 5 (1.58%) Reference Data
10 5 (1.58%) Taxonomies
11 4 (1.26%) N-Tier
12 3 (0.95%) Life Science
12 3 (0.95%) Online Games
12 3 (0.95%) User Experience
13 2 (0.63%) Blog
13 2 (0.63%) Data Protection Act
14 1 (0.32%) IVR
14 1 (0.32%) PKI
Operating Systems
1 64 (20.19%) Linux
2 47 (14.83%) Windows
3 40 (12.62%) Unix
4 30 (9.46%) Solaris
5 16 (5.05%) Windows Server 2008
6 15 (4.73%) Windows Server 2012
7 14 (4.42%) Red Hat Enterprise Linux
8 13 (4.10%) Windows Server
9 1 (0.32%) Android
9 1 (0.32%) Apple iOS
9 1 (0.32%) CentOS
9 1 (0.32%) Windows NT
Processes & Methodologies
1 125 (39.43%) Business Intelligence
2 123 (38.80%) Performance Tuning
3 96 (30.28%) Agile Software Development
4 87 (27.44%) ETL
5 65 (20.50%) Disaster Recovery
6 43 (13.56%) High Availability
7 42 (13.25%) Data Modelling
7 42 (13.25%) Scrum
8 40 (12.62%) Kimball Methodology
9 26 (8.20%) Data Integration
9 26 (8.20%) Time Management
10 24 (7.57%) Kanban
11 22 (6.94%) Unit Testing
12 21 (6.62%) ITIL
13 20 (6.31%) Analytics
13 20 (6.31%) System Testing
14 19 (5.99%) Dimensional Modelling
14 19 (5.99%) OO
15 18 (5.68%) SDLC
16 17 (5.36%) Migration
Programming Languages
1 256 (80.76%) SQL
2 99 (31.23%) T-SQL
3 47 (14.83%) PL/SQL
4 31 (9.78%) C++
5 21 (6.62%) C#
5 21 (6.62%) Java
6 13 (4.10%) PowerShell
7 12 (3.79%) Shell Script
8 8 (2.52%) JavaScript
8 8 (2.52%) Python
9 4 (1.26%) Data Analysis Expressions (DAX)
9 4 (1.26%) VB.NET
10 3 (0.95%) VBScript
11 2 (0.63%) PHP
11 2 (0.63%) R
12 1 (0.32%) ABAP
12 1 (0.32%) AWK
12 1 (0.32%) Objective-C
12 1 (0.32%) Ruby
12 1 (0.32%) SPARQL
Qualifications
1 41 (12.93%) Degree
2 35 (11.04%) Microsoft Certification
3 13 (4.10%) SC Cleared
3 13 (4.10%) Security Cleared
4 11 (3.47%) MCITP
5 6 (1.89%) MCSE
6 3 (0.95%) PhD
7 1 (0.32%) Oracle Certification
Quality Assurance & Compliance
1 20 (6.31%) Data Quality
2 16 (5.05%) SLA
3 10 (3.15%) QA
4 5 (1.58%) ISO20022
5 2 (0.63%) PCI DSS
System Software
1 20 (6.31%) Oracle RAC
2 16 (5.05%) VMware Infrastructure
3 15 (4.73%) Hyper-V
3 15 (4.73%) KVM
3 15 (4.73%) NFS
3 15 (4.73%) SRDF
3 15 (4.73%) Xen
4 14 (4.42%) Veritas Cluster Server
5 10 (3.15%) Active Directory
6 8 (2.52%) GlusterFS
7 5 (1.58%) HDFS
8 1 (0.32%) Docker
Systems Management
1 21 (6.62%) Puppet
2 14 (4.42%) NetBackup
3 9 (2.84%) Oracle ZFS
3 9 (2.84%) Veritas Storage Foundation
4 8 (2.52%) Red Hat Satellite
5 6 (1.89%) Oracle Enterprise Manager
6 5 (1.58%) Enterprise Manager Cloud Control
6 5 (1.58%) Oracle RMAN
7 4 (1.26%) Failover Clustering
8 3 (0.95%) Microsoft Clustering
9 1 (0.32%) Tivoli
9 1 (0.32%) Tivoli Storage Manager
Vendors
1 135 (42.59%) Microsoft
2 118 (37.22%) Oracle
3 36 (11.36%) Cognos
4 27 (8.52%) Intel
5 23 (7.26%) EMC
6 21 (6.62%) IBM
7 19 (5.99%) Talend
8 18 (5.68%) VMware
9 16 (5.05%) NetApp
10 15 (4.73%) Cisco
10 15 (4.73%) Vertica
11 14 (4.42%) Veritas
12 13 (4.10%) Red Hat
13 9 (2.84%) Brocade
13 9 (2.84%) Computacenter
13 9 (2.84%) StorageTek
13 9 (2.84%) Sun
14 7 (2.21%) SolarWinds
14 7 (2.21%) Tableau
15 6 (1.89%) Informatica
West London
Michael Bailey Associates
Salary: Market Rates
Posted: Yesterday
City, London
Spencer Rose
Salary: £60000 - £80000 per annum + pension after 6 months probation
Posted: Yesterday
Brentford
Nigel Frank International
Salary: £60000 per annum
Posted: 4 days ago
City, London
onezeero.
Salary: £70000 - £75000 per annum + Benefits + Bonus
Posted: 3 days ago
Reading, Oxfordshire
Oracle
Salary: Competitive
Posted: 3 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 9 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 9 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 8 days ago
London
asos
Salary: Competitive Salary
Posted: 9 days ago
Middlesbrough, Cleveland
The Bridge Ltd
Posted: 2 days ago
Stoke-On-Trent, Staffordshire
bet365
Salary: Competitive Base Salary + Bonus and benefits
Posted: 18 days ago
London
Reco Group
Salary: £35,000 - £60,000 per year
Posted: 20 days ago