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

3 months to
26 Sep 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 362 390 451
Rank change year-on-year
+28 +61
Permanent jobs citing OLTP 61 70 30
As % of all permanent IT jobs located in the South East 0.35% 0.34% 0.14%
As % of the Database & Business Intelligence category 1.18% 1.03% 0.45%
Number of salaries quoted 54 49 18
Median salary £52,500 £47,500 £51,250
Median salary % change year-on-year
+10.52% -7.31%
90% offered a salary of more than £42,500 £35,000 £40,000
10% offered a salary of more than £60,700 £62,500 £60,750
UK excluding London median salary £50,000 £50,000 £45,000
% change year-on-year
- +11.11%
OLTP
England

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 South East region.

Database & Business Intelligence Category
South East
Permanent IT job ads with a match in the
Database & Business Intelligence category
5170 6768 6612
As % of all permanent IT jobs located in the South East 29.42% 32.43% 30.07%
Number of salaries quoted 4466 5837 5454
Median salary £47,500 £43,500 £42,500
Median salary % change year-on-year
+9.19% +2.35%
90% offered a salary of more than £32,500 £31,500 £30,000
10% offered a salary of more than £60,000 £62,500 £60,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLTP
Jobs Demand Trend in the South East

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

OLTP Jobs Demand Trend in the South East

OLTP
Salary Trend in the South East

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP across the South East region.

OLTP Salary Trend in the South East

OLTP
Salary Histogram in the South East

This chart provides a salary histogram for IT jobs citing OLTP across the South East region over the 3 months to 26 September 2016.

OLTP Salary Histogram in the South East

OLTP
Job Locations in the South East

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the South East region over the 3 months to 26 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
West Sussex +37 21 £58,500 +30.00%
Hampshire +14 17 £50,000 +42.85% 1
Berkshire +2 12 £55,000 +22.22% 1
Oxfordshire - 8 £60,000 -
Buckinghamshire +16 1 £50,000 +17.64%
Surrey +4 1 £57,500 -
Middlesex - 1 - -
OLTP
England

OLTP
Top 30 Related IT Skills in the South East

For the 6 months to 26 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 South East region with a requirement for OLTP.

1 80 (85.11%) SQL
2 71 (75.53%) OLAP
3 69 (73.40%) SQL Server
4 63 (67.02%) T-SQL
5 55 (58.51%) Data Warehouse
6 35 (37.23%) Microsoft
6 35 (37.23%) Business Intelligence
7 33 (35.11%) MS Excel
8 31 (32.98%) Performance Tuning
9 29 (30.85%) MySQL
9 29 (30.85%) Disaster Recovery
10 27 (28.72%) ETL
11 25 (26.60%) Computer Science
12 24 (25.53%) High Availability
12 24 (25.53%) SQL Server Integration Services
13 22 (23.40%) Oracle
14 21 (22.34%) Data Modelling
15 20 (21.28%) JIRA
15 20 (21.28%) SQL Server Reporting Services
15 20 (21.28%) Clustering
15 20 (21.28%) NoSQL
16 19 (20.21%) Scrum
17 18 (19.15%) VMware
17 18 (19.15%) Degree
17 18 (19.15%) Windows
18 17 (18.09%) Big Data
19 16 (17.02%) SQL Server 2012
19 16 (17.02%) Enterprise Software
19 16 (17.02%) Data Management
20 15 (15.96%) Data Analysis

