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

3 months to
3 Dec 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 698 721 689
Rank change year-on-year
+23 -32
Permanent jobs citing OLTP 158 209 278
As % of all permanent IT jobs located in England 0.19% 0.21% 0.26%
As % of the Database & Business Intelligence category 0.63% 0.65% 0.84%
Number of salaries quoted 118 157 196
Median salary £52,500 £55,000 £50,000
Median salary % change year-on-year
-4.54% +10.00%
90% offered a salary of more than £37,200 £42,500 £37,500
10% offered a salary of more than £66,000 £80,000 £73,750
UK excluding London median salary £52,500 £50,000 £40,000
% change year-on-year
+5.00% +25.00%
OLTP
UK

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
24981 32192 32957
As % of all permanent IT jobs located in England 29.80% 32.03% 30.54%
Number of salaries quoted 21569 27378 28328
Median salary £50,000 £47,850 £45,000
Median salary % change year-on-year
+4.49% +6.33%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 3 December 2016.

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 3 December 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
London +53 69 £62,500 +4.16% 5
South East +72 46 £52,500 +5.00% 2
East of England +38 21 £50,000 -24.52% 4
North West -35 10 £48,750 +2.63% 2
East Midlands - 7 £32,500 -
West Midlands -39 3 £47,500 -13.63%
Yorkshire +10 1 - -
OLTP
UK

OLTP
Top 30 Related IT Skills in England

For the 6 months to 3 December 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 across the England region with a requirement for OLTP.

