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

3 months to
29 Aug 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 154 185 208
Rank change year-on-year
+31 +23
Permanent jobs citing OLTP 28 4 3
As % of all permanent IT jobs located in Hampshire 0.81% 0.11% 0.075%
As % of the Database & Business Intelligence category 2.30% 0.34% 0.24%
Number of salaries quoted 25 4 2
Median salary £45,000 £35,000 £39,799
Median salary % change year-on-year
+28.57% -12.05%
UK excluding London median salary £50,000 £47,500 £47,750
% change year-on-year
+5.26% -0.52%
OLTP
South East

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 Hampshire region.

Database & Business Intelligence Category
Hampshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
1217 1194 1267
As % of all permanent IT jobs located in Hampshire 35.37% 33.71% 31.53%
Number of salaries quoted 1100 1043 1003
Median salary £42,500 £42,500 £40,000
Median salary % change year-on-year
- +6.25%
90% offered a salary of more than £30,000 £27,500 £27,500
10% offered a salary of more than £55,000 £55,000 £57,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLTP
Jobs Demand Trend in Hampshire

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

OLTP Jobs Demand Trend in Hampshire

OLTP
Salary Trend in Hampshire

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

OLTP Salary Trend in Hampshire

OLTP
Salary Histogram in Hampshire

This chart provides a salary histogram for IT jobs citing OLTP across the Hampshire region over the 3 months to 29 August 2016.

OLTP Salary Histogram in Hampshire

OLTP
Job Locations in Hampshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the Hampshire region over the 3 months to 29 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
Southampton - 24 £50,000 - 1
Fareham - 1 £35,000 -
OLTP
South East

OLTP
Top 30 Related IT Skills in Hampshire

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

1 41 (100.00%) SQL
1 41 (100.00%) OLAP
2 40 (97.56%) SQL Server
3 37 (90.24%) T-SQL
4 27 (65.85%) Data Warehouse
5 18 (43.90%) Microsoft
5 18 (43.90%) MS Excel
5 18 (43.90%) Database Security
6 17 (41.46%) Enterprise Software
6 17 (41.46%) Degree
7 16 (39.02%) Computer Science
8 15 (36.59%) Reverse Engineering
9 14 (34.15%) Data Analysis
10 13 (31.71%) Data Management
11 11 (26.83%) Disaster Recovery
11 11 (26.83%) Replication
11 11 (26.83%) VMware
11 11 (26.83%) Clustering
11 11 (26.83%) Windows
11 11 (26.83%) Retail
11 11 (26.83%) High Availability
11 11 (26.83%) Capacity Planning
11 11 (26.83%) Performance Tuning
11 11 (26.83%) Microsoft Clustering
12 10 (24.39%) Refactoring
13 8 (19.51%) Finance
14 7 (17.07%) MS Access
14 7 (17.07%) C#
14 7 (17.07%) Java
14 7 (17.07%) Software Engineering

OLTP
Top Related IT Skills in Hampshire 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:

Applications
1 18 (43.90%) MS Excel
Business Applications
1 1 (2.44%) Cognos Business Intelligence
Database & Business Intelligence
1 41 (100.00%) OLAP
2 40 (97.56%) SQL Server
3 27 (65.85%) Data Warehouse
4 7 (17.07%) MS Access
5 2 (4.88%) BusinessObjects
5 2 (4.88%) Data Mining
5 2 (4.88%) SQL Server Analysis Services
5 2 (4.88%) SQL Server Integration Services
5 2 (4.88%) SQL Server Reporting Services
6 1 (2.44%) Cognos Report Studio
6 1 (2.44%) Oracle OLAP
6 1 (2.44%) Oracle Reports
Development Applications
1 2 (4.88%) Git (software)
1 2 (4.88%) Subversion
1 2 (4.88%) Team Foundation Server
General
1 11 (26.83%) Retail
2 8 (19.51%) Finance
3 1 (2.44%) Banking
3 1 (2.44%) Manufacturing
3 1 (2.44%) Telecoms
Job Titles
1 25 (60.98%) Developer
2 23 (56.10%) SQL Developer
3 11 (26.83%) DBA
3 11 (26.83%) Senior DBA
3 11 (26.83%) Senior SQL DBA
3 11 (26.83%) SQL DBA
4 10 (24.39%) Database Developer
4 10 (24.39%) Senior SQL Server DBA
4 10 (24.39%) SQL Server DBA
5 8 (19.51%) SQL Database Developer
6 7 (17.07%) Lead Developer
7 6 (14.63%) Analyst
7 6 (14.63%) SQL Server Developer
8 4 (9.76%) Data Warehouse Analyst
8 4 (9.76%) OLAP Developer
8 4 (9.76%) Senior Data Analyst
8 4 (9.76%) Senior Data Warehouse Analyst
8 4 (9.76%) SQL Analyst
8 4 (9.76%) SQL Data Analyst
8 4 (9.76%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 2 (4.88%) .NET
2 1 (2.44%) Dapper ORM
2 1 (2.44%) EJB
2 1 (2.44%) Entity Framework
2 1 (2.44%) Hibernate
2 1 (2.44%) LINQ
2 1 (2.44%) LINQ to SQL
Miscellaneous
1 17 (41.46%) Enterprise Software
2 16 (39.02%) Computer Science
3 11 (26.83%) Clustering
3 11 (26.83%) Replication
4 3 (7.32%) Algorithms
4 3 (7.32%) Statistics
Operating Systems
1 11 (26.83%) Windows
Processes & Methodologies
1 18 (43.90%) Database Security
2 15 (36.59%) Reverse Engineering
3 14 (34.15%) Data Analysis
4 13 (31.71%) Data Management
5 11 (26.83%) Capacity Planning
5 11 (26.83%) Disaster Recovery
5 11 (26.83%) High Availability
5 11 (26.83%) Performance Tuning
6 10 (24.39%) Refactoring
7 7 (17.07%) Software Engineering
8 6 (14.63%) Business Intelligence
9 3 (7.32%) OO
10 2 (4.88%) Agile Software Development
10 2 (4.88%) Functional Programming
10 2 (4.88%) Scrum
10 2 (4.88%) SDLC
10 2 (4.88%) TDD
10 2 (4.88%) Unit Testing
11 1 (2.44%) Data Migration
11 1 (2.44%) Time Management
Programming Languages
1 41 (100.00%) SQL
2 37 (90.24%) T-SQL
3 7 (17.07%) C#
3 7 (17.07%) Java
4 2 (4.88%) Python
4 2 (4.88%) Ruby
4 2 (4.88%) VB.NET
Qualifications
1 17 (41.46%) Degree
Systems Management
1 11 (26.83%) Microsoft Clustering
Vendors
1 18 (43.90%) Microsoft
2 11 (26.83%) VMware
3 2 (4.88%) Cognos
3 2 (4.88%) IBM
4 1 (2.44%) Baan
4 1 (2.44%) Oracle
4 1 (2.44%) SAP
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 4 days ago