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

3 months to
4 May 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 792 770 685
Rank change year-on-year
-22 -85
Permanent jobs citing OLTP 162 195 314
As % of all permanent IT jobs located in the UK 0.16% 0.18% 0.26%
As % of the Database & Business Intelligence category 0.52% 0.55% 0.81%
Number of salaries quoted 111 135 247
Median salary £55,000 £55,000 £52,500
Median salary % change year-on-year
- +4.76%
90% offered a salary of more than £41,000 £40,000 £37,500
10% offered a salary of more than £75,000 £74,000 £80,000
UK excluding London median salary £50,000 £45,000 £55,000
% change year-on-year
+11.11% -18.18%

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
31384 35259 38674
As % of all permanent IT jobs located in the UK 30.58% 31.99% 32.41%
Number of salaries quoted 26823 29740 32835
Median salary £50,000 £46,000 £45,000
Median salary % change year-on-year
+8.69% +2.22%
90% offered a salary of more than £32,500 £31,500 £30,000
10% offered a salary of more than £70,000 £67,500 £70,000
UK excluding London median salary £42,500 £40,000 £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 4 May 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 4 May 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 -4 157 £55,000 -2.22% 17
London -3 88 £60,000 -7.69% 11
South East -9 26 £50,000 -8.25% 4
East Midlands +33 15 £60,000 +50.00%
Hampshire +15 14 £45,000 -35.71% 2
City of London +40 13 £62,500 - 8
Northampton - 12 £60,000 -
Northamptonshire - 12 £60,000 -
Yorkshire +11 10 £65,000 +103.12% 1
Surrey -19 10 £56,250 +3.21% 2
West Yorkshire - 9 £65,000 - 1
Southampton - 9 £45,000 - 2
West Midlands -17 7 £40,000 -1.84%
Bradford - 6 £65,000 -
North East - 5 £32,500 -
Staffordshire +7 4 £35,500 -12.88%
East of England +16 3 £55,000 -15.38%
Birmingham - 3 £45,000 -
Newcastle upon Tyne - 3 £32,500 -
Leeds - 3 £60,000 - 1
Woking - 3 £50,000 -
Nottinghamshire - 3 - -
Tyne and Wear - 3 £32,500 -
Farnborough - 3 - -
Nottingham - 3 - -
North West +15 2 £47,500 +35.71%
Manchester +2 2 £47,500 +2.15%
Scotland 0 2 £40,000 +1.91% 7
Berkshire -2 2 £48,750 +21.87%
Glasgow -4 2 £40,000 +1.91% 7

OLTP
Top 30 Related IT Skills

