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

3 months to
28 Aug 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 697 682 677
Rank change year-on-year
-15 -5
Permanent jobs citing OLTP 189 275 282
As % of all permanent IT jobs located in England 0.21% 0.27% 0.26%
As % of the Database & Business Intelligence category 0.71% 0.86% 0.82%
Number of salaries quoted 140 170 208
Median salary £50,000 £52,500 £50,750
Median salary % change year-on-year
-4.76% +3.44%
90% offered a salary of more than £34,850 £35,000 £37,500
10% offered a salary of more than £77,650 £70,000 £65,000
UK excluding London median salary £50,000 £47,500 £47,750
% change year-on-year
+5.26% -0.52%
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
26753 31837 34593
As % of all permanent IT jobs located in England 29.59% 31.18% 31.87%
Number of salaries quoted 23131 27101 29413
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,000 £30,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 28 August 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 August 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 +12 68 £55,000 - 4
South East +13 53 £50,000 +3.62% 4
South West -3 22 £50,000 -2.43% 2
East Midlands +24 20 £33,500 -50.37% 1
Yorkshire +10 9 £80,000 +28.00%
North West +20 7 £52,500 +40.00%
East of England 0 5 £45,000 -10.00%
West Midlands -22 5 £52,500 +75.00% 2
OLTP
UK

OLTP
Top 30 Related IT Skills in England

