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 8 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
8 Dec 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 714 769 706
Rank change year-on-year
+55 -63
Permanent jobs citing OLTP 167 205 291
As % of all permanent IT jobs located in the UK 0.19% 0.19% 0.26%
As % of the Database & Business Intelligence category 0.62% 0.60% 0.83%
Number of salaries quoted 121 152 212
Median salary £52,500 £55,000 £50,000
Median salary % change year-on-year
-4.54% +10.00%
90% offered a salary of more than £37,500 £40,250 £35,000
10% offered a salary of more than £69,500 £80,000 £72,250
UK excluding London median salary £51,250 £50,000 £40,000
% change year-on-year
+2.50% +25.00%

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
26928 33987 34858
As % of all permanent IT jobs located in the UK 29.98% 31.93% 30.71%
Number of salaries quoted 23062 28622 29771
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 £30,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 8 December 2016 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 8 December 2016. 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
(Click see detailed
statistics and trends)
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 +30 157 £52,500 -4.54% 12
London +35 73 £62,500 +4.16% 4
South East +63 41 £52,500 +5.00% 4
East of England +20 22 £48,750 -26.41% 3
West Sussex +43 21 £48,000 +6.66% 1
City of London +30 11 £66,000 +3.52% 1
Hertfordshire +8 10 £30,000 -51.02% 1
North West -35 10 £42,750 -10.00% 1
Bedfordshire - 10 £52,500 - 1
Manchester -25 9 £47,500 - 1
Scotland +28 7 £46,000 -
Glasgow - 7 £46,000 -
Surrey +33 6 £52,500 -16.00%
East Midlands - 6 £36,500 -
Gatwick +4 5 £58,500 +46.25%
Leicestershire - 5 £36,500 -
Leicester - 5 £36,500 -
Bishop's Stortford - 4 - -
Luton - 4 £46,250 - 1
Berkshire +45 3 £52,500 -4.54% 1
Reading +32 3 £52,500 -4.54% 1
West Midlands -14 3 £47,500 -9.52%
Cardiff +4 2 £38,750 +29.16%
South Wales -2 2 £38,750 +29.16%
Wales -6 2 £38,750 +29.16%
Staffordshire -21 2 £50,000 +49.25%
Stoke-on-Trent -22 2 £50,000 -9.09%
Stevenage - 2 £30,000 - 1
West Yorkshire +30 1 - -
Leeds +25 1 - -

OLTP
Top 30 Related IT Skills

