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

3 months to
30 Jul 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 715 701 681
Rank change year-on-year
-14 -20
Permanent jobs citing OLTP 189 239 284
As % of all permanent IT jobs located in England 0.21% 0.23% 0.26%
As % of the Database & Business Intelligence category 0.69% 0.73% 0.81%
Number of salaries quoted 132 138 225
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 £35,000 £33,250 £37,900
10% offered a salary of more than £80,000 £71,750 £65,000
UK excluding London median salary £43,000 £45,000 £48,000
% change year-on-year
-4.44% -6.25%
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
27215 32599 35155
As % of all permanent IT jobs located in England 29.69% 31.83% 32.11%
Number of salaries quoted 23493 27734 30265
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 £70,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 30 July 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 30 July 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 +47 83 £55,000 - 5
South East +5 53 £50,000 +11.11% 4
East Midlands +17 16 £33,500 -50.37% 1
South West -15 16 £40,000 -5.88% 2
Yorkshire +18 9 £80,000 +28.00%
West Midlands -10 7 £46,250 +48.00% 2
East of England +10 4 £40,000 - 1
North West +15 1 £52,500 +40.00%
OLTP
UK

OLTP
Top 30 Related IT Skills in England

For the 6 months to 30 July 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 272 (78.61%) SQL
2 213 (61.56%) SQL Server
3 169 (48.84%) OLAP
4 135 (39.02%) Data Warehouse
5 123 (35.55%) Oracle
6 122 (35.26%) Business Intelligence
7 113 (32.66%) T-SQL
7 113 (32.66%) Performance Tuning
8 109 (31.50%) Microsoft
9 105 (30.35%) Finance
10 100 (28.90%) SQL Server Reporting Services
11 97 (28.03%) SQL Server Integration Services
12 90 (26.01%) ETL
13 80 (23.12%) MS Excel
14 74 (21.39%) Degree
14 74 (21.39%) SQL Server Analysis Services
15 70 (20.23%) Agile Software Development
15 70 (20.23%) MySQL
16 62 (17.92%) Linux
17 60 (17.34%) OO
18 53 (15.32%) SQL Server 2008
18 53 (15.32%) Analytical Skills
19 52 (15.03%) Oracle OLAP
20 51 (14.74%) Windows
21 49 (14.16%) Java
21 49 (14.16%) Data Management
22 46 (13.29%) PL/SQL
23 44 (12.72%) XML
24 41 (11.85%) SOA
25 39 (11.27%) Unix

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.91%) Apache
1 17 (4.91%) Tomcat
2 14 (4.05%) IIS
3 13 (3.76%) Oracle Coherence
3 13 (3.76%) Oracle HTTP Server
3 13 (3.76%) WebSphere
4 4 (1.16%) Apache Spark
4 4 (1.16%) Cloud Foundry
4 4 (1.16%) Confluence
4 4 (1.16%) GemFire
4 4 (1.16%) Oracle Spatial
4 4 (1.16%) Oracle Workflow
5 3 (0.87%) WebLogic
6 1 (0.29%) SAS
6 1 (0.29%) SharePoint
6 1 (0.29%) SharePoint 2013
Applications
1 80 (23.12%) MS Excel
2 4 (1.16%) MS Office
3 1 (0.29%) MS PowerPoint
3 1 (0.29%) MS Visio
3 1 (0.29%) Spreadsheet
Business Applications
1 5 (1.45%) Cognos Business Intelligence
2 4 (1.16%) MetaTrader
2 4 (1.16%) Unica
3 2 (0.58%) Endur
3 2 (0.58%) SAP FI
4 1 (0.29%) BASE24
4 1 (0.29%) SAP CRM
4 1 (0.29%) SAP ERP
4 1 (0.29%) SAP SCM
Cloud Services
1 9 (2.60%) Amazon AWS
2 4 (1.16%) GitHub
2 4 (1.16%) Microsoft Azure
2 4 (1.16%) PaaS
Communications & Networking
1 27 (7.80%) SAN
2 16 (4.62%) Extranet
2 16 (4.62%) Fibre Channel
2 16 (4.62%) Intranet
3 14 (4.05%) LAN
3 14 (4.05%) NAS
3 14 (4.05%) WAN
4 13 (3.76%) FCoE
4 13 (3.76%) HTTP
4 13 (3.76%) iSCSI
4 13 (3.76%) Multicast
5 8 (2.31%) Firewall
6 3 (0.87%) Internet
7 2 (0.58%) Skype
8 1 (0.29%) PABX
8 1 (0.29%) VoIP
8 1 (0.29%) WebEx
8 1 (0.29%) Wi-Fi
Database & Business Intelligence
1 213 (61.56%) SQL Server
2 169 (48.84%) OLAP
3 135 (39.02%) Data Warehouse
4 100 (28.90%) SQL Server Reporting Services
5 97 (28.03%) SQL Server Integration Services
6 74 (21.39%) SQL Server Analysis Services
7 70 (20.23%) MySQL
8 53 (15.32%) SQL Server 2008
9 52 (15.03%) Oracle OLAP
10 38 (10.98%) Oracle Database
11 37 (10.69%) SQL Server 2012
12 35 (10.12%) Relational Database
13 33 (9.54%) SQL Server 2014
14 28 (8.09%) DB2
15 21 (6.07%) Microsoft Analysis Services
16 19 (5.49%) Oracle ODI
17 18 (5.20%) BusinessObjects
18 17 (4.91%) Big Data
19 16 (4.62%) Oracle Database 10g
19 16 (4.62%) Oracle Database 11g
Development Applications
1 19 (5.49%) Git (software)
2 17 (4.91%) Team Foundation Server
3 11 (3.18%) Oracle APEX
3 11 (3.18%) VSS/SourceSafe
4 10 (2.89%) Jenkins
4 10 (2.89%) JIRA
5 6 (1.73%) tSQLt
6 5 (1.45%) Subversion
6 5 (1.45%) Visual Studio
7 4 (1.16%) Eclipse
7 4 (1.16%) Gradle
7 4 (1.16%) JUnit
7 4 (1.16%) SQL Server Management Studio (SSMS)
8 2 (0.58%) ERwin
General
1 105 (30.35%) Finance
2 36 (10.40%) Retail
3 19 (5.49%) Banking
4 13 (3.76%) Telecoms
5 10 (2.89%) Marketing
6 9 (2.60%) Pharmaceutical
7 5 (1.45%) Private Banking
7 5 (1.45%) Publishing
8 4 (1.16%) Games
9 3 (0.87%) Back Office
9 3 (0.87%) Legal
10 2 (0.58%) Advertising
10 2 (0.58%) Financial Institution
11 1 (0.29%) Manufacturing
Job Titles
1 172 (49.71%) Developer
2 86 (24.86%) SQL Developer
3 77 (22.25%) DBA
4 67 (19.36%) SQL DBA
5 64 (18.50%) Architect
6 57 (16.47%) Oracle Developer
7 44 (12.72%) SQL Server DBA
8 29 (8.38%) Database Developer
8 29 (8.38%) Infrastructure Architect
9 26 (7.51%) Business Intelligence Developer
10 25 (7.23%) SQL Server Developer
11 23 (6.65%) C++ Developer
11 23 (6.65%) SQL Database Developer
11 23 (6.65%) Unix Developer
12 22 (6.36%) Administrator
12 22 (6.36%) Senior Developer
12 22 (6.36%) SSIS Developer
13 21 (6.07%) Information Architect
13 21 (6.07%) Lead Developer
13 21 (6.07%) SSRS Developer
Libraries, Frameworks & Software Standards
1 44 (12.72%) XML
2 30 (8.67%) Web Services
3 26 (7.51%) .NET
4 23 (6.65%) Middleware
4 23 (6.65%) STL
5 22 (6.36%) WSDL
6 21 (6.07%) WS-I
6 21 (6.07%) XSD
7 19 (5.49%) MDX
8 17 (4.91%) SOAP
9 13 (3.76%) Oracle GoldenGate
10 10 (2.89%) ASP.NET
10 10 (2.89%) REST
11 8 (2.31%) JSON
12 6 (1.73%) Django
12 6 (1.73%) WCF
13 5 (1.45%) WinForms
14 4 (1.16%) ASP.NET MVC
14 4 (1.16%) Spring
14 4 (1.16%) WF
Miscellaneous
1 53 (15.32%) Analytical Skills
2 36 (10.40%) Enterprise Software
3 32 (9.25%) Clustering
3 32 (9.25%) Management Information System
3 32 (9.25%) Replication
4 27 (7.80%) Computer Science
5 15 (4.34%) Data Integration
6 12 (3.47%) Fintech
7 9 (2.60%) Data Structures
7 9 (2.60%) Life Science
7 9 (2.60%) Statistics
8 8 (2.31%) Data Protection Act
9 7 (2.02%) Visualisation
10 4 (1.16%) Microsoft Licensing
10 4 (1.16%) Virtual Team
11 3 (0.87%) Algorithms
11 3 (0.87%) EMC VMAX
11 3 (0.87%) Mobile Payment
11 3 (0.87%) Online Games
11 3 (0.87%) PKI
Operating Systems
1 62 (17.92%) Linux
2 51 (14.74%) Windows
3 39 (11.27%) Unix
4 22 (6.36%) Solaris
5 17 (4.91%) Windows Server
6 13 (3.76%) Red Hat Enterprise Linux
7 7 (2.02%) Windows Server 2008
8 5 (1.45%) Windows Server 2012
Processes & Methodologies
1 122 (35.26%) Business Intelligence
2 113 (32.66%) Performance Tuning
3 90 (26.01%) ETL
4 70 (20.23%) Agile Software Development
5 60 (17.34%) OO
6 49 (14.16%) Data Management
7 41 (11.85%) SOA
8 39 (11.27%) Kimball Methodology
9 34 (9.83%) Disaster Recovery
10 30 (8.67%) High Availability
11 28 (8.09%) Data Architecture
11 28 (8.09%) Enterprise Architecture
12 27 (7.80%) Data Analysis
12 27 (7.80%) Data Modelling
13 26 (7.51%) Dimensional Modelling
14 25 (7.23%) Data Governance
15 24 (6.94%) UML
16 22 (6.36%) Performance Management
16 22 (6.36%) Project Management
16 22 (6.36%) TOGAF
Programming Languages
1 272 (78.61%) SQL
2 113 (32.66%) T-SQL
3 49 (14.16%) Java
4 46 (13.29%) PL/SQL
5 29 (8.38%) C++
6 28 (8.09%) C#
7 18 (5.20%) JavaScript
7 18 (5.20%) PowerShell
7 18 (5.20%) Python
8 9 (2.60%) Shell Script
9 8 (2.31%) Data Analysis Expressions (DAX)
9 8 (2.31%) Perl
9 8 (2.31%) PHP
10 7 (2.02%) C
11 6 (1.73%) VB.NET
12 3 (0.87%) R
12 3 (0.87%) Ruby
13 2 (0.58%) VB
14 1 (0.29%) Data Mining Extensions (DMX)
14 1 (0.29%) Scala
Qualifications
1 74 (21.39%) Degree
2 14 (4.05%) Microsoft Certification
3 9 (2.60%) PhD
4 8 (2.31%) MCSE
5 6 (1.73%) MCP
5 6 (1.73%) MCSA
6 5 (1.45%) MCITP
6 5 (1.45%) SC Cleared
6 5 (1.45%) Security Cleared
7 3 (0.87%) IBM Certification
8 1 (0.29%) CISSP
8 1 (0.29%) ITIL Foundation Certificate
8 1 (0.29%) MBA
8 1 (0.29%) Oracle Certification
Quality Assurance & Compliance
1 17 (4.91%) QA
2 11 (3.18%) Data Quality
3 7 (2.02%) PCI DSS
4 4 (1.16%) SLA
System Software
1 17 (4.91%) VMware Infrastructure
2 14 (4.05%) Oracle RAC
3 13 (3.76%) Hyper-V
3 13 (3.76%) KVM
3 13 (3.76%) NFS
3 13 (3.76%) SRDF
3 13 (3.76%) Xen
4 4 (1.16%) Apache ZooKeeper
4 4 (1.16%) HDFS
4 4 (1.16%) Virtual Machines
4 4 (1.16%) VMware ESX
4 4 (1.16%) vSphere
5 3 (0.87%) GlusterFS
5 3 (0.87%) Veritas Cluster Server
Systems Management
1 8 (2.31%) Microsoft Clustering
2 3 (0.87%) NetBackup
2 3 (0.87%) OpenView
2 3 (0.87%) Oracle ZFS
2 3 (0.87%) Red Hat Satellite
2 3 (0.87%) Tivoli
2 3 (0.87%) Veritas Storage Foundation
3 2 (0.58%) Oracle RMAN
4 1 (0.29%) Ansible
4 1 (0.29%) Oracle Enterprise Manager
4 1 (0.29%) Perfmon
4 1 (0.29%) Puppet
Vendors
1 123 (35.55%) Oracle
2 109 (31.50%) Microsoft
3 31 (8.96%) IBM
4 24 (6.94%) VMware
5 20 (5.78%) Tableau
6 18 (5.20%) Cognos
7 17 (4.91%) NetApp
8 16 (4.62%) EMC
9 13 (3.76%) Cisco
9 13 (3.76%) Intel
9 13 (3.76%) Red Hat
10 7 (2.02%) SAP
11 6 (1.73%) Facebook
11 6 (1.73%) Sun
12 5 (1.45%) RedGate
12 5 (1.45%) Vertica
13 4 (1.16%) Alterian
13 4 (1.16%) Atlassian
13 4 (1.16%) SolarWinds
13 4 (1.16%) Sophos
Slough, Berkshire
Evolution Recruitment Solutions
Salary: Up to 55,000 + Benefits
Posted: 2 days ago
South East London
Client Server
Salary: £25k to £40k + benefits
Posted: Yesterday
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: 6 days ago
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 5 days ago
Redhill, Surrey
Cubic Transportation Systems Limited
Salary: Competitive basic + benefits
Posted: 4 days ago
London
Client Server
Salary: £30k to £45k + benefits
Posted: 8 days ago
Warwick
Computer Futures
Salary: competitive
Posted: 15 days ago
Malmesbury, Wiltshire
Dyson
Posted: 22 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 23 days ago
High Wycombe, Buckinghamshire
Johnson and Johnson
Salary: Highly competitive salary, bonus and flexible benefits
Posted: 18 days ago
South West London
Gamesys
Posted: 22 days ago
Bristol, Avon
BJSS Ltd
Salary: From £75,000 to £90,000 per annum
Posted: 18 days ago