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

Online Transaction Processing (OLTP)
UK
3 months to
30 Mar 2017
Same period 2016 Same period 2015
Rank 736 789 789
Rank change year-on-year +53 0  
Permanent jobs citing OLTP 116 161 180
As % of all permanent IT jobs advertised in the UK 0.14% 0.15% 0.17%
As % of the Database & Business Intelligence category 0.44% 0.50% 0.53%
Number of salaries quoted 86 111 122
Median salary £60,000 £55,000 £50,000
Median salary % change year-on-year +9.09% +10.00%  
90% offered a salary of more than £42,000 £35,000 £40,000
10% offered a salary of more than £77,500 £70,000 £73,850
UK excluding London median salary £52,500 £50,000 £45,000
% change year-on-year +5.00% +11.11%  

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 with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
UK
Permanent job vacancies with a requirement for database and business intelligence skills 26331 32293 33782
As % of all permanent IT job vacancies advertised in the UK 30.80% 30.88% 31.38%
Number of salaries quoted 22328 27534 28625
Median salary £47,500 £50,000 £45,000
Median salary % change year-on-year -5.00% +11.11%  
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,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

OLTP
Job Vacancy Trend

The job posting trend of jobs advertised 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 the UK

OLTP
Salary Trend

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

Salary trend for OLTP in the UK

OLTP
Salary Histogram

The salary distribution of IT jobs citing OLTP over the 3 months to 30 March 2017.

Salary histogram for OLTP 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 30 March 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 +29 109 £60,000 +9.09% 13
London +30 52 £70,000 +21.73% 7
South East +73 34 £52,500 +5.00% 2
City of London +36 14 £71,250 +23.91% 2
East Midlands +5 11 £75,000 +25.00%
Berkshire +50 10 £55,000 -
Nottingham +14 9 £75,000 -
Nottinghamshire +13 9 £75,000 -
Surrey +51 8 £52,500 +2.43%
Guildford - 8 £52,500 -
Kent - 7 £65,000 -
East of England +34 5 £46,250 -15.90% 3
Glasgow +21 5 £62,500 +56.25%
Scotland +17 5 £62,500 +56.25%
Reading - 5 - -
Wokingham - 5 £55,000 -
Buckinghamshire +20 3 £41,500 -
Milton Keynes +11 3 £41,500 -
North West -16 3 £75,000 +57.89% 1
Manchester -24 3 £75,000 +57.89% 1
West Sussex - 3 £47,500 - 1
Hatfield +29 2 £50,000 +11.11%
Yorkshire +23 2 £42,500 -32.00%
West Midlands +23 2 £52,500 +50.00%
Hertfordshire +15 2 £50,000 -9.09%
Northamptonshire +10 2 £33,000 -45.00%
West Yorkshire +8 2 £42,500 -33.33%
Stoke-on-Trent +7 2 £52,500 +41.89%
Staffordshire +6 2 £52,500 +50.00%
Wellingborough - 2 £33,000 -

For the 6 months to 30 March 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 211 (76.17%) SQL
2 165 (59.57%) SQL Server
3 134 (48.38%) OLAP
4 106 (38.27%) Microsoft
4 106 (38.27%) SQL Server Integration Services
5 103 (37.18%) Oracle
6 102 (36.82%) Performance Tuning
7 99 (35.74%) SQL Server Reporting Services
8 96 (34.66%) Data Warehouse
8 96 (34.66%) Business Intelligence
9 85 (30.69%) Agile Software Development
10 83 (29.96%) ETL
11 80 (28.88%) T-SQL
12 72 (25.99%) SQL Server Analysis Services
13 63 (22.74%) MySQL
14 61 (22.02%) Linux
15 56 (20.22%) Analytical Skills
16 54 (19.49%) Oracle OLAP
17 53 (19.13%) Disaster Recovery
18 45 (16.25%) Replication
19 43 (15.52%) PL/SQL
20 42 (15.16%) MS Excel
20 42 (15.16%) Degree
20 42 (15.16%) SQL Server 2008
21 41 (14.80%) NoSQL
22 40 (14.44%) Unix
22 40 (14.44%) Windows
22 40 (14.44%) High Availability
23 37 (13.36%) Hadoop
23 37 (13.36%) Relational Database

