Period
to 20 November 2017

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

MySQL
North West > Lancashire
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 35 26 39
Rank change year-on-year -9 +13 -10
Permanent jobs citing MySQL 47 63 53
As % of all permanent IT jobs advertised in Lancashire 5.26% 7.02% 5.26%
As % of the Database & Business Intelligence category 14.29% 19.03% 14.48%
Number of salaries quoted 42 61 50
Lancashire median annual salary £32,500 £32,500 £30,750
Median salary % change year-on-year - +5.69% +2.50%
10th Percentile £25,000 £20,250 £22,375
90th Percentile £47,500 £43,750 £44,775
North West median annual salary £40,000 £37,500 £35,000
% change year-on-year +6.67% +7.14% +7.69%

MySQL is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Lancashire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Lancashire
Permanent vacancies with a requirement for database or business intelligence skills 329 331 366
As % of all permanent IT jobs advertised in Lancashire 36.84% 36.90% 36.31%
Number of salaries quoted 289 292 308
Lancashire median annual salary £35,000 £37,500 £35,000
Median salary % change year-on-year -6.67% +7.14% -
10th Percentile £27,500 £26,250 £26,250
90th Percentile £47,500 £45,000 £45,779
North West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +5.26%

MySQL
Job Vacancy Trend in Lancashire

Job postings citing MySQL as a percentage of all IT jobs advertised in Lancashire.

Job vacancy trend for MySQL in Lancashire

MySQL
Salary Trend in Lancashire

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing MySQL in Lancashire.

Salary trend for MySQL in Lancashire

MySQL
Salary Histogram in Lancashire

The salary distribution of IT jobs citing MySQL in Lancashire over the 6 months to 20 November 2017.

Salary histogram for MySQL in Lancashire

MySQL
Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing MySQL within the Lancashire region over the 6 months to 20 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Preston -13 19 £32,500 - 1
Blackburn +7 6 £32,500 -27.78%
Skelmersdale - 5 £25,000 -
Burnley -6 4 £30,000 -14.29%
Chorley -2 3 £40,000 +14.29%
Blackpool +17 2 £41,125 +58.17% 1
MySQL
North West

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

1 36 (76.60%) PHP
2 30 (63.83%) CSS
3 29 (61.70%) HTML
4 25 (53.19%) SQL
5 18 (38.30%) Linux
6 17 (36.17%) OOP
7 16 (34.04%) Symfony
7 16 (34.04%) HTML5
8 15 (31.91%) PHP 5
8 15 (31.91%) jQuery
9 14 (29.79%) OO
9 14 (29.79%) SQL Server
10 12 (25.53%) PHP 7
11 11 (23.40%) JavaScript
11 11 (23.40%) CakePHP
12 10 (21.28%) Ajax
12 10 (21.28%) Marketing
12 10 (21.28%) Apache
12 10 (21.28%) Laravel
13 9 (19.15%) Magento
13 9 (19.15%) Digital Marketing
13 9 (19.15%) E-Commerce
13 9 (19.15%) Web Development
14 8 (17.02%) Creative Marketing
14 8 (17.02%) Project Management
15 7 (14.89%) Windows
15 7 (14.89%) Computer Science
15 7 (14.89%) Windows Server
16 6 (12.77%) WordPress
16 6 (12.77%) nginx

