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

3 months to
1 Jul 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 725 738 686
Rank change year-on-year
+13 -52
Permanent jobs citing OLTP 191 233 317
As % of all permanent IT jobs located in the UK 0.20% 0.21% 0.26%
As % of the Database & Business Intelligence category 0.66% 0.65% 0.82%
Number of salaries quoted 131 151 236
Median salary £50,000 £52,500 £50,000
Median salary % change year-on-year
-4.76% +5.00%
90% offered a salary of more than £35,000 £32,500 £37,750
10% offered a salary of more than £80,000 £73,000 £65,000
UK excluding London median salary £45,000 £45,000 £45,000

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
29145 36067 38672
As % of all permanent IT jobs located in the UK 29.87% 32.55% 32.15%
Number of salaries quoted 24822 30399 33209
Median salary £49,000 £47,500 £45,000
Median salary % change year-on-year
+3.15% +5.55%
90% offered a salary of more than £32,500 £32,000 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 1 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 1 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 +16 179 £50,000 -4.76% 22
London +80 98 £57,500 -11.53% 10
South East +1 38 £50,000 +8.10% 5
Hampshire - 27 £45,000 - 3
Southampton - 23 £45,000 - 3
City of London +70 19 £65,000 +30.00% 1
West Yorkshire +32 11 £79,500 -
Yorkshire +3 11 £79,500 +148.43%
South West -10 11 £40,000 -17.94% 3
East Midlands - 11 £37,500 - 2
Bradford - 10 £80,000 -
Surrey -4 9 £60,000 +33.33%
West Midlands -14 8 £45,000 +10.42% 2
Northamptonshire - 8 - - 1
Northampton - 8 - - 1
Wales +3 6 £24,500 -45.55% 1
South Wales +2 6 £24,500 -45.55% 1
Scotland +2 6 £45,000 +14.64% 2
Cardiff -1 6 £24,500 -45.55% 1
Glasgow -3 6 £45,000 +14.64% 2
Staffordshire -23 5 £46,250 +13.49%
Stoke-on-Trent -26 5 £46,250 +42.30%
Gloucestershire -2 4 £40,000 -
Somerset - 4 £41,000 - 1
Bath - 4 £41,000 - 1
Cirencester - 4 £40,000 -
Reigate -7 3 £55,000 +22.22%
Leicestershire - 3 £37,500 - 1
Teddington - 3 £52,500 - 1
Birmingham - 3 £45,000 - 1

OLTP
Top 30 Related IT Skills

