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

3 months to
28 Sep 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 697 666 696
Rank change year-on-year
-31 +30
Permanent jobs citing OLTP 185 265 265
As % of all permanent IT jobs located in England 0.21% 0.26% 0.25%
As % of the Database & Business Intelligence category 0.70% 0.84% 0.80%
Number of salaries quoted 140 182 184
Median salary £50,000 £55,000 £50,000
Median salary % change year-on-year
-9.09% +10.00%
90% offered a salary of more than £35,900 £38,250 £37,500
10% offered a salary of more than £66,150 £70,000 £69,250
UK excluding London median salary £50,000 £50,000 £45,000
% change year-on-year
- +11.11%
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
26422 31665 33260
As % of all permanent IT jobs located in England 29.49% 30.96% 31.51%
Number of salaries quoted 22670 27000 28189
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £75,000 £67,500 £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 28 September 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 28 September 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
South East +33 60 £52,500 +10.52% 3
London +3 55 £55,000 -8.33% 5
East Midlands +34 21 £33,500 -50.37%
South West -6 19 £50,000 -16.66%
East of England +21 12 £40,000 -42.85% 2
North West -4 11 £52,500 +10.52%
West Midlands -27 4 £50,000 +5.26%
Yorkshire -4 3 £85,000 +36.00%
OLTP
UK

OLTP
Top 30 Related IT Skills in England