MySQL
Co-occurring IT Skills in Lancashire 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 10 (21.28%) Apache
2 6 (12.77%) nginx
2 6 (12.77%) WordPress
3 1 (2.13%) Drupal
3 1 (2.13%) ExpressionEngine
3 1 (2.13%) IIS
3 1 (2.13%) JBoss
3 1 (2.13%) Liferay
3 1 (2.13%) MS Exchange
3 1 (2.13%) Tomcat
Applications
1 1 (2.13%) Microsoft Excel
1 1 (2.13%) Microsoft Office
Business Applications
1 9 (19.15%) Magento
Cloud Services
1 1 (2.13%) Amazon AWS
1 1 (2.13%) GitHub
1 1 (2.13%) Microsoft Azure
Communications & Networking
1 3 (6.38%) Network Security
1 3 (6.38%) SAN
1 3 (6.38%) SSH
2 2 (4.26%) ADSL
2 2 (4.26%) MPLS
3 1 (2.13%) Firewall
3 1 (2.13%) SSL
3 1 (2.13%) VLAN
3 1 (2.13%) Wireless
Database & Business Intelligence
1 14 (29.79%) SQL Server
2 5 (10.64%) PostgreSQL
3 3 (6.38%) SQL Server 2008
3 3 (6.38%) SQL Server 2014
4 2 (4.26%) MongoDB
5 1 (2.13%) NoSQL
5 1 (2.13%) Oracle Database
5 1 (2.13%) Redis
Development Applications
1 5 (10.64%) Git (software)
2 3 (6.38%) PHPUnit
3 2 (4.26%) Bitbucket
3 2 (4.26%) GitLab
3 2 (4.26%) PhpStorm
4 1 (2.13%) Cucumber
4 1 (2.13%) JIRA
4 1 (2.13%) Selenium
4 1 (2.13%) SpecFlow
4 1 (2.13%) Subversion
General
1 10 (21.28%) Marketing
2 3 (6.38%) Retail
3 1 (2.13%) Back Office
Job Titles
1 33 (70.21%) Developer
2 30 (63.83%) PHP Developer
3 9 (19.15%) Senior Developer
4 8 (17.02%) Senior PHP Developer
5 5 (10.64%) PHP Web Developer
5 5 (10.64%) Web Developer
6 4 (8.51%) Analyst
6 4 (8.51%) Development Manager
6 4 (8.51%) Infrastructure Manager
6 4 (8.51%) IT Development Manager
6 4 (8.51%) IT Infrastructure Manager
6 4 (8.51%) IT Manager
7 3 (6.38%) Applications Support Analyst
7 3 (6.38%) MySQL Developer
7 3 (6.38%) PHP MySQL Developer
7 3 (6.38%) SQL Analyst
7 3 (6.38%) SQL Support Analyst
7 3 (6.38%) Unix Analyst
7 3 (6.38%) Unix Support
7 3 (6.38%) Unix Support Analyst
Libraries, Frameworks & Software Standards
1 30 (63.83%) CSS
2 29 (61.70%) HTML
3 16 (34.04%) HTML5
3 16 (34.04%) Symfony
4 15 (31.91%) jQuery
5 11 (23.40%) CakePHP
6 10 (21.28%) Ajax
6 10 (21.28%) Laravel
7 6 (12.77%) LAMP
8 5 (10.64%) CSS3
9 4 (8.51%) Doctrine
10 3 (6.38%) CodeIgniter
10 3 (6.38%) LEMP Stack
11 2 (4.26%) .NET
11 2 (4.26%) AngularJS
11 2 (4.26%) Web Services
12 1 (2.13%) Behat
12 1 (2.13%) Ember.js
12 1 (2.13%) React
12 1 (2.13%) Twitter Bootstrap
Miscellaneous
1 7 (14.89%) Computer Science
2 6 (12.77%) Analytical Skills
3 5 (10.64%) iPad
4 4 (8.51%) Management Information System
5 2 (4.26%) Greenfield Project
6 1 (2.13%) Digital Media
6 1 (2.13%) Mainframe
6 1 (2.13%) Replication
6 1 (2.13%) User Experience
6 1 (2.13%) Web 2.0
Operating Systems
1 18 (38.30%) Linux
2 7 (14.89%) Windows
2 7 (14.89%) Windows Server
3 4 (8.51%) Unix
4 2 (4.26%) CentOS
4 2 (4.26%) Ubuntu
5 1 (2.13%) Red Hat Enterprise Linux
5 1 (2.13%) Windows 10
5 1 (2.13%) Windows 7
5 1 (2.13%) Windows 8
5 1 (2.13%) Windows Server 2012
Processes & Methodologies
1 17 (36.17%) OOP
2 14 (29.79%) OO
3 9 (19.15%) Digital Marketing
3 9 (19.15%) E-Commerce
3 9 (19.15%) Web Development
4 8 (17.02%) Creative Marketing
4 8 (17.02%) Project Management
5 6 (12.77%) MVC
6 5 (10.64%) Coaching
6 5 (10.64%) ERP
7 4 (8.51%) Agile Software Development
7 4 (8.51%) Business Continuity
7 4 (8.51%) Information Security
7 4 (8.51%) ITIL
8 3 (6.38%) Change Control
8 3 (6.38%) Data Protection
8 3 (6.38%) Disaster Recovery
8 3 (6.38%) Incident Management
8 3 (6.38%) OO PHP
8 3 (6.38%) Problem Management
Programming Languages
1 36 (76.60%) PHP
2 25 (53.19%) SQL
3 15 (31.91%) PHP 5
4 12 (25.53%) PHP 7
5 11 (23.40%) JavaScript
6 5 (10.64%) C#
7 2 (4.26%) Java
8 1 (2.13%) Bash Shell
8 1 (2.13%) VB.NET
8 1 (2.13%) VBA
Qualifications
1 3 (6.38%) NVQ Level 4
2 2 (4.26%) Degree
3 1 (2.13%) ISEB
3 1 (2.13%) ISTQB
3 1 (2.13%) Oracle Certification
Quality Assurance & Compliance
1 3 (6.38%) SLA
2 2 (4.26%) GDPR
3 1 (2.13%) ISO/IEC 27001
3 1 (2.13%) PCI DSS
3 1 (2.13%) QA
System Software
1 3 (6.38%) Active Directory
2 2 (4.26%) VMware Infrastructure
3 1 (2.13%) Virtual Machines
3 1 (2.13%) Xen
Systems Management
1 1 (2.13%) Oracle RMAN
Vendors
1 5 (10.64%) Microsoft
2 4 (8.51%) Oracle
3 3 (6.38%) VMware
4 2 (4.26%) Cisco
4 2 (4.26%) Citrix
4 2 (4.26%) HP
4 2 (4.26%) Red Hat
4 2 (4.26%) Zend
5 1 (2.13%) CheckPoint
5 1 (2.13%) EMC
5 1 (2.13%) Facebook
5 1 (2.13%) Twitter