1 303 (86.32%) SQL
2 246 (70.09%) SQL Server
3 178 (50.71%) OLAP
4 153 (43.59%) T-SQL
5 145 (41.31%) Data Warehouse
6 140 (39.89%) Performance Tuning
7 136 (38.75%) Microsoft
8 125 (35.61%) SQL Server Integration Services
9 121 (34.47%) Business Intelligence
10 118 (33.62%) SQL Server Reporting Services
11 115 (32.76%) Oracle
12 101 (28.77%) SQL Server Analysis Services
13 99 (28.21%) Agile Software Development
14 90 (25.64%) MySQL
15 88 (25.07%) MS Excel
16 75 (21.37%) ETL
17 68 (19.37%) Finance
18 65 (18.52%) Oracle OLAP
19 63 (17.95%) Linux
20 61 (17.38%) Disaster Recovery
21 58 (16.52%) Degree
22 57 (16.24%) SQL Server 2008
23 56 (15.95%) Windows
24 53 (15.10%) NoSQL
25 51 (14.53%) Analytical Skills
26 48 (13.68%) SAN
27 47 (13.39%) Web Services
28 45 (12.82%) Kimball Methodology
29 44 (12.54%) Computer Science
29 44 (12.54%) PL/SQL

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 (7.12%) IIS
2 24 (6.84%) Apache
2 24 (6.84%) Oracle Coherence
2 24 (6.84%) Oracle HTTP Server
2 24 (6.84%) Tomcat
2 24 (6.84%) WebSphere
3 11 (3.13%) Apache Pig
4 5 (1.42%) SharePoint
5 4 (1.14%) Jupyter
6 1 (0.28%) Apache Spark
6 1 (0.28%) Oracle SOA Suite
Applications
1 88 (25.07%) MS Excel
2 1 (0.28%) MS Visio
Business Applications
1 4 (1.14%) FastStats
2 2 (0.57%) Cognos TM1
3 1 (0.28%) Dynamics AX
3 1 (0.28%) Dynamics CRM
3 1 (0.28%) Dynamics NAV
3 1 (0.28%) OPENHousing
Cloud Services
1 25 (7.12%) Amazon AWS
2 18 (5.13%) GitHub
3 14 (3.99%) Microsoft Azure
4 5 (1.42%) Amazon S3
5 4 (1.14%) Cloud Computing
5 4 (1.14%) IaaS
5 4 (1.14%) PaaS
6 3 (0.85%) Google Cloud Platform
7 2 (0.57%) SaaS
Communications & Networking
1 48 (13.68%) SAN
2 34 (9.69%) Fibre Channel
3 25 (7.12%) LAN
3 25 (7.12%) WAN
4 24 (6.84%) FCoE
4 24 (6.84%) HTTP
4 24 (6.84%) iSCSI
4 24 (6.84%) Multicast
4 24 (6.84%) NAS
5 9 (2.56%) Extranet
5 9 (2.56%) Firewall
5 9 (2.56%) Intranet
6 2 (0.57%) Internet
6 2 (0.57%) LDAP
6 2 (0.57%) Skype
6 2 (0.57%) VoIP
7 1 (0.28%) PABX
7 1 (0.28%) Wi-Fi
Database & Business Intelligence
1 246 (70.09%) SQL Server
2 178 (50.71%) OLAP
3 145 (41.31%) Data Warehouse
4 125 (35.61%) SQL Server Integration Services
5 118 (33.62%) SQL Server Reporting Services
6 101 (28.77%) SQL Server Analysis Services
7 90 (25.64%) MySQL
8 65 (18.52%) Oracle OLAP
9 57 (16.24%) SQL Server 2008
10 53 (15.10%) NoSQL
11 41 (11.68%) Relational Database
12 38 (10.83%) SQL Server 2012
13 35 (9.97%) DB2
14 34 (9.69%) Big Data
15 30 (8.55%) Power BI
15 30 (8.55%) RDBMS
16 27 (7.69%) Hadoop
17 26 (7.41%) MongoDB
17 26 (7.41%) SQL Server 2005
17 26 (7.41%) SQL Server 2014
Development Applications
1 41 (11.68%) JIRA
2 18 (5.13%) Team Foundation Server
3 13 (3.70%) Talend Open Studio
4 10 (2.85%) Jenkins
5 9 (2.56%) Cucumber
5 9 (2.56%) Vagrant
6 7 (1.99%) Oracle APEX
6 7 (1.99%) VSS/SourceSafe
7 6 (1.71%) Git (software)
8 5 (1.42%) git-flow
8 5 (1.42%) SQL Server Management Studio (SSMS)
8 5 (1.42%) Visual Studio
9 4 (1.14%) ERwin
9 4 (1.14%) tSQLt
10 2 (0.57%) FitNesse
10 2 (0.57%) JBehave
General
1 68 (19.37%) Finance
2 22 (6.27%) Retail
3 7 (1.99%) Marketing
3 7 (1.99%) Pharmaceutical
3 7 (1.99%) Telecoms
4 5 (1.42%) Advertising
4 5 (1.42%) Games
4 5 (1.42%) Manufacturing
5 3 (0.85%) Legal
6 2 (0.57%) Banking
7 1 (0.28%) German Language
7 1 (0.28%) Investment Banking
Job Titles
1 154 (43.87%) Developer
2 108 (30.77%) DBA
3 101 (28.77%) SQL Developer
4 93 (26.50%) SQL DBA
5 64 (18.23%) SQL Server DBA
6 40 (11.40%) Architect
7 38 (10.83%) Administrator
8 32 (9.12%) Oracle Developer
9 31 (8.83%) Senior DBA
10 27 (7.69%) Infrastructure Architect
10 27 (7.69%) SQL Server Developer
11 25 (7.12%) Lead Architect
12 23 (6.55%) Analyst
13 22 (6.27%) Business Intelligence Developer
14 21 (5.98%) C++ Developer
14 21 (5.98%) Senior SQL DBA
15 19 (5.41%) ETL Developer
15 19 (5.41%) Senior Developer
16 17 (4.84%) Database Developer
16 17 (4.84%) Unix Developer
Libraries, Frameworks & Software Standards
1 47 (13.39%) Web Services
2 30 (8.55%) .NET
2 30 (8.55%) XML
3 24 (6.84%) MDX
3 24 (6.84%) Middleware
4 22 (6.27%) STL
5 15 (4.27%) REST
6 13 (3.70%) ASP.NET
7 10 (2.85%) Oracle GoldenGate
7 10 (2.85%) SOAP
8 8 (2.28%) JSON
9 5 (1.42%) .NET Framework
9 5 (1.42%) ASP.NET MVC
9 5 (1.42%) Boost C++ Libraries
10 4 (1.14%) Ajax
10 4 (1.14%) HTML
10 4 (1.14%) WinForms
10 4 (1.14%) WSDL
10 4 (1.14%) WS-I
10 4 (1.14%) XSD
Miscellaneous
1 51 (14.53%) Analytical Skills
2 44 (12.54%) Computer Science
3 42 (11.97%) Replication
4 39 (11.11%) Clustering
5 34 (9.69%) Enterprise Software
6 19 (5.41%) Fintech
6 19 (5.41%) Management Information System
7 11 (3.13%) Data Integration
8 8 (2.28%) EMC VMAX
8 8 (2.28%) Statistics
9 6 (1.71%) Life Science
9 6 (1.71%) User Experience
10 5 (1.42%) Data Protection Act
10 5 (1.42%) Equities
10 5 (1.42%) Fixed Income
10 5 (1.42%) Microsoft Licensing
10 5 (1.42%) N-Tier
11 3 (0.85%) Data Structures
11 3 (0.85%) Online Games
12 2 (0.57%) Hedge funds
Operating Systems
1 63 (17.95%) Linux
2 56 (15.95%) Windows
3 39 (11.11%) Solaris
4 36 (10.26%) Unix
5 13 (3.70%) Red Hat Enterprise Linux
6 10 (2.85%) Windows Server
7 6 (1.71%) Windows Server 2008
8 2 (0.57%) Windows Server 2012
9 1 (0.28%) Android
9 1 (0.28%) Apple iOS
Processes & Methodologies
1 140 (39.89%) Performance Tuning
2 121 (34.47%) Business Intelligence
3 99 (28.21%) Agile Software Development
4 75 (21.37%) ETL
5 61 (17.38%) Disaster Recovery
6 45 (12.82%) Kimball Methodology
7 38 (10.83%) High Availability
8 36 (10.26%) Scrum
9 33 (9.40%) Data Modelling
10 31 (8.83%) OO
11 24 (6.84%) Benchmarking
11 24 (6.84%) Risk Management
12 23 (6.55%) Dimensional Modelling
13 21 (5.98%) Time Management
14 20 (5.70%) Kanban
15 18 (5.13%) Data Management
16 17 (4.84%) Mentoring
16 17 (4.84%) Unit Testing
17 16 (4.56%) Analytics
18 15 (4.27%) Capacity Planning
Programming Languages
1 303 (86.32%) SQL
2 153 (43.59%) T-SQL
3 44 (12.54%) PL/SQL
4 31 (8.83%) Java
5 24 (6.84%) C#
6 22 (6.27%) C++
7 16 (4.56%) PowerShell
8 13 (3.70%) JavaScript
9 11 (3.13%) Data Analysis Expressions (DAX)
10 10 (2.85%) Python
11 7 (1.99%) Shell Script
12 2 (0.57%) C
13 1 (0.28%) AWK
13 1 (0.28%) Objective-C
13 1 (0.28%) PHP
13 1 (0.28%) R
13 1 (0.28%) Ruby
13 1 (0.28%) VB.NET
13 1 (0.28%) VBA
13 1 (0.28%) VBScript
Qualifications
1 58 (16.52%) Degree
2 29 (8.26%) Microsoft Certification
3 11 (3.13%) MCITP
3 11 (3.13%) SC Cleared
3 11 (3.13%) Security Cleared
4 9 (2.56%) MCSE
5 6 (1.71%) PhD
6 4 (1.14%) MCP
6 4 (1.14%) MCSA
7 1 (0.28%) CISSP
7 1 (0.28%) Oracle Certification
Quality Assurance & Compliance
1 12 (3.42%) SLA
2 10 (2.85%) QA
3 9 (2.56%) Data Quality
4 3 (0.85%) PCI DSS
System Software
1 29 (8.26%) VMware Infrastructure
2 25 (7.12%) Oracle RAC
3 24 (6.84%) Hyper-V
3 24 (6.84%) KVM
3 24 (6.84%) NFS
3 24 (6.84%) SRDF
3 24 (6.84%) Xen
4 15 (4.27%) Veritas Cluster Server
5 8 (2.28%) GlusterFS
6 5 (1.42%) HDFS
6 5 (1.42%) Virtual Machines
6 5 (1.42%) VMware ESX
6 5 (1.42%) vSphere
Systems Management
1 18 (5.13%) Puppet
2 15 (4.27%) NetBackup
3 14 (3.99%) Microsoft Clustering
4 10 (2.85%) Oracle ZFS
4 10 (2.85%) Veritas Storage Foundation
5 8 (2.28%) Red Hat Satellite
6 3 (0.85%) Failover Clustering
7 1 (0.28%) Ansible
7 1 (0.28%) Perfmon
7 1 (0.28%) Tivoli Storage Manager
Vendors
1 136 (38.75%) Microsoft
2 115 (32.76%) Oracle
3 40 (11.40%) VMware
4 32 (9.12%) Cognos
4 32 (9.12%) EMC
5 30 (8.55%) IBM
5 30 (8.55%) NetApp
6 29 (8.26%) Intel
7 24 (6.84%) Cisco
8 15 (4.27%) Veritas
9 13 (3.70%) Red Hat
9 13 (3.70%) Talend
10 11 (3.13%) Computacenter
11 10 (2.85%) Brocade
11 10 (2.85%) StorageTek
11 10 (2.85%) Sun
11 10 (2.85%) Tableau
12 6 (1.71%) RedGate
13 5 (1.42%) Atlassian
13 5 (1.42%) Vertica
Stevenage, Hertfordshire
Nigel Frank International Ltd
Salary: £25000 - £32000 per annum + Benefits
Posted: Yesterday
Ipswich, Suffolk
Hurren and Hope
Salary: £45k - 50k per year + 2017 benefit pack
Posted: Yesterday
London
Stott & May
Salary: £55000 - £65000 per annum + Benefits + 15% bonus
Posted: 2 days ago
Central London / West End
Client Server
Salary: £35k to £45k + benefits
Posted: Yesterday
Crawley
Nigel Frank International
Salary: £50000 - £65000 per annum + Benefits
Posted: 6 days ago
London
Lorien Resourcing
Salary: £50000 - £55000 per annum
Posted: 3 days ago
Reading
Oracle
Salary: Competitive
Posted: 4 days ago
London
Pioneer Search
Salary: £60000.00 - £85000.00 per annum + Competitive Bonus + Benefits
Posted: 3 days ago
Luton
easyJet Airline
Posted: 12 days ago
Manchester
Adria Solutions Ltd
Salary: £30000 - £45000 per annum + Benefits
Posted: 22 days ago
London
Real Staffing
Salary: £40000 - £50000 per annum + competitive
Posted: 24 days ago