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

3 months to
24 Sep 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 718 692 714
Rank change year-on-year
-26 +22
Permanent jobs citing OLTP 193 273 273
As % of all permanent IT jobs located in the UK 0.20% 0.25% 0.24%
As % of the Database & Business Intelligence category 0.69% 0.81% 0.76%
Number of salaries quoted 144 189 191
Median salary £50,000 £55,000 £50,000
Median salary % change year-on-year
-9.09% +10.00%
90% offered a salary of more than £35,000 £37,500 £37,500
10% offered a salary of more than £67,500 £70,000 £70,000
UK excluding London median salary £50,000 £50,000 £45,000
% change year-on-year
- +11.11%

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
27899 33705 35855
As % of all permanent IT jobs located in the UK 29.60% 30.81% 31.39%
Number of salaries quoted 23759 28514 30081
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 £67,500 £72,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 24 September 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 24 September 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 -22 186 £50,000 -9.09% 7
South East +31 60 £52,500 +10.52% 2
London -25 56 £55,000 -8.33% 3
East Midlands +37 22 £33,500 -50.37%
West Sussex +31 21 £58,500 +30.00%
South West +2 19 £50,000 -16.66%
Hampshire +17 17 £50,000 +42.85% 1
Southampton - 16 £50,000 - 1
Leicestershire - 15 £33,500 -
East of England +25 13 £40,000 -42.85% 2
Cornwall - 12 £50,000 -
Leicester - 12 £33,500 -
Berkshire +2 11 £55,000 +22.22% 1
North West +15 10 £52,500 +10.52%
Manchester -10 9 £52,500 +10.52%
Camborne - 9 £50,000 -
Hertfordshire +23 8 - -
Slough +21 8 £55,000 +25.71%
Oxfordshire - 8 £60,000 -
City of London +20 7 £66,000 -2.22%
Gatwick +3 5 £58,500 +46.25%
Nottinghamshire - 5 - -
Nottingham - 5 - -
Abingdon - 5 - -
Bristol +5 4 £82,500 +37.50%
Suffolk - 4 £40,000 - 1
Yorkshire +9 3 £85,000 +36.00%
West Yorkshire +1 3 £85,000 +36.00%
Staffordshire -12 3 £52,500 +64.06%
Stoke-on-Trent -15 3 £52,500 +25.74%

OLTP
Top 30 Related IT Skills