For the 6 months to 1 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 270 (76.49%) SQL
2 210 (59.49%) SQL Server
3 176 (49.86%) OLAP
4 135 (38.24%) Data Warehouse
5 130 (36.83%) Business Intelligence
6 126 (35.69%) Oracle
7 118 (33.43%) Microsoft
8 110 (31.16%) SQL Server Reporting Services
9 105 (29.75%) Finance
9 105 (29.75%) SQL Server Integration Services
10 104 (29.46%) Performance Tuning
11 98 (27.76%) ETL
12 97 (27.48%) T-SQL
13 89 (25.21%) MS Excel
14 82 (23.23%) SQL Server Analysis Services
15 75 (21.25%) Degree
16 67 (18.98%) Agile Software Development
17 61 (17.28%) MySQL
18 60 (17.00%) Linux
19 58 (16.43%) Oracle OLAP
20 56 (15.86%) OO
21 51 (14.45%) Java
22 48 (13.60%) PL/SQL
22 48 (13.60%) Analytical Skills
23 47 (13.31%) Data Management
24 45 (12.75%) Retail
24 45 (12.75%) XML
24 45 (12.75%) SQL Server 2008
25 43 (12.18%) Windows
26 41 (11.61%) SOA

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 14 (3.97%) Apache
1 14 (3.97%) Tomcat
2 10 (2.83%) IIS
2 10 (2.83%) Oracle Coherence
2 10 (2.83%) Oracle HTTP Server
2 10 (2.83%) WebSphere
3 6 (1.70%) Confluence
4 5 (1.42%) Apache Spark
4 5 (1.42%) Oracle Spatial
4 5 (1.42%) Oracle Workflow
5 4 (1.13%) Cloud Foundry
5 4 (1.13%) GemFire
5 4 (1.13%) SharePoint
6 3 (0.85%) WebLogic
7 1 (0.28%) Apache Pig
7 1 (0.28%) SAS
7 1 (0.28%) SharePoint 2013
Applications
1 89 (25.21%) MS Excel
2 9 (2.55%) MS Office
3 1 (0.28%) MS PowerPoint
3 1 (0.28%) MS Visio
3 1 (0.28%) Spreadsheet
Business Applications
1 5 (1.42%) Cognos Business Intelligence
1 5 (1.42%) MetaTrader
1 5 (1.42%) Unica
2 2 (0.57%) Endur
2 2 (0.57%) SAP FI
3 1 (0.28%) BASE24
3 1 (0.28%) Markit EDM
3 1 (0.28%) SAP CRM
3 1 (0.28%) SAP ERP
3 1 (0.28%) SAP SCM
Cloud Services
1 12 (3.40%) Microsoft Azure
2 8 (2.27%) Amazon AWS
3 4 (1.13%) GitHub
3 4 (1.13%) PaaS
Communications & Networking
1 20 (5.67%) SAN
2 16 (4.53%) Extranet
2 16 (4.53%) Intranet
3 13 (3.68%) Fibre Channel
4 11 (3.12%) LAN
4 11 (3.12%) NAS
4 11 (3.12%) WAN
5 10 (2.83%) FCoE
5 10 (2.83%) HTTP
5 10 (2.83%) iSCSI
5 10 (2.83%) Multicast
6 5 (1.42%) Firewall
7 2 (0.57%) Internet
7 2 (0.57%) Skype
8 1 (0.28%) PABX
8 1 (0.28%) VoIP
8 1 (0.28%) WebEx
8 1 (0.28%) Wi-Fi
Database & Business Intelligence
1 210 (59.49%) SQL Server
2 176 (49.86%) OLAP
3 135 (38.24%) Data Warehouse
4 110 (31.16%) SQL Server Reporting Services
5 105 (29.75%) SQL Server Integration Services
6 82 (23.23%) SQL Server Analysis Services
7 61 (17.28%) MySQL
8 58 (16.43%) Oracle OLAP
9 45 (12.75%) SQL Server 2008
10 40 (11.33%) Oracle Database
10 40 (11.33%) Relational Database
11 35 (9.92%) SQL Server 2012
12 27 (7.65%) DB2
13 23 (6.52%) BusinessObjects
13 23 (6.52%) SQL Server 2014
14 22 (6.23%) Oracle ODI
15 21 (5.95%) Big Data
16 19 (5.38%) Microsoft Analysis Services
17 17 (4.82%) Oracle Database 11g
18 16 (4.53%) Oracle Database 10g
Development Applications
1 22 (6.23%) Git (software)
2 17 (4.82%) Team Foundation Server
3 13 (3.68%) Jenkins
4 11 (3.12%) Oracle APEX
4 11 (3.12%) VSS/SourceSafe
5 8 (2.27%) JIRA
6 5 (1.42%) Subversion
7 4 (1.13%) Eclipse
7 4 (1.13%) Gradle
7 4 (1.13%) JUnit
7 4 (1.13%) tSQLt
8 3 (0.85%) ERwin
8 3 (0.85%) SQL Server Management Studio (SSMS)
9 1 (0.28%) Visual Studio
General
1 105 (29.75%) Finance
2 45 (12.75%) Retail
3 23 (6.52%) Banking
3 23 (6.52%) Marketing
4 15 (4.25%) Telecoms
5 10 (2.83%) Pharmaceutical
6 8 (2.27%) Games
7 5 (1.42%) Legal
7 5 (1.42%) Private Banking
7 5 (1.42%) Publishing
8 3 (0.85%) Advertising
8 3 (0.85%) Back Office
9 2 (0.57%) Financial Institution
9 2 (0.57%) Manufacturing
Job Titles
1 182 (51.56%) Developer
2 89 (25.21%) SQL Developer
3 68 (19.26%) DBA
4 63 (17.85%) Architect
5 61 (17.28%) Oracle Developer
6 56 (15.86%) SQL DBA
7 36 (10.20%) Database Developer
7 36 (10.20%) SQL Server DBA
8 31 (8.78%) SSRS Developer
9 30 (8.50%) SSIS Developer
10 29 (8.22%) SSAS Developer
11 28 (7.93%) Senior Developer
12 27 (7.65%) Infrastructure Architect
13 25 (7.08%) Business Intelligence Developer
13 25 (7.08%) SQL Server Developer
14 24 (6.80%) SQL Database Developer
15 23 (6.52%) Analyst
16 22 (6.23%) C++ Developer
16 22 (6.23%) Unix Developer
17 20 (5.67%) Information Architect
Libraries, Frameworks & Software Standards
1 45 (12.75%) XML
2 35 (9.92%) .NET
3 27 (7.65%) Web Services
4 22 (6.23%) STL
5 21 (5.95%) WSDL
6 20 (5.67%) MDX
6 20 (5.67%) Middleware
6 20 (5.67%) WS-I
6 20 (5.67%) XSD
7 18 (5.10%) SOAP
8 15 (4.25%) Oracle GoldenGate
9 9 (2.55%) ASP.NET
9 9 (2.55%) REST
10 7 (1.98%) WCF
11 6 (1.70%) Django
11 6 (1.70%) JSON
12 5 (1.42%) ASP.NET MVC
12 5 (1.42%) Kafka
12 5 (1.42%) WF
12 5 (1.42%) Windows Identity Foundation
Miscellaneous
1 48 (13.60%) Analytical Skills
2 36 (10.20%) Replication
3 33 (9.35%) Management Information System
4 31 (8.78%) Enterprise Software
5 30 (8.50%) Clustering
6 26 (7.37%) Computer Science
7 17 (4.82%) Data Integration
8 12 (3.40%) Data Structures
9 10 (2.83%) Fintech
10 9 (2.55%) Life Science
10 9 (2.55%) Statistics
11 8 (2.27%) Data Protection Act
11 8 (2.27%) Visualisation
12 5 (1.42%) Online Games
13 4 (1.13%) Client/Server
13 4 (1.13%) Virtual Team
14 3 (0.85%) Algorithms
14 3 (0.85%) Data Conversion
14 3 (0.85%) EMC VMAX
14 3 (0.85%) Spread Betting
Operating Systems
1 60 (17.00%) Linux
2 43 (12.18%) Windows
3 39 (11.05%) Unix
4 21 (5.95%) Solaris
5 14 (3.97%) Red Hat Enterprise Linux
6 12 (3.40%) Windows Server
7 5 (1.42%) Windows Server 2008
7 5 (1.42%) Windows Server 2012
8 1 (0.28%) AIX
Processes & Methodologies
1 130 (36.83%) Business Intelligence
2 104 (29.46%) Performance Tuning
3 98 (27.76%) ETL
4 67 (18.98%) Agile Software Development
5 56 (15.86%) OO
6 47 (13.31%) Data Management
7 41 (11.61%) SOA
8 37 (10.48%) Kimball Methodology
9 36 (10.20%) Data Modelling
10 30 (8.50%) High Availability
11 29 (8.22%) Disaster Recovery
12 28 (7.93%) Data Analysis
12 28 (7.93%) Dimensional Modelling
13 27 (7.65%) Data Architecture
14 26 (7.37%) Analytics
14 26 (7.37%) Data Governance
14 26 (7.37%) Enterprise Architecture
15 23 (6.52%) UML
16 21 (5.95%) SDLC
16 21 (5.95%) TOGAF
Programming Languages
1 270 (76.49%) SQL
2 97 (27.48%) T-SQL
3 51 (14.45%) Java
4 48 (13.60%) PL/SQL
5 33 (9.35%) C#
6 28 (7.93%) C++
7 19 (5.38%) Python
8 18 (5.10%) JavaScript
9 14 (3.97%) PowerShell
10 9 (2.55%) Perl
10 9 (2.55%) Shell Script
11 8 (2.27%) PHP
12 7 (1.98%) C
12 7 (1.98%) VB.NET
13 4 (1.13%) Ruby
14 3 (0.85%) Data Analysis Expressions (DAX)
14 3 (0.85%) R
15 2 (0.57%) Scala
15 2 (0.57%) VB
16 1 (0.28%) VBScript
Qualifications
1 75 (21.25%) Degree
2 9 (2.55%) Microsoft Certification
2 9 (2.55%) PhD
3 6 (1.70%) MCSE
4 5 (1.42%) SC Cleared
4 5 (1.42%) Security Cleared
5 4 (1.13%) MCP
5 4 (1.13%) MCSA
6 3 (0.85%) IBM Certification
6 3 (0.85%) MCITP
7 1 (0.28%) CISSP
7 1 (0.28%) ITIL Foundation Certificate
7 1 (0.28%) MBA
7 1 (0.28%) Oracle Certification
Quality Assurance & Compliance
1 19 (5.38%) QA
2 14 (3.97%) Data Quality
3 10 (2.83%) PCI DSS
4 5 (1.42%) SLA
System Software
1 11 (3.12%) VMware Infrastructure
2 10 (2.83%) Hyper-V
2 10 (2.83%) KVM
2 10 (2.83%) NFS
2 10 (2.83%) Oracle RAC
2 10 (2.83%) SRDF
2 10 (2.83%) Xen
3 4 (1.13%) Apache ZooKeeper
3 4 (1.13%) HDFS
4 3 (0.85%) GlusterFS
4 3 (0.85%) Veritas Cluster Server
5 1 (0.28%) Docker
Systems Management
1 5 (1.42%) Microsoft Clustering
2 3 (0.85%) NetBackup
2 3 (0.85%) OpenView
2 3 (0.85%) Oracle RMAN
2 3 (0.85%) Oracle ZFS
2 3 (0.85%) Puppet
2 3 (0.85%) Red Hat Satellite
2 3 (0.85%) Tivoli
2 3 (0.85%) Veritas Storage Foundation
3 1 (0.28%) Ansible
3 1 (0.28%) Data Guard
3 1 (0.28%) Mesos
3 1 (0.28%) Oracle Enterprise Manager
3 1 (0.28%) Perfmon
Vendors
1 126 (35.69%) Oracle
2 118 (33.43%) Microsoft
3 24 (6.80%) IBM
4 17 (4.82%) Tableau
5 16 (4.53%) VMware
6 15 (4.25%) Cognos
7 13 (3.68%) EMC
7 13 (3.68%) Red Hat
8 11 (3.12%) Intel
8 11 (3.12%) NetApp
9 10 (2.83%) Cisco
10 7 (1.98%) SAP
11 6 (1.70%) Sun
11 6 (1.70%) Vertica
12 5 (1.42%) Alterian
12 5 (1.42%) Apteco
12 5 (1.42%) Facebook
13 4 (1.13%) Informatica
14 3 (0.85%) StorageTek
14 3 (0.85%) Veritas
Leicester, Leicestershire
Computer People
Salary: £30000.00 - £37000.00 per annum
Posted: 2 hours ago
Bath, Avon
Opus Recruitment Solutions Ltd
Salary: £30000 per annum
Posted: 11 hours ago
City, London
onezeero.
Salary: £32000 - £35000 per annum + Bonus
Posted: Yesterday
Glasgow, Lanarkshire
Search Consultancy
Salary: Excellent salary, bonus and benefits
Posted: 2 days ago
Birmingham, West Midlands (County)
Rullion IT Plus
Salary: £35000 - £50000 per annum + 10% bonus & more
Posted: Yesterday
Slough, Berkshire
X4 Group
Salary: £45k - 55k per year
Posted: 2 days ago
South East London
Client Server
Salary: £30k to £45k + benefits
Posted: Yesterday
Glasgow, Lanarkshire
Net Talent
Posted: 3 days ago
Camborne
Recruitment Genius Ltd
Salary: £45000 - £55000 per annum
Posted: 4 days ago
Southampton, Hampshire
Go IT Recruitment Ltd
Salary: From £35,000 to £50,000 per annum + 25 days Holiday + Great career pro
Posted: 4 days ago
London - Mornington Crescent
ASOS
Posted: 4 days ago
Abingdon
Sophos
Salary: Highly Competitive + bonus & benefits
Posted: 4 days ago
Northampton, Northamptonshire
Emponics Ltd
Salary: neg + car + bonus
Posted: 3 days ago
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 10 days ago
Southampton
Hays Specialist Recruitment Ltd
Salary: £30000 - £50000 per annum + Package
Posted: 14 days ago
London
TDA Group
Salary: £65000 per annum + Benefits & Bonus
Posted: 8 days ago
London
ASOS
Salary: Excellent salary and package
Posted: 17 days ago
London
Computer Futures
Salary: £50000 - £55000 per annum + competitive
Posted: 21 days ago
London
Client Server
Salary: £30,000 to £45,000 + benefits
Posted: 9 days ago
Teddington
Ortolan Group
Posted: 15 days ago
Warwick
Computer Futures
Salary: competitive
Posted: 23 days ago
London
Client Server
Salary: £25k to £40k + benefits
Posted: 24 days ago