OLTP
Top Related IT Skills in the South East 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 7 (7.45%) Apache Pig
2 2 (2.13%) Jupyter
Applications
1 33 (35.11%) MS Excel
Business Applications
1 1 (1.06%) FastStats
Cloud Services
1 11 (11.70%) GitHub
2 10 (10.64%) Amazon AWS
3 5 (5.32%) Amazon S3
Communications & Networking
1 10 (10.64%) SAN
2 5 (5.32%) Fibre Channel
2 5 (5.32%) Firewall
3 2 (2.13%) Internet
3 2 (2.13%) LDAP
4 1 (1.06%) LAN
4 1 (1.06%) PABX
4 1 (1.06%) VoIP
4 1 (1.06%) WAN
4 1 (1.06%) Wi-Fi
Database & Business Intelligence
1 71 (75.53%) OLAP
2 69 (73.40%) SQL Server
3 55 (58.51%) Data Warehouse
4 29 (30.85%) MySQL
5 24 (25.53%) SQL Server Integration Services
6 20 (21.28%) NoSQL
6 20 (21.28%) SQL Server Reporting Services
7 17 (18.09%) Big Data
8 16 (17.02%) SQL Server 2012
9 15 (15.96%) Oracle OLAP
9 15 (15.96%) SQL Server 2014
9 15 (15.96%) SQL Server Analysis Services
10 12 (12.77%) Hadoop
11 10 (10.64%) Relational Database
12 9 (9.57%) Power BI
12 9 (9.57%) SQL Server 2016
13 8 (8.51%) BusinessObjects XI
13 8 (8.51%) SQL Server 2008
14 7 (7.45%) Apache Hive
14 7 (7.45%) Microsoft Analysis Services
Development Applications
1 20 (21.28%) JIRA
2 9 (9.57%) Jenkins
2 9 (9.57%) Vagrant
3 8 (8.51%) Talend Open Studio
4 7 (7.45%) Cucumber
5 5 (5.32%) SQL Server Management Studio (SSMS)
5 5 (5.32%) Visual Studio
6 4 (4.26%) ERwin
General
1 15 (15.96%) Finance
2 10 (10.64%) Retail
3 1 (1.06%) Banking
3 1 (1.06%) German Language
3 1 (1.06%) Marketing
3 1 (1.06%) Pharmaceutical
3 1 (1.06%) Telecoms
Job Titles
1 46 (48.94%) Developer
2 36 (38.30%) SQL Developer
3 26 (27.66%) DBA
3 26 (27.66%) SQL DBA
4 17 (18.09%) Administrator
4 17 (18.09%) Senior DBA
4 17 (18.09%) Senior SQL DBA
5 16 (17.02%) SQL Server DBA
6 13 (13.83%) Business Intelligence Developer
7 12 (12.77%) Senior SQL Server DBA
8 9 (9.57%) Analyst
9 8 (8.51%) Database Developer
9 8 (8.51%) SQL Database Developer
10 7 (7.45%) ETL Developer
10 7 (7.45%) Lead Developer
10 7 (7.45%) Linux Administrator
10 7 (7.45%) Senior Developer
10 7 (7.45%) SQL Server Developer
10 7 (7.45%) T-SQL Developer
11 5 (5.32%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 9 (9.57%) .NET
2 8 (8.51%) MDX
3 5 (5.32%) .NET Framework
3 5 (5.32%) Web Services
4 3 (3.19%) Middleware
5 1 (1.06%) AngularJS
5 1 (1.06%) CSS
5 1 (1.06%) HTML
5 1 (1.06%) jQuery
5 1 (1.06%) Node.js
Miscellaneous
1 25 (26.60%) Computer Science
2 20 (21.28%) Clustering
3 16 (17.02%) Enterprise Software
4 15 (15.96%) Replication
5 8 (8.51%) Statistics
6 5 (5.32%) Analytical Skills
6 5 (5.32%) Microsoft Licensing
7 4 (4.26%) Data Integration
8 3 (3.19%) Algorithms
8 3 (3.19%) EMC VMAX
9 2 (2.13%) Fintech
10 1 (1.06%) BYOD
10 1 (1.06%) Data Centre
10 1 (1.06%) Management Information System
10 1 (1.06%) Visualisation
Operating Systems
1 18 (19.15%) Windows
2 9 (9.57%) Unix
3 7 (7.45%) Linux
3 7 (7.45%) Red Hat Enterprise Linux
4 5 (5.32%) Solaris
4 5 (5.32%) Windows Server
Processes & Methodologies
1 35 (37.23%) Business Intelligence
2 31 (32.98%) Performance Tuning
3 29 (30.85%) Disaster Recovery
4 27 (28.72%) ETL
5 24 (25.53%) High Availability
6 21 (22.34%) Data Modelling
7 19 (20.21%) Scrum
8 16 (17.02%) Data Management
9 15 (15.96%) Data Analysis
9 15 (15.96%) Database Security
10 14 (14.89%) Kimball Methodology
11 13 (13.83%) Capacity Planning
12 12 (12.77%) Agile Software Development
12 12 (12.77%) Reverse Engineering
13 10 (10.64%) Dimensional Modelling
14 9 (9.57%) Kanban
15 7 (7.45%) Refactoring
15 7 (7.45%) Software Engineering
16 6 (6.38%) Stakeholder Management
17 5 (5.32%) Project Management
Programming Languages
1 80 (85.11%) SQL
2 63 (67.02%) T-SQL
3 13 (13.83%) Java
4 12 (12.77%) PL/SQL
4 12 (12.77%) PowerShell
5 9 (9.57%) Data Analysis Expressions (DAX)
6 7 (7.45%) Shell Script
7 4 (4.26%) C#
8 3 (3.19%) Python
9 1 (1.06%) JavaScript
9 1 (1.06%) PHP
Qualifications
1 18 (19.15%) Degree
Quality Assurance & Compliance
1 3 (3.19%) Data Quality
2 1 (1.06%) QA
System Software
1 5 (5.32%) HDFS
1 5 (5.32%) Veritas Cluster Server
1 5 (5.32%) Virtual Machines
1 5 (5.32%) VMware ESX
1 5 (5.32%) VMware Infrastructure
1 5 (5.32%) vSphere
2 3 (3.19%) GlusterFS
Systems Management
1 13 (13.83%) Microsoft Clustering
2 11 (11.70%) Puppet
3 5 (5.32%) NetBackup
3 5 (5.32%) Oracle ZFS
3 5 (5.32%) Veritas Storage Foundation
4 3 (3.19%) Red Hat Satellite
Vendors
1 35 (37.23%) Microsoft
2 22 (23.40%) Oracle
3 18 (19.15%) VMware
4 15 (15.96%) Cognos
5 8 (8.51%) Talend
6 7 (7.45%) Red Hat
7 6 (6.38%) IBM
8 5 (5.32%) Atlassian
8 5 (5.32%) Brocade
8 5 (5.32%) CommVault
8 5 (5.32%) NetApp
8 5 (5.32%) RedGate
8 5 (5.32%) SolarWinds
8 5 (5.32%) Sophos
8 5 (5.32%) StorageTek
8 5 (5.32%) Sun
8 5 (5.32%) Tableau
8 5 (5.32%) Veritas
9 3 (3.19%) EMC
10 1 (1.06%) SAP
Reading
Hays West And Wales
Salary: £45000.00 - £50000.00 per annum + Benefits
Posted: 3 days ago
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 26 days ago