For the 6 months to 24 September 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 310 (82.45%) SQL
2 249 (66.22%) SQL Server
3 204 (54.26%) OLAP
4 162 (43.09%) T-SQL
5 161 (42.82%) Data Warehouse
6 141 (37.50%) Performance Tuning
7 138 (36.70%) Business Intelligence
8 127 (33.78%) Microsoft
8 127 (33.78%) SQL Server Integration Services
9 117 (31.12%) Oracle
9 117 (31.12%) SQL Server Reporting Services
10 98 (26.06%) MS Excel
11 97 (25.80%) ETL
12 94 (25.00%) SQL Server Analysis Services
13 92 (24.47%) Finance
14 86 (22.87%) Agile Software Development
15 79 (21.01%) MySQL
16 69 (18.35%) Degree
17 66 (17.55%) SQL Server 2008
18 59 (15.69%) Oracle OLAP
19 57 (15.16%) Windows
20 55 (14.63%) Linux
21 50 (13.30%) Analytical Skills
22 49 (13.03%) Kimball Methodology
23 48 (12.77%) Relational Database
24 47 (12.50%) Disaster Recovery
25 46 (12.23%) PL/SQL
26 44 (11.70%) OO
27 42 (11.17%) NoSQL
27 42 (11.17%) SQL Server 2012

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 22 (5.85%) IIS
2 21 (5.59%) Apache
3 20 (5.32%) Oracle Coherence
3 20 (5.32%) Oracle HTTP Server
3 20 (5.32%) Tomcat
3 20 (5.32%) WebSphere
4 9 (2.39%) SharePoint
5 7 (1.86%) Apache Pig
6 3 (0.80%) Oracle Spatial
7 2 (0.53%) Jupyter
7 2 (0.53%) Oracle Workflow
8 1 (0.27%) Apache Solr
8 1 (0.27%) Apache Spark
8 1 (0.27%) SharePoint 2013
8 1 (0.27%) WebLogic
Applications
1 98 (26.06%) MS Excel
2 5 (1.33%) MS Office
3 1 (0.27%) MS Visio
Business Applications
1 5 (1.33%) Cognos Business Intelligence
2 2 (0.53%) Endur
2 2 (0.53%) SAP FI
2 2 (0.53%) Unica
3 1 (0.27%) Cognos TM1
3 1 (0.27%) FastStats
3 1 (0.27%) SAP CRM
3 1 (0.27%) SAP ERP
3 1 (0.27%) SAP SCM
Cloud Services
1 12 (3.19%) Amazon AWS
2 11 (2.93%) GitHub
3 5 (1.33%) Amazon S3
4 4 (1.06%) Cloud Computing
4 4 (1.06%) Microsoft Azure
5 3 (0.80%) PaaS
6 2 (0.53%) Google Cloud Platform
6 2 (0.53%) IaaS
6 2 (0.53%) SaaS
Communications & Networking
1 37 (9.84%) SAN
2 25 (6.65%) Fibre Channel
3 21 (5.59%) LAN
3 21 (5.59%) WAN
4 20 (5.32%) FCoE
4 20 (5.32%) HTTP
4 20 (5.32%) iSCSI
4 20 (5.32%) Multicast
4 20 (5.32%) NAS
5 13 (3.46%) Extranet
5 13 (3.46%) Intranet
6 9 (2.39%) Firewall
7 2 (0.53%) Internet
7 2 (0.53%) LDAP
7 2 (0.53%) Skype
7 2 (0.53%) VoIP
8 1 (0.27%) PABX
8 1 (0.27%) Wi-Fi
Database & Business Intelligence
1 249 (66.22%) SQL Server
2 204 (54.26%) OLAP
3 161 (42.82%) Data Warehouse
4 127 (33.78%) SQL Server Integration Services
5 117 (31.12%) SQL Server Reporting Services
6 94 (25.00%) SQL Server Analysis Services
7 79 (21.01%) MySQL
8 66 (17.55%) SQL Server 2008
9 59 (15.69%) Oracle OLAP
10 48 (12.77%) Relational Database
11 42 (11.17%) NoSQL
11 42 (11.17%) SQL Server 2012
12 34 (9.04%) DB2
12 34 (9.04%) SQL Server 2014
13 28 (7.45%) SQL Server 2005
14 26 (6.91%) RDBMS
15 25 (6.65%) Big Data
16 24 (6.38%) Oracle Database
17 22 (5.85%) Microsoft Analysis Services
18 21 (5.59%) BusinessObjects
Development Applications
1 22 (5.85%) JIRA
2 20 (5.32%) Team Foundation Server
3 11 (2.93%) Jenkins
4 9 (2.39%) Vagrant
5 8 (2.13%) Cucumber
5 8 (2.13%) Oracle APEX
5 8 (2.13%) SQL Server Management Studio (SSMS)
5 8 (2.13%) Talend Open Studio
5 8 (2.13%) VSS/SourceSafe
6 6 (1.60%) tSQLt
6 6 (1.60%) Visual Studio
7 4 (1.06%) ERwin
8 1 (0.27%) FitNesse
8 1 (0.27%) Git (software)
8 1 (0.27%) JBehave
8 1 (0.27%) Subversion
8 1 (0.27%) TeamCity
General
1 92 (24.47%) Finance
2 31 (8.24%) Retail
3 14 (3.72%) Banking
4 13 (3.46%) Marketing
5 11 (2.93%) Telecoms
6 10 (2.66%) Pharmaceutical
7 6 (1.60%) Legal
7 6 (1.60%) Manufacturing
8 4 (1.06%) Back Office
9 3 (0.80%) Games
9 3 (0.80%) Publishing
10 2 (0.53%) Advertising
10 2 (0.53%) Financial Institution
11 1 (0.27%) German Language
11 1 (0.27%) Law
Job Titles
1 187 (49.73%) Developer
2 102 (27.13%) DBA
3 101 (26.86%) SQL Developer
4 88 (23.40%) SQL DBA
5 62 (16.49%) SQL Server DBA
6 52 (13.83%) Architect
7 49 (13.03%) Oracle Developer
8 34 (9.04%) Business Intelligence Developer
9 32 (8.51%) Administrator
10 31 (8.24%) Infrastructure Architect
11 29 (7.71%) SQL Server Developer
12 28 (7.45%) Senior Developer
13 27 (7.18%) Senior DBA
14 25 (6.65%) Lead Developer
15 21 (5.59%) Lead Architect
16 20 (5.32%) Analyst
16 20 (5.32%) C++ Developer
16 20 (5.32%) SSIS Developer
16 20 (5.32%) Unix Developer
17 19 (5.05%) Database Developer
Libraries, Frameworks & Software Standards
1 38 (10.11%) XML
2 37 (9.84%) Web Services
3 32 (8.51%) .NET
4 29 (7.71%) MDX
5 25 (6.65%) Middleware
6 20 (5.32%) STL
7 14 (3.72%) REST
8 12 (3.19%) SOAP
9 11 (2.93%) Oracle GoldenGate
10 10 (2.66%) ASP.NET
10 10 (2.66%) WSDL
10 10 (2.66%) WS-I
10 10 (2.66%) XSD
11 9 (2.39%) JSON
12 6 (1.60%) Django
13 5 (1.33%) .NET Framework
13 5 (1.33%) WCF
13 5 (1.33%) WinForms
14 4 (1.06%) ASP.NET MVC
15 3 (0.80%) Windows Identity Foundation
Miscellaneous
1 50 (13.30%) Analytical Skills
2 37 (9.84%) Clustering
2 37 (9.84%) Enterprise Software
3 32 (8.51%) Replication
4 28 (7.45%) Computer Science
5 18 (4.79%) Management Information System
6 13 (3.46%) Data Integration
7 12 (3.19%) Fintech
8 9 (2.39%) Life Science
9 8 (2.13%) Statistics
10 6 (1.60%) Data Protection Act
10 6 (1.60%) N-Tier
10 6 (1.60%) User Experience
11 5 (1.33%) Microsoft Licensing
11 5 (1.33%) Visualisation
12 3 (0.80%) Algorithms
12 3 (0.80%) Data Conversion
12 3 (0.80%) Data Structures
12 3 (0.80%) EMC VMAX
13 2 (0.53%) Online Games
Operating Systems
1 57 (15.16%) Windows
2 55 (14.63%) Linux
3 34 (9.04%) Unix
4 27 (7.18%) Solaris
5 14 (3.72%) Windows Server
6 9 (2.39%) Red Hat Enterprise Linux
6 9 (2.39%) Windows Server 2008
7 5 (1.33%) Windows Server 2012
8 1 (0.27%) Android
8 1 (0.27%) Apple iOS
8 1 (0.27%) CentOS
Processes & Methodologies
1 141 (37.50%) Performance Tuning
2 138 (36.70%) Business Intelligence
3 97 (25.80%) ETL
4 86 (22.87%) Agile Software Development
5 49 (13.03%) Kimball Methodology
6 47 (12.50%) Disaster Recovery
7 44 (11.70%) OO
8 39 (10.37%) High Availability
9 38 (10.11%) Data Modelling
10 34 (9.04%) Data Management
11 32 (8.51%) Dimensional Modelling
12 28 (7.45%) SOA
13 25 (6.65%) Mentoring
14 24 (6.38%) Scrum
15 22 (5.85%) Data Analysis
16 21 (5.59%) Benchmarking
16 21 (5.59%) Project Management
17 20 (5.32%) Risk Management
17 20 (5.32%) SDLC
18 19 (5.05%) Capacity Planning
Programming Languages
1 310 (82.45%) SQL
2 162 (43.09%) T-SQL
3 46 (12.23%) PL/SQL
4 40 (10.64%) Java
5 27 (7.18%) C#
6 20 (5.32%) C++
6 20 (5.32%) PowerShell
7 18 (4.79%) JavaScript
8 13 (3.46%) Data Analysis Expressions (DAX)
9 12 (3.19%) Python
10 10 (2.66%) Shell Script
11 6 (1.60%) C
12 3 (0.80%) VB.NET
13 2 (0.53%) PHP
14 1 (0.27%) Objective-C
14 1 (0.27%) Perl
14 1 (0.27%) Ruby
14 1 (0.27%) VB
14 1 (0.27%) VBA
14 1 (0.27%) VBScript
Qualifications
1 69 (18.35%) Degree
2 25 (6.65%) Microsoft Certification
3 13 (3.46%) MCITP
3 13 (3.46%) SC Cleared
3 13 (3.46%) Security Cleared
4 11 (2.93%) MCSE
5 9 (2.39%) PhD
6 6 (1.60%) MCP
6 6 (1.60%) MCSA
7 3 (0.80%) IBM Certification
8 1 (0.27%) CISSP
8 1 (0.27%) Oracle Certification
Quality Assurance & Compliance
1 13 (3.46%) QA
2 7 (1.86%) Data Quality
3 3 (0.80%) PCI DSS
4 1 (0.27%) SLA
System Software
1 25 (6.65%) VMware Infrastructure
2 21 (5.59%) Oracle RAC
3 20 (5.32%) Hyper-V
3 20 (5.32%) KVM
3 20 (5.32%) NFS
3 20 (5.32%) SRDF
3 20 (5.32%) Xen
4 5 (1.33%) HDFS
4 5 (1.33%) Veritas Cluster Server
4 5 (1.33%) Virtual Machines
4 5 (1.33%) VMware ESX
4 5 (1.33%) vSphere
5 3 (0.80%) GlusterFS
6 1 (0.27%) Docker
Systems Management
1 16 (4.26%) Microsoft Clustering
2 12 (3.19%) Puppet
3 5 (1.33%) NetBackup
3 5 (1.33%) Oracle ZFS
3 5 (1.33%) Veritas Storage Foundation
4 3 (0.80%) Red Hat Satellite
5 1 (0.27%) Ansible
5 1 (0.27%) OpenView
5 1 (0.27%) Perfmon
5 1 (0.27%) Tivoli
Vendors
1 127 (33.78%) Microsoft
2 117 (31.12%) Oracle
3 38 (10.11%) VMware
4 34 (9.04%) IBM
5 25 (6.65%) NetApp
6 24 (6.38%) Cognos
7 23 (6.12%) EMC
8 20 (5.32%) Cisco
8 20 (5.32%) Intel
9 16 (4.26%) Tableau
10 13 (3.46%) Computacenter
11 8 (2.13%) Red Hat
11 8 (2.13%) Talend
12 7 (1.86%) SAP
13 6 (1.60%) RedGate
13 6 (1.60%) Sun
14 5 (1.33%) CommVault
14 5 (1.33%) Sophos
14 5 (1.33%) StorageTek
14 5 (1.33%) Veritas
Reading
Hays West And Wales
Salary: £45000.00 - £50000.00 per annum + Benefits
Posted: Yesterday
Central London / West End
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: Yesterday
Suffolk
Nigel Frank International Ltd
Salary: £30000 - £50000 per annum + Pension, Training
Posted: 12 days ago
London
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 8 days ago
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 24 days ago
Luton, Bedfordshire
Tui (Ip) Ltd
Salary: Competitive Salary
Posted: 16 days ago