For the 6 months to 8 December 2016, 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 312 (84.78%) SQL
2 258 (70.11%) SQL Server
3 194 (52.72%) OLAP
4 156 (42.39%) T-SQL
5 155 (42.12%) Data Warehouse
6 144 (39.13%) Microsoft
7 143 (38.86%) Performance Tuning
8 132 (35.87%) SQL Server Integration Services
9 126 (34.24%) Business Intelligence
10 124 (33.70%) SQL Server Reporting Services
11 115 (31.25%) Oracle
12 104 (28.26%) SQL Server Analysis Services
13 101 (27.45%) Agile Software Development
14 91 (24.73%) MySQL
15 90 (24.46%) MS Excel
16 82 (22.28%) ETL
17 69 (18.75%) Finance
18 67 (18.21%) Oracle OLAP
19 64 (17.39%) Linux
20 62 (16.85%) Disaster Recovery
21 61 (16.58%) SQL Server 2008
22 60 (16.30%) Windows
23 59 (16.03%) Degree
24 56 (15.22%) Analytical Skills
25 55 (14.95%) NoSQL
26 49 (13.32%) SAN
27 47 (12.77%) Web Services
27 47 (12.77%) Relational Database
28 46 (12.50%) Kimball Methodology
29 44 (11.96%) PL/SQL

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 (7.34%) IIS
2 25 (6.79%) Apache
3 24 (6.52%) Oracle Coherence
3 24 (6.52%) Oracle HTTP Server
3 24 (6.52%) Tomcat
3 24 (6.52%) WebSphere
4 11 (2.99%) Apache Pig
5 8 (2.17%) SharePoint
6 4 (1.09%) Jupyter
7 2 (0.54%) Apache Spark
7 2 (0.54%) Oracle SOA Suite
8 1 (0.27%) Apache Solr
Applications
1 90 (24.46%) MS Excel
2 1 (0.27%) MS Office
2 1 (0.27%) MS Visio
Business Applications
1 4 (1.09%) FastStats
2 2 (0.54%) Cognos TM1
3 1 (0.27%) Dynamics AX
3 1 (0.27%) Dynamics CRM
3 1 (0.27%) Dynamics NAV
3 1 (0.27%) OPENHousing
Cloud Services
1 26 (7.07%) Amazon AWS
2 18 (4.89%) GitHub
2 18 (4.89%) Microsoft Azure
3 6 (1.63%) IaaS
3 6 (1.63%) PaaS
4 5 (1.36%) Amazon S3
5 4 (1.09%) Cloud Computing
6 3 (0.82%) Google Cloud Platform
6 3 (0.82%) SaaS
Communications & Networking
1 49 (13.32%) SAN
2 34 (9.24%) Fibre Channel
3 25 (6.79%) LAN
3 25 (6.79%) WAN
4 24 (6.52%) FCoE
4 24 (6.52%) HTTP
4 24 (6.52%) iSCSI
4 24 (6.52%) Multicast
4 24 (6.52%) NAS
5 9 (2.45%) Extranet
5 9 (2.45%) Firewall
5 9 (2.45%) Intranet
6 2 (0.54%) Internet
6 2 (0.54%) LDAP
6 2 (0.54%) Skype
6 2 (0.54%) VoIP
7 1 (0.27%) PABX
7 1 (0.27%) Wi-Fi
Database & Business Intelligence
1 258 (70.11%) SQL Server
2 194 (52.72%) OLAP
3 155 (42.12%) Data Warehouse
4 132 (35.87%) SQL Server Integration Services
5 124 (33.70%) SQL Server Reporting Services
6 104 (28.26%) SQL Server Analysis Services
7 91 (24.73%) MySQL
8 67 (18.21%) Oracle OLAP
9 61 (16.58%) SQL Server 2008
10 55 (14.95%) NoSQL
11 47 (12.77%) Relational Database
12 39 (10.60%) SQL Server 2012
13 36 (9.78%) DB2
14 35 (9.51%) Big Data
15 33 (8.97%) RDBMS
16 31 (8.42%) SQL Server 2005
17 30 (8.15%) Power BI
18 28 (7.61%) Hadoop
19 26 (7.07%) MongoDB
19 26 (7.07%) SQL Server 2014
Development Applications
1 42 (11.41%) JIRA
2 20 (5.43%) Team Foundation Server
3 13 (3.53%) Talend Open Studio
4 11 (2.99%) Jenkins
5 9 (2.45%) Cucumber
5 9 (2.45%) ERwin
5 9 (2.45%) Vagrant
6 6 (1.63%) Git (software)
6 6 (1.63%) MagicDraw
6 6 (1.63%) Oracle APEX
6 6 (1.63%) VSS/SourceSafe
7 5 (1.36%) git-flow
7 5 (1.36%) SQL Server Management Studio (SSMS)
7 5 (1.36%) Visual Studio
8 3 (0.82%) tSQLt
9 2 (0.54%) FitNesse
9 2 (0.54%) JBehave
10 1 (0.27%) TeamCity
General
1 69 (18.75%) Finance
2 21 (5.71%) Retail
3 10 (2.72%) Banking
4 8 (2.17%) Marketing
5 7 (1.90%) Telecoms
6 6 (1.63%) Advertising
6 6 (1.63%) Pharmaceutical
7 5 (1.36%) Back Office
7 5 (1.36%) Games
7 5 (1.36%) Manufacturing
8 4 (1.09%) General Ledger
9 3 (0.82%) Legal
10 1 (0.27%) German Language
10 1 (0.27%) Investment Banking
10 1 (0.27%) Law
Job Titles
1 159 (43.21%) Developer
2 112 (30.43%) DBA
3 102 (27.72%) SQL Developer
4 97 (26.36%) SQL DBA
5 68 (18.48%) SQL Server DBA
6 46 (12.50%) Architect
7 38 (10.33%) Administrator
8 32 (8.70%) Senior DBA
9 30 (8.15%) Oracle Developer
10 27 (7.34%) Infrastructure Architect
10 27 (7.34%) SQL Server Developer
11 25 (6.79%) Lead Architect
12 24 (6.52%) Business Intelligence Developer
13 22 (5.98%) Senior SQL DBA
14 21 (5.71%) Analyst
14 21 (5.71%) Senior Developer
15 20 (5.43%) C++ Developer
15 20 (5.43%) ETL Developer
16 18 (4.89%) Database Developer
16 18 (4.89%) SSIS Developer
Libraries, Frameworks & Software Standards
1 47 (12.77%) Web Services
2 34 (9.24%) XML
3 32 (8.70%) .NET
4 25 (6.79%) MDX
4 25 (6.79%) Middleware
5 22 (5.98%) STL
6 15 (4.08%) REST
7 12 (3.26%) ASP.NET
8 11 (2.99%) Oracle GoldenGate
9 9 (2.45%) SOAP
10 8 (2.17%) JSON
11 6 (1.63%) Boost C++ Libraries
12 5 (1.36%) .NET Framework
12 5 (1.36%) ASP.NET MVC
13 4 (1.09%) Ajax
13 4 (1.09%) HTML
13 4 (1.09%) WCF
13 4 (1.09%) XML Schema
14 3 (0.82%) Django
14 3 (0.82%) WF
Miscellaneous
1 56 (15.22%) Analytical Skills
2 44 (11.96%) Computer Science
3 43 (11.68%) Replication
4 41 (11.14%) Clustering
5 34 (9.24%) Enterprise Software
6 20 (5.43%) Fintech
7 19 (5.16%) Management Information System
8 16 (4.35%) Data Integration
9 8 (2.17%) EMC VMAX
9 8 (2.17%) Statistics
10 6 (1.63%) Equities
10 6 (1.63%) Fixed Income
10 6 (1.63%) N-Tier
10 6 (1.63%) User Experience
11 5 (1.36%) Data Protection Act
11 5 (1.36%) Life Science
11 5 (1.36%) Microsoft Licensing
12 4 (1.09%) Ontologies
12 4 (1.09%) Reference Data
12 4 (1.09%) Taxonomies
Operating Systems
1 64 (17.39%) Linux
2 60 (16.30%) Windows
3 39 (10.60%) Solaris
4 35 (9.51%) Unix
5 14 (3.80%) Red Hat Enterprise Linux
6 13 (3.53%) Windows Server
7 7 (1.90%) Windows Server 2008
8 3 (0.82%) Windows Server 2012
9 1 (0.27%) Android
9 1 (0.27%) Apple iOS
9 1 (0.27%) CentOS
Processes & Methodologies
1 143 (38.86%) Performance Tuning
2 126 (34.24%) Business Intelligence
3 101 (27.45%) Agile Software Development
4 82 (22.28%) ETL
5 62 (16.85%) Disaster Recovery
6 46 (12.50%) Kimball Methodology
7 41 (11.14%) Data Modelling
8 40 (10.87%) High Availability
9 37 (10.05%) Scrum
10 28 (7.61%) OO
11 24 (6.52%) Benchmarking
11 24 (6.52%) Dimensional Modelling
11 24 (6.52%) Risk Management
12 21 (5.71%) Kanban
12 21 (5.71%) Migration
12 21 (5.71%) Time Management
13 20 (5.43%) Data Management
13 20 (5.43%) Mentoring
14 18 (4.89%) Unit Testing
15 17 (4.62%) Analytics
Programming Languages
1 312 (84.78%) SQL
2 156 (42.39%) T-SQL
3 44 (11.96%) PL/SQL
4 32 (8.70%) Java
5 27 (7.34%) C#
6 22 (5.98%) C++
7 18 (4.89%) PowerShell
8 13 (3.53%) JavaScript
9 11 (2.99%) Data Analysis Expressions (DAX)
10 10 (2.72%) Python
11 7 (1.90%) Shell Script
12 2 (0.54%) R
13 1 (0.27%) AWK
13 1 (0.27%) C
13 1 (0.27%) Objective-C
13 1 (0.27%) PHP
13 1 (0.27%) Ruby
13 1 (0.27%) VB.NET
13 1 (0.27%) VBA
13 1 (0.27%) VBScript
Qualifications
1 59 (16.03%) Degree
2 30 (8.15%) Microsoft Certification
3 13 (3.53%) MCITP
3 13 (3.53%) SC Cleared
3 13 (3.53%) Security Cleared
4 8 (2.17%) MCSE
5 5 (1.36%) PhD
6 3 (0.82%) MCP
6 3 (0.82%) MCSA
7 1 (0.27%) CISSP
7 1 (0.27%) Oracle Certification
Quality Assurance & Compliance
1 14 (3.80%) Data Quality
2 12 (3.26%) SLA
3 11 (2.99%) QA
4 5 (1.36%) ISO20022
5 3 (0.82%) PCI DSS
System Software
1 29 (7.88%) VMware Infrastructure
2 25 (6.79%) Oracle RAC
3 24 (6.52%) Hyper-V
3 24 (6.52%) KVM
3 24 (6.52%) NFS
3 24 (6.52%) SRDF
3 24 (6.52%) Xen
4 15 (4.08%) Veritas Cluster Server
5 8 (2.17%) GlusterFS
6 5 (1.36%) HDFS
6 5 (1.36%) Virtual Machines
6 5 (1.36%) VMware ESX
6 5 (1.36%) vSphere
7 1 (0.27%) Active Directory
7 1 (0.27%) Docker
Systems Management
1 19 (5.16%) Puppet
2 15 (4.08%) NetBackup
3 14 (3.80%) Microsoft Clustering
4 10 (2.72%) Oracle ZFS
4 10 (2.72%) Veritas Storage Foundation
5 8 (2.17%) Red Hat Satellite
6 3 (0.82%) Failover Clustering
7 1 (0.27%) Ansible
7 1 (0.27%) Perfmon
7 1 (0.27%) Tivoli Storage Manager
Vendors
1 144 (39.13%) Microsoft
2 115 (31.25%) Oracle
3 40 (10.87%) VMware
4 35 (9.51%) IBM
5 32 (8.70%) Cognos
5 32 (8.70%) EMC
6 30 (8.15%) Intel
6 30 (8.15%) NetApp
7 24 (6.52%) Cisco
8 15 (4.08%) Veritas
9 13 (3.53%) Computacenter
9 13 (3.53%) Red Hat
9 13 (3.53%) Talend
10 10 (2.72%) Brocade
10 10 (2.72%) StorageTek
10 10 (2.72%) Sun
10 10 (2.72%) Tableau
11 7 (1.90%) Vertica
12 6 (1.63%) RedGate
13 5 (1.36%) SolarWinds
South East
Austin Fraser
Salary: £55000 - £65000 per annum + Bonus + Benefits
Posted: 4 hours ago
London
Pioneer Search
Salary: £60000.00 - £85000.00 per annum + Competitive Bonus + Benefits
Posted: 11 hours ago
Crawley
Nigel Frank International
Salary: £50000 - £65000 per annum + Benefits
Posted: 2 days ago
Tunbridge Wells
Nigel Frank International
Salary: £30000 - £55000 per annum + Pensions, Benefits
Posted: 2 days ago
City, London
Client Server
Salary: £35k to £45k + benefits
Posted: Yesterday
London
Client Server
Salary: £35k to £45k + benefits
Posted: Yesterday
UK
Nigel Frank International Ltd
Salary: £40000 - £60000 per annum + Travel, Car, Pension
Posted: 3 days ago
Stevenage, Hertfordshire
Nigel Frank International Ltd
Salary: £25000 - £32000 per annum + Benefits
Posted: 6 days ago
Ipswich, Suffolk
Hurren and Hope
Salary: £45k - 50k per year + 2017 benefit pack
Posted: 6 days ago
Central London / West End
Client Server
Salary: £35k to £45k + benefits
Posted: 6 days ago
Reading
Oracle
Salary: Competitive
Posted: 8 days ago
Manchester
Adria Solutions Ltd
Salary: £30000 - £45000 per annum + Benefits
Posted: 27 days ago
Luton
easyJet Airline
Posted: 17 days ago