The table below looks at the statistics for OLTP skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited OLTP over the 3 months to 25 August 2016 with a comparison to the same period over the previous 2 years.

3 months to
25 Aug 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 712 700 699
Rank change year-on-year
-12 -1
Permanent jobs citing OLTP 202 285 299
As % of all permanent IT jobs located in the UK 0.21% 0.26% 0.26%
As % of the Database & Business Intelligence category 0.70% 0.84% 0.80%
Number of salaries quoted 145 179 222
Median salary £50,000 £52,500 £50,000
Median salary % change year-on-year
-4.76% +5.00%
90% offered a salary of more than £33,500 £35,000 £37,500
10% offered a salary of more than £76,500 £70,000 £65,000
UK excluding London median salary £50,000 £47,500 £47,500
% change year-on-year
+5.26% -

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
28975 34099 37336
As % of all permanent IT jobs located in the UK 29.66% 31.07% 31.85%
Number of salaries quoted 24750 28761 31491
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 £69,000 £71,900
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLTP
Jobs Demand Trend

The demand trend of job ads citing OLTP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLTP Jobs Demand Trend in the UK

OLTP
Salary Trend

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

OLTP Salary Trend in the UK

OLTP
Salary Histogram

This chart provides a salary histogram for IT jobs citing OLTP over the 3 months to 25 August 2016 within the UK.

OLTP Salary Histogram in the UK

OLTP
Top 30 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the UK over the 3 months to 25 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
England -40 193 £50,000 -4.76% 11
London +36 71 £55,000 - 2
South East +8 52 £50,000 +3.62% 5
Hampshire +25 28 £45,000 +28.57% 1
Southampton - 24 £50,000 - 1
South West -8 23 £50,000 -2.43% 2
East Midlands +27 20 £33,500 -50.37% 1
Berkshire -4 12 £55,000 +22.22%
Leicestershire - 12 £33,500 -
Leicester - 10 £33,500 -
Cornwall - 10 £50,000 - 2
West Yorkshire +15 9 £80,000 +28.00%
Yorkshire +9 9 £80,000 +28.00%
Slough +20 8 £55,000 +25.00%
Bradford - 8 £80,000 -
Camborne - 8 £50,000 - 1
City of London +47 7 £80,000 +23.07%
Staffordshire -15 7 £46,250 +58.11%
Stoke-on-Trent -21 7 £46,250 +65.17%
West Midlands -23 7 £46,250 +54.16% 1
Oxfordshire - 7 £60,000 - 1
North West +16 6 £52,500 +40.00%
Bath - 6 £41,000 -
Somerset - 6 £41,000 -
East of England +19 5 £45,000 -10.00%
Scotland +18 5 £45,000 +5.88%
Manchester -7 5 £52,500 +40.00%
Northampton - 5 - -
Glasgow - 5 £45,000 -
Abingdon - 5 - -

OLTP
Top 30 Related IT Skills

For the 6 months to 25 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 with a requirement for OLTP.

1 293 (80.49%) SQL
2 230 (63.19%) SQL Server
3 184 (50.55%) OLAP
4 146 (40.11%) T-SQL
4 146 (40.11%) Data Warehouse
5 139 (38.19%) Performance Tuning
6 127 (34.89%) Business Intelligence
7 118 (32.42%) Microsoft
8 115 (31.59%) Oracle
9 112 (30.77%) SQL Server Integration Services
10 104 (28.57%) SQL Server Reporting Services
11 96 (26.37%) Finance
12 94 (25.82%) MS Excel
13 89 (24.45%) ETL
14 84 (23.08%) SQL Server Analysis Services
15 75 (20.60%) Degree
16 69 (18.96%) Agile Software Development
17 68 (18.68%) MySQL
18 64 (17.58%) SQL Server 2008
19 58 (15.93%) Linux
20 56 (15.38%) Windows
21 54 (14.84%) Analytical Skills
22 52 (14.29%) OO
23 46 (12.64%) PL/SQL
24 45 (12.36%) Oracle OLAP
25 44 (12.09%) SQL Server 2012
25 44 (12.09%) XML
26 43 (11.81%) Data Management
27 42 (11.54%) Disaster Recovery
27 42 (11.54%) Kimball Methodology

