The table below looks at the statistics for OLTP skills in IT jobs advertised for the England region. Included is a guide to the salaries offered in IT jobs that have cited OLTP over the 3 months to 19 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
19 Jan 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
UK / England
Rank 677 743 739
Rank change year-on-year
+66 -4
Permanent jobs citing OLTP 156 156 199
As % of all permanent IT jobs located in England 0.20% 0.17% 0.20%
As % of the Database & Business Intelligence category 0.66% 0.52% 0.65%
Number of salaries quoted 124 121 153
Median salary £55,000 £50,000 £52,500
Median salary % change year-on-year
+10.00% -4.76%
90% offered a salary of more than £38,950 £35,500 £37,500
10% offered a salary of more than £72,500 £75,000 £75,000
UK excluding London median salary £52,500 £47,500 £42,500
% change year-on-year
+10.52% +11.76%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the England region.

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
23653 30190 30395
As % of all permanent IT jobs located in England 30.06% 32.28% 30.97%
Number of salaries quoted 20508 25834 26253
Median salary £50,000 £50,000 £45,000
Median salary % change year-on-year
- +11.11%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

OLTP
Jobs Demand Trend in England

The demand trend of job ads across the England region citing OLTP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLTP Jobs Demand Trend in England

OLTP
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP across the England region.

OLTP Salary Trend in England

OLTP
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing OLTP across the England region over the 3 months to 19 January 2017.

OLTP Salary Histogram in England

OLTP
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the England region over the 3 months to 19 January 2017. 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 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
London +45 68 £65,000 +18.18% 11
South East +97 56 £52,500 +16.66% 6
East of England +34 16 £55,000 -12.00% 1
North West -32 5 £37,500 -21.05%
East Midlands - 4 £43,250 - 3
Yorkshire +24 3 - -
West Midlands -13 2 £42,000 +20.00%
OLTP
UK

OLTP
Top 30 Related IT Skills in England

For the 6 months to 19 January 2017, 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 across the England region with a requirement for OLTP.

1 279 (85.85%) SQL
2 218 (67.08%) SQL Server
3 161 (49.54%) OLAP
4 133 (40.92%) Microsoft
4 133 (40.92%) Performance Tuning
5 125 (38.46%) SQL Server Integration Services
6 122 (37.54%) Data Warehouse
7 120 (36.92%) Oracle
7 120 (36.92%) T-SQL
8 118 (36.31%) SQL Server Reporting Services
9 117 (36.00%) Business Intelligence
10 103 (31.69%) Agile Software Development
11 96 (29.54%) SQL Server Analysis Services
12 86 (26.46%) MySQL
13 82 (25.23%) ETL
14 71 (21.85%) Disaster Recovery
14 71 (21.85%) Oracle OLAP
15 70 (21.54%) MS Excel
16 65 (20.00%) Linux
17 60 (18.46%) NoSQL
18 59 (18.15%) SQL Server 2008
19 56 (17.23%) Windows
20 55 (16.92%) Finance
21 51 (15.69%) Analytical Skills
22 47 (14.46%) High Availability
22 47 (14.46%) Replication
23 46 (14.15%) PL/SQL
24 44 (13.54%) JIRA
25 43 (13.23%) Hadoop
26 42 (12.92%) Relational Database

