The following table provides summary statistics for permanent job vacancies advertised in England with a requirement for OLTP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLTP over the 3 months to 24 March 2017 with a comparison to the same period in the previous 2 years.

3 months to
24 Mar 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
UK / England
Rank 708 769 783
Rank change year-on-year +61 +14  
Permanent jobs citing OLTP 115 153 155
As % of all permanent IT jobs advertised in England 0.14% 0.16% 0.16%
As % of the Database & Business Intelligence category 0.48% 0.51% 0.50%
Number of salaries quoted 86 107 97
Median salary £60,000 £55,000 £54,000
Median salary % change year-on-year +9.09% +1.85%  
90% offered a salary of more than £42,500 £35,000 £40,000
10% offered a salary of more than £75,000 £70,000 £74,000
UK excluding London median salary £52,500 £47,500 £45,000
% change year-on-year +10.52% +5.55%  

OLTP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in England with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
England
Permanent job vacancies with a requirement for database and business intelligence skills 24201 29914 30920
As % of all permanent IT job vacancies advertised in England 30.33% 31.00% 31.27%
Number of salaries quoted 20765 25760 26436
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,250
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

OLTP
Job Vacancy Trend in England

The job posting trend of jobs advertised in England citing OLTP as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for OLTP in England

OLTP
Salary Trend in England

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

Salary trend for OLTP in England

OLTP
Salary Histogram in England

The salary distribution of IT jobs citing OLTP in England over the 3 months to 24 March 2017.

Salary histogram for OLTP 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 24 March 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 +41 55 £70,000 +21.73% 5
South East +76 37 £52,500 +5.00% 1
East Midlands 0 11 £75,000 +25.00%
East of England +23 5 £50,000 -9.09% 3
North West -17 3 £75,000 +57.89%
West Midlands +18 2 £52,500 +50.00%
Yorkshire +15 2 £42,500 -32.00%
OLTP
UK

OLTP
Top 30 Related IT Skills in England

