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 23 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
23 Jan 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
UK
Rank 691 754 718
Rank change year-on-year
+63 -36
Permanent jobs citing OLTP 160 164 227
As % of all permanent IT jobs located in the UK 0.19% 0.17% 0.22%
As % of the Database & Business Intelligence category 0.63% 0.52% 0.70%
Number of salaries quoted 123 120 182
Median salary £55,000 £50,000 £48,750
Median salary % change year-on-year
+10.00% +2.56%
90% offered a salary of more than £38,100 £35,000 £35,000
10% offered a salary of more than £72,500 £75,500 £72,500
UK excluding London median salary £52,500 £47,500 £42,500
% change year-on-year
+10.52% +11.76%

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
25519 31743 32640
As % of all permanent IT jobs located in the UK 30.27% 32.09% 30.99%
Number of salaries quoted 21954 26834 28017
Median salary £50,000 £48,000 £45,000
Median salary % change year-on-year
+4.16% +6.66%
90% offered a salary of more than £32,500 £32,500 £30,500
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 23 January 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 23 January 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 +75 151 £55,000 +10.00% 22
London +44 65 £65,000 +18.18% 12
South East +103 55 £52,500 +16.66% 6
West Sussex +14 19 £48,000 +6.66%
East of England +35 15 £55,000 -12.00% 1
Surrey +57 12 £55,000 +12.82%
Guildford - 9 £55,000 -
City of London +14 6 £66,250 +15.21% 3
North West -22 6 £37,500 -21.05%
Suffolk - 6 £42,500 - 1
Ipswich - 6 £42,500 - 1
Scotland +19 5 £46,000 - 1
Manchester -30 5 £37,500 -21.05%
Gatwick - 5 £57,500 -
Glasgow - 5 £46,000 - 1
Bedfordshire - 5 £58,500 -
Milton Keynes +17 4 £41,500 -2.35%
Buckinghamshire +14 4 £41,500 -2.35%
Kent +8 4 £65,000 +18.18% 3
East Midlands - 4 £43,250 - 3
Berkshire +33 3 - -
West Yorkshire +20 3 - -
Yorkshire +17 3 - -
Reading - 3 - -
Hertfordshire +12 2 £30,000 -52.00%
Crawley +6 2 £44,500 +11.25%
Bradford +2 2 - -
Stevenage - 2 £30,000 -
Folkestone - 2 £35,000 - 2
Leicester - 2 £36,500 - 1

OLTP
Top 30 Related IT Skills

