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 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 163 177 210
Rank change year-on-year
+14 +33
Permanent jobs citing OLTP 17 12 1
As % of all permanent IT jobs located in Hampshire 0.53% 0.33% 0.025%
As % of the Database & Business Intelligence category 1.53% 0.97% 0.078%
Number of salaries quoted 16 8 0
Median salary £50,000 £35,000 -
Median salary % change year-on-year
+42.85% -
UK excluding London median salary £50,000 £50,000 £45,000
% change year-on-year
- +11.11%
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
1112 1236 1274
As % of all permanent IT jobs located in Hampshire 34.56% 33.78% 31.69%
Number of salaries quoted 1008 1093 1011
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 £30,000 £27,500
10% offered a salary of more than £55,000 £55,000 £60,000
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 26 September 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 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
Southampton - 16 £50,000 - 1
Fareham - 1 £35,000 -
OLTP
South East

OLTP
Top 30 Related IT Skills in Hampshire

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 Hampshire region with a requirement for OLTP.

1 39 (100.00%) SQL
1 39 (100.00%) OLAP
2 38 (97.44%) SQL Server
3 36 (92.31%) T-SQL
4 23 (58.97%) Data Warehouse
5 20 (51.28%) Microsoft
5 20 (51.28%) MS Excel
6 16 (41.03%) Degree
6 16 (41.03%) Computer Science
6 16 (41.03%) Enterprise Software
7 15 (38.46%) Database Security
8 13 (33.33%) Performance Tuning
8 13 (33.33%) Capacity Planning
8 13 (33.33%) High Availability
8 13 (33.33%) Microsoft Clustering
8 13 (33.33%) Windows
8 13 (33.33%) Replication
8 13 (33.33%) VMware
8 13 (33.33%) Clustering
8 13 (33.33%) Disaster Recovery
9 12 (30.77%) Data Management
9 12 (30.77%) Data Analysis
9 12 (30.77%) Reverse Engineering
10 9 (23.08%) Retail
11 8 (20.51%) Finance
12 7 (17.95%) MS Access
12 7 (17.95%) Software Engineering
12 7 (17.95%) Refactoring
13 4 (10.26%) C#
13 4 (10.26%) Java

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 20 (51.28%) MS Excel
Database & Business Intelligence
1 39 (100.00%) OLAP
2 38 (97.44%) SQL Server
3 23 (58.97%) Data Warehouse
4 7 (17.95%) MS Access
5 2 (5.13%) SQL Server Analysis Services
5 2 (5.13%) SQL Server Integration Services
5 2 (5.13%) SQL Server Reporting Services
6 1 (2.56%) BusinessObjects
General
1 9 (23.08%) Retail
2 8 (20.51%) Finance
3 1 (2.56%) Banking
3 1 (2.56%) Telecoms
Job Titles
1 22 (56.41%) Developer
1 22 (56.41%) SQL Developer
2 13 (33.33%) DBA
2 13 (33.33%) Senior DBA
2 13 (33.33%) Senior SQL DBA
2 13 (33.33%) SQL DBA
3 12 (30.77%) Senior SQL Server DBA
3 12 (30.77%) SQL Server DBA
4 8 (20.51%) Database Developer
4 8 (20.51%) SQL Database Developer
5 7 (17.95%) Lead Developer
6 5 (12.82%) Analyst
6 5 (12.82%) SQL Server Developer
7 4 (10.26%) Data Analyst
7 4 (10.26%) Data Warehouse Analyst
7 4 (10.26%) OLAP Developer
7 4 (10.26%) Senior Analyst
7 4 (10.26%) Senior Data Analyst
7 4 (10.26%) Senior Data Warehouse Analyst
7 4 (10.26%) SQL Data Analyst
Miscellaneous
1 16 (41.03%) Computer Science
1 16 (41.03%) Enterprise Software
2 13 (33.33%) Clustering
2 13 (33.33%) Replication
3 3 (7.69%) Algorithms
3 3 (7.69%) Statistics
Operating Systems
1 13 (33.33%) Windows
Processes & Methodologies
1 15 (38.46%) Database Security
2 13 (33.33%) Capacity Planning
2 13 (33.33%) Disaster Recovery
2 13 (33.33%) High Availability
2 13 (33.33%) Performance Tuning
3 12 (30.77%) Data Analysis
3 12 (30.77%) Data Management
3 12 (30.77%) Reverse Engineering
4 7 (17.95%) Refactoring
4 7 (17.95%) Software Engineering
5 3 (7.69%) Business Intelligence
6 2 (5.13%) Agile Software Development
6 2 (5.13%) Functional Programming
6 2 (5.13%) OO
6 2 (5.13%) Scrum
6 2 (5.13%) SDLC
6 2 (5.13%) TDD
7 1 (2.56%) Data Migration
7 1 (2.56%) Migration
Programming Languages
1 39 (100.00%) SQL
2 36 (92.31%) T-SQL
3 4 (10.26%) C#
3 4 (10.26%) Java
Qualifications
1 16 (41.03%) Degree
Systems Management
1 13 (33.33%) Microsoft Clustering
Vendors
1 20 (51.28%) Microsoft
2 13 (33.33%) VMware
3 1 (2.56%) Cognos
3 1 (2.56%) IBM
3 1 (2.56%) SAP
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 26 days ago