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

3 months to
11 Dec 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 190 156 196
Rank change year-on-year
-34 +40
Permanent jobs citing OLTP 9 22 10
As % of all permanent IT jobs located in Manchester 0.24% 0.63% 0.24%
As % of the Database & Business Intelligence category 0.66% 2.01% 0.67%
Number of salaries quoted 9 20 8
Median salary £47,500 £47,500 £45,000
Median salary % change year-on-year
- +5.55%
90% offered a salary of more than £37,500 £47,500 £39,250
10% offered a salary of more than £52,500 £50,000 £49,350
UK excluding London median salary £52,500 £50,000 £40,000
% change year-on-year
+5.00% +25.00%
OLTP
North West

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

Database & Business Intelligence Category
Manchester
Permanent IT job ads with a match in the
Database & Business Intelligence category
1360 1093 1492
As % of all permanent IT jobs located in Manchester 36.45% 31.16% 35.17%
Number of salaries quoted 1237 945 1313
Median salary £45,000 £42,500 £38,500
Median salary % change year-on-year
+5.88% +10.38%
90% offered a salary of more than £30,000 £30,000 £28,500
10% offered a salary of more than £60,000 £52,500 £52,500
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

OLTP
Jobs Demand Trend in Manchester

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

OLTP Jobs Demand Trend in Manchester

OLTP
Salary Trend in Manchester

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

OLTP Salary Trend in Manchester

OLTP
Salary Histogram in Manchester

This chart provides a salary histogram for IT jobs citing OLTP across the Manchester region over the 3 months to 11 December 2016.

OLTP Salary Histogram in Manchester

OLTP
Top 20 Related IT Skills in Manchester

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

1 16 (100.00%) SQL
1 16 (100.00%) SQL Server
2 15 (93.75%) Business Intelligence
2 15 (93.75%) Microsoft
2 15 (93.75%) SQL Server Reporting Services
2 15 (93.75%) SQL Server Integration Services
2 15 (93.75%) SQL Server Analysis Services
3 14 (87.50%) SQL Server 2008
4 11 (68.75%) T-SQL
4 11 (68.75%) Enterprise Software
4 11 (68.75%) Performance Tuning
5 5 (31.25%) Data Warehouse
6 4 (25.00%) Time Management
6 4 (25.00%) SQL Server 2005
6 4 (25.00%) OLAP
7 1 (6.25%) Performance Monitoring
7 1 (6.25%) DevOps
7 1 (6.25%) SDLC
7 1 (6.25%) High Availability
7 1 (6.25%) Agile Software Development

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

Database & Business Intelligence
1 16 (100.00%) SQL Server
2 15 (93.75%) SQL Server Analysis Services
2 15 (93.75%) SQL Server Integration Services
2 15 (93.75%) SQL Server Reporting Services
3 14 (87.50%) SQL Server 2008
4 5 (31.25%) Data Warehouse
5 4 (25.00%) OLAP
5 4 (25.00%) SQL Server 2005
Job Titles
1 12 (75.00%) DBA
1 12 (75.00%) SQL DBA
1 12 (75.00%) SQL Server DBA
2 8 (50.00%) Developer
2 8 (50.00%) SQL Developer
3 4 (25.00%) Business Intelligence Developer
3 4 (25.00%) SQL BI Developer
3 4 (25.00%) SQL Server Developer
4 3 (18.75%) Development DBA
4 3 (18.75%) SQL Server Development DBA
5 1 (6.25%) DBA Manager
5 1 (6.25%) Project Manager
5 1 (6.25%) Technical Manager
5 1 (6.25%) Technical Project Manager
Miscellaneous
1 11 (68.75%) Enterprise Software
Processes & Methodologies
1 15 (93.75%) Business Intelligence
2 11 (68.75%) Performance Tuning
3 4 (25.00%) Time Management
4 1 (6.25%) Agile Software Development
4 1 (6.25%) DevOps
4 1 (6.25%) High Availability
4 1 (6.25%) Performance Monitoring
4 1 (6.25%) SDLC
Programming Languages
1 16 (100.00%) SQL
2 11 (68.75%) T-SQL
Vendors
1 15 (93.75%) Microsoft