OLTP
Top Related IT Skills in England 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 29 (8.92%) IIS
2 20 (6.15%) Apache
2 20 (6.15%) Oracle Coherence
2 20 (6.15%) Oracle HTTP Server
2 20 (6.15%) Tomcat
2 20 (6.15%) WebSphere
3 12 (3.69%) Apache Pig
4 11 (3.38%) SharePoint
5 5 (1.54%) Jupyter
6 3 (0.92%) Oracle Service Bus
7 2 (0.62%) Oracle SOA Suite
8 1 (0.31%) Apache Spark
Applications
1 70 (21.54%) MS Excel
2 2 (0.62%) MS Visio
Business Applications
1 6 (1.85%) FastStats
2 2 (0.62%) Cognos TM1
3 1 (0.31%) Dynamics AX
3 1 (0.31%) Dynamics CRM
3 1 (0.31%) Dynamics NAV
3 1 (0.31%) OPENHousing
Cloud Services
1 26 (8.00%) Amazon AWS
2 24 (7.38%) Microsoft Azure
3 20 (6.15%) GitHub
4 6 (1.85%) Cloud Computing
4 6 (1.85%) IaaS
4 6 (1.85%) PaaS
5 5 (1.54%) Amazon S3
6 3 (0.92%) Google Cloud Platform
7 2 (0.62%) SaaS
Communications & Networking
1 41 (12.62%) SAN
2 31 (9.54%) Fibre Channel
3 21 (6.46%) LAN
3 21 (6.46%) WAN
4 20 (6.15%) FCoE
4 20 (6.15%) HTTP
4 20 (6.15%) iSCSI
4 20 (6.15%) Multicast
4 20 (6.15%) NAS
5 9 (2.77%) Intranet
6 3 (0.92%) Extranet
6 3 (0.92%) Internet
7 2 (0.62%) Firewall
7 2 (0.62%) LDAP
7 2 (0.62%) VoIP
8 1 (0.31%) PABX
8 1 (0.31%) Wi-Fi
Database & Business Intelligence
1 218 (67.08%) SQL Server
2 161 (49.54%) OLAP
3 125 (38.46%) SQL Server Integration Services
4 122 (37.54%) Data Warehouse
5 118 (36.31%) SQL Server Reporting Services
6 96 (29.54%) SQL Server Analysis Services
7 86 (26.46%) MySQL
8 71 (21.85%) Oracle OLAP
9 60 (18.46%) NoSQL
10 59 (18.15%) SQL Server 2008
11 43 (13.23%) Hadoop
12 42 (12.92%) Relational Database
13 41 (12.62%) Big Data
14 39 (12.00%) SQL Server 2012
15 37 (11.38%) Power BI
16 33 (10.15%) RDBMS
17 27 (8.31%) DB2
17 27 (8.31%) Microsoft Analysis Services
18 26 (8.00%) MongoDB
18 26 (8.00%) SQL Server 2014
Development Applications
1 44 (13.54%) JIRA
2 29 (8.92%) Team Foundation Server
3 19 (5.85%) Talend Open Studio
4 11 (3.38%) Visual Studio
5 9 (2.77%) Cucumber
5 9 (2.77%) Jenkins
5 9 (2.77%) Vagrant
6 7 (2.15%) Git (software)
6 7 (2.15%) git-flow
7 5 (1.54%) Oracle APEX
7 5 (1.54%) VSS/SourceSafe
8 4 (1.23%) ERwin
9 2 (0.62%) FitNesse
9 2 (0.62%) JBehave
9 2 (0.62%) SQL Server Management Studio (SSMS)
General
1 55 (16.92%) Finance
2 12 (3.69%) Retail
3 9 (2.77%) Advertising
4 6 (1.85%) Games
4 6 (1.85%) Marketing
5 5 (1.54%) Manufacturing
5 5 (1.54%) Pharmaceutical
6 3 (0.92%) Legal
6 3 (0.92%) Telecoms
7 1 (0.31%) Banking
7 1 (0.31%) German Language
7 1 (0.31%) Investment Banking
Job Titles
1 132 (40.62%) Developer
2 104 (32.00%) DBA
3 86 (26.46%) SQL DBA
4 85 (26.15%) SQL Developer
5 62 (19.08%) SQL Server DBA
6 43 (13.23%) Administrator
7 30 (9.23%) Architect
7 30 (9.23%) Senior DBA
8 28 (8.62%) Oracle Developer
9 24 (7.38%) ETL Developer
10 22 (6.77%) Lead Architect
11 21 (6.46%) Analyst
11 21 (6.46%) Infrastructure Architect
12 20 (6.15%) C++ Developer
12 20 (6.15%) SSIS Developer
13 19 (5.85%) Business Intelligence Developer
14 18 (5.54%) Senior SQL DBA
15 17 (5.23%) SQL Server Developer
16 16 (4.92%) Unix Developer
17 15 (4.62%) NoSQL Developer
Libraries, Frameworks & Software Standards
1 38 (11.69%) Web Services
2 29 (8.92%) .NET
3 26 (8.00%) STL
4 20 (6.15%) MDX
4 20 (6.15%) Middleware
4 20 (6.15%) XML
5 12 (3.69%) ASP.NET
5 12 (3.69%) REST
6 10 (3.08%) Boost C++ Libraries
7 7 (2.15%) SOAP
8 6 (1.85%) JSON
9 5 (1.54%) .NET Framework
9 5 (1.54%) ASP.NET MVC
9 5 (1.54%) Oracle GoldenGate
10 4 (1.23%) Ajax
10 4 (1.23%) HTML
11 3 (0.92%) CSS
11 3 (0.92%) EDI
11 3 (0.92%) XHTML
11 3 (0.92%) XSL
Miscellaneous
1 51 (15.69%) Analytical Skills
2 47 (14.46%) Replication
3 39 (12.00%) Clustering
4 38 (11.69%) Computer Science
5 19 (5.85%) Data Integration
6 18 (5.54%) Fintech
7 17 (5.23%) Management Information System
8 14 (4.31%) Enterprise Software
9 11 (3.38%) Statistics
10 10 (3.08%) Equities
10 10 (3.08%) Fixed Income
11 9 (2.77%) EMC VMAX
12 6 (1.85%) Visualisation
13 5 (1.54%) N-Tier
13 5 (1.54%) User Experience
14 4 (1.23%) Life Science
15 3 (0.92%) Mathematics
15 3 (0.92%) Online Games
15 3 (0.92%) Physics
16 2 (0.62%) Data Protection Act
Operating Systems
1 65 (20.00%) Linux
2 56 (17.23%) Windows
3 40 (12.31%) Unix
4 36 (11.08%) Solaris
5 14 (4.31%) Red Hat Enterprise Linux
6 12 (3.69%) Windows Server 2008
7 11 (3.38%) Windows Server
8 10 (3.08%) Windows Server 2012
9 1 (0.31%) Android
9 1 (0.31%) Apple iOS
9 1 (0.31%) Windows NT
Processes & Methodologies
1 133 (40.92%) Performance Tuning
2 117 (36.00%) Business Intelligence
3 103 (31.69%) Agile Software Development
4 82 (25.23%) ETL
5 71 (21.85%) Disaster Recovery
6 47 (14.46%) High Availability
7 41 (12.62%) Kimball Methodology
7 41 (12.62%) Scrum
8 38 (11.69%) Data Modelling
9 26 (8.00%) Time Management
10 24 (7.38%) Kanban
11 22 (6.77%) OO
12 20 (6.15%) Benchmarking
12 20 (6.15%) Risk Management
13 19 (5.85%) Analytics
13 19 (5.85%) Dimensional Modelling
14 18 (5.54%) Unit Testing
15 17 (5.23%) SDLC
16 16 (4.92%) E-Commerce
17 15 (4.62%) ITIL
Programming Languages
1 279 (85.85%) SQL
2 120 (36.92%) T-SQL
3 46 (14.15%) PL/SQL
4 27 (8.31%) C++
5 20 (6.15%) Java
6 18 (5.54%) C#
7 12 (3.69%) PowerShell
8 10 (3.08%) Shell Script
9 8 (2.46%) Data Analysis Expressions (DAX)
9 8 (2.46%) JavaScript
9 8 (2.46%) Python
10 2 (0.62%) R
10 2 (0.62%) VB.NET
10 2 (0.62%) VBScript
11 1 (0.31%) AWK
11 1 (0.31%) Objective-C
11 1 (0.31%) PHP
11 1 (0.31%) Ruby
Qualifications
1 41 (12.62%) Degree
2 29 (8.92%) Microsoft Certification
3 11 (3.38%) MCITP
3 11 (3.38%) SC Cleared
3 11 (3.38%) Security Cleared
4 5 (1.54%) MCSE
5 4 (1.23%) PhD
Quality Assurance & Compliance
1 16 (4.92%) SLA
2 11 (3.38%) Data Quality
3 6 (1.85%) QA
4 2 (0.62%) PCI DSS
System Software
1 23 (7.08%) Oracle RAC
2 22 (6.77%) VMware Infrastructure
3 20 (6.15%) Hyper-V
3 20 (6.15%) KVM
3 20 (6.15%) NFS
3 20 (6.15%) SRDF
3 20 (6.15%) Xen
4 16 (4.92%) Veritas Cluster Server
5 9 (2.77%) GlusterFS
6 8 (2.46%) Active Directory
7 5 (1.54%) HDFS
8 2 (0.62%) Virtual Machines
8 2 (0.62%) VMware ESX
8 2 (0.62%) vSphere
Systems Management
1 20 (6.15%) Puppet
2 16 (4.92%) NetBackup
3 11 (3.38%) Oracle ZFS
3 11 (3.38%) Veritas Storage Foundation
4 9 (2.77%) Microsoft Clustering
4 9 (2.77%) Red Hat Satellite
5 4 (1.23%) Failover Clustering
6 3 (0.92%) Enterprise Manager Cloud Control
6 3 (0.92%) Oracle Enterprise Manager
6 3 (0.92%) Oracle RMAN
7 1 (0.31%) Tivoli Storage Manager
Vendors
1 133 (40.92%) Microsoft
2 120 (36.92%) Oracle
3 38 (11.69%) Cognos
4 30 (9.23%) Intel
5 29 (8.92%) EMC
5 29 (8.92%) VMware
6 23 (7.08%) NetApp
7 22 (6.77%) IBM
8 20 (6.15%) Cisco
9 19 (5.85%) Talend
10 16 (4.92%) Veritas
11 14 (4.31%) Red Hat
12 11 (3.38%) Brocade
12 11 (3.38%) StorageTek
12 11 (3.38%) Sun
13 10 (3.08%) Computacenter
13 10 (3.08%) Vertica
14 8 (2.46%) SolarWinds
15 6 (1.85%) Tableau
16 5 (1.54%) Informatica
London
Nigel Frank International
Salary: £400 - £450 per day
Posted: 15 hours ago
West Malling, Kent
Anthony James Consulting
Salary: From £60,000 to £70,000 per annum
Posted: Yesterday
South East
Lawrence Harvey Enterprise
Salary: £65000.00 - £80000.00 per annum
Posted: 2 days ago
Central London / West End
Source Technology
Salary: Up to £60,000 per annum £30000 - £60000 + bonus package
Posted: 6 days ago
Folkestone
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits
Posted: 8 days ago
London
Pioneer Search
Salary: £60000 - £90000 per annum + Competitive Bonus + Benefits
Posted: 2 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 6 days ago
Ipswich
Nigel Frank International
Salary: £35000 - £50000 per annum
Posted: 10 days ago
South East England
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum
Posted: 9 days ago
London
Huxley
Salary: £60000 - £70000 per annum + Excellent Benefits
Posted: 10 days ago
Hampshire
Venturi
Salary: £45000 - £48000.00 per annum + full benefits
Posted: 15 days ago
London
Huxley
Salary: £60000 - £70000 per annum + Excellent Benefits
Posted: 14 days ago
London
Client Server
Salary: £30000 - £45000 per annum + benefits
Posted: 7 days ago
Leicester, Leicestershire
TriMas Corporation
Posted: 8 days ago
City of London
Huxley
Salary: £55000 - £70000 per annum + Package
Posted: 9 days ago
City of London
Huxley
Salary: £55000 - £70000 per annum + Package
Posted: 13 days ago
London
Client Server
Salary: £35k to £45k + benefits
Posted: 14 days ago
City, London
BJSS Ltd
Salary: From £90,000 to £105,000 per annum Bonus, Health & Pension
Posted: 9 days ago
Nottingham, Nottinghamshire
BJSS Ltd
Salary: From £75,000 to £90,000 per annum Bonus, Health & Pension
Posted: 9 days ago
Folkestone
Edward Carter Solutions
Salary: £5000 per annum + Fantastic benefits
Posted: 21 days ago