For the 6 months to 24 March 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 211 (78.73%) SQL
2 164 (61.19%) SQL Server
3 125 (46.64%) OLAP
4 105 (39.18%) SQL Server Integration Services
5 104 (38.81%) Microsoft
5 104 (38.81%) Performance Tuning
6 102 (38.06%) Oracle
6 102 (38.06%) SQL Server Reporting Services
7 99 (36.94%) Business Intelligence
8 92 (34.33%) Data Warehouse
9 85 (31.72%) Agile Software Development
10 78 (29.10%) T-SQL
11 77 (28.73%) ETL
12 76 (28.36%) SQL Server Analysis Services
13 62 (23.13%) Linux
13 62 (23.13%) MySQL
14 57 (21.27%) Disaster Recovery
15 55 (20.52%) Oracle OLAP
16 50 (18.66%) Analytical Skills
17 47 (17.54%) SQL Server 2008
18 45 (16.79%) Replication
19 41 (15.30%) PL/SQL
19 41 (15.30%) MS Excel
20 40 (14.93%) Unix
20 40 (14.93%) Windows
20 40 (14.93%) Finance
21 39 (14.55%) NoSQL
21 39 (14.55%) High Availability
22 38 (14.18%) Degree
23 37 (13.81%) Hadoop

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 21 (7.84%) IIS
2 16 (5.97%) Apache
2 16 (5.97%) Tomcat
3 11 (4.10%) Oracle Coherence
3 11 (4.10%) Oracle HTTP Server
3 11 (4.10%) WebSphere
4 9 (3.36%) SharePoint
5 6 (2.24%) Oracle Service Bus
6 5 (1.87%) Apache Pig
6 5 (1.87%) Apache Spark
7 3 (1.12%) JBoss
7 3 (1.12%) Jupyter
7 3 (1.12%) Oracle SOA Suite
7 3 (1.12%) WebLogic
8 2 (0.75%) Cloud Foundry
8 2 (0.75%) GemFire
9 1 (0.37%) Apache Solr
Applications
1 41 (15.30%) MS Excel
2 3 (1.12%) MS Visio
Business Applications
1 5 (1.87%) FastStats
2 2 (0.75%) SAP CO
2 2 (0.75%) SAP FI
2 2 (0.75%) SAP FI/CO
2 2 (0.75%) SAP FSCM
2 2 (0.75%) SAP MM
2 2 (0.75%) SAP PS
2 2 (0.75%) SAP SD
3 1 (0.37%) Cognos TM1
3 1 (0.37%) Dynamics AX
3 1 (0.37%) Dynamics CRM
3 1 (0.37%) Dynamics NAV
3 1 (0.37%) OPENHousing
Cloud Services
1 32 (11.94%) Microsoft Azure
2 23 (8.58%) Amazon AWS
3 12 (4.48%) Cloud Computing
4 11 (4.10%) GitHub
5 10 (3.73%) IaaS
6 9 (3.36%) PaaS
7 3 (1.12%) SaaS
8 1 (0.37%) Google Cloud Platform
Communications & Networking
1 28 (10.45%) SAN
2 18 (6.72%) Fibre Channel
3 11 (4.10%) FCoE
3 11 (4.10%) HTTP
3 11 (4.10%) iSCSI
3 11 (4.10%) LAN
3 11 (4.10%) Multicast
3 11 (4.10%) NAS
3 11 (4.10%) WAN
4 9 (3.36%) Intranet
5 2 (0.75%) Extranet
5 2 (0.75%) Internet
Database & Business Intelligence
1 164 (61.19%) SQL Server
2 125 (46.64%) OLAP
3 105 (39.18%) SQL Server Integration Services
4 102 (38.06%) SQL Server Reporting Services
5 92 (34.33%) Data Warehouse
6 76 (28.36%) SQL Server Analysis Services
7 62 (23.13%) MySQL
8 55 (20.52%) Oracle OLAP
9 47 (17.54%) SQL Server 2008
10 39 (14.55%) NoSQL
11 37 (13.81%) Hadoop
12 35 (13.06%) Relational Database
12 35 (13.06%) SQL Server 2012
13 33 (12.31%) Big Data
14 30 (11.19%) Power BI
15 27 (10.07%) SQL Server 2014
16 26 (9.70%) RDBMS
17 25 (9.33%) Microsoft Analysis Services
17 25 (9.33%) Oracle Database
18 20 (7.46%) DB2
Development Applications
1 29 (10.82%) JIRA
2 27 (10.07%) Team Foundation Server
3 11 (4.10%) Talend Open Studio
3 11 (4.10%) Visual Studio
4 9 (3.36%) Git (software)
5 7 (2.61%) git-flow
6 3 (1.12%) Oracle APEX
6 3 (1.12%) VSS/SourceSafe
7 2 (0.75%) Eclipse
7 2 (0.75%) Gradle
7 2 (0.75%) Jenkins
7 2 (0.75%) JUnit
8 1 (0.37%) Cucumber
8 1 (0.37%) ERwin
8 1 (0.37%) FitNesse
8 1 (0.37%) JBehave
8 1 (0.37%) MagicDraw
General
1 40 (14.93%) Finance
2 15 (5.60%) Advertising
3 6 (2.24%) Retail
4 4 (1.49%) Games
5 3 (1.12%) Pharmaceutical
6 2 (0.75%) Banking
6 2 (0.75%) Telecoms
7 1 (0.37%) Automotive
7 1 (0.37%) Investment Banking
7 1 (0.37%) Marketing
7 1 (0.37%) Wholesale Banking
Job Titles
1 111 (41.42%) Developer
2 73 (27.24%) DBA
3 61 (22.76%) SQL Developer
4 58 (21.64%) SQL DBA
5 37 (13.81%) SQL Server DBA
6 34 (12.69%) Administrator
6 34 (12.69%) Architect
7 26 (9.70%) Oracle Developer
8 25 (9.33%) C++ Developer
9 22 (8.21%) Analyst
10 21 (7.84%) Lead Architect
11 19 (7.09%) Business Intelligence Developer
12 17 (6.34%) ETL Developer
12 17 (6.34%) Unix Developer
13 16 (5.97%) SSIS Developer
14 15 (5.60%) Senior DBA
14 15 (5.60%) Technical Architect
15 14 (5.22%) Database Developer
15 14 (5.22%) Infrastructure Architect
15 14 (5.22%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 31 (11.57%) STL
2 29 (10.82%) Web Services
3 23 (8.58%) .NET
4 16 (5.97%) Middleware
5 14 (5.22%) Boost C++ Libraries
6 12 (4.48%) ASP.NET
7 10 (3.73%) XML
8 8 (2.99%) MDX
8 8 (2.99%) Oracle GoldenGate
9 6 (2.24%) HTML
10 5 (1.87%) REST
10 5 (1.87%) SOAP
11 4 (1.49%) Ajax
11 4 (1.49%) ASP.NET MVC
11 4 (1.49%) CSS
11 4 (1.49%) XHTML
12 3 (1.12%) SAML
12 3 (1.12%) WCF
12 3 (1.12%) WF
12 3 (1.12%) XSL
Miscellaneous
1 50 (18.66%) Analytical Skills
2 45 (16.79%) Replication
3 35 (13.06%) Computer Science
4 27 (10.07%) Clustering
5 23 (8.58%) Fintech
6 19 (7.09%) Management Information System
7 14 (5.22%) Equities
7 14 (5.22%) Fixed Income
8 9 (3.36%) Enterprise Software
9 7 (2.61%) EMC VMAX
10 3 (1.12%) Life Science
10 3 (1.12%) PKI
11 2 (0.75%) Blog
11 2 (0.75%) Data Protection Act
11 2 (0.75%) Linux Command Line
11 2 (0.75%) Online Games
11 2 (0.75%) Virtual Team
12 1 (0.37%) Data Structures
12 1 (0.37%) Reference Data
12 1 (0.37%) Taxonomies
Operating Systems
1 62 (23.13%) Linux
2 40 (14.93%) Unix
2 40 (14.93%) Windows
3 23 (8.58%) Solaris
4 15 (5.60%) Windows Server 2008
4 15 (5.60%) Windows Server 2012
5 14 (5.22%) Red Hat Enterprise Linux
6 11 (4.10%) Windows Server
7 1 (0.37%) Windows NT
Processes & Methodologies
1 104 (38.81%) Performance Tuning
2 99 (36.94%) Business Intelligence
3 85 (31.72%) Agile Software Development
4 77 (28.73%) ETL
5 57 (21.27%) Disaster Recovery
6 39 (14.55%) High Availability
7 31 (11.57%) Kimball Methodology
8 30 (11.19%) Scrum
9 29 (10.82%) Data Modelling
10 23 (8.58%) Time Management
11 21 (7.84%) Analytics
11 21 (7.84%) ITIL
12 20 (7.46%) OO
12 20 (7.46%) System Testing
13 18 (6.72%) Data Integration
13 18 (6.72%) SDLC
13 18 (6.72%) Unit Testing
14 17 (6.34%) Kanban
15 16 (5.97%) Performance Monitoring
15 16 (5.97%) Performance Optimisation
Programming Languages
1 211 (78.73%) SQL
2 78 (29.10%) T-SQL
3 41 (15.30%) PL/SQL
4 32 (11.94%) C++
5 18 (6.72%) C#
6 13 (4.85%) Java
7 8 (2.99%) Shell Script
8 7 (2.61%) JavaScript
9 6 (2.24%) Python
10 5 (1.87%) PowerShell
11 4 (1.49%) ABAP
11 4 (1.49%) R
11 4 (1.49%) VB.NET
12 3 (1.12%) VBScript
13 2 (0.75%) Data Analysis Expressions (DAX)
14 1 (0.37%) AWK
14 1 (0.37%) SPARQL
14 1 (0.37%) XPath
Qualifications
1 38 (14.18%) Degree
2 22 (8.21%) Microsoft Certification
3 5 (1.87%) SC Cleared
3 5 (1.87%) Security Cleared
4 3 (1.12%) MCITP
4 3 (1.12%) PhD
5 2 (0.75%) MCSE
Quality Assurance & Compliance
1 16 (5.97%) SLA
2 15 (5.60%) Data Quality
3 12 (4.48%) QA
4 2 (0.75%) PCI DSS
System Software
1 17 (6.34%) Oracle RAC
2 12 (4.48%) Veritas Cluster Server
3 11 (4.10%) Hyper-V
3 11 (4.10%) KVM
3 11 (4.10%) NFS
3 11 (4.10%) SRDF
3 11 (4.10%) VMware Infrastructure
3 11 (4.10%) Xen
4 9 (3.36%) Active Directory
5 7 (2.61%) GlusterFS
6 2 (0.75%) Apache ZooKeeper
6 2 (0.75%) HDFS
Systems Management
1 12 (4.48%) NetBackup
2 9 (3.36%) Oracle Enterprise Manager
2 9 (3.36%) Puppet
3 7 (2.61%) Oracle ZFS
3 7 (2.61%) Red Hat Satellite
3 7 (2.61%) Veritas Storage Foundation
4 6 (2.24%) Enterprise Manager Cloud Control
4 6 (2.24%) Oracle RMAN
5 4 (1.49%) Failover Clustering
6 3 (1.12%) Tivoli
7 1 (0.37%) Tivoli Storage Manager
Vendors
1 104 (38.81%) Microsoft
2 102 (38.06%) Oracle
3 26 (9.70%) Cognos
4 23 (8.58%) Intel
5 18 (6.72%) EMC
6 14 (5.22%) IBM
6 14 (5.22%) Red Hat
6 14 (5.22%) Vertica
7 12 (4.48%) NetApp
7 12 (4.48%) Veritas
8 11 (4.10%) Cisco
8 11 (4.10%) Talend
8 11 (4.10%) VMware
9 7 (2.61%) Brocade
9 7 (2.61%) SolarWinds
9 7 (2.61%) StorageTek
9 7 (2.61%) Sun
9 7 (2.61%) Tableau
10 6 (2.24%) Informatica
11 5 (1.87%) Salesforce.com
Cambridge
Nigel Frank International
Salary: £30000 - £50000 per annum + Benefits
Posted: 2 days ago
West London
Michael Bailey Associates
Salary: Market Rates
Posted: 2 days ago
City, London
Rutherford Grant Recruitment
Salary: £60000.00 per annum
Posted: 3 days ago
Central London / West End
The Workshop
Posted: 3 days ago
Haywards Heath
Nigel Frank International
Salary: £40000 - £55000 per annum + Benfits
Posted: 10 days ago
Ipswich
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits
Posted: 16 days ago
Cambridge
360 Resourcing Solutions .
Salary: £45,000 £50,000 per annum
Posted: 15 days ago