For the 6 months to 28 August 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 273 (79.59%) SQL
2 217 (63.27%) SQL Server
3 168 (48.98%) OLAP
4 139 (40.52%) T-SQL
5 135 (39.36%) Data Warehouse
6 132 (38.48%) Performance Tuning
7 119 (34.69%) Business Intelligence
8 111 (32.36%) Oracle
9 108 (31.49%) Microsoft
10 105 (30.61%) SQL Server Integration Services
11 99 (28.86%) SQL Server Reporting Services
12 95 (27.70%) Finance
13 88 (25.66%) MS Excel
14 84 (24.49%) ETL
15 79 (23.03%) SQL Server Analysis Services
16 72 (20.99%) Degree
17 69 (20.12%) Agile Software Development
18 66 (19.24%) MySQL
19 60 (17.49%) SQL Server 2008
20 56 (16.33%) Linux
21 54 (15.74%) Windows
22 52 (15.16%) Analytical Skills
23 51 (14.87%) OO
24 44 (12.83%) XML
24 44 (12.83%) Oracle OLAP
25 43 (12.54%) PL/SQL
26 42 (12.24%) Disaster Recovery
26 42 (12.24%) Data Management
26 42 (12.24%) Kimball Methodology
27 40 (11.66%) SQL Server 2012

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 17 (4.96%) IIS
2 16 (4.66%) Apache
2 16 (4.66%) Oracle Coherence
2 16 (4.66%) Oracle HTTP Server
2 16 (4.66%) Tomcat
2 16 (4.66%) WebSphere
3 4 (1.17%) Oracle Spatial
3 4 (1.17%) Oracle Workflow
4 3 (0.87%) WebLogic
5 1 (0.29%) SharePoint
5 1 (0.29%) SharePoint 2013
Applications
1 88 (25.66%) MS Excel
2 4 (1.17%) MS Office
3 1 (0.29%) MS PowerPoint
3 1 (0.29%) MS Visio
3 1 (0.29%) Spreadsheet
Business Applications
1 5 (1.46%) Cognos Business Intelligence
2 4 (1.17%) Unica
3 2 (0.58%) Endur
3 2 (0.58%) SAP FI
4 1 (0.29%) SAP CRM
4 1 (0.29%) SAP ERP
4 1 (0.29%) SAP SCM
Cloud Services
1 6 (1.75%) Amazon AWS
2 3 (0.87%) Cloud Computing
3 1 (0.29%) Microsoft Azure
Communications & Networking
1 33 (9.62%) SAN
2 20 (5.83%) Fibre Channel
3 17 (4.96%) LAN
3 17 (4.96%) NAS
3 17 (4.96%) WAN
4 16 (4.66%) FCoE
4 16 (4.66%) HTTP
4 16 (4.66%) iSCSI
4 16 (4.66%) Multicast
5 15 (4.37%) Extranet
5 15 (4.37%) Intranet
6 9 (2.62%) Firewall
7 2 (0.58%) Internet
7 2 (0.58%) Skype
8 1 (0.29%) LDAP
8 1 (0.29%) PABX
8 1 (0.29%) VoIP
8 1 (0.29%) Wi-Fi
Database & Business Intelligence
1 217 (63.27%) SQL Server
2 168 (48.98%) OLAP
3 135 (39.36%) Data Warehouse
4 105 (30.61%) SQL Server Integration Services
5 99 (28.86%) SQL Server Reporting Services
6 79 (23.03%) SQL Server Analysis Services
7 66 (19.24%) MySQL
8 60 (17.49%) SQL Server 2008
9 44 (12.83%) Oracle OLAP
10 40 (11.66%) SQL Server 2012
11 36 (10.50%) SQL Server 2014
12 34 (9.91%) Oracle Database
13 33 (9.62%) Relational Database
14 30 (8.75%) DB2
15 21 (6.12%) NoSQL
16 20 (5.83%) Microsoft Analysis Services
17 18 (5.25%) BusinessObjects
17 18 (5.25%) MongoDB
17 18 (5.25%) Oracle ODI
18 16 (4.66%) Oracle Database 11g
Development Applications
1 17 (4.96%) Team Foundation Server
2 11 (3.21%) Oracle APEX
2 11 (3.21%) VSS/SourceSafe
3 7 (2.04%) JIRA
4 6 (1.75%) Git (software)
4 6 (1.75%) tSQLt
4 6 (1.75%) Visual Studio
5 5 (1.46%) SQL Server Management Studio (SSMS)
6 4 (1.17%) Subversion
7 1 (0.29%) Cucumber
7 1 (0.29%) ERwin
7 1 (0.29%) FitNesse
7 1 (0.29%) JBehave
7 1 (0.29%) Jenkins
General
1 95 (27.70%) Finance
2 31 (9.04%) Retail
3 12 (3.50%) Telecoms
4 11 (3.21%) Banking
5 10 (2.92%) Marketing
5 10 (2.92%) Pharmaceutical
6 6 (1.75%) Legal
7 5 (1.46%) Publishing
8 3 (0.87%) Back Office
8 3 (0.87%) Manufacturing
8 3 (0.87%) Private Banking
9 2 (0.58%) Advertising
9 2 (0.58%) Financial Institution
9 2 (0.58%) Games
Job Titles
1 170 (49.56%) Developer
2 89 (25.95%) DBA
3 84 (24.49%) SQL Developer
4 77 (22.45%) SQL DBA
5 56 (16.33%) Architect
6 54 (15.74%) Oracle Developer
7 51 (14.87%) SQL Server DBA
8 31 (9.04%) Business Intelligence Developer
8 31 (9.04%) Infrastructure Architect
9 30 (8.75%) Administrator
10 25 (7.29%) SQL Server Developer
11 24 (7.00%) Lead Developer
12 22 (6.41%) Senior DBA
13 21 (6.12%) C++ Developer
13 21 (6.12%) Database Developer
13 21 (6.12%) Senior Developer
13 21 (6.12%) Unix Developer
14 20 (5.83%) SSIS Developer
15 17 (4.96%) Lead Architect
15 17 (4.96%) SSRS Developer
Libraries, Frameworks & Software Standards
1 44 (12.83%) XML
2 36 (10.50%) Web Services
3 25 (7.29%) MDX
4 22 (6.41%) .NET
4 22 (6.41%) Middleware
5 21 (6.12%) STL
6 17 (4.96%) SOAP
7 15 (4.37%) REST
7 15 (4.37%) WSDL
7 15 (4.37%) WS-I
7 15 (4.37%) XSD
8 12 (3.50%) Oracle GoldenGate
9 10 (2.92%) ASP.NET
10 9 (2.62%) JSON
11 6 (1.75%) Django
11 6 (1.75%) WCF
12 5 (1.46%) WinForms
13 4 (1.17%) ASP.NET MVC
13 4 (1.17%) WF
13 4 (1.17%) Windows Identity Foundation
Miscellaneous
1 52 (15.16%) Analytical Skills
2 38 (11.08%) Enterprise Software
3 35 (10.20%) Clustering
4 28 (8.16%) Replication
5 25 (7.29%) Computer Science
6 23 (6.71%) Management Information System
7 12 (3.50%) Fintech
8 9 (2.62%) Data Integration
8 9 (2.62%) Life Science
8 9 (2.62%) Statistics
9 7 (2.04%) Data Protection Act
9 7 (2.04%) Visualisation
10 5 (1.46%) Microsoft Licensing
11 3 (0.87%) Algorithms
11 3 (0.87%) Data Conversion
11 3 (0.87%) Data Structures
11 3 (0.87%) EMC VMAX
11 3 (0.87%) Mobile Payment
11 3 (0.87%) PKI
11 3 (0.87%) User Experience
Operating Systems
1 56 (16.33%) Linux
2 54 (15.74%) Windows
3 34 (9.91%) Unix
4 25 (7.29%) Solaris
5 16 (4.66%) Windows Server
6 8 (2.33%) Red Hat Enterprise Linux
6 8 (2.33%) Windows Server 2008
7 5 (1.46%) Windows Server 2012
Processes & Methodologies
1 132 (38.48%) Performance Tuning
2 119 (34.69%) Business Intelligence
3 84 (24.49%) ETL
4 69 (20.12%) Agile Software Development
5 51 (14.87%) OO
6 42 (12.24%) Data Management
6 42 (12.24%) Disaster Recovery
6 42 (12.24%) Kimball Methodology
7 34 (9.91%) High Availability
7 34 (9.91%) SOA
8 26 (7.58%) Data Modelling
8 26 (7.58%) Dimensional Modelling
9 24 (7.00%) Project Management
10 22 (6.41%) Data Architecture
10 22 (6.41%) SDLC
11 21 (6.12%) Data Analysis
11 21 (6.12%) Enterprise Architecture
11 21 (6.12%) Performance Management
12 20 (5.83%) Benchmarking
13 19 (5.54%) UML
Programming Languages
1 273 (79.59%) SQL
2 139 (40.52%) T-SQL
3 43 (12.54%) PL/SQL
4 37 (10.79%) Java
5 25 (7.29%) C#
6 23 (6.71%) C++
7 19 (5.54%) JavaScript
8 17 (4.96%) PowerShell
9 13 (3.79%) Python
10 11 (3.21%) Data Analysis Expressions (DAX)
11 6 (1.75%) C
12 5 (1.46%) PHP
12 5 (1.46%) Shell Script
12 5 (1.46%) VB.NET
13 4 (1.17%) Perl
14 2 (0.58%) R
14 2 (0.58%) Ruby
14 2 (0.58%) VB
15 1 (0.29%) VBA
15 1 (0.29%) VBScript
Qualifications
1 72 (20.99%) Degree
2 12 (3.50%) Microsoft Certification
3 9 (2.62%) PhD
4 7 (2.04%) MCSE
5 6 (1.75%) MCP
5 6 (1.75%) MCSA
6 4 (1.17%) MCITP
6 4 (1.17%) SC Cleared
6 4 (1.17%) Security Cleared
7 3 (0.87%) IBM Certification
8 1 (0.29%) CISSP
8 1 (0.29%) MBA
8 1 (0.29%) Oracle Certification
Quality Assurance & Compliance
1 13 (3.79%) QA
2 5 (1.46%) Data Quality
3 3 (0.87%) PCI DSS
3 3 (0.87%) SLA
System Software
1 21 (6.12%) VMware Infrastructure
2 17 (4.96%) Oracle RAC
3 16 (4.66%) Hyper-V
3 16 (4.66%) KVM
3 16 (4.66%) NFS
3 16 (4.66%) SRDF
3 16 (4.66%) Xen
4 5 (1.46%) Virtual Machines
4 5 (1.46%) VMware ESX
4 5 (1.46%) vSphere
5 4 (1.17%) Veritas Cluster Server
6 3 (0.87%) GlusterFS
Systems Management
1 13 (3.79%) Microsoft Clustering
2 4 (1.17%) NetBackup
2 4 (1.17%) Oracle ZFS
2 4 (1.17%) Veritas Storage Foundation
3 3 (0.87%) OpenView
3 3 (0.87%) Red Hat Satellite
3 3 (0.87%) Tivoli
4 1 (0.29%) Ansible
4 1 (0.29%) Oracle RMAN
4 1 (0.29%) Perfmon
Vendors
1 111 (32.36%) Oracle
2 108 (31.49%) Microsoft
3 32 (9.33%) IBM
3 32 (9.33%) VMware
4 21 (6.12%) NetApp
5 19 (5.54%) EMC
6 16 (4.66%) Cisco
6 16 (4.66%) Cognos
6 16 (4.66%) Intel
7 15 (4.37%) Tableau
8 8 (2.33%) Red Hat
9 7 (2.04%) SAP
9 7 (2.04%) Sun
10 6 (1.75%) RedGate
11 5 (1.46%) Atlassian
11 5 (1.46%) CommVault
11 5 (1.46%) SolarWinds
11 5 (1.46%) Sophos
12 4 (1.17%) Informatica
12 4 (1.17%) StorageTek
Truro, Cornwall
Fruition IT Resources Limited
Salary: £45000 - £55000 per annum + benefits
Posted: 5 days ago
Central London / West End
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 2 days ago
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 4 days ago
Surrey
Lawrence Harvey Enterprise
Salary: £55000.00 - £60000.00 per annum + pension, bonus, flexi-working
Posted: 6 days ago
Crawley, Sussex
Juice Resource Solutions Limited
Salary: package
Posted: 3 days ago
Central London / West End
Gamesys
Posted: 2 days ago
Redhill, Surrey
Cubic Transportation Systems Limited
Salary: Competitive basic + benefits
Posted: 2 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 10 days ago
Birmingham, West Midlands (County)
FIS Global
Salary: Competitive + Benefits
Posted: 2 days ago
Camborne
Hays Specialist Recruitment Ltd
Salary: £45000.00 - £55000.00 per annum + Relocation + Home working
Posted: 19 days ago
London
Exceedra
Posted: 16 days ago
Sutton, London UK
Reed Business Information
Salary: Competitive Salary + bonus + benefits
Posted: 13 days ago
Warwick
Computer Futures
Salary: competitive
Posted: 25 days ago