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

3 months to
23 Jul 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 728 713 689
Rank change year-on-year
-15 -24
Permanent jobs citing OLTP 207 248 295
As % of all permanent IT jobs located in the UK 0.21% 0.22% 0.25%
As % of the Database & Business Intelligence category 0.71% 0.70% 0.79%
Number of salaries quoted 144 150 227
Median salary £50,000 £50,000 £50,000
90% offered a salary of more than £32,800 £34,000 £37,500
10% offered a salary of more than £79,700 £72,500 £65,000
UK excluding London median salary £43,000 £45,000 £46,250
% change year-on-year
-4.44% -2.70%

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
29161 35285 37279
As % of all permanent IT jobs located in the UK 29.73% 31.95% 32.06%
Number of salaries quoted 24763 29707 31852
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 £31,500 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 July 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 23 July 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 +8 192 £50,000 -4.76% 17
London +64 90 £55,000 - 6
South East +8 50 £48,750 +8.33% 4
Hampshire - 32 £45,000 - 1
Southampton - 28 £45,000 - 1
South West -5 16 £40,000 -5.88% 3
City of London +71 15 £67,500 +50.00%
East Midlands - 15 £35,500 - 1
West Yorkshire +19 10 £80,000 +28.00%
Yorkshire +6 10 £80,000 +28.00%
Bradford - 9 £80,000 -
Northamptonshire - 8 - -
Northampton - 8 - -
Berkshire -12 7 £50,000 +5.26% 1
Staffordshire -16 7 £46,250 +42.30%
West Midlands -18 7 £46,250 +42.30% 1
Stoke-on-Trent -27 7 £46,250 +48.00%
Bath - 7 £41,000 -
Somerset - 7 £41,000 -
Glasgow - 7 £45,000 - 1
Scotland - 7 £45,000 - 1
Cardiff +9 6 £24,500 -45.55%
South Wales +5 6 £24,500 -45.55%
Wales -8 6 £24,500 -45.55%
Surrey -1 5 £60,000 +33.33%
Oxfordshire - 5 £60,000 - 1
Leicestershire - 5 £33,500 -
Slough +15 4 £55,000 +24.29% 1
Gloucestershire +3 4 £40,000 -
Leicester - 4 £33,500 -

OLTP
Top 30 Related IT Skills

