Period
to 17 January 2018

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 17 January 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
Hampshire > Portsmouth
6 months to
17 Jan 2018
Same period 2017 Same period 2016
Rank 30 24 20
Rank change year-on-year -6 -4 +50
Permanent jobs citing T-SQL 61 63 98
As % of all permanent IT jobs advertised in Portsmouth 9.50% 10.14% 12.60%
As % of the Programming Languages category 16.40% 16.58% 18.15%
Number of salaries quoted 69 62 97
Portsmouth median annual salary £45,000 £38,625 £40,000
Median salary % change year-on-year +16.50% -3.44% +14.29%
10th Percentile £24,000 £29,375 £23,100
90th Percentile £53,750 £42,750 £66,000
Hampshire median annual salary £37,500 £39,750 £37,500
% change year-on-year -5.66% +6.00% -6.25%

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 372 380 540
As % of all permanent IT jobs advertised in Portsmouth 57.94% 61.19% 69.41%
Number of salaries quoted 342 361 488
Portsmouth median annual salary £42,500 £40,000 £42,500
Median salary % change year-on-year +6.25% -5.88% +6.25%
10th Percentile £24,000 £26,000 £27,500
90th Percentile £57,500 £53,750 £58,750
Hampshire median annual salary £40,000 £40,000 £42,500
% change year-on-year - -5.88% +6.25%

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 17 January 2018.

Salary histogram for T-SQL in Portsmouth

For the 6 months to 17 January 2018, 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 61 (100.00%) SQL
2 53 (86.89%) C#
2 53 (86.89%) .NET
3 43 (70.49%) ASP.NET
4 40 (65.57%) MVC
5 34 (55.74%) SQL Server
6 33 (54.10%) Agile Software Development
7 28 (45.90%) ASP.NET MVC
8 19 (31.15%) JavaScript
9 17 (27.87%) CRM
9 17 (27.87%) Data Analytics
9 17 (27.87%) Analytics
10 16 (26.23%) Unit Testing
11 12 (19.67%) Git (software)
12 11 (18.03%) VB.NET
13 10 (16.39%) Microsoft
13 10 (16.39%) ASP.NET Web Forms
14 9 (14.75%) InfluxDB
14 9 (14.75%) Selenium
14 9 (14.75%) MongoDB
14 9 (14.75%) Scrum
14 9 (14.75%) Business Intelligence
14 9 (14.75%) E-Commerce
14 9 (14.75%) Creative Thinking
15 8 (13.11%) HTML
15 8 (13.11%) CSS
16 7 (11.48%) AngularJS
16 7 (11.48%) ASP.NET MVC 4
16 7 (11.48%) Internet
16 7 (11.48%) Lead Generation

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 (3.28%) SharePoint
Applications
1 2 (3.28%) Microsoft Excel
1 2 (3.28%) MS Visio
1 2 (3.28%) Photoshop
Cloud Services
1 1 (1.64%) Amazon AWS
1 1 (1.64%) Microsoft Azure
Communications & Networking
1 7 (11.48%) Internet
2 4 (6.56%) DNS
2 4 (6.56%) HTTP
2 4 (6.56%) SMTP
2 4 (6.56%) TCP/IP
Database & Business Intelligence
1 34 (55.74%) SQL Server
2 9 (14.75%) InfluxDB
2 9 (14.75%) MongoDB
3 5 (8.20%) SQL Server Integration Services
3 5 (8.20%) SQL Server Reporting Services
4 2 (3.28%) Crystal Reports
4 2 (3.28%) Microsoft Power View
4 2 (3.28%) PerformancePoint
4 2 (3.28%) QlikView
4 2 (3.28%) SQL Server 2008
4 2 (3.28%) SQL Server Analysis Services
5 1 (1.64%) Amazon RDS
5 1 (1.64%) Data Warehouse
5 1 (1.64%) Power BI
5 1 (1.64%) SQL Server 2005
5 1 (1.64%) SQL Server 2012
5 1 (1.64%) SQL Server 2016
Development Applications
1 12 (19.67%) Git (software)
2 9 (14.75%) Selenium
3 3 (4.92%) Team Foundation Server
4 2 (3.28%) Moq
4 2 (3.28%) NUnit
5 1 (1.64%) SQL Server Management Studio (SSMS)
General
1 1 (1.64%) Advertising
1 1 (1.64%) Retail
Job Titles
1 53 (86.89%) Developer
2 35 (57.38%) .NET Developer
2 35 (57.38%) C# Developer
3 24 (39.34%) C# .NET Developer
4 23 (37.70%) ASP.NET Developer
4 23 (37.70%) C# ASP.NET Developer
5 20 (32.79%) ASP.NET MVC Developer
5 20 (32.79%) SQL Developer
6 17 (27.87%) Software Developer
7 16 (26.23%) Applications Developer
7 16 (26.23%) C# Application Developer
8 12 (19.67%) Senior Developer
9 11 (18.03%) C# Software Developer
10 10 (16.39%) Senior .NET Developer
11 9 (14.75%) .NET Applications Developer
11 9 (14.75%) Applications Support
11 9 (14.75%) Junior
11 9 (14.75%) Junior .NET Developer
11 9 (14.75%) Junior Developer
11 9 (14.75%) Senior C# Developer
Libraries, Frameworks & Software Standards
1 53 (86.89%) .NET
2 43 (70.49%) ASP.NET
3 28 (45.90%) ASP.NET MVC
4 10 (16.39%) ASP.NET Web Forms
5 8 (13.11%) CSS
5 8 (13.11%) HTML
6 7 (11.48%) AngularJS
6 7 (11.48%) ASP.NET MVC 4
7 5 (8.20%) Kendo UI
8 2 (3.28%) jQuery
8 2 (3.28%) Twitter Bootstrap
Miscellaneous
1 2 (3.28%) User Experience
2 1 (1.64%) Replication
Operating Systems
1 5 (8.20%) Linux
2 4 (6.56%) Unix
2 4 (6.56%) Windows
2 4 (6.56%) Windows 10
2 4 (6.56%) Windows 7
2 4 (6.56%) Windows Server 2008
Processes & Methodologies
1 40 (65.57%) MVC
2 33 (54.10%) Agile Software Development
3 17 (27.87%) Analytics
3 17 (27.87%) CRM
3 17 (27.87%) Data Analytics
4 16 (26.23%) Unit Testing
5 9 (14.75%) Business Intelligence
5 9 (14.75%) Creative Thinking
5 9 (14.75%) E-Commerce
5 9 (14.75%) Scrum
6 7 (11.48%) Lead Generation
7 6 (9.84%) Customer Requirements
7 6 (9.84%) Front End Development
7 6 (9.84%) SOLID
8 4 (6.56%) Fault Management
8 4 (6.56%) Technical Architecture
9 3 (4.92%) Performance Tuning
10 2 (3.28%) Configure, Price, Quote (CPQ)
10 2 (3.28%) Responsive Web Design
10 2 (3.28%) SDLC
Programming Languages
1 61 (100.00%) SQL
2 53 (86.89%) C#
3 19 (31.15%) JavaScript
4 11 (18.03%) VB.NET
5 4 (6.56%) PowerShell
5 4 (6.56%) VBScript
6 2 (3.28%) Java
6 2 (3.28%) PL/SQL
Qualifications
1 4 (6.56%) SC Cleared
1 4 (6.56%) Security Cleared
2 2 (3.28%) Degree
System Software
1 4 (6.56%) Active Directory
Systems Management
1 4 (6.56%) SCCM
1 4 (6.56%) SCOM
2 1 (1.64%) Perfmon
Vendors
1 10 (16.39%) Microsoft
2 4 (6.56%) VMware
3 2 (3.28%) Salesforce.com