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

3 months to
25 Feb 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
UK / England
Rank 697 782 757
Rank change year-on-year
+85 -25
Permanent jobs citing OLTP 131 146 171
As % of all permanent IT jobs located in England 0.17% 0.15% 0.17%
As % of the Database & Business Intelligence category 0.56% 0.49% 0.55%
Number of salaries quoted 97 109 118
Median salary £57,500 £52,500 £52,500
Median salary % change year-on-year
+9.52% -
90% offered a salary of more than £40,000 £35,000 £40,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £52,500 £47,500 £45,000
% change year-on-year
+10.52% +5.55%

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
23527 30077 31008
As % of all permanent IT jobs located in England 30.26% 31.58% 31.21%
Number of salaries quoted 20193 25803 26748
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 £42,500 £42,500 £40,000
% change year-on-year
- +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 25 February 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 25 February 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 +56 58 £65,000 +18.18% 11
South East +96 47 £52,500 - 1
East of England +28 11 £48,750 -11.36% 3
East Midlands +10 5 £77,500 +29.16%
Yorkshire +29 3 £42,500 -32.00% 1
West Midlands +26 3 £52,500 +47.88% 1
North West -18 3 £56,500 +18.94%
OLTP
UK

OLTP
Top 30 Related IT Skills in England

For the 6 months to 25 February 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 248 (82.94%) SQL
2 193 (64.55%) SQL Server
3 153 (51.17%) OLAP
4 128 (42.81%) Microsoft
5 122 (40.80%) Business Intelligence
6 120 (40.13%) SQL Server Integration Services
7 118 (39.46%) SQL Server Reporting Services
7 118 (39.46%) Performance Tuning
8 116 (38.80%) Oracle
9 108 (36.12%) Data Warehouse
10 93 (31.10%) T-SQL
11 92 (30.77%) Agile Software Development
12 88 (29.43%) SQL Server Analysis Services
13 82 (27.42%) ETL
14 74 (24.75%) MySQL
15 70 (23.41%) Oracle OLAP
16 65 (21.74%) Disaster Recovery
17 63 (21.07%) Linux
18 57 (19.06%) SQL Server 2008
19 51 (17.06%) NoSQL
19 51 (17.06%) MS Excel
20 50 (16.72%) Analytical Skills
21 47 (15.72%) Finance
22 46 (15.38%) PL/SQL
23 45 (15.05%) Windows
23 45 (15.05%) Hadoop
24 43 (14.38%) Replication
25 42 (14.05%) JIRA
25 42 (14.05%) Big Data
26 41 (13.71%) High Availability

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 25 (8.36%) IIS
2 16 (5.35%) Apache
2 16 (5.35%) Tomcat
3 15 (5.02%) Oracle Coherence
3 15 (5.02%) Oracle HTTP Server
3 15 (5.02%) WebSphere
4 13 (4.35%) SharePoint
5 12 (4.01%) Apache Pig
6 5 (1.67%) Jupyter
6 5 (1.67%) Oracle Service Bus
7 3 (1.00%) Oracle SOA Suite
8 1 (0.33%) Apache Solr
8 1 (0.33%) Apache Spark
8 1 (0.33%) JBoss
8 1 (0.33%) WebLogic
Applications
1 51 (17.06%) MS Excel
2 3 (1.00%) MS Visio
Business Applications
1 6 (2.01%) FastStats
2 2 (0.67%) Cognos TM1
3 1 (0.33%) Dynamics AX
3 1 (0.33%) Dynamics CRM
3 1 (0.33%) Dynamics NAV
3 1 (0.33%) OPENHousing
Cloud Services
1 30 (10.03%) Microsoft Azure
2 28 (9.36%) Amazon AWS
3 20 (6.69%) GitHub
4 9 (3.01%) IaaS
4 9 (3.01%) PaaS
5 5 (1.67%) Amazon S3
5 5 (1.67%) Cloud Computing
6 3 (1.00%) Google Cloud Platform
7 2 (0.67%) SaaS
Communications & Networking
1 34 (11.37%) SAN
2 24 (8.03%) Fibre Channel
3 16 (5.35%) LAN
3 16 (5.35%) WAN
4 15 (5.02%) FCoE
4 15 (5.02%) HTTP
4 15 (5.02%) iSCSI
4 15 (5.02%) Multicast
4 15 (5.02%) NAS
5 9 (3.01%) Intranet
6 2 (0.67%) Extranet
6 2 (0.67%) Internet
6 2 (0.67%) VoIP
7 1 (0.33%) LDAP
7 1 (0.33%) PABX
7 1 (0.33%) Wi-Fi
Database & Business Intelligence
1 193 (64.55%) SQL Server
2 153 (51.17%) OLAP
3 120 (40.13%) SQL Server Integration Services
4 118 (39.46%) SQL Server Reporting Services
5 108 (36.12%) Data Warehouse
6 88 (29.43%) SQL Server Analysis Services
7 74 (24.75%) MySQL
8 70 (23.41%) Oracle OLAP
9 57 (19.06%) SQL Server 2008
10 51 (17.06%) NoSQL
11 45 (15.05%) Hadoop
12 42 (14.05%) Big Data
13 41 (13.71%) Relational Database
14 39 (13.04%) Power BI
15 38 (12.71%) SQL Server 2012
16 33 (11.04%) RDBMS
17 27 (9.03%) Microsoft Analysis Services
18 26 (8.70%) SQL Server 2014
19 23 (7.69%) Oracle Database
20 22 (7.36%) Apache Hive
Development Applications
1 42 (14.05%) JIRA
2 31 (10.37%) Team Foundation Server
3 19 (6.35%) Talend Open Studio
4 11 (3.68%) Visual Studio
5 9 (3.01%) Jenkins
5 9 (3.01%) Vagrant
6 8 (2.68%) Cucumber
7 7 (2.34%) Git (software)
7 7 (2.34%) git-flow
8 5 (1.67%) ERwin
8 5 (1.67%) Oracle APEX
8 5 (1.67%) VSS/SourceSafe
9 1 (0.33%) FitNesse
9 1 (0.33%) JBehave
9 1 (0.33%) MagicDraw
General
1 47 (15.72%) Finance
2 13 (4.35%) Advertising
3 10 (3.34%) Retail
4 6 (2.01%) Games
5 4 (1.34%) Marketing
6 3 (1.00%) Manufacturing
6 3 (1.00%) Pharmaceutical
6 3 (1.00%) Telecoms
7 2 (0.67%) Banking
8 1 (0.33%) Automotive
8 1 (0.33%) German Language
8 1 (0.33%) Investment Banking
8 1 (0.33%) Wholesale Banking
Job Titles
1 128 (42.81%) Developer
2 86 (28.76%) DBA
3 78 (26.09%) SQL Developer
4 72 (24.08%) SQL DBA
5 50 (16.72%) SQL Server DBA
6 35 (11.71%) Administrator
7 30 (10.03%) Architect
8 27 (9.03%) Oracle Developer
9 25 (8.36%) ETL Developer
10 24 (8.03%) C++ Developer
11 22 (7.36%) Analyst
12 20 (6.69%) Senior DBA
13 18 (6.02%) SSIS Developer
14 17 (5.69%) Business Intelligence Developer
14 17 (5.69%) Infrastructure Architect
14 17 (5.69%) Lead Architect
14 17 (5.69%) SQL Server Developer
15 16 (5.35%) Unix Developer
16 15 (5.02%) Database Developer
16 15 (5.02%) NoSQL Developer
Libraries, Frameworks & Software Standards
1 34 (11.37%) Web Services
2 31 (10.37%) .NET
3 30 (10.03%) STL
4 16 (5.35%) Middleware
5 14 (4.68%) Boost C++ Libraries
6 13 (4.35%) XML
7 12 (4.01%) ASP.NET
8 11 (3.68%) MDX
9 7 (2.34%) REST
9 7 (2.34%) SOAP
10 6 (2.01%) .NET Framework
11 5 (1.67%) Ajax
11 5 (1.67%) HTML
11 5 (1.67%) Oracle GoldenGate
12 4 (1.34%) ASP.NET MVC
12 4 (1.34%) CSS
12 4 (1.34%) XHTML
13 3 (1.00%) Entity Framework
13 3 (1.00%) WCF
13 3 (1.00%) XSL
Miscellaneous
1 50 (16.72%) Analytical Skills
2 43 (14.38%) Replication
3 36 (12.04%) Computer Science
4 30 (10.03%) Clustering
5 20 (6.69%) Fintech
6 18 (6.02%) Management Information System
7 14 (4.68%) Equities
7 14 (4.68%) Fixed Income
8 12 (4.01%) Enterprise Software
9 8 (2.68%) EMC VMAX
10 3 (1.00%) Life Science
10 3 (1.00%) N-Tier
10 3 (1.00%) Online Games
10 3 (1.00%) User Experience
11 2 (0.67%) Blog
11 2 (0.67%) Data Protection Act
12 1 (0.33%) Client/Server
12 1 (0.33%) IVR
12 1 (0.33%) PKI
12 1 (0.33%) Taxonomies
Operating Systems
1 63 (21.07%) Linux
2 45 (15.05%) Windows
3 40 (13.38%) Unix
4 29 (9.70%) Solaris
5 16 (5.35%) Windows Server 2008
6 15 (5.02%) Windows Server 2012
7 13 (4.35%) Red Hat Enterprise Linux
8 11 (3.68%) Windows Server
9 1 (0.33%) Android
9 1 (0.33%) Apple iOS
9 1 (0.33%) Windows NT
Processes & Methodologies
1 122 (40.80%) Business Intelligence
2 118 (39.46%) Performance Tuning
3 92 (30.77%) Agile Software Development
4 82 (27.42%) ETL
5 65 (21.74%) Disaster Recovery
6 41 (13.71%) High Availability
6 41 (13.71%) Scrum
7 39 (13.04%) Kimball Methodology
8 35 (11.71%) Data Modelling
9 26 (8.70%) Time Management
10 24 (8.03%) Kanban
11 22 (7.36%) Data Integration
11 22 (7.36%) Unit Testing
12 20 (6.69%) Dimensional Modelling
12 20 (6.69%) ITIL
12 20 (6.69%) System Testing
13 19 (6.35%) Analytics
13 19 (6.35%) OO
14 18 (6.02%) SDLC
15 16 (5.35%) Database Mirroring
Programming Languages
1 248 (82.94%) SQL
2 93 (31.10%) T-SQL
3 46 (15.38%) PL/SQL
4 31 (10.37%) C++
5 19 (6.35%) Java
6 18 (6.02%) C#
7 12 (4.01%) PowerShell
7 12 (4.01%) Shell Script
8 8 (2.68%) Python
9 7 (2.34%) JavaScript
10 4 (1.34%) Data Analysis Expressions (DAX)
10 4 (1.34%) VB.NET
11 3 (1.00%) VBScript
12 2 (0.67%) R
13 1 (0.33%) ABAP
13 1 (0.33%) Objective-C
13 1 (0.33%) PHP
13 1 (0.33%) Ruby
13 1 (0.33%) SPARQL
13 1 (0.33%) XPath
Qualifications
1 37 (12.37%) Degree
2 33 (11.04%) Microsoft Certification
3 11 (3.68%) SC Cleared
3 11 (3.68%) Security Cleared
4 10 (3.34%) MCITP
5 6 (2.01%) MCSE
6 3 (1.00%) PhD
Quality Assurance & Compliance
1 16 (5.35%) SLA
2 15 (5.02%) Data Quality
3 10 (3.34%) QA
4 2 (0.67%) PCI DSS
System Software
1 20 (6.69%) Oracle RAC
2 15 (5.02%) Hyper-V
2 15 (5.02%) KVM
2 15 (5.02%) NFS
2 15 (5.02%) SRDF
2 15 (5.02%) VMware Infrastructure
2 15 (5.02%) Xen
3 14 (4.68%) Veritas Cluster Server
4 9 (3.01%) Active Directory
5 8 (2.68%) GlusterFS
6 5 (1.67%) HDFS
Systems Management
1 20 (6.69%) Puppet
2 14 (4.68%) NetBackup
3 9 (3.01%) Oracle ZFS
3 9 (3.01%) Veritas Storage Foundation
4 8 (2.68%) Red Hat Satellite
5 6 (2.01%) Oracle Enterprise Manager
6 5 (1.67%) Enterprise Manager Cloud Control
6 5 (1.67%) Oracle RMAN
7 4 (1.34%) Failover Clustering
8 3 (1.00%) Microsoft Clustering
9 1 (0.33%) Tivoli
9 1 (0.33%) Tivoli Storage Manager
Vendors
1 128 (42.81%) Microsoft
2 116 (38.80%) Oracle
3 36 (12.04%) Cognos
4 27 (9.03%) Intel
5 23 (7.69%) EMC
6 19 (6.35%) Talend
7 17 (5.69%) VMware
8 16 (5.35%) IBM
8 16 (5.35%) NetApp
9 15 (5.02%) Cisco
10 14 (4.68%) Veritas
10 14 (4.68%) Vertica
11 13 (4.35%) Red Hat
12 9 (3.01%) Brocade
12 9 (3.01%) Computacenter
12 9 (3.01%) StorageTek
12 9 (3.01%) Sun
13 7 (2.34%) SolarWinds
13 7 (2.34%) Tableau
14 6 (2.01%) Informatica
West London
Michael Bailey Associates
Salary: Market Rates
Posted: 17 hours ago
City, London
Spencer Rose
Salary: £60000 - £80000 per annum + pension after 6 months probation
Posted: 17 hours ago
City, London
onezeero.
Salary: £70000 - £75000 per annum + Benefits + Bonus
Posted: Yesterday
Brentford
Nigel Frank International
Salary: £60000 per annum
Posted: 3 days ago
Reading, Oxfordshire
Oracle
Salary: Competitive
Posted: 2 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 7 days ago
Middlesbrough, Cleveland
The Bridge Ltd
Posted: Yesterday
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 7 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 7 days ago
London
asos
Salary: Competitive Salary
Posted: 8 days ago
Stoke-On-Trent, Staffordshire
bet365
Salary: Competitive Base Salary + Bonus and benefits
Posted: 16 days ago
London
Reco Group
Salary: £35,000 - £60,000 per year
Posted: 19 days ago