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

3 months to
10 Dec 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 49 30 -
Rank change year-on-year
-19 -
Permanent jobs citing OLTP 2 11 0
As % of all permanent IT jobs located in Stoke-on-Trent 0.85% 5.45% -
As % of the Database & Business Intelligence category 1.80% 11.34% -
Number of salaries quoted 2 6 0
Median salary £50,000 £55,000 -
Median salary % change year-on-year
-9.09% -
UK excluding London median salary £52,500 £50,000 £40,000
% change year-on-year
+5.00% +25.00%
OLTP
Staffordshire

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 Stoke-on-Trent region.

Database & Business Intelligence Category
Stoke-on-Trent
Permanent IT job ads with a match in the
Database & Business Intelligence category
111 97 104
As % of all permanent IT jobs located in Stoke-on-Trent 47.44% 48.02% 42.28%
Number of salaries quoted 98 74 82
Median salary £42,500 £37,750 £35,000
Median salary % change year-on-year
+12.58% +7.85%
90% offered a salary of more than £27,500 £28,500 £23,500
10% offered a salary of more than £52,500 £46,000 £55,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

OLTP
Jobs Demand Trend in Stoke-on-Trent

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

OLTP Jobs Demand Trend 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 across the Stoke-on-Trent region.

OLTP Salary Trend in Stoke-on-Trent

OLTP
Top 16 Related IT Skills in Stoke-on-Trent

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

1 7 (100.00%) SQL
1 7 (100.00%) T-SQL
1 7 (100.00%) SQL Server
1 7 (100.00%) SQL Server Reporting Services
1 7 (100.00%) SQL Server Integration Services
1 7 (100.00%) SQL Server 2008
2 5 (71.43%) SQL Server Analysis Services
2 5 (71.43%) Performance Tuning
2 5 (71.43%) Business Intelligence
2 5 (71.43%) Microsoft
3 4 (57.14%) Enterprise Software
4 2 (28.57%) Data Modelling
4 2 (28.57%) ETL
4 2 (28.57%) Performance Monitoring
4 2 (28.57%) Analytical Skills
4 2 (28.57%) ETL Development

OLTP
Top Related 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:

Database & Business Intelligence
1 7 (100.00%) SQL Server
1 7 (100.00%) SQL Server 2008
1 7 (100.00%) SQL Server Integration Services
1 7 (100.00%) SQL Server Reporting Services
2 5 (71.43%) SQL Server Analysis Services
Job Titles
1 5 (71.43%) DBA
1 5 (71.43%) SQL DBA
2 4 (57.14%) SQL Server DBA
3 3 (42.86%) Developer
3 3 (42.86%) SQL Developer
3 3 (42.86%) SQL Server Developer
4 2 (28.57%) Junior
4 2 (28.57%) Junior Developer
4 2 (28.57%) Junior SQL Developer
4 2 (28.57%) Junior SQL Server Developer
4 2 (28.57%) Senior Developer
4 2 (28.57%) Senior SQL Developer
4 2 (28.57%) Senior SQL Server Developer
5 1 (14.29%) Administrator
Miscellaneous
1 4 (57.14%) Enterprise Software
2 2 (28.57%) Analytical Skills
Processes & Methodologies
1 5 (71.43%) Business Intelligence
1 5 (71.43%) Performance Tuning
2 2 (28.57%) Data Modelling
2 2 (28.57%) ETL
2 2 (28.57%) ETL Development
2 2 (28.57%) Performance Monitoring
Programming Languages
1 7 (100.00%) SQL
1 7 (100.00%) T-SQL
Vendors
1 5 (71.43%) Microsoft