Period
to 18 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Stoke-on-Trent with a requirement for OLTP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLTP over the 6 months to 18 November 2017 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
Staffordshire > Stoke-on-Trent
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 51 65 29
Rank change year-on-year +14 -36 +25
Permanent jobs citing OLTP 2 9 32
As % of all permanent IT jobs advertised in Stoke-on-Trent 0.50% 1.65% 7.64%
As % of the Database & Business Intelligence category 1.10% 3.26% 15.31%
Number of salaries quoted 2 8 23
Stoke-on-Trent median annual salary £45,000 £50,000 £33,500
Median salary % change year-on-year -10.00% +49.25% -
10th Percentile £34,500 £35,000 £21,600
90th Percentile £55,500 £56,250 £59,500
Staffordshire median annual salary £45,000 £50,000 £33,500
% change year-on-year -10.00% +49.25% +3.08%

OLTP is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Stoke-on-Trent with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Stoke-on-Trent
Permanent vacancies with a requirement for database or business intelligence skills 182 276 209
As % of all permanent IT jobs advertised in Stoke-on-Trent 45.84% 50.46% 49.88%
Number of salaries quoted 164 250 173
Stoke-on-Trent median annual salary £37,500 £35,000 £37,500
Median salary % change year-on-year +7.14% -6.67% +15.38%
10th Percentile £21,250 £25,675 £22,100
90th Percentile £50,875 £55,000 £53,750
Staffordshire median annual salary £35,000 £36,000 £35,000
% change year-on-year -2.78% +2.86% -

OLTP
Job Vacancy Trend in Stoke-on-Trent

Job postings citing OLTP as a percentage of all IT jobs advertised in Stoke-on-Trent.

Job vacancy trend for OLTP in Stoke-on-Trent

OLTP
Salary Trend in Stoke-on-Trent

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP in Stoke-on-Trent.

Salary trend for OLTP in Stoke-on-Trent

OLTP
Salary Histogram in Stoke-on-Trent

The salary distribution of IT jobs citing OLTP in Stoke-on-Trent over the 6 months to 18 November 2017.

Salary histogram for OLTP in Stoke-on-Trent

For the 6 months to 18 November 2017, 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 Stoke-on-Trent region with a requirement for OLTP.

1 2 (100.00%) SQL
1 2 (100.00%) T-SQL
1 2 (100.00%) SQL Server
1 2 (100.00%) SQL Server Reporting Services
1 2 (100.00%) SQL Server Integration Services
1 2 (100.00%) SQL Server 2012
2 1 (50.00%) Performance Tuning
2 1 (50.00%) SQL Server 2016
2 1 (50.00%) SQL Server Analysis Services
2 1 (50.00%) Data Modelling
2 1 (50.00%) SMS
2 1 (50.00%) Business Intelligence
2 1 (50.00%) Microsoft

OLTP
Co-occurring IT Skills in Stoke-on-Trent 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:

Communications & Networking
1 1 (50.00%) SMS
Database & Business Intelligence
1 2 (100.00%) SQL Server
1 2 (100.00%) SQL Server 2012
1 2 (100.00%) SQL Server Integration Services
1 2 (100.00%) SQL Server Reporting Services
2 1 (50.00%) SQL Server 2016
2 1 (50.00%) SQL Server Analysis Services
Job Titles
1 2 (100.00%) Developer
1 2 (100.00%) SQL Developer
2 1 (50.00%) DBA
2 1 (50.00%) SQL DBA
2 1 (50.00%) SQL Server DBA
2 1 (50.00%) SQL Server Developer
Processes & Methodologies
1 1 (50.00%) Business Intelligence
1 1 (50.00%) Data Modelling
1 1 (50.00%) Performance Tuning
Programming Languages
1 2 (100.00%) SQL
1 2 (100.00%) T-SQL
Vendors
1 1 (50.00%) Microsoft