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 3 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
3 May 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 40 - 46
Rank change year-on-year
- 0
Permanent jobs citing OLTP 1 0 2
As % of all permanent IT jobs located in Stoke-on-Trent 0.56% - 0.72%
As % of the Database & Business Intelligence category 1.49% - 1.33%
Number of salaries quoted 1 0 2
Median salary £36,000 - £47,500
UK excluding London median salary £50,000 £45,000 £55,000
% change year-on-year
+11.11% -18.18%
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
67 90 150
As % of all permanent IT jobs located in Stoke-on-Trent 37.64% 48.39% 54.35%
Number of salaries quoted 57 81 112
Median salary £37,500 £35,000 £33,500
Median salary % change year-on-year
+7.14% +4.47%
90% offered a salary of more than £32,500 £22,500 £20,000
10% offered a salary of more than £55,000 £55,000 £45,000
UK excluding London median salary £42,500 £40,000 £40,000
% change year-on-year
+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 28 Related IT Skills in Stoke-on-Trent

For the 6 months to 3 May 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 6 (100.00%) SQL
1 6 (100.00%) SQL Server
2 4 (66.67%) Data Modelling
3 3 (50.00%) Finance
3 3 (50.00%) SQL Server Reporting Services
4 2 (33.33%) QA
4 2 (33.33%) User Acceptance Testing
4 2 (33.33%) SQL Server 2008
4 2 (33.33%) Capacity Planning
4 2 (33.33%) Performance Monitoring
4 2 (33.33%) Relational Database
4 2 (33.33%) Analytical Skills
4 2 (33.33%) Database Mirroring
4 2 (33.33%) ETL Development
4 2 (33.33%) Games
4 2 (33.33%) Replication
4 2 (33.33%) ETL
4 2 (33.33%) RDBMS
4 2 (33.33%) T-SQL
5 1 (16.67%) E-Commerce
5 1 (16.67%) Clustering
5 1 (16.67%) High Availability
5 1 (16.67%) Database Security
5 1 (16.67%) Performance Tuning
5 1 (16.67%) SQL Server Analysis Services
5 1 (16.67%) SQL Server 2005
5 1 (16.67%) SQL Server Integration Services
5 1 (16.67%) Degree

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 6 (100.00%) SQL Server
2 3 (50.00%) SQL Server Reporting Services
3 2 (33.33%) RDBMS
3 2 (33.33%) Relational Database
3 2 (33.33%) SQL Server 2008
4 1 (16.67%) SQL Server 2005
4 1 (16.67%) SQL Server Analysis Services
4 1 (16.67%) SQL Server Integration Services
General
1 3 (50.00%) Finance
2 2 (33.33%) Games
Job Titles
1 4 (66.67%) Developer
2 3 (50.00%) SQL Developer
3 2 (33.33%) DBA
3 2 (33.33%) MIS Developer
3 2 (33.33%) SQL Server Developer
3 2 (33.33%) SSRS Developer
4 1 (16.67%) Administrator
4 1 (16.67%) Graduate
4 1 (16.67%) Graduate DBA
4 1 (16.67%) Junior
4 1 (16.67%) Junior DBA
4 1 (16.67%) Production DBA
4 1 (16.67%) Report Developer
4 1 (16.67%) SQL DBA
Miscellaneous
1 2 (33.33%) Analytical Skills
1 2 (33.33%) Replication
2 1 (16.67%) Clustering
Processes & Methodologies
1 4 (66.67%) Data Modelling
2 2 (33.33%) Capacity Planning
2 2 (33.33%) Database Mirroring
2 2 (33.33%) ETL
2 2 (33.33%) ETL Development
2 2 (33.33%) Performance Monitoring
2 2 (33.33%) User Acceptance Testing
3 1 (16.67%) Database Security
3 1 (16.67%) E-Commerce
3 1 (16.67%) High Availability
3 1 (16.67%) Performance Tuning
Programming Languages
1 6 (100.00%) SQL
2 2 (33.33%) T-SQL
Qualifications
1 1 (16.67%) Degree
Quality Assurance & Compliance
1 2 (33.33%) QA