Period
to 20 November 2017

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

Transact-SQL
Hampshire > Portsmouth
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 48 22 19
Rank change year-on-year -26 -3 +70
Permanent jobs citing T-SQL 40 63 89
As % of all permanent IT jobs advertised in Portsmouth 5.76% 9.53% 11.00%
As % of the Programming Languages category 9.95% 16.24% 16.64%
Number of salaries quoted 42 62 89
Portsmouth median annual salary £45,000 £37,500 £40,000
Median salary % change year-on-year +20.00% -6.25% -23.08%
10th Percentile £24,000 £31,025 £25,700
90th Percentile £51,125 £42,750 £64,500
Hampshire median annual salary £38,500 £40,000 £38,000
% change year-on-year -3.75% +5.26% -7.32%

T-SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Portsmouth with a requirement for coding skills.

All Programming Languages
Portsmouth
Permanent vacancies with a requirement for coding skills 402 388 535
As % of all permanent IT jobs advertised in Portsmouth 57.93% 58.70% 66.13%
Number of salaries quoted 371 376 462
Portsmouth median annual salary £42,500 £40,000 £42,500
Median salary % change year-on-year +6.25% -5.88% +6.25%
10th Percentile £23,750 £26,250 £27,500
90th Percentile £57,500 £55,625 £58,750
Hampshire median annual salary £42,500 £40,000 £42,000
% change year-on-year +6.25% -4.76% +5.00%

T-SQL
Job Vacancy Trend in Portsmouth

Job postings citing T-SQL as a percentage of all IT jobs advertised in Portsmouth.

Job vacancy trend for T-SQL in Portsmouth

T-SQL
Salary Trend in Portsmouth

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in Portsmouth.

Salary trend for T-SQL in Portsmouth

T-SQL
Salary Histogram in Portsmouth

The salary distribution of IT jobs citing T-SQL in Portsmouth over the 6 months to 20 November 2017.

Salary histogram for T-SQL in Portsmouth

For the 6 months to 20 November 2017, IT jobs citing T-SQL 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 Portsmouth region with a requirement for T-SQL.

1 40 (100.00%) SQL
2 34 (85.00%) C#
2 34 (85.00%) .NET
3 31 (77.50%) ASP.NET
4 28 (70.00%) MVC
5 20 (50.00%) SQL Server
6 18 (45.00%) Agile Software Development
7 16 (40.00%) ASP.NET MVC
8 13 (32.50%) JavaScript
9 12 (30.00%) Microsoft
10 11 (27.50%) Unit Testing
11 10 (25.00%) VB.NET
11 10 (25.00%) CRM
11 10 (25.00%) Data Analytics
11 10 (25.00%) Analytics
11 10 (25.00%) ASP.NET Web Forms
12 8 (20.00%) CSS
12 8 (20.00%) HTML
12 8 (20.00%) Business Intelligence
13 7 (17.50%) AngularJS
14 6 (15.00%) SQL Server Reporting Services
14 6 (15.00%) SQL Server Integration Services
15 5 (12.50%) Scrum
15 5 (12.50%) Git (software)
15 5 (12.50%) Front End Development
15 5 (12.50%) SOLID
15 5 (12.50%) Kendo UI
16 4 (10.00%) Performance Tuning
16 4 (10.00%) SQL Server 2008
16 4 (10.00%) Selenium

T-SQL
Co-occurring IT Skills in Portsmouth 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:

Application Platforms
1 2 (5.00%) SharePoint
2 1 (2.50%) Confluence
Applications
1 2 (5.00%) Microsoft Excel
1 2 (5.00%) MS Visio
1 2 (5.00%) Photoshop
Cloud Services
1 1 (2.50%) Amazon AWS
1 1 (2.50%) Microsoft Azure
Communications & Networking
1 2 (5.00%) Internet
Database & Business Intelligence
1 20 (50.00%) SQL Server
2 6 (15.00%) SQL Server Integration Services
2 6 (15.00%) SQL Server Reporting Services
3 4 (10.00%) SQL Server 2008
4 3 (7.50%) InfluxDB
4 3 (7.50%) MongoDB
4 3 (7.50%) SQL Server 2005
4 3 (7.50%) SQL Server 2012
5 2 (5.00%) Crystal Reports
5 2 (5.00%) Microsoft Power View
5 2 (5.00%) PerformancePoint
5 2 (5.00%) QlikView
6 1 (2.50%) Amazon RDS
6 1 (2.50%) Data Warehouse
6 1 (2.50%) Endeca
6 1 (2.50%) SQL Server Analysis Services
Development Applications
1 5 (12.50%) Git (software)
2 4 (10.00%) Selenium
3 3 (7.50%) NUnit
3 3 (7.50%) SQL Server Management Studio (SSMS)
3 3 (7.50%) Team Foundation Server
4 2 (5.00%) Moq
5 1 (2.50%) JIRA
5 1 (2.50%) TeamCity
General
1 1 (2.50%) Retail
Job Titles
1 34 (85.00%) Developer
2 23 (57.50%) C# Developer
3 18 (45.00%) .NET Developer
4 13 (32.50%) C# .NET Developer
4 13 (32.50%) SQL Developer
5 12 (30.00%) ASP.NET Developer
5 12 (30.00%) C# ASP.NET Developer
6 11 (27.50%) Software Developer
7 10 (25.00%) Applications Developer
7 10 (25.00%) C# Application Developer
8 9 (22.50%) ASP.NET MVC Developer
9 8 (20.00%) Senior Developer
10 7 (17.50%) Applications Support
10 7 (17.50%) T-SQL Developer
11 6 (15.00%) Senior .NET Developer
12 5 (12.50%) Full Stack Developer
12 5 (12.50%) Graduate
12 5 (12.50%) Graduate Developer
12 5 (12.50%) Graduate Software Developer
12 5 (12.50%) Senior C# Developer
Libraries, Frameworks & Software Standards
1 34 (85.00%) .NET
2 31 (77.50%) ASP.NET
3 16 (40.00%) ASP.NET MVC
4 10 (25.00%) ASP.NET Web Forms
5 8 (20.00%) CSS
5 8 (20.00%) HTML
6 7 (17.50%) AngularJS
7 5 (12.50%) Kendo UI
8 3 (7.50%) jQuery
9 2 (5.00%) ASP.NET MVC 4
9 2 (5.00%) Twitter Bootstrap
10 1 (2.50%) ASP.NET MVC 3
Miscellaneous
1 3 (7.50%) Replication
2 2 (5.00%) User Experience
Operating Systems
1 3 (7.50%) Linux
Processes & Methodologies
1 28 (70.00%) MVC
2 18 (45.00%) Agile Software Development
3 11 (27.50%) Unit Testing
4 10 (25.00%) Analytics
4 10 (25.00%) CRM
4 10 (25.00%) Data Analytics
5 8 (20.00%) Business Intelligence
6 5 (12.50%) Front End Development
6 5 (12.50%) Scrum
6 5 (12.50%) SOLID
7 4 (10.00%) Performance Tuning
8 3 (7.50%) Change Management
8 3 (7.50%) Creative Thinking
8 3 (7.50%) Database Mirroring
8 3 (7.50%) E-Commerce
8 3 (7.50%) Statistics
8 3 (7.50%) Web Development
9 2 (5.00%) Data Modelling
9 2 (5.00%) Innovative Thinking
9 2 (5.00%) SOA
Programming Languages
1 40 (100.00%) SQL
2 34 (85.00%) C#
3 13 (32.50%) JavaScript
4 10 (25.00%) VB.NET
5 2 (5.00%) Java
5 2 (5.00%) PL/SQL
Qualifications
1 2 (5.00%) Degree
Systems Management
1 3 (7.50%) Perfmon
Vendors
1 12 (30.00%) Microsoft
2 2 (5.00%) Salesforce.com