For the 6 months to 4 May 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 246 (74.77%) SQL
2 185 (56.23%) SQL Server
3 157 (47.72%) OLAP
4 117 (35.56%) Oracle
5 115 (34.95%) Data Warehouse
6 109 (33.13%) SQL Server Reporting Services
7 105 (31.91%) Business Intelligence
8 103 (31.31%) SQL Server Integration Services
9 99 (30.09%) Microsoft
9 99 (30.09%) ETL
10 95 (28.88%) Finance
11 89 (27.05%) SQL Server Analysis Services
12 75 (22.80%) Performance Tuning
13 72 (21.88%) MS Excel
14 70 (21.28%) T-SQL
15 67 (20.36%) Agile Software Development
16 59 (17.93%) Relational Database
17 57 (17.33%) Linux
18 56 (17.02%) MySQL
18 56 (17.02%) Oracle OLAP
19 54 (16.41%) Java
20 53 (16.11%) XML
20 53 (16.11%) Degree
21 52 (15.81%) Data Modelling
22 49 (14.89%) SQL Server 2008
23 45 (13.68%) .NET
24 44 (13.37%) Data Management
25 42 (12.77%) OO
25 42 (12.77%) Analytical Skills
26 41 (12.46%) Unix

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 8 (2.43%) Apache
2 7 (2.13%) Tomcat
3 6 (1.82%) Apache Spark
3 6 (1.82%) Confluence
3 6 (1.82%) MQSeries
4 5 (1.52%) IIS
4 5 (1.52%) Oracle Spatial
4 5 (1.52%) WebSphere
5 4 (1.22%) Cloud Foundry
5 4 (1.22%) GemFire
5 4 (1.22%) Oracle Workflow
6 3 (0.91%) Node.js
6 3 (0.91%) Oracle Coherence
6 3 (0.91%) Oracle HTTP Server
6 3 (0.91%) SharePoint
6 3 (0.91%) WebLogic
7 2 (0.61%) Apache Pig
8 1 (0.30%) SAS
Applications
1 72 (21.88%) MS Excel
2 5 (1.52%) MS Office
3 1 (0.30%) MS PowerPoint
3 1 (0.30%) MS Visio
3 1 (0.30%) Spreadsheet
Business Applications
1 6 (1.82%) Temenos T24
2 5 (1.52%) Cognos Business Intelligence
2 5 (1.52%) MetaTrader
3 4 (1.22%) Unica
4 2 (0.61%) Oracle Cash Management
5 1 (0.30%) BASE24
5 1 (0.30%) Markit EDM
Cloud Services
1 14 (4.26%) Microsoft Azure
2 7 (2.13%) Amazon AWS
3 4 (1.22%) GitHub
3 4 (1.22%) PaaS
Communications & Networking
1 15 (4.56%) Intranet
2 13 (3.95%) Extranet
3 12 (3.65%) SAN
4 6 (1.82%) Fibre Channel
4 6 (1.82%) Internet
5 4 (1.22%) LAN
5 4 (1.22%) NAS
5 4 (1.22%) WAN
6 3 (0.91%) FCoE
6 3 (0.91%) Firewall
6 3 (0.91%) HTTP
6 3 (0.91%) iSCSI
6 3 (0.91%) Multicast
7 2 (0.61%) LDAP
7 2 (0.61%) TCP/IP
8 1 (0.30%) PABX
8 1 (0.30%) VoIP
8 1 (0.30%) WebEx
8 1 (0.30%) Wi-Fi
Database & Business Intelligence
1 185 (56.23%) SQL Server
2 157 (47.72%) OLAP
3 115 (34.95%) Data Warehouse
4 109 (33.13%) SQL Server Reporting Services
5 103 (31.31%) SQL Server Integration Services
6 89 (27.05%) SQL Server Analysis Services
7 59 (17.93%) Relational Database
8 56 (17.02%) MySQL
8 56 (17.02%) Oracle OLAP
9 49 (14.89%) SQL Server 2008
10 41 (12.46%) Oracle Database
11 27 (8.21%) SQL Server 2012
12 26 (7.90%) Microsoft Analysis Services
13 24 (7.29%) Big Data
14 19 (5.78%) DB2
15 18 (5.47%) Oracle ODI
15 18 (5.47%) SQL Server 2005
16 17 (5.17%) NoSQL
16 17 (5.17%) Oracle Database 11g
17 16 (4.86%) SQL Server 2000
Development Applications
1 21 (6.38%) Git (software)
2 15 (4.56%) Team Foundation Server
3 12 (3.65%) Jenkins
4 8 (2.43%) Subversion
5 6 (1.82%) ERwin
5 6 (1.82%) JIRA
5 6 (1.82%) Oracle APEX
5 6 (1.82%) VSS/SourceSafe
6 4 (1.22%) Eclipse
6 4 (1.22%) Gradle
6 4 (1.22%) JUnit
General
1 95 (28.88%) Finance
2 33 (10.03%) Retail
3 32 (9.73%) Marketing
4 25 (7.60%) Banking
5 20 (6.08%) Games
6 10 (3.04%) Legal
7 8 (2.43%) Financial Institution
7 8 (2.43%) Telecoms
8 7 (2.13%) Pharmaceutical
9 5 (1.52%) Private Banking
10 4 (1.22%) Publishing
11 3 (0.91%) Advertising
11 3 (0.91%) Back Office
12 2 (0.61%) Manufacturing
13 1 (0.30%) Spanish Language
Job Titles
1 160 (48.63%) Developer
2 73 (22.19%) SQL Developer
3 71 (21.58%) DBA
4 58 (17.63%) Architect
5 49 (14.89%) Oracle Developer
5 49 (14.89%) SQL DBA
6 42 (12.77%) Database Developer
7 37 (11.25%) SSRS Developer
8 34 (10.33%) SSIS Developer
9 31 (9.42%) SSAS Developer
10 30 (9.12%) SQL Server DBA
11 27 (8.21%) SQL Database Developer
12 26 (7.90%) Business Intelligence Developer
13 23 (6.99%) Administrator
13 23 (6.99%) Senior Developer
14 22 (6.69%) Infrastructure Architect
15 20 (6.08%) Senior Database Developer
16 19 (5.78%) C++ Developer
16 19 (5.78%) Unix Developer
17 16 (4.86%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 53 (16.11%) XML
2 45 (13.68%) .NET
3 36 (10.94%) MDX
4 25 (7.60%) Middleware
5 20 (6.08%) Web Services
6 19 (5.78%) STL
7 18 (5.47%) HTML
7 18 (5.47%) Oracle GoldenGate
8 15 (4.56%) WSDL
9 14 (4.26%) SOAP
9 14 (4.26%) WS-I
9 14 (4.26%) XSD
10 13 (3.95%) HTML5
11 11 (3.34%) WCF
12 10 (3.04%) REST
13 9 (2.74%) Apache Flex
13 9 (2.74%) JavaFX
14 8 (2.43%) ASP.NET
15 7 (2.13%) AngularJS
15 7 (2.13%) CSS
Miscellaneous
1 42 (12.77%) Analytical Skills
2 38 (11.55%) Replication
3 25 (7.60%) Management Information System
4 20 (6.08%) Enterprise Software
5 19 (5.78%) Clustering
6 15 (4.56%) Data Integration
7 11 (3.34%) Computer Science
7 11 (3.34%) Data Structures
7 11 (3.34%) Online Games
8 7 (2.13%) Visualisation
9 6 (1.82%) Data Protection Act
9 6 (1.82%) Life Science
9 6 (1.82%) Statistics
10 5 (1.52%) Mobile Payment
11 4 (1.22%) Client/Server
11 4 (1.22%) Data Centre
11 4 (1.22%) User Experience
12 3 (0.91%) EMC VMAX
12 3 (0.91%) N-Tier
12 3 (0.91%) PKI
Operating Systems
1 57 (17.33%) Linux
2 41 (12.46%) Unix
2 41 (12.46%) Windows
3 17 (5.17%) Solaris
4 13 (3.95%) Red Hat Enterprise Linux
5 12 (3.65%) Windows Server
6 4 (1.22%) AIX
6 4 (1.22%) Android
6 4 (1.22%) Windows Mobile
7 2 (0.61%) Windows Server 2008
Processes & Methodologies
1 105 (31.91%) Business Intelligence
2 99 (30.09%) ETL
3 75 (22.80%) Performance Tuning
4 67 (20.36%) Agile Software Development
5 52 (15.81%) Data Modelling
6 44 (13.37%) Data Management
7 42 (12.77%) OO
8 37 (11.25%) SOA
9 36 (10.94%) Kimball Methodology
10 33 (10.03%) Disaster Recovery
11 31 (9.42%) Analytics
12 28 (8.51%) Dimensional Modelling
12 28 (8.51%) High Availability
13 26 (7.90%) Open Source
14 25 (7.60%) Data Architecture
15 23 (6.99%) E-Commerce
15 23 (6.99%) Enterprise Architecture
16 21 (6.38%) SDLC
17 20 (6.08%) Marketing Analytics
17 20 (6.08%) Project Management
Programming Languages
1 246 (74.77%) SQL
2 70 (21.28%) T-SQL
3 54 (16.41%) Java
4 39 (11.85%) PL/SQL
5 37 (11.25%) C#
6 25 (7.60%) C++
7 16 (4.86%) JavaScript
8 14 (4.26%) Python
9 13 (3.95%) Perl
10 12 (3.65%) PHP
11 9 (2.74%) PowerShell
12 8 (2.43%) Shell Script
13 7 (2.13%) VB.NET
14 6 (1.82%) VB
15 4 (1.22%) Apple Swift
15 4 (1.22%) Data Analysis Expressions (DAX)
15 4 (1.22%) Objective-C
15 4 (1.22%) Ruby
15 4 (1.22%) XAML
15 4 (1.22%) XPath
Qualifications
1 53 (16.11%) Degree
2 9 (2.74%) Security Cleared
3 7 (2.13%) Microsoft Certification
4 6 (1.82%) ISEB
4 6 (1.82%) PhD
5 5 (1.52%) SC Cleared
6 4 (1.22%) ISTQB
6 4 (1.22%) ISTQB Advanced Certification
6 4 (1.22%) MCSE
6 4 (1.22%) Oracle Certification
7 3 (0.91%) IBM Certification
7 3 (0.91%) MCITP
8 2 (0.61%) ISTQB Foundation Certification
8 2 (0.61%) MCSA
9 1 (0.30%) ITIL Foundation Certificate
9 1 (0.30%) MBA
9 1 (0.30%) OCA
9 1 (0.30%) OCP
Quality Assurance & Compliance
1 26 (7.90%) QA
2 20 (6.08%) Data Quality
3 8 (2.43%) PCI DSS
4 7 (2.13%) SLA
5 2 (0.61%) COBIT
System Software
1 6 (1.82%) VMware Infrastructure
2 4 (1.22%) Apache ZooKeeper
2 4 (1.22%) HDFS
2 4 (1.22%) Oracle RAC
3 3 (0.91%) GlusterFS
3 3 (0.91%) Hyper-V
3 3 (0.91%) KVM
3 3 (0.91%) NFS
3 3 (0.91%) SRDF
3 3 (0.91%) Veritas Cluster Server
3 3 (0.91%) Xen
4 1 (0.30%) Docker
Systems Management
1 7 (2.13%) Oracle RMAN
2 6 (1.82%) Data Guard
3 5 (1.52%) Oracle ZFS
4 4 (1.22%) HP Quality Center
5 3 (0.91%) NetBackup
5 3 (0.91%) OpenView
5 3 (0.91%) Oracle Enterprise Manager
5 3 (0.91%) Puppet
5 3 (0.91%) Red Hat Satellite
5 3 (0.91%) Tivoli
5 3 (0.91%) Veritas Storage Foundation
6 2 (0.61%) Oracle Statspack
7 1 (0.30%) Mesos
Vendors
1 117 (35.56%) Oracle
2 99 (30.09%) Microsoft
3 21 (6.38%) IBM
4 17 (5.17%) Tableau
5 13 (3.95%) Vertica
6 12 (3.65%) Cognos
7 11 (3.34%) Red Hat
8 9 (2.74%) InterSystems
9 6 (1.82%) EMC
9 6 (1.82%) Green Hat
9 6 (1.82%) HP
9 6 (1.82%) Intel
9 6 (1.82%) NetApp
9 6 (1.82%) Sun
9 6 (1.82%) VMware
9 6 (1.82%) webMethods
10 5 (1.52%) Facebook
10 5 (1.52%) RedGate
11 4 (1.22%) Apple
11 4 (1.22%) Apteco
Cirencester, Gloucestershire
Sanderson
Salary: £35 - £45 per annum + Excellent Benefits
Posted: 6 hours ago
Surrey
Spencer Rose
Salary: From £75,000 to £79,000 per annum + £8k car + bonus & package
Posted: 7 hours ago
City, London
onezeero.
Salary: £50000 - £60000 per annum + Bonus + Benefits
Posted: 14 hours ago
London
Westbourne Partners
Salary: From £50,000 to £60,000 per annum
Posted: Yesterday
City, London
Streamline Connections
Salary: £55000 - £70000 per annum + Benefits
Posted: Yesterday
Cardiff, South Glamorgan
CPS Group UK
Salary: £19 - £34000 per annum + Pension, bonus etc
Posted: Yesterday
Glasgow
Vivid Resourcing
Posted: Yesterday
Reigate, Surrey
Vantage Recruitment Solutions Ltd
Salary: From £50,000 to £60,000 per annum
Posted: 2 days ago
Glasgow, Lanarkshire
Search Consultancy
Salary: Excellent rate plus benefits
Posted: 6 days ago
Glasgow, Lanarkshire
Net Talent
Salary: excellent package and bens
Posted: 6 days ago
City, London
Sage UK Limited
Posted: 7 days ago
Southampton
Deerfoot IT Resources Ltd
Salary: £50000 per annum
Posted: 8 days ago
London
Hays Specialist Recruitment Ltd
Salary: £50000.00 - £60000.00 per annum
Posted: 8 days ago
City of London
Hays London City Cheapside
Salary: £60000.00 - £65000.00 per annum
Posted: 20 days ago
City of London
Deerfoot IT Resources Ltd
Salary: £60000 - £65000 per annum + Bonus and Benefits
Posted: 20 days ago
Southampton
Hays Specialist Recruitment Ltd
Salary: £30000 - £50000 per annum + Package
Posted: 22 days ago