For the 6 months to 28 September 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 293 (82.07%) SQL
2 237 (66.39%) SQL Server
3 188 (52.66%) OLAP
4 157 (43.98%) T-SQL
5 149 (41.74%) Data Warehouse
6 139 (38.94%) Performance Tuning
7 128 (35.85%) Business Intelligence
8 122 (34.17%) SQL Server Integration Services
9 117 (32.77%) Microsoft
10 113 (31.65%) SQL Server Reporting Services
11 111 (31.09%) Oracle
12 93 (26.05%) Finance
13 92 (25.77%) SQL Server Analysis Services
14 91 (25.49%) MS Excel
15 87 (24.37%) ETL
16 85 (23.81%) Agile Software Development
17 76 (21.29%) MySQL
18 66 (18.49%) Degree
19 65 (18.21%) SQL Server 2008
20 57 (15.97%) Oracle OLAP
21 56 (15.69%) Windows
22 54 (15.13%) Linux
23 49 (13.73%) Disaster Recovery
23 49 (13.73%) Analytical Skills
24 47 (13.17%) Kimball Methodology
25 42 (11.76%) OO
26 41 (11.48%) PL/SQL
26 41 (11.48%) NoSQL
27 39 (10.92%) SQL Server 2012
27 39 (10.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 22 (6.16%) IIS
2 21 (5.88%) Apache
2 21 (5.88%) Oracle Coherence
2 21 (5.88%) Oracle HTTP Server
2 21 (5.88%) Tomcat
2 21 (5.88%) WebSphere
3 7 (1.96%) Apache Pig
4 5 (1.40%) SharePoint
5 3 (0.84%) Oracle Spatial
6 2 (0.56%) Jupyter
6 2 (0.56%) Oracle Workflow
7 1 (0.28%) SharePoint 2013
7 1 (0.28%) WebLogic
Applications
1 91 (25.49%) MS Excel
2 2 (0.56%) MS Office
3 1 (0.28%) MS Visio
Business Applications
1 4 (1.12%) Cognos Business Intelligence
2 2 (0.56%) Endur
2 2 (0.56%) SAP FI
2 2 (0.56%) Unica
3 1 (0.28%) Cognos TM1
3 1 (0.28%) FastStats
3 1 (0.28%) SAP CRM
3 1 (0.28%) SAP ERP
3 1 (0.28%) SAP SCM
Cloud Services
1 11 (3.08%) Amazon AWS
1 11 (3.08%) GitHub
2 5 (1.40%) Amazon S3
3 4 (1.12%) Cloud Computing
4 2 (0.56%) Google Cloud Platform
4 2 (0.56%) Microsoft Azure
4 2 (0.56%) PaaS
5 1 (0.28%) IaaS
5 1 (0.28%) SaaS
Communications & Networking
1 38 (10.64%) SAN
2 26 (7.28%) Fibre Channel
3 22 (6.16%) LAN
3 22 (6.16%) WAN
4 21 (5.88%) FCoE
4 21 (5.88%) HTTP
4 21 (5.88%) iSCSI
4 21 (5.88%) Multicast
4 21 (5.88%) NAS
5 13 (3.64%) Extranet
5 13 (3.64%) Intranet
6 9 (2.52%) Firewall
7 2 (0.56%) Internet
7 2 (0.56%) LDAP
7 2 (0.56%) Skype
7 2 (0.56%) VoIP
8 1 (0.28%) PABX
8 1 (0.28%) Wi-Fi
Database & Business Intelligence
1 237 (66.39%) SQL Server
2 188 (52.66%) OLAP
3 149 (41.74%) Data Warehouse
4 122 (34.17%) SQL Server Integration Services
5 113 (31.65%) SQL Server Reporting Services
6 92 (25.77%) SQL Server Analysis Services
7 76 (21.29%) MySQL
8 65 (18.21%) SQL Server 2008
9 57 (15.97%) Oracle OLAP
10 41 (11.48%) NoSQL
11 39 (10.92%) Relational Database
11 39 (10.92%) SQL Server 2012
12 34 (9.52%) DB2
12 34 (9.52%) SQL Server 2014
13 24 (6.72%) Big Data
13 24 (6.72%) SQL Server 2005
14 23 (6.44%) Microsoft Analysis Services
14 23 (6.44%) RDBMS
15 21 (5.88%) Oracle Database
16 16 (4.48%) MongoDB
Development Applications
1 22 (6.16%) JIRA
2 19 (5.32%) Team Foundation Server
3 10 (2.80%) Jenkins
4 9 (2.52%) Vagrant
5 8 (2.24%) Cucumber
5 8 (2.24%) Oracle APEX
5 8 (2.24%) Talend Open Studio
5 8 (2.24%) VSS/SourceSafe
6 6 (1.68%) tSQLt
6 6 (1.68%) Visual Studio
7 5 (1.40%) SQL Server Management Studio (SSMS)
8 4 (1.12%) ERwin
9 1 (0.28%) FitNesse
9 1 (0.28%) Git (software)
9 1 (0.28%) JBehave
9 1 (0.28%) Subversion
General
1 93 (26.05%) Finance
2 29 (8.12%) Retail
3 10 (2.80%) Marketing
3 10 (2.80%) Pharmaceutical
3 10 (2.80%) Telecoms
4 8 (2.24%) Banking
5 6 (1.68%) Legal
6 5 (1.40%) Manufacturing
7 3 (0.84%) Back Office
8 2 (0.56%) Financial Institution
8 2 (0.56%) Games
8 2 (0.56%) Publishing
9 1 (0.28%) Advertising
9 1 (0.28%) German Language
Job Titles
1 173 (48.46%) Developer
2 102 (28.57%) DBA
3 96 (26.89%) SQL Developer
4 88 (24.65%) SQL DBA
5 61 (17.09%) SQL Server DBA
6 51 (14.29%) Architect
7 44 (12.32%) Oracle Developer
8 32 (8.96%) Administrator
8 32 (8.96%) Infrastructure Architect
9 31 (8.68%) Business Intelligence Developer
10 29 (8.12%) Senior DBA
11 26 (7.28%) Senior Developer
11 26 (7.28%) SQL Server Developer
12 25 (7.00%) Lead Developer
13 22 (6.16%) Lead Architect
14 20 (5.60%) SSIS Developer
15 19 (5.32%) C++ Developer
15 19 (5.32%) Database Developer
15 19 (5.32%) ETL Developer
15 19 (5.32%) Unix Developer
Libraries, Frameworks & Software Standards
1 36 (10.08%) XML
2 35 (9.80%) Web Services
3 28 (7.84%) .NET
3 28 (7.84%) MDX
4 25 (7.00%) Middleware
5 19 (5.32%) STL
6 14 (3.92%) REST
7 12 (3.36%) SOAP
8 10 (2.80%) ASP.NET
8 10 (2.80%) Oracle GoldenGate
9 9 (2.52%) JSON
9 9 (2.52%) WSDL
9 9 (2.52%) WS-I
9 9 (2.52%) XSD
10 6 (1.68%) Django
11 5 (1.40%) .NET Framework
11 5 (1.40%) WinForms
12 4 (1.12%) ASP.NET MVC
12 4 (1.12%) WCF
13 3 (0.84%) WF
Miscellaneous
1 49 (13.73%) Analytical Skills
2 37 (10.36%) Clustering
2 37 (10.36%) Enterprise Software
3 32 (8.96%) Replication
4 26 (7.28%) Computer Science
5 17 (4.76%) Management Information System
6 13 (3.64%) Data Integration
7 12 (3.36%) Fintech
8 9 (2.52%) Life Science
9 8 (2.24%) Statistics
10 6 (1.68%) Data Protection Act
10 6 (1.68%) User Experience
11 5 (1.40%) Microsoft Licensing
11 5 (1.40%) N-Tier
11 5 (1.40%) Visualisation
12 3 (0.84%) Algorithms
12 3 (0.84%) Data Conversion
12 3 (0.84%) Data Structures
12 3 (0.84%) EMC VMAX
13 2 (0.56%) Blackberry
Operating Systems
1 56 (15.69%) Windows
2 54 (15.13%) Linux
3 32 (8.96%) Unix
4 28 (7.84%) Solaris
5 13 (3.64%) Windows Server
6 9 (2.52%) Windows Server 2008
7 8 (2.24%) Red Hat Enterprise Linux
8 5 (1.40%) Windows Server 2012
9 1 (0.28%) Android
9 1 (0.28%) Apple iOS
Processes & Methodologies
1 139 (38.94%) Performance Tuning
2 128 (35.85%) Business Intelligence
3 87 (24.37%) ETL
4 85 (23.81%) Agile Software Development
5 49 (13.73%) Disaster Recovery
6 47 (13.17%) Kimball Methodology
7 42 (11.76%) OO
8 37 (10.36%) Data Modelling
9 36 (10.08%) High Availability
10 33 (9.24%) Data Management
11 30 (8.40%) Dimensional Modelling
12 26 (7.28%) SOA
13 23 (6.44%) Scrum
14 22 (6.16%) Benchmarking
15 21 (5.88%) Project Management
15 21 (5.88%) Risk Management
16 20 (5.60%) Data Analysis
16 20 (5.60%) Mentoring
16 20 (5.60%) SDLC
17 19 (5.32%) Capacity Planning
Programming Languages
1 293 (82.07%) SQL
2 157 (43.98%) T-SQL
3 41 (11.48%) PL/SQL
4 38 (10.64%) Java
5 23 (6.44%) C#
6 19 (5.32%) C++
6 19 (5.32%) PowerShell
7 17 (4.76%) JavaScript
8 13 (3.64%) Data Analysis Expressions (DAX)
9 12 (3.36%) Python
10 9 (2.52%) Shell Script
11 6 (1.68%) C
12 2 (0.56%) PHP
12 2 (0.56%) VB.NET
13 1 (0.28%) Objective-C
13 1 (0.28%) Perl
13 1 (0.28%) R
13 1 (0.28%) Ruby
13 1 (0.28%) VBA
13 1 (0.28%) VBScript
Qualifications
1 66 (18.49%) Degree
2 23 (6.44%) Microsoft Certification
3 11 (3.08%) MCITP
3 11 (3.08%) MCSE
3 11 (3.08%) SC Cleared
3 11 (3.08%) Security Cleared
4 9 (2.52%) PhD
5 6 (1.68%) MCP
5 6 (1.68%) MCSA
6 3 (0.84%) IBM Certification
7 1 (0.28%) CISSP
7 1 (0.28%) Oracle Certification
Quality Assurance & Compliance
1 13 (3.64%) QA
2 7 (1.96%) Data Quality
3 3 (0.84%) PCI DSS
4 1 (0.28%) SLA
System Software
1 26 (7.28%) VMware Infrastructure
2 22 (6.16%) Oracle RAC
3 21 (5.88%) Hyper-V
3 21 (5.88%) KVM
3 21 (5.88%) NFS
3 21 (5.88%) SRDF
3 21 (5.88%) Xen
4 5 (1.40%) HDFS
4 5 (1.40%) Veritas Cluster Server
4 5 (1.40%) Virtual Machines
4 5 (1.40%) VMware ESX
4 5 (1.40%) vSphere
5 3 (0.84%) GlusterFS
Systems Management
1 16 (4.48%) Microsoft Clustering
2 11 (3.08%) Puppet
3 5 (1.40%) NetBackup
3 5 (1.40%) Oracle ZFS
3 5 (1.40%) Veritas Storage Foundation
4 3 (0.84%) Red Hat Satellite
5 1 (0.28%) Ansible
5 1 (0.28%) OpenView
5 1 (0.28%) Perfmon
5 1 (0.28%) Tivoli
Vendors
1 117 (32.77%) Microsoft
2 111 (31.09%) Oracle
3 39 (10.92%) VMware
4 34 (9.52%) IBM
5 26 (7.28%) NetApp
6 24 (6.72%) EMC
7 23 (6.44%) Cognos
8 21 (5.88%) Cisco
8 21 (5.88%) Intel
9 16 (4.48%) Tableau
10 11 (3.08%) Computacenter
11 8 (2.24%) Red Hat
11 8 (2.24%) Talend
12 7 (1.96%) SAP
13 6 (1.68%) RedGate
13 6 (1.68%) Sun
14 5 (1.40%) CommVault
14 5 (1.40%) Sophos
14 5 (1.40%) StorageTek
14 5 (1.40%) Veritas
London
Tech
Salary: From £45,000 to £50,000 per annum
Posted: 9 hours ago
Redhill, Surrey
Total Recruitment Specialists Limited / TRG / Total recruitment group
Salary: £45000 - £60000 Per Annum Benefits Package (Pension, Bonus etc)
Posted: 7 hours ago
Surrey
TRG
Salary: 45000-60000 Per Annum Benefits Package (Pension, Bonus etc)
Posted: 20 hours ago
City, London
Stott & May
Salary: £65000 - £80000 per annum + Bonus + overtime + 5k benefits
Posted: 2 days ago
Reading
Hays West And Wales
Salary: £45000.00 - £50000.00 per annum + Benefits
Posted: 5 days ago
Central London / West End
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 5 days ago
Suffolk
Nigel Frank International Ltd
Salary: £30000 - £50000 per annum + Pension, Training
Posted: 16 days ago
London
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 12 days ago
Luton, Bedfordshire
Tui (Ip) Ltd
Salary: Competitive Salary
Posted: 20 days ago