For the 6 months to 23 July 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 288 (78.26%) SQL
2 226 (61.41%) SQL Server
3 187 (50.82%) OLAP
4 144 (39.13%) Data Warehouse
5 137 (37.23%) Business Intelligence
6 126 (34.24%) Oracle
7 121 (32.88%) Microsoft
8 119 (32.34%) Performance Tuning
9 117 (31.79%) T-SQL
10 113 (30.71%) SQL Server Reporting Services
11 111 (30.16%) SQL Server Integration Services
12 105 (28.53%) Finance
13 98 (26.63%) ETL
14 90 (24.46%) MS Excel
15 84 (22.83%) SQL Server Analysis Services
16 77 (20.92%) Degree
17 71 (19.29%) Agile Software Development
18 68 (18.48%) MySQL
19 60 (16.30%) Linux
20 59 (16.03%) OO
21 55 (14.95%) SQL Server 2008
22 54 (14.67%) Oracle OLAP
22 54 (14.67%) Analytical Skills
23 51 (13.86%) Data Management
24 50 (13.59%) Windows
25 49 (13.32%) Java
26 48 (13.04%) PL/SQL
27 44 (11.96%) XML
28 41 (11.14%) SOA
28 41 (11.14%) Relational Database

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 16 (4.35%) Apache
1 16 (4.35%) Tomcat
2 13 (3.53%) IIS
3 12 (3.26%) Oracle Coherence
3 12 (3.26%) Oracle HTTP Server
3 12 (3.26%) WebSphere
4 5 (1.36%) Confluence
4 5 (1.36%) Oracle Workflow
4 5 (1.36%) SharePoint
5 4 (1.09%) Apache Spark
5 4 (1.09%) Cloud Foundry
5 4 (1.09%) GemFire
5 4 (1.09%) Oracle Spatial
6 3 (0.82%) WebLogic
7 1 (0.27%) SAS
7 1 (0.27%) SharePoint 2013
Applications
1 90 (24.46%) MS Excel
2 9 (2.45%) MS Office
3 1 (0.27%) MS PowerPoint
3 1 (0.27%) MS Visio
3 1 (0.27%) Spreadsheet
Business Applications
1 5 (1.36%) Cognos Business Intelligence
1 5 (1.36%) Unica
2 4 (1.09%) MetaTrader
3 2 (0.54%) Endur
3 2 (0.54%) SAP FI
4 1 (0.27%) BASE24
4 1 (0.27%) SAP CRM
4 1 (0.27%) SAP ERP
4 1 (0.27%) SAP SCM
Cloud Services
1 9 (2.45%) Amazon AWS
2 8 (2.17%) Microsoft Azure
3 4 (1.09%) GitHub
3 4 (1.09%) PaaS
Communications & Networking
1 24 (6.52%) SAN
2 16 (4.35%) Extranet
2 16 (4.35%) Intranet
3 14 (3.80%) Fibre Channel
4 13 (3.53%) LAN
4 13 (3.53%) NAS
4 13 (3.53%) WAN
5 12 (3.26%) FCoE
5 12 (3.26%) HTTP
5 12 (3.26%) iSCSI
5 12 (3.26%) Multicast
6 7 (1.90%) Firewall
7 3 (0.82%) Internet
8 2 (0.54%) Skype
9 1 (0.27%) PABX
9 1 (0.27%) VoIP
9 1 (0.27%) WebEx
9 1 (0.27%) Wi-Fi
Database & Business Intelligence
1 226 (61.41%) SQL Server
2 187 (50.82%) OLAP
3 144 (39.13%) Data Warehouse
4 113 (30.71%) SQL Server Reporting Services
5 111 (30.16%) SQL Server Integration Services
6 84 (22.83%) SQL Server Analysis Services
7 68 (18.48%) MySQL
8 55 (14.95%) SQL Server 2008
9 54 (14.67%) Oracle OLAP
10 41 (11.14%) Relational Database
10 41 (11.14%) SQL Server 2012
11 39 (10.60%) Oracle Database
12 32 (8.70%) SQL Server 2014
13 27 (7.34%) DB2
14 23 (6.25%) BusinessObjects
15 21 (5.71%) Microsoft Analysis Services
16 19 (5.16%) Big Data
16 19 (5.16%) Oracle ODI
17 17 (4.62%) Oracle Database 11g
17 17 (4.62%) SQL Server 2005
Development Applications
1 20 (5.43%) Git (software)
2 17 (4.62%) Team Foundation Server
3 11 (2.99%) Jenkins
3 11 (2.99%) Oracle APEX
3 11 (2.99%) VSS/SourceSafe
4 10 (2.72%) JIRA
5 6 (1.63%) SQL Server Management Studio (SSMS)
5 6 (1.63%) tSQLt
6 5 (1.36%) Subversion
7 4 (1.09%) Eclipse
7 4 (1.09%) Gradle
7 4 (1.09%) JUnit
7 4 (1.09%) Visual Studio
8 3 (0.82%) ERwin
General
1 105 (28.53%) Finance
2 40 (10.87%) Retail
3 24 (6.52%) Banking
4 18 (4.89%) Marketing
5 14 (3.80%) Telecoms
6 10 (2.72%) Pharmaceutical
7 5 (1.36%) Games
7 5 (1.36%) Private Banking
7 5 (1.36%) Publishing
8 3 (0.82%) Advertising
8 3 (0.82%) Back Office
8 3 (0.82%) Legal
9 2 (0.54%) Financial Institution
9 2 (0.54%) Manufacturing
Job Titles
1 184 (50.00%) Developer
2 91 (24.73%) SQL Developer
3 82 (22.28%) DBA
4 70 (19.02%) SQL DBA
5 66 (17.93%) Architect
6 59 (16.03%) Oracle Developer
7 43 (11.68%) SQL Server DBA
8 32 (8.70%) Database Developer
9 28 (7.61%) Infrastructure Architect
10 27 (7.34%) Business Intelligence Developer
10 27 (7.34%) Senior Developer
11 26 (7.07%) SQL Server Developer
12 25 (6.79%) SSIS Developer
12 25 (6.79%) SSRS Developer
13 23 (6.25%) C++ Developer
13 23 (6.25%) SQL Database Developer
13 23 (6.25%) SSAS Developer
13 23 (6.25%) Unix Developer
14 22 (5.98%) Analyst
15 21 (5.71%) Lead Developer
Libraries, Frameworks & Software Standards
1 44 (11.96%) XML
2 32 (8.70%) .NET
3 29 (7.88%) Web Services
4 23 (6.25%) STL
5 22 (5.98%) MDX
5 22 (5.98%) Middleware
5 22 (5.98%) WSDL
6 21 (5.71%) WS-I
6 21 (5.71%) XSD
7 17 (4.62%) SOAP
8 14 (3.80%) Oracle GoldenGate
9 10 (2.72%) ASP.NET
9 10 (2.72%) REST
10 8 (2.17%) JSON
11 7 (1.90%) WCF
12 6 (1.63%) Django
13 5 (1.36%) WinForms
14 4 (1.09%) J2EE
14 4 (1.09%) Spring
14 4 (1.09%) WF
Miscellaneous
1 54 (14.67%) Analytical Skills
2 37 (10.05%) Enterprise Software
3 34 (9.24%) Management Information System
4 33 (8.97%) Clustering
4 33 (8.97%) Replication
5 27 (7.34%) Computer Science
6 15 (4.08%) Data Integration
7 12 (3.26%) Fintech
8 10 (2.72%) Data Structures
8 10 (2.72%) Statistics
9 9 (2.45%) Life Science
10 8 (2.17%) Data Protection Act
10 8 (2.17%) Visualisation
11 4 (1.09%) Client/Server
11 4 (1.09%) Virtual Team
12 3 (0.82%) Algorithms
12 3 (0.82%) Data Conversion
12 3 (0.82%) Microsoft Licensing
12 3 (0.82%) Online Games
12 3 (0.82%) PKI
Operating Systems
1 60 (16.30%) Linux
2 50 (13.59%) Windows
3 38 (10.33%) Unix
4 20 (5.43%) Solaris
5 16 (4.35%) Windows Server
6 12 (3.26%) Red Hat Enterprise Linux
7 7 (1.90%) Windows Server 2008
8 5 (1.36%) Windows Server 2012
Processes & Methodologies
1 137 (37.23%) Business Intelligence
2 119 (32.34%) Performance Tuning
3 98 (26.63%) ETL
4 71 (19.29%) Agile Software Development
5 59 (16.03%) OO
6 51 (13.86%) Data Management
7 41 (11.14%) SOA
8 38 (10.33%) Kimball Methodology
9 34 (9.24%) Data Modelling
10 32 (8.70%) Disaster Recovery
11 31 (8.42%) High Availability
12 28 (7.61%) Data Analysis
12 28 (7.61%) Data Architecture
12 28 (7.61%) Enterprise Architecture
13 26 (7.07%) Data Governance
13 26 (7.07%) Dimensional Modelling
14 24 (6.52%) UML
15 23 (6.25%) SDLC
16 22 (5.98%) Performance Management
16 22 (5.98%) TOGAF
Programming Languages
1 288 (78.26%) SQL
2 117 (31.79%) T-SQL
3 49 (13.32%) Java
4 48 (13.04%) PL/SQL
5 32 (8.70%) C#
6 29 (7.88%) C++
7 18 (4.89%) JavaScript
7 18 (4.89%) Python
8 17 (4.62%) PowerShell
9 9 (2.45%) Shell Script
10 8 (2.17%) Perl
10 8 (2.17%) PHP
11 7 (1.90%) C
11 7 (1.90%) Data Analysis Expressions (DAX)
11 7 (1.90%) VB.NET
12 3 (0.82%) R
12 3 (0.82%) Ruby
13 2 (0.54%) VB
14 1 (0.27%) VBA
14 1 (0.27%) VBScript
Qualifications
1 77 (20.92%) Degree
2 14 (3.80%) Microsoft Certification
3 9 (2.45%) PhD
4 8 (2.17%) MCSE
5 7 (1.90%) SC Cleared
5 7 (1.90%) Security Cleared
6 6 (1.63%) MCP
6 6 (1.63%) MCSA
7 5 (1.36%) MCITP
8 3 (0.82%) IBM Certification
9 2 (0.54%) Oracle Certification
10 1 (0.27%) CISSP
10 1 (0.27%) ITIL Foundation Certificate
10 1 (0.27%) MBA
Quality Assurance & Compliance
1 18 (4.89%) QA
2 12 (3.26%) Data Quality
3 8 (2.17%) PCI DSS
4 4 (1.09%) SLA
System Software
1 15 (4.08%) VMware Infrastructure
2 13 (3.53%) Oracle RAC
3 12 (3.26%) Hyper-V
3 12 (3.26%) KVM
3 12 (3.26%) NFS
3 12 (3.26%) SRDF
3 12 (3.26%) Xen
4 4 (1.09%) Apache ZooKeeper
4 4 (1.09%) HDFS
5 3 (0.82%) Virtual Machines
5 3 (0.82%) VMware ESX
5 3 (0.82%) vSphere
6 2 (0.54%) GlusterFS
6 2 (0.54%) Veritas Cluster Server
Systems Management
1 7 (1.90%) Microsoft Clustering
2 3 (0.82%) OpenView
2 3 (0.82%) Tivoli
3 2 (0.54%) NetBackup
3 2 (0.54%) Oracle RMAN
3 2 (0.54%) Oracle ZFS
3 2 (0.54%) Puppet
3 2 (0.54%) Red Hat Satellite
3 2 (0.54%) Veritas Storage Foundation
4 1 (0.27%) Ansible
4 1 (0.27%) Data Guard
4 1 (0.27%) Oracle Enterprise Manager
4 1 (0.27%) Perfmon
Vendors
1 126 (34.24%) Oracle
2 121 (32.88%) Microsoft
3 29 (7.88%) IBM
4 21 (5.71%) VMware
5 20 (5.43%) Tableau
6 18 (4.89%) Cognos
7 15 (4.08%) NetApp
8 14 (3.80%) EMC
9 12 (3.26%) Cisco
9 12 (3.26%) Intel
9 12 (3.26%) Red Hat
10 7 (1.90%) SAP
11 6 (1.63%) Facebook
12 5 (1.36%) Alterian
12 5 (1.36%) Apteco
12 5 (1.36%) Sun
12 5 (1.36%) Vertica
13 4 (1.09%) Informatica
13 4 (1.09%) RedGate
14 3 (0.82%) Alteryx
London
onezeero.
Salary: £65000 - £70000 per annum + Benefits
Posted: 2 days ago
Birkenhead, Merseyside
Uniting Ambition
Salary: £30k - 40k per year + (Depending on experience)
Posted: 4 days ago
Glasgow
Vivid Resourcing
Posted: 3 days ago
South East London
Client Server
Salary: £30k to £45k + benefits
Posted: Yesterday
Ellesmere Port, Merseyside
Uniting Ambition
Salary: Market related
Posted: 5 days ago
Slough, Berkshire
IT Talent Solutions
Salary: From £50,000 to £60,000 per annum
Posted: 5 days ago
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 6 days ago
Belfast, County Antrim
HAYS INFORMATION TECHNOLOGY
Salary: £27000.00 - £35000.00 per annum
Posted: 4 days ago
Warwick
Computer Futures
Salary: competitive
Posted: 8 days ago
London
Client Server
Salary: £25,000 to £40,000 + benefits
Posted: 9 days ago
Malmesbury, Wiltshire
Dyson
Posted: 15 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 16 days ago
Camborne
Recruitment Genius Ltd
Salary: £45000 - £55000 per annum
Posted: 26 days ago
High Wycombe, Buckinghamshire
Johnson and Johnson
Salary: Highly competitive salary, bonus and flexible benefits
Posted: 11 days ago
South West London
Gamesys
Posted: 15 days ago
London - Mornington Crescent
ASOS
Posted: 26 days ago
Abingdon
Sophos
Salary: Highly Competitive + bonus & benefits
Posted: 26 days ago
London
Client Server
Salary: £30k to £45k + benefits
Posted: 23 days ago
Bristol, Avon
BJSS Ltd
Salary: From £75,000 to £90,000 per annum
Posted: 11 days ago