For the 6 months to 23 January 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 286 (84.62%) SQL
2 227 (67.16%) SQL Server
3 175 (51.78%) OLAP
4 141 (41.72%) Microsoft
5 135 (39.94%) Performance Tuning
6 134 (39.64%) SQL Server Integration Services
7 130 (38.46%) Data Warehouse
8 128 (37.87%) T-SQL
9 124 (36.69%) Business Intelligence
10 123 (36.39%) SQL Server Reporting Services
11 117 (34.62%) Oracle
12 104 (30.77%) Agile Software Development
13 100 (29.59%) SQL Server Analysis Services
14 88 (26.04%) ETL
15 85 (25.15%) MySQL
16 72 (21.30%) MS Excel
16 72 (21.30%) Disaster Recovery
17 71 (21.01%) Oracle OLAP
18 64 (18.93%) Linux
19 62 (18.34%) SQL Server 2008
20 61 (18.05%) NoSQL
21 56 (16.57%) Analytical Skills
21 56 (16.57%) Windows
22 55 (16.27%) Finance
23 48 (14.20%) High Availability
24 47 (13.91%) Relational Database
24 47 (13.91%) Replication
25 45 (13.31%) PL/SQL
25 45 (13.31%) Data Modelling
26 44 (13.02%) Degree

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 30 (8.88%) IIS
2 20 (5.92%) Apache
3 19 (5.62%) Oracle Coherence
3 19 (5.62%) Oracle HTTP Server
3 19 (5.62%) Tomcat
3 19 (5.62%) WebSphere
4 12 (3.55%) Apache Pig
4 12 (3.55%) SharePoint
5 5 (1.48%) Jupyter
6 3 (0.89%) Oracle Service Bus
6 3 (0.89%) Oracle SOA Suite
7 2 (0.59%) Apache Spark
8 1 (0.30%) Apache Solr
Applications
1 72 (21.30%) MS Excel
2 2 (0.59%) MS Visio
Business Applications
1 6 (1.78%) FastStats
2 2 (0.59%) Cognos TM1
3 1 (0.30%) Dynamics AX
3 1 (0.30%) Dynamics CRM
3 1 (0.30%) Dynamics NAV
3 1 (0.30%) OPENHousing
Cloud Services
1 30 (8.88%) Amazon AWS
2 28 (8.28%) Microsoft Azure
3 20 (5.92%) GitHub
4 8 (2.37%) IaaS
4 8 (2.37%) PaaS
5 6 (1.78%) Cloud Computing
6 5 (1.48%) Amazon S3
7 3 (0.89%) Google Cloud Platform
7 3 (0.89%) SaaS
Communications & Networking
1 40 (11.83%) SAN
2 30 (8.88%) Fibre Channel
3 20 (5.92%) LAN
3 20 (5.92%) WAN
4 19 (5.62%) FCoE
4 19 (5.62%) HTTP
4 19 (5.62%) iSCSI
4 19 (5.62%) Multicast
4 19 (5.62%) NAS
5 8 (2.37%) Intranet
6 2 (0.59%) Extranet
6 2 (0.59%) Firewall
6 2 (0.59%) Internet
6 2 (0.59%) LDAP
6 2 (0.59%) VoIP
7 1 (0.30%) PABX
7 1 (0.30%) Wi-Fi
Database & Business Intelligence
1 227 (67.16%) SQL Server
2 175 (51.78%) OLAP
3 134 (39.64%) SQL Server Integration Services
4 130 (38.46%) Data Warehouse
5 123 (36.39%) SQL Server Reporting Services
6 100 (29.59%) SQL Server Analysis Services
7 85 (25.15%) MySQL
8 71 (21.01%) Oracle OLAP
9 62 (18.34%) SQL Server 2008
10 61 (18.05%) NoSQL
11 47 (13.91%) Relational Database
12 44 (13.02%) Hadoop
13 43 (12.72%) Big Data
14 41 (12.13%) SQL Server 2012
15 38 (11.24%) Power BI
16 37 (10.95%) RDBMS
17 30 (8.88%) Microsoft Analysis Services
18 27 (7.99%) SQL Server 2005
19 26 (7.69%) DB2
19 26 (7.69%) SQL Server 2014
Development Applications
1 44 (13.02%) JIRA
2 29 (8.58%) Team Foundation Server
3 19 (5.62%) Talend Open Studio
4 11 (3.25%) Visual Studio
5 10 (2.96%) Jenkins
6 9 (2.66%) Cucumber
6 9 (2.66%) ERwin
6 9 (2.66%) Vagrant
7 7 (2.07%) Git (software)
7 7 (2.07%) git-flow
8 6 (1.78%) MagicDraw
9 5 (1.48%) Oracle APEX
9 5 (1.48%) VSS/SourceSafe
10 2 (0.59%) FitNesse
10 2 (0.59%) JBehave
10 2 (0.59%) SQL Server Management Studio (SSMS)
11 1 (0.30%) TeamCity
General
1 55 (16.27%) Finance
2 12 (3.55%) Retail
3 11 (3.25%) Advertising
4 7 (2.07%) Banking
5 6 (1.78%) Games
5 6 (1.78%) Marketing
6 5 (1.48%) Back Office
6 5 (1.48%) Manufacturing
7 4 (1.18%) General Ledger
7 4 (1.18%) Pharmaceutical
8 3 (0.89%) Legal
8 3 (0.89%) Telecoms
9 1 (0.30%) German Language
9 1 (0.30%) Investment Banking
9 1 (0.30%) Law
Job Titles
1 136 (40.24%) Developer
2 107 (31.66%) DBA
3 89 (26.33%) SQL DBA
3 89 (26.33%) SQL Developer
4 65 (19.23%) SQL Server DBA
5 43 (12.72%) Administrator
6 36 (10.65%) Architect
7 29 (8.58%) Senior DBA
8 26 (7.69%) Oracle Developer
9 24 (7.10%) ETL Developer
10 21 (6.21%) Analyst
10 21 (6.21%) Lead Architect
11 20 (5.92%) Business Intelligence Developer
11 20 (5.92%) Infrastructure Architect
11 20 (5.92%) SSIS Developer
12 19 (5.62%) C++ Developer
12 19 (5.62%) SQL Server Developer
13 17 (5.03%) Senior SQL DBA
14 16 (4.73%) Database Developer
15 15 (4.44%) Unix Developer
Libraries, Frameworks & Software Standards
1 40 (11.83%) Web Services
2 30 (8.88%) .NET
3 25 (7.40%) STL
3 25 (7.40%) XML
4 22 (6.51%) MDX
5 20 (5.92%) Middleware
6 12 (3.55%) REST
7 11 (3.25%) ASP.NET
8 10 (2.96%) Boost C++ Libraries
9 7 (2.07%) SOAP
10 6 (1.78%) JSON
11 5 (1.48%) .NET Framework
11 5 (1.48%) Oracle GoldenGate
12 4 (1.18%) Ajax
12 4 (1.18%) ASP.NET MVC
12 4 (1.18%) HTML
12 4 (1.18%) XML Schema
13 3 (0.89%) CSS
13 3 (0.89%) XHTML
13 3 (0.89%) XSL
Miscellaneous
1 56 (16.57%) Analytical Skills
2 47 (13.91%) Replication
3 39 (11.54%) Clustering
3 39 (11.54%) Computer Science
4 23 (6.80%) Data Integration
5 18 (5.33%) Fintech
6 17 (5.03%) Management Information System
7 14 (4.14%) Enterprise Software
8 13 (3.85%) Statistics
9 10 (2.96%) Equities
9 10 (2.96%) Fixed Income
10 9 (2.66%) EMC VMAX
11 7 (2.07%) Visualisation
12 6 (1.78%) N-Tier
13 5 (1.48%) User Experience
14 4 (1.18%) Ontologies
14 4 (1.18%) Reference Data
14 4 (1.18%) Taxonomies
15 3 (0.89%) Life Science
15 3 (0.89%) Mathematics
Operating Systems
1 64 (18.93%) Linux
2 56 (16.57%) Windows
3 39 (11.54%) Unix
4 35 (10.36%) Solaris
5 15 (4.44%) Red Hat Enterprise Linux
6 13 (3.85%) Windows Server
6 13 (3.85%) Windows Server 2008
7 11 (3.25%) Windows Server 2012
8 1 (0.30%) Android
8 1 (0.30%) Apple iOS
8 1 (0.30%) CentOS
8 1 (0.30%) Windows NT
Processes & Methodologies
1 135 (39.94%) Performance Tuning
2 124 (36.69%) Business Intelligence
3 104 (30.77%) Agile Software Development
4 88 (26.04%) ETL
5 72 (21.30%) Disaster Recovery
6 48 (14.20%) High Availability
7 45 (13.31%) Data Modelling
8 43 (12.72%) Kimball Methodology
9 42 (12.43%) Scrum
10 26 (7.69%) Time Management
11 24 (7.10%) Kanban
12 21 (6.21%) Analytics
13 20 (5.92%) Migration
13 20 (5.92%) OO
14 19 (5.62%) Benchmarking
14 19 (5.62%) Dimensional Modelling
14 19 (5.62%) Risk Management
15 18 (5.33%) Unit Testing
16 17 (5.03%) E-Commerce
16 17 (5.03%) Mentoring
Programming Languages
1 286 (84.62%) SQL
2 128 (37.87%) T-SQL
3 45 (13.31%) PL/SQL
4 26 (7.69%) C++
5 21 (6.21%) Java
6 20 (5.92%) C#
7 13 (3.85%) PowerShell
8 10 (2.96%) Shell Script
9 8 (2.37%) Data Analysis Expressions (DAX)
9 8 (2.37%) JavaScript
9 8 (2.37%) Python
10 2 (0.59%) R
10 2 (0.59%) VB.NET
10 2 (0.59%) VBScript
11 1 (0.30%) AWK
11 1 (0.30%) Objective-C
11 1 (0.30%) PHP
11 1 (0.30%) Ruby
Qualifications
1 44 (13.02%) Degree
2 32 (9.47%) Microsoft Certification
3 14 (4.14%) SC Cleared
3 14 (4.14%) Security Cleared
4 13 (3.85%) MCITP
5 5 (1.48%) MCSE
6 3 (0.89%) PhD
Quality Assurance & Compliance
1 16 (4.73%) Data Quality
1 16 (4.73%) SLA
2 7 (2.07%) QA
3 5 (1.48%) ISO20022
4 2 (0.59%) PCI DSS
System Software
1 22 (6.51%) Oracle RAC
2 21 (6.21%) VMware Infrastructure
3 19 (5.62%) Hyper-V
3 19 (5.62%) KVM
3 19 (5.62%) NFS
3 19 (5.62%) SRDF
3 19 (5.62%) Xen
4 16 (4.73%) Veritas Cluster Server
5 9 (2.66%) Active Directory
5 9 (2.66%) GlusterFS
6 5 (1.48%) HDFS
7 2 (0.59%) Virtual Machines
7 2 (0.59%) VMware ESX
7 2 (0.59%) vSphere
8 1 (0.30%) Docker
Systems Management
1 21 (6.21%) Puppet
2 16 (4.73%) NetBackup
3 11 (3.25%) Oracle ZFS
3 11 (3.25%) Veritas Storage Foundation
4 9 (2.66%) Microsoft Clustering
4 9 (2.66%) Red Hat Satellite
5 4 (1.18%) Failover Clustering
6 3 (0.89%) Enterprise Manager Cloud Control
6 3 (0.89%) Oracle Enterprise Manager
6 3 (0.89%) Oracle RMAN
7 1 (0.30%) Tivoli Storage Manager
Vendors
1 141 (41.72%) Microsoft
2 117 (34.62%) Oracle
3 38 (11.24%) Cognos
4 29 (8.58%) Intel
5 28 (8.28%) EMC
5 28 (8.28%) VMware
6 26 (7.69%) IBM
7 22 (6.51%) NetApp
8 19 (5.62%) Cisco
8 19 (5.62%) Talend
9 16 (4.73%) Veritas
10 14 (4.14%) Red Hat
11 11 (3.25%) Brocade
11 11 (3.25%) Computacenter
11 11 (3.25%) StorageTek
11 11 (3.25%) Sun
11 11 (3.25%) Vertica
12 8 (2.37%) SolarWinds
13 7 (2.07%) Tableau
14 5 (1.48%) Salesforce.com
West London
Michael Bailey Associates
Salary: Market Rates
Posted: 3 days ago
West Malling, Kent
Anthony James Consulting
Salary: From £60,000 to £70,000 per annum
Posted: 5 days ago
Folkestone
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits
Posted: 12 days ago
South East
Lawrence Harvey Enterprise
Salary: £65000.00 - £80000.00 per annum
Posted: 6 days ago
Ipswich
Nigel Frank International
Salary: £35000 - £50000 per annum
Posted: 14 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 11 days ago
London
Huxley
Salary: £60000 - £70000 per annum + Excellent Benefits
Posted: 14 days ago
South East England
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum
Posted: 13 days ago
Hampshire
Venturi
Salary: £45000 - £48000.00 per annum + full benefits
Posted: 19 days ago
London
Huxley
Salary: £60000 - £70000 per annum + Excellent Benefits
Posted: 19 days ago
London
Pioneer Search
Salary: £60000 - £90000 per annum + Competitive Bonus + Benefits
Posted: 6 days ago
Glasgow, Lanarkshire
BJSS Ltd
Salary: From £75,000 to £90,000 per annum Bonus, Health & Pension
Posted: 4 days ago
City of London
Huxley
Salary: £55000 - £70000 per annum + Package
Posted: 14 days ago
Leicester, Leicestershire
TriMas Corporation
Posted: 12 days ago
London
Client Server
Salary: £30000 - £45000 per annum + benefits
Posted: 12 days ago
City of London
Huxley
Salary: £55000 - £70000 per annum + Package
Posted: 18 days ago
London
Client Server
Salary: £35k to £45k + benefits
Posted: 19 days ago
City, London
BJSS Ltd
Salary: From £90,000 to £105,000 per annum Bonus, Health & Pension
Posted: 13 days ago
Nottingham, Nottinghamshire
BJSS Ltd
Salary: From £75,000 to £90,000 per annum Bonus, Health & Pension
Posted: 13 days ago
Folkestone
Edward Carter Solutions
Salary: £5000 per annum + Fantastic benefits
Posted: 25 days ago