OLTP
Co-occurring 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 21 (7.58%) IIS
2 15 (5.42%) Apache
2 15 (5.42%) Tomcat
3 10 (3.61%) Oracle Coherence
3 10 (3.61%) Oracle HTTP Server
3 10 (3.61%) WebSphere
4 9 (3.25%) SharePoint
5 6 (2.17%) Oracle Service Bus
6 5 (1.81%) Apache Pig
6 5 (1.81%) Apache Spark
7 3 (1.08%) JBoss
7 3 (1.08%) Jupyter
7 3 (1.08%) Oracle SOA Suite
7 3 (1.08%) WebLogic
8 2 (0.72%) Cloud Foundry
8 2 (0.72%) GemFire
9 1 (0.36%) Apache Solr
Applications
1 42 (15.16%) MS Excel
2 3 (1.08%) MS Visio
Business Applications
1 5 (1.81%) FastStats
2 3 (1.08%) SAP CO
2 3 (1.08%) SAP FI
2 3 (1.08%) SAP FI/CO
2 3 (1.08%) SAP FSCM
2 3 (1.08%) SAP MM
2 3 (1.08%) SAP PS
2 3 (1.08%) SAP SD
3 1 (0.36%) Cognos TM1
3 1 (0.36%) Dynamics AX
3 1 (0.36%) Dynamics CRM
3 1 (0.36%) Dynamics NAV
3 1 (0.36%) OPENHousing
Cloud Services
1 34 (12.27%) Microsoft Azure
2 25 (9.03%) Amazon AWS
3 14 (5.05%) Cloud Computing
4 11 (3.97%) GitHub
5 10 (3.61%) IaaS
6 9 (3.25%) PaaS
7 3 (1.08%) SaaS
8 1 (0.36%) Google Cloud Platform
Communications & Networking
1 27 (9.75%) SAN
2 17 (6.14%) Fibre Channel
3 10 (3.61%) FCoE
3 10 (3.61%) HTTP
3 10 (3.61%) iSCSI
3 10 (3.61%) LAN
3 10 (3.61%) Multicast
3 10 (3.61%) NAS
3 10 (3.61%) WAN
4 9 (3.25%) Intranet
5 2 (0.72%) Extranet
5 2 (0.72%) Internet
Database & Business Intelligence
1 165 (59.57%) SQL Server
2 134 (48.38%) OLAP
3 106 (38.27%) SQL Server Integration Services
4 99 (35.74%) SQL Server Reporting Services
5 96 (34.66%) Data Warehouse
6 72 (25.99%) SQL Server Analysis Services
7 63 (22.74%) MySQL
8 54 (19.49%) Oracle OLAP
9 42 (15.16%) SQL Server 2008
10 41 (14.80%) NoSQL
11 37 (13.36%) Hadoop
11 37 (13.36%) Relational Database
12 35 (12.64%) SQL Server 2012
13 34 (12.27%) Big Data
14 30 (10.83%) Power BI
15 28 (10.11%) RDBMS
16 27 (9.75%) SQL Server 2014
17 26 (9.39%) Oracle Database
18 22 (7.94%) Microsoft Analysis Services
19 19 (6.86%) DB2
Development Applications
1 29 (10.47%) JIRA
2 26 (9.39%) Team Foundation Server
3 11 (3.97%) Talend Open Studio
3 11 (3.97%) Visual Studio
4 9 (3.25%) Git (software)
5 7 (2.53%) git-flow
5 7 (2.53%) MagicDraw
6 6 (2.17%) ERwin
7 3 (1.08%) Oracle APEX
7 3 (1.08%) VSS/SourceSafe
8 2 (0.72%) Eclipse
8 2 (0.72%) Gradle
8 2 (0.72%) Jenkins
8 2 (0.72%) JUnit
General
1 37 (13.36%) Finance
2 16 (5.78%) Advertising
3 6 (2.17%) Banking
3 6 (2.17%) Retail
4 4 (1.44%) Back Office
4 4 (1.44%) Games
4 4 (1.44%) General Ledger
5 3 (1.08%) Pharmaceutical
6 2 (0.72%) Telecoms
7 1 (0.36%) Automotive
7 1 (0.36%) Investment Banking
7 1 (0.36%) Marketing
7 1 (0.36%) Wholesale Banking
Job Titles
1 114 (41.16%) Developer
2 73 (26.35%) DBA
3 64 (23.10%) SQL Developer
4 56 (20.22%) SQL DBA
5 41 (14.80%) Architect
6 37 (13.36%) Administrator
6 37 (13.36%) SQL Server DBA
7 26 (9.39%) Oracle Developer
8 25 (9.03%) C++ Developer
9 23 (8.30%) Analyst
10 20 (7.22%) Lead Architect
11 19 (6.86%) Business Intelligence Developer
12 17 (6.14%) ETL Developer
12 17 (6.14%) Technical Architect
12 17 (6.14%) Unix Developer
13 16 (5.78%) SSIS Developer
14 15 (5.42%) Database Developer
14 15 (5.42%) SQL Analyst
14 15 (5.42%) SQL Server Developer
15 14 (5.05%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 31 (11.19%) STL
2 30 (10.83%) Web Services
3 23 (8.30%) .NET
4 15 (5.42%) Middleware
4 15 (5.42%) XML
5 14 (5.05%) Boost C++ Libraries
6 12 (4.33%) ASP.NET
7 8 (2.89%) MDX
7 8 (2.89%) Oracle GoldenGate
8 6 (2.17%) HTML
9 5 (1.81%) REST
9 5 (1.81%) SOAP
10 4 (1.44%) Ajax
10 4 (1.44%) ASP.NET MVC
10 4 (1.44%) CSS
10 4 (1.44%) XHTML
10 4 (1.44%) XML Schema
11 3 (1.08%) Entity Framework
11 3 (1.08%) SAML
11 3 (1.08%) XSL
Miscellaneous
1 56 (20.22%) Analytical Skills
2 45 (16.25%) Replication
3 36 (13.00%) Computer Science
4 27 (9.75%) Clustering
5 24 (8.66%) Fintech
6 19 (6.86%) Management Information System
7 14 (5.05%) Equities
7 14 (5.05%) Fixed Income
8 7 (2.53%) EMC VMAX
8 7 (2.53%) Enterprise Software
9 5 (1.81%) Reference Data
9 5 (1.81%) Taxonomies
10 3 (1.08%) Life Science
10 3 (1.08%) PKI
11 2 (0.72%) Blog
11 2 (0.72%) Data Protection Act
11 2 (0.72%) Linux Command Line
11 2 (0.72%) Online Games
11 2 (0.72%) Virtual Team
12 1 (0.36%) Data Structures
Operating Systems
1 61 (22.02%) Linux
2 40 (14.44%) Unix
2 40 (14.44%) Windows
3 23 (8.30%) Solaris
4 15 (5.42%) Windows Server 2008
4 15 (5.42%) Windows Server 2012
5 14 (5.05%) Red Hat Enterprise Linux
6 12 (4.33%) Windows Server
7 1 (0.36%) Windows NT
Processes & Methodologies
1 102 (36.82%) Performance Tuning
2 96 (34.66%) Business Intelligence
3 85 (30.69%) Agile Software Development
4 83 (29.96%) ETL
5 53 (19.13%) Disaster Recovery
6 40 (14.44%) High Availability
7 36 (13.00%) Data Modelling
8 32 (11.55%) Kimball Methodology
9 30 (10.83%) Scrum
10 23 (8.30%) Time Management
11 22 (7.94%) Analytics
11 22 (7.94%) Data Integration
11 22 (7.94%) ITIL
12 20 (7.22%) OO
12 20 (7.22%) System Testing
13 18 (6.50%) SDLC
14 17 (6.14%) Kanban
14 17 (6.14%) Unit Testing
15 16 (5.78%) Continuous Delivery
15 16 (5.78%) DevOps
Programming Languages
1 211 (76.17%) SQL
2 80 (28.88%) T-SQL
3 43 (15.52%) PL/SQL
4 32 (11.55%) C++
5 19 (6.86%) C#
6 13 (4.69%) Java
7 8 (2.89%) Shell Script
8 7 (2.53%) JavaScript
9 6 (2.17%) Python
10 5 (1.81%) ABAP
10 5 (1.81%) PowerShell
11 4 (1.44%) R
11 4 (1.44%) VB.NET
12 3 (1.08%) VBScript
13 2 (0.72%) Data Analysis Expressions (DAX)
14 1 (0.36%) AWK
14 1 (0.36%) PHP
14 1 (0.36%) SPARQL
14 1 (0.36%) XPath
Qualifications
1 42 (15.16%) Degree
2 22 (7.94%) Microsoft Certification
3 5 (1.81%) SC Cleared
3 5 (1.81%) Security Cleared
4 3 (1.08%) MCITP
4 3 (1.08%) PhD
5 1 (0.36%) MCSE
5 1 (0.36%) Oracle Certification
Quality Assurance & Compliance
1 21 (7.58%) Data Quality
2 16 (5.78%) SLA
3 12 (4.33%) QA
4 5 (1.81%) ISO20022
5 2 (0.72%) PCI DSS
System Software
1 16 (5.78%) Oracle RAC
2 12 (4.33%) Veritas Cluster Server
3 11 (3.97%) VMware Infrastructure
4 10 (3.61%) Active Directory
4 10 (3.61%) Hyper-V
4 10 (3.61%) KVM
4 10 (3.61%) NFS
4 10 (3.61%) SRDF
4 10 (3.61%) Xen
5 7 (2.53%) GlusterFS
6 2 (0.72%) Apache ZooKeeper
6 2 (0.72%) HDFS
Systems Management
1 12 (4.33%) NetBackup
2 9 (3.25%) Oracle Enterprise Manager
2 9 (3.25%) Puppet
3 7 (2.53%) Oracle ZFS
3 7 (2.53%) Red Hat Satellite
3 7 (2.53%) Veritas Storage Foundation
4 6 (2.17%) Enterprise Manager Cloud Control
4 6 (2.17%) Oracle RMAN
5 4 (1.44%) Failover Clustering
6 3 (1.08%) Tivoli
7 1 (0.36%) Tivoli Storage Manager
Vendors
1 106 (38.27%) Microsoft
2 103 (37.18%) Oracle
3 26 (9.39%) Cognos
4 22 (7.94%) Intel
5 18 (6.50%) IBM
6 17 (6.14%) EMC
7 14 (5.05%) Red Hat
7 14 (5.05%) Vertica
8 12 (4.33%) Veritas
9 11 (3.97%) NetApp
9 11 (3.97%) Talend
9 11 (3.97%) VMware
10 10 (3.61%) Cisco
11 7 (2.53%) Brocade
11 7 (2.53%) SolarWinds
11 7 (2.53%) StorageTek
11 7 (2.53%) Sun
11 7 (2.53%) Tableau
12 6 (2.17%) Informatica
13 5 (1.81%) Salesforce.com
City, London
onezeero.
Salary: £50000 - £65000 per annum
Posted: 10 hours ago
City, London
Rutherford Grant Recruitment
Salary: £60000.00 per annum
Posted: 15 hours ago
West London
Michael Bailey Associates
Salary: Market Rates
Posted: Yesterday
Fareham
aap3
Salary: £45000 - £51000.00 per annum + benefits package
Posted: Yesterday
London
Talent International
Salary: £350 - £500 per day
Posted: 3 days ago
Manchester, Lancashire
Mortimer Spinks
Posted: Yesterday
Cambridge
Nigel Frank International
Salary: £30000 - £50000 per annum + Benefits
Posted: 8 days ago
Central London / West End
The Workshop
Posted: 9 days ago
London
Square One Resources
Salary: From £100,000 to £120,000 per annum
Posted: 3 days ago
Haywards Heath
Nigel Frank International
Salary: £40000 - £55000 per annum + Benfits
Posted: 16 days ago
Ipswich
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits
Posted: 22 days ago
Cambridge
360 Resourcing Solutions .
Salary: £45,000 £50,000 per annum
Posted: 21 days ago