OLTP
Top Related IT Skills 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.67%) IIS
2 16 (4.40%) Apache
2 16 (4.40%) Oracle Coherence
2 16 (4.40%) Oracle HTTP Server
2 16 (4.40%) Tomcat
2 16 (4.40%) WebSphere
3 5 (1.37%) SharePoint
4 4 (1.10%) Oracle Spatial
4 4 (1.10%) Oracle Workflow
5 3 (0.82%) WebLogic
6 1 (0.27%) SharePoint 2013
Applications
1 94 (25.82%) MS Excel
2 7 (1.92%) MS Office
3 1 (0.27%) MS PowerPoint
3 1 (0.27%) MS Visio
3 1 (0.27%) Spreadsheet
Business Applications
1 5 (1.37%) Cognos Business Intelligence
2 4 (1.10%) Unica
3 2 (0.55%) Endur
3 2 (0.55%) SAP FI
4 1 (0.27%) SAP CRM
4 1 (0.27%) SAP ERP
4 1 (0.27%) SAP SCM
Cloud Services
1 6 (1.65%) Amazon AWS
2 3 (0.82%) Cloud Computing
3 2 (0.55%) Microsoft Azure
Communications & Networking
1 33 (9.07%) SAN
2 20 (5.49%) Fibre Channel
3 17 (4.67%) LAN
3 17 (4.67%) NAS
3 17 (4.67%) WAN
4 16 (4.40%) FCoE
4 16 (4.40%) HTTP
4 16 (4.40%) iSCSI
4 16 (4.40%) Multicast
5 15 (4.12%) Extranet
5 15 (4.12%) Intranet
6 9 (2.47%) Firewall
7 2 (0.55%) Internet
7 2 (0.55%) Skype
8 1 (0.27%) LDAP
8 1 (0.27%) PABX
8 1 (0.27%) VoIP
8 1 (0.27%) Wi-Fi
Database & Business Intelligence
1 230 (63.19%) SQL Server
2 184 (50.55%) OLAP
3 146 (40.11%) Data Warehouse
4 112 (30.77%) SQL Server Integration Services
5 104 (28.57%) SQL Server Reporting Services
6 84 (23.08%) SQL Server Analysis Services
7 68 (18.68%) MySQL
8 64 (17.58%) SQL Server 2008
9 45 (12.36%) Oracle OLAP
10 44 (12.09%) SQL Server 2012
11 41 (11.26%) Relational Database
12 35 (9.62%) SQL Server 2014
13 34 (9.34%) Oracle Database
14 30 (8.24%) DB2
15 21 (5.77%) BusinessObjects
15 21 (5.77%) NoSQL
15 21 (5.77%) SQL Server 2005
16 20 (5.49%) Microsoft Analysis Services
17 18 (4.95%) MongoDB
17 18 (4.95%) Oracle ODI
Development Applications
1 17 (4.67%) Team Foundation Server
2 11 (3.02%) Oracle APEX
2 11 (3.02%) VSS/SourceSafe
3 8 (2.20%) SQL Server Management Studio (SSMS)
4 7 (1.92%) Git (software)
4 7 (1.92%) JIRA
5 6 (1.65%) tSQLt
5 6 (1.65%) Visual Studio
6 4 (1.10%) Subversion
7 1 (0.27%) Cucumber
7 1 (0.27%) ERwin
7 1 (0.27%) FitNesse
7 1 (0.27%) JBehave
7 1 (0.27%) Jenkins
General
1 96 (26.37%) Finance
2 31 (8.52%) Retail
3 15 (4.12%) Banking
4 13 (3.57%) Marketing
5 12 (3.30%) Telecoms
6 10 (2.75%) Pharmaceutical
7 6 (1.65%) Legal
8 5 (1.37%) Publishing
9 3 (0.82%) Advertising
9 3 (0.82%) Back Office
9 3 (0.82%) Manufacturing
9 3 (0.82%) Private Banking
10 2 (0.55%) Financial Institution
10 2 (0.55%) Games
Job Titles
1 180 (49.45%) Developer
2 94 (25.82%) DBA
3 89 (24.45%) SQL Developer
4 82 (22.53%) SQL DBA
5 57 (15.66%) Architect
5 57 (15.66%) Oracle Developer
6 54 (14.84%) SQL Server DBA
7 32 (8.79%) Business Intelligence Developer
8 31 (8.52%) Infrastructure Architect
9 30 (8.24%) Administrator
10 28 (7.69%) SQL Server Developer
11 24 (6.59%) Lead Developer
12 23 (6.32%) Senior Developer
13 22 (6.04%) C++ Developer
13 22 (6.04%) Database Developer
13 22 (6.04%) Senior DBA
13 22 (6.04%) Unix Developer
14 19 (5.22%) Analyst
14 19 (5.22%) SSIS Developer
15 17 (4.67%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 44 (12.09%) XML
2 36 (9.89%) Web Services
3 25 (6.87%) .NET
3 25 (6.87%) MDX
4 22 (6.04%) Middleware
4 22 (6.04%) STL
5 17 (4.67%) SOAP
6 15 (4.12%) REST
6 15 (4.12%) WSDL
6 15 (4.12%) WS-I
6 15 (4.12%) XSD
7 12 (3.30%) Oracle GoldenGate
8 10 (2.75%) ASP.NET
9 9 (2.47%) JSON
10 7 (1.92%) WCF
11 6 (1.65%) Django
12 5 (1.37%) WinForms
13 4 (1.10%) ASP.NET MVC
13 4 (1.10%) WF
13 4 (1.10%) Windows Identity Foundation
Miscellaneous
1 54 (14.84%) Analytical Skills
2 39 (10.71%) Enterprise Software
3 37 (10.16%) Clustering
4 29 (7.97%) Replication
5 26 (7.14%) Computer Science
6 23 (6.32%) Management Information System
7 12 (3.30%) Fintech
8 11 (3.02%) Statistics
9 9 (2.47%) Data Integration
9 9 (2.47%) Life Science
10 8 (2.20%) Visualisation
11 7 (1.92%) Data Protection Act
12 5 (1.37%) Microsoft Licensing
13 3 (0.82%) Algorithms
13 3 (0.82%) Data Conversion
13 3 (0.82%) Data Structures
13 3 (0.82%) EMC VMAX
13 3 (0.82%) Mobile Payment
13 3 (0.82%) PKI
13 3 (0.82%) User Experience
Operating Systems
1 58 (15.93%) Linux
2 56 (15.38%) Windows
3 35 (9.62%) Unix
4 25 (6.87%) Solaris
5 16 (4.40%) Windows Server
6 8 (2.20%) Red Hat Enterprise Linux
6 8 (2.20%) Windows Server 2008
7 5 (1.37%) Windows Server 2012
Processes & Methodologies
1 139 (38.19%) Performance Tuning
2 127 (34.89%) Business Intelligence
3 89 (24.45%) ETL
4 69 (18.96%) Agile Software Development
5 52 (14.29%) OO
6 43 (11.81%) Data Management
7 42 (11.54%) Disaster Recovery
7 42 (11.54%) Kimball Methodology
8 36 (9.89%) High Availability
9 34 (9.34%) SOA
10 27 (7.42%) Data Modelling
11 25 (6.87%) Dimensional Modelling
12 24 (6.59%) Project Management
13 22 (6.04%) Data Analysis
13 22 (6.04%) Data Architecture
13 22 (6.04%) Mentoring
13 22 (6.04%) SDLC
14 21 (5.77%) Enterprise Architecture
14 21 (5.77%) Performance Management
15 20 (5.49%) Benchmarking
Programming Languages
1 293 (80.49%) SQL
2 146 (40.11%) T-SQL
3 46 (12.64%) PL/SQL
4 38 (10.44%) Java
5 27 (7.42%) C#
6 25 (6.87%) C++
7 19 (5.22%) JavaScript
8 17 (4.67%) PowerShell
9 14 (3.85%) Python
10 11 (3.02%) Data Analysis Expressions (DAX)
11 6 (1.65%) C
11 6 (1.65%) PHP
11 6 (1.65%) VB.NET
12 5 (1.37%) Perl
12 5 (1.37%) Shell Script
13 2 (0.55%) R
13 2 (0.55%) Ruby
13 2 (0.55%) VB
14 1 (0.27%) VBA
14 1 (0.27%) VBScript
Qualifications
1 75 (20.60%) Degree
2 15 (4.12%) Microsoft Certification
3 9 (2.47%) PhD
4 8 (2.20%) SC Cleared
4 8 (2.20%) Security Cleared
5 7 (1.92%) MCITP
5 7 (1.92%) MCSE
6 6 (1.65%) MCP
6 6 (1.65%) MCSA
7 3 (0.82%) IBM Certification
8 1 (0.27%) CISSP
8 1 (0.27%) MBA
8 1 (0.27%) Oracle Certification
Quality Assurance & Compliance
1 14 (3.85%) QA
2 5 (1.37%) Data Quality
3 3 (0.82%) PCI DSS
3 3 (0.82%) SLA
System Software
1 21 (5.77%) VMware Infrastructure
2 17 (4.67%) Oracle RAC
3 16 (4.40%) Hyper-V
3 16 (4.40%) KVM
3 16 (4.40%) NFS
3 16 (4.40%) SRDF
3 16 (4.40%) Xen
4 5 (1.37%) Virtual Machines
4 5 (1.37%) VMware ESX
4 5 (1.37%) vSphere
5 4 (1.10%) Veritas Cluster Server
6 3 (0.82%) GlusterFS
Systems Management
1 13 (3.57%) Microsoft Clustering
2 4 (1.10%) NetBackup
2 4 (1.10%) Oracle ZFS
2 4 (1.10%) Veritas Storage Foundation
3 3 (0.82%) OpenView
3 3 (0.82%) Red Hat Satellite
3 3 (0.82%) Tivoli
4 1 (0.27%) Ansible
4 1 (0.27%) Oracle RMAN
4 1 (0.27%) Perfmon
Vendors
1 118 (32.42%) Microsoft
2 115 (31.59%) Oracle
3 32 (8.79%) IBM
3 32 (8.79%) VMware
4 21 (5.77%) NetApp
5 19 (5.22%) EMC
6 16 (4.40%) Cisco
6 16 (4.40%) Cognos
6 16 (4.40%) Intel
6 16 (4.40%) Tableau
7 8 (2.20%) Red Hat
8 7 (1.92%) SAP
8 7 (1.92%) Sun
9 6 (1.65%) RedGate
10 5 (1.37%) Atlassian
10 5 (1.37%) CommVault
10 5 (1.37%) Computacenter
10 5 (1.37%) SolarWinds
10 5 (1.37%) Sophos
11 4 (1.10%) Alterian
Crawley, Sussex
Juice Resource Solutions Limited
Salary: Package
Posted: 6 hours ago
Crawley, Sussex
Juice Resource Solutions Limited
Salary: package
Posted: 6 hours ago
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: Yesterday
United Kingdom
Cigna Careers
Posted: Yesterday
Truro, Cornwall
Fruition IT Resources Limited
Salary: £45000 - £55000 per annum + benefits
Posted: 2 days ago
Surrey
Lawrence Harvey Enterprise
Salary: £55000.00 - £60000.00 per annum + pension, bonus, flexi-working
Posted: 3 days ago
Oxford, Oxfordshire
X4 Group
Salary: £30k - 40k per year
Posted: 6 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 7 days ago
Camborne
Hays Specialist Recruitment Ltd
Salary: £45000.00 - £55000.00 per annum + Relocation + Home working
Posted: 16 days ago
London
Exceedra
Posted: 13 days ago
Sutton, London UK
Reed Business Information
Salary: Competitive Salary + bonus + benefits
Posted: 10 days ago
Warwick
Computer Futures
Salary: competitive
Posted: 22 days ago