Period
to 24 November 2017

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

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

SQL (Structured Query Language)
Hampshire > Portsmouth
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 13 6 9
Rank change year-on-year -7 +3 -1
Contract jobs citing SQL 34 62 27
As % of all contract IT jobs advertised in Portsmouth 10.93% 18.13% 11.20%
As % of the Programming Languages category 30.63% 53.45% 34.18%
Number of daily rates quoted 21 26 14
Portsmouth median daily rate £335 £313 £281
Median daily rate % change year-on-year +7.20% +11.11% -19.64%
10th Percentile £308 £243 £263
90th Percentile £500 £425 £425
Hampshire median daily rate £375 £350 £360
% change year-on-year +7.14% -2.78% +2.86%
Number of hourly rates quoted 2 12 2
Portsmouth median hourly rate £39.22 £36.25 £32.73
Median hourly rate % change year-on-year +8.19% +10.75% +28.35%
10th Percentile £20.91 £31.31 £27.42
90th Percentile £57.23 £44.95 £38.04
Hampshire median hourly rate £44.12 £40.50 £36.50
% change year-on-year +8.93% +10.96% +37.74%

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

All Programming Languages
Portsmouth
Contract vacancies with a requirement for coding skills 111 116 79
As % of all contract IT jobs advertised in Portsmouth 35.69% 33.92% 32.78%
Number of daily rates quoted 54 52 39
Portsmouth median daily rate £368 £350 £325
Median daily rate % change year-on-year +5.00% +7.69% -7.14%
10th Percentile £308 £263 £263
90th Percentile £500 £438 £425
Hampshire median daily rate £400 £370 £365
% change year-on-year +8.11% +1.37% +4.29%
Number of hourly rates quoted 14 23 7
Portsmouth median hourly rate £45.00 £42.50 £39.00
Median hourly rate % change year-on-year +5.88% +8.97% +39.29%
10th Percentile £41.25 £31.87 £16.15
90th Percentile £51.63 £48.40 £42.55
Hampshire median hourly rate £44.06 £42.50 £37.50
% change year-on-year +3.66% +13.33% -

SQL
Job Vacancy Trend in Portsmouth

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

Job vacancy trend for SQL in Portsmouth

SQL
Contractor Daily Rate Trend in Portsmouth

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing SQL in Portsmouth.

Contractor daily rate trend for SQL in Portsmouth

SQL
Contractor Daily Rate Histogram in Portsmouth

The daily rate distribution of IT jobs citing SQL in Portsmouth over the 6 months to 24 November 2017.

Contractor daily rate histogram for SQL in Portsmouth

SQL
Contractor Hourly Rate Trend in Portsmouth

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing SQL in Portsmouth.

Contractor hourly rate trend for SQL in Portsmouth

SQL
Contractor Hourly Rate Histogram in Portsmouth

The hourly rate distribution of IT jobs citing SQL in Portsmouth over the 6 months to 24 November 2017.

Contractor hourly rate histogram for SQL in Portsmouth

For the 6 months to 24 November 2017, IT contractor jobs citing SQL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the Portsmouth region with a requirement for SQL.

1 19 (55.88%) SQL Server
2 17 (50.00%) .NET
3 16 (47.06%) C#
3 16 (47.06%) MVC
4 15 (44.12%) Microsoft
5 14 (41.18%) JavaScript
5 14 (41.18%) Agile Software Development
6 13 (38.24%) CSS
7 12 (35.29%) Visual Studio
7 12 (35.29%) jQuery
7 12 (35.29%) Relational Database
7 12 (35.29%) ASP.NET Web API
7 12 (35.29%) SDLC
8 11 (32.35%) LINQ to SQL
8 11 (32.35%) LINQ
8 11 (32.35%) .NET Framework
8 11 (32.35%) ASP.NET
8 11 (32.35%) HTML
8 11 (32.35%) XML
9 10 (29.41%) Windows
9 10 (29.41%) SQL Server 2008
10 9 (26.47%) Ajax
10 9 (26.47%) Web Services
10 9 (26.47%) Entity Framework
10 9 (26.47%) ASP.NET MVC
10 9 (26.47%) API Development
11 7 (20.59%) Windows Server
12 6 (17.65%) RequireJS
12 6 (17.65%) Security Cleared
12 6 (17.65%) Team Foundation Server

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 4 (11.76%) MS Exchange
1 4 (11.76%) SharePoint
2 3 (8.82%) IIS
2 3 (8.82%) WebLogic
3 1 (2.94%) Apache
3 1 (2.94%) Apache Pig
3 1 (2.94%) Apache Spark
3 1 (2.94%) CICS
3 1 (2.94%) Confluence
3 1 (2.94%) Jupyter
Applications
1 1 (2.94%) Microsoft Excel
Business Applications
1 3 (8.82%) Oracle EBS
1 3 (8.82%) Oracle EBS R12
Cloud Services
1 3 (8.82%) Office 365
2 2 (5.88%) Cloud Computing
2 2 (5.88%) Microsoft Azure
3 1 (2.94%) Amazon AWS
3 1 (2.94%) Amazon S3
3 1 (2.94%) Google Cloud Platform
Communications & Networking
1 4 (11.76%) Skype
2 3 (8.82%) DNS
2 3 (8.82%) IMAP
2 3 (8.82%) Internet
2 3 (8.82%) SMTP
3 2 (5.88%) TCP/IP
4 1 (2.94%) LAN
Database & Business Intelligence
1 19 (55.88%) SQL Server
2 12 (35.29%) Relational Database
3 10 (29.41%) SQL Server 2008
4 3 (8.82%) Oracle BI EE
4 3 (8.82%) Oracle Database
4 3 (8.82%) Oracle Database 11g
4 3 (8.82%) Oracle Database 12c
4 3 (8.82%) RDBMS
4 3 (8.82%) SQL Server Analysis Services
4 3 (8.82%) SQL Server Integration Services
4 3 (8.82%) SQL Server Reporting Services
5 1 (2.94%) Amazon Redshift
5 1 (2.94%) Apache Hive
5 1 (2.94%) Big Data
5 1 (2.94%) BigQuery
5 1 (2.94%) HBase
5 1 (2.94%) Mahout
5 1 (2.94%) MongoDB
5 1 (2.94%) SAP BW
5 1 (2.94%) SQL Server 2012
Development Applications
1 12 (35.29%) Visual Studio
2 6 (17.65%) Team Foundation Server
3 2 (5.88%) JIRA
4 1 (2.94%) Atlassian Bamboo
4 1 (2.94%) Eclipse
4 1 (2.94%) Git (software)
4 1 (2.94%) Gradle
4 1 (2.94%) Jenkins
4 1 (2.94%) Maven
General
1 5 (14.71%) Finance
2 2 (5.88%) Local Government
3 1 (2.94%) Aerospace
3 1 (2.94%) Billing
3 1 (2.94%) Pharmaceutical
Job Titles
1 20 (58.82%) Developer
2 11 (32.35%) .NET Developer
3 4 (11.76%) ASP.NET MVC Developer
3 4 (11.76%) Build Engineer
3 4 (11.76%) DBA
3 4 (11.76%) Server Engineer
4 3 (8.82%) C# .NET Developer
4 3 (8.82%) C# Developer
4 3 (8.82%) Full Stack Developer
4 3 (8.82%) Oracle DBA
5 2 (5.88%) .NET Software Developer
5 2 (5.88%) Administrator
5 2 (5.88%) ASP Developer
5 2 (5.88%) Software Developer
5 2 (5.88%) SQL Developer
6 1 (2.94%) Data Scientist
6 1 (2.94%) DevOps Engineer
6 1 (2.94%) E-Business Administrator
6 1 (2.94%) SSIS Developer
6 1 (2.94%) SSRS Developer
Libraries, Frameworks & Software Standards
1 17 (50.00%) .NET
2 13 (38.24%) CSS
3 12 (35.29%) ASP.NET Web API
3 12 (35.29%) jQuery
4 11 (32.35%) .NET Framework
4 11 (32.35%) ASP.NET
4 11 (32.35%) HTML
4 11 (32.35%) LINQ
4 11 (32.35%) LINQ to SQL
4 11 (32.35%) XML
5 9 (26.47%) Ajax
5 9 (26.47%) ASP.NET MVC
5 9 (26.47%) Entity Framework
5 9 (26.47%) Web Services
6 6 (17.65%) RequireJS
7 5 (14.71%) JSON
7 5 (14.71%) WCF
8 3 (8.82%) Middleware
9 2 (5.88%) WPF
10 1 (2.94%) XML Messaging
Miscellaneous
1 5 (14.71%) User Experience
2 4 (11.76%) Greenfield Project
3 2 (5.88%) W3C
4 1 (2.94%) Analytical Skills
4 1 (2.94%) Blackberry
4 1 (2.94%) Client/Server
4 1 (2.94%) Fintech
4 1 (2.94%) Mainframe
4 1 (2.94%) Replication
Operating Systems
1 10 (29.41%) Windows
2 7 (20.59%) Windows Server
3 3 (8.82%) Solaris
4 2 (5.88%) Linux
Processes & Methodologies
1 16 (47.06%) MVC
2 14 (41.18%) Agile Software Development
3 12 (35.29%) SDLC
4 9 (26.47%) API Development
5 5 (14.71%) Performance Tuning
6 4 (11.76%) Business Intelligence
6 4 (11.76%) Server Building
7 3 (8.82%) Data Modelling
7 3 (8.82%) Scrum
7 3 (8.82%) Software Delivery
7 3 (8.82%) Web Development
8 2 (5.88%) Continuous Improvement
8 2 (5.88%) Front End Development
8 2 (5.88%) Software Engineering
8 2 (5.88%) Test Automation
8 2 (5.88%) Unit Testing
9 1 (2.94%) Data Extraction
9 1 (2.94%) Integration Testing
9 1 (2.94%) Manual Testing
9 1 (2.94%) Performance Management
Programming Languages
1 16 (47.06%) C#
2 14 (41.18%) JavaScript
3 3 (8.82%) F#
4 1 (2.94%) C++
4 1 (2.94%) COBOL
4 1 (2.94%) Java
4 1 (2.94%) Python
4 1 (2.94%) Scala
4 1 (2.94%) T-SQL
Qualifications
1 6 (17.65%) Security Cleared
2 5 (14.71%) SC Cleared
3 4 (11.76%) MCSA
3 4 (11.76%) Microsoft Certification
4 3 (8.82%) DV Cleared
4 3 (8.82%) MCSE
5 2 (5.88%) Degree
Quality Assurance & Compliance
1 2 (5.88%) Data Quality
1 2 (5.88%) SLA
System Software
1 4 (11.76%) Active Directory
2 1 (2.94%) Docker
Systems Management
1 4 (11.76%) McAfee ePO
2 3 (8.82%) Oracle Enterprise Manager
2 3 (8.82%) Oracle RMAN
Vendors
1 15 (44.12%) Microsoft
2 4 (11.76%) McAfee
2 4 (11.76%) Oracle
3 2 (5.88%) SAP
3 2 (5.88%) Telerik
4 1 (2.94%) Google
4 1 (2.94%) Tableau