The table below looks at the statistics for OLTP skills in IT jobs advertised for the Hampshire region. Included is a guide to the salaries offered in IT jobs that have cited OLTP over the 3 months to 27 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
27 Jul 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 160 - 194
Rank change year-on-year
- 0
Permanent jobs citing OLTP 32 0 2
As % of all permanent IT jobs located in Hampshire 0.92% - 0.051%
As % of the Database & Business Intelligence category 2.53% - 0.17%
Number of salaries quoted 29 0 2
Median salary £45,000 - £39,799
UK excluding London median salary £45,000 £45,000 £47,750
% change year-on-year
- -5.75%
OLTP
South East

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 Hampshire region.

Database & Business Intelligence Category
Hampshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
1267 1235 1204
As % of all permanent IT jobs located in Hampshire 36.53% 34.19% 30.53%
Number of salaries quoted 1142 1067 995
Median salary £42,500 £42,500 £40,000
Median salary % change year-on-year
- +6.25%
90% offered a salary of more than £30,000 £28,500 £28,000
10% offered a salary of more than £55,000 £55,000 £57,500
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

OLTP
Jobs Demand Trend in Hampshire

The demand trend of job ads across the Hampshire region citing OLTP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLTP Jobs Demand Trend in Hampshire

OLTP
Salary Trend in Hampshire

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP across the Hampshire region.

OLTP Salary Trend in Hampshire

OLTP
Salary Histogram in Hampshire

This chart provides a salary histogram for IT jobs citing OLTP across the Hampshire region over the 3 months to 27 July 2016.

OLTP Salary Histogram in Hampshire

OLTP
Job Locations in Hampshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the Hampshire region over the 3 months to 27 July 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Southampton - 28 £45,000 - 1
Fareham - 1 £35,000 -
OLTP
South East

OLTP
Top 30 Related IT Skills in Hampshire

For the 6 months to 27 July 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 Hampshire region with a requirement for OLTP.

1 44 (100.00%) SQL
2 40 (90.91%) OLAP
3 39 (88.64%) SQL Server
4 36 (81.82%) T-SQL
5 30 (68.18%) Data Warehouse
6 20 (45.45%) Database Security
7 19 (43.18%) Enterprise Software
7 19 (43.18%) Degree
8 16 (36.36%) Reverse Engineering
9 15 (34.09%) Data Management
9 15 (34.09%) Data Analysis
10 14 (31.82%) Computer Science
10 14 (31.82%) MS Excel
10 14 (31.82%) Microsoft
11 13 (29.55%) Refactoring
12 12 (27.27%) Finance
12 12 (27.27%) Java
13 11 (25.00%) Replication
13 11 (25.00%) Retail
13 11 (25.00%) Performance Tuning
14 8 (18.18%) C#
15 7 (15.91%) Windows
15 7 (15.91%) Business Intelligence
15 7 (15.91%) MS Access
15 7 (15.91%) Clustering
15 7 (15.91%) VMware
15 7 (15.91%) Disaster Recovery
15 7 (15.91%) Git (software)
15 7 (15.91%) High Availability
15 7 (15.91%) Unit Testing

OLTP
Top Related IT Skills in Hampshire 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 (9.09%) Apache
1 4 (9.09%) Apache Spark
1 4 (9.09%) Cloud Foundry
1 4 (9.09%) GemFire
1 4 (9.09%) Tomcat
2 1 (2.27%) SAS
Applications
1 14 (31.82%) MS Excel
Business Applications
1 1 (2.27%) Cognos Business Intelligence
Cloud Services
1 4 (9.09%) GitHub
1 4 (9.09%) PaaS
Database & Business Intelligence
1 40 (90.91%) OLAP
2 39 (88.64%) SQL Server
3 30 (68.18%) Data Warehouse
4 7 (15.91%) MS Access
5 4 (9.09%) Apache Hive
5 4 (9.09%) Big Data
5 4 (9.09%) Hadoop
5 4 (9.09%) HBase
6 3 (6.82%) Data Mining
6 3 (6.82%) SQL Server Analysis Services
6 3 (6.82%) SQL Server Integration Services
6 3 (6.82%) SQL Server Reporting Services
7 2 (4.55%) BusinessObjects
8 1 (2.27%) Cognos Report Studio
8 1 (2.27%) Oracle OLAP
8 1 (2.27%) Oracle Reports
8 1 (2.27%) Power BI
Development Applications
1 7 (15.91%) Git (software)
2 4 (9.09%) Eclipse
2 4 (9.09%) Gradle
2 4 (9.09%) Jenkins
2 4 (9.09%) JUnit
3 3 (6.82%) Subversion
3 3 (6.82%) Team Foundation Server
General
1 12 (27.27%) Finance
2 11 (25.00%) Retail
3 5 (11.36%) Banking
4 1 (2.27%) Manufacturing
4 1 (2.27%) Telecoms
Job Titles
1 28 (63.64%) Developer
2 26 (59.09%) SQL Developer
3 13 (29.55%) Database Developer
4 11 (25.00%) SQL Database Developer
5 9 (20.45%) SQL Server Developer
6 7 (15.91%) DBA
6 7 (15.91%) Lead Developer
6 7 (15.91%) Senior DBA
6 7 (15.91%) Senior SQL DBA
6 7 (15.91%) SQL DBA
7 6 (13.64%) Analyst
7 6 (13.64%) Senior SQL Server DBA
7 6 (13.64%) SQL Server DBA
8 4 (9.09%) Data Analyst
8 4 (9.09%) Data Warehouse Analyst
8 4 (9.09%) Java Team Leader
8 4 (9.09%) Senior Analyst
8 4 (9.09%) Senior Data Analyst
8 4 (9.09%) Team Leader
8 4 (9.09%) Technical Team Leader
Libraries, Frameworks & Software Standards
1 4 (9.09%) J2EE
1 4 (9.09%) JSON
1 4 (9.09%) Kafka
1 4 (9.09%) Middleware
1 4 (9.09%) Spark Streaming
1 4 (9.09%) Spring
1 4 (9.09%) Spring Boot
1 4 (9.09%) Spring Integration
2 3 (6.82%) .NET
3 2 (4.55%) Dapper ORM
3 2 (4.55%) EJB
3 2 (4.55%) Entity Framework
3 2 (4.55%) Hibernate
3 2 (4.55%) LINQ
3 2 (4.55%) LINQ to SQL
4 1 (2.27%) MDX
Miscellaneous
1 19 (43.18%) Enterprise Software
2 14 (31.82%) Computer Science
3 11 (25.00%) Replication
4 7 (15.91%) Clustering
5 4 (9.09%) Statistics
5 4 (9.09%) Virtual Team
6 3 (6.82%) Algorithms
Operating Systems
1 7 (15.91%) Windows
2 4 (9.09%) Linux
2 4 (9.09%) Red Hat Enterprise Linux
2 4 (9.09%) Unix
Processes & Methodologies
1 20 (45.45%) Database Security
2 16 (36.36%) Reverse Engineering
3 15 (34.09%) Data Analysis
3 15 (34.09%) Data Management
4 13 (29.55%) Refactoring
5 11 (25.00%) Performance Tuning
6 7 (15.91%) Business Intelligence
6 7 (15.91%) Capacity Planning
6 7 (15.91%) Disaster Recovery
6 7 (15.91%) High Availability
6 7 (15.91%) Software Engineering
6 7 (15.91%) Unit Testing
7 6 (13.64%) Agile Software Development
7 6 (13.64%) Scrum
7 6 (13.64%) TDD
8 5 (11.36%) ETL
9 4 (9.09%) Benchmarking
9 4 (9.09%) OO
9 4 (9.09%) System Testing
9 4 (9.09%) Validation
Programming Languages
1 44 (100.00%) SQL
2 36 (81.82%) T-SQL
3 12 (27.27%) Java
4 8 (18.18%) C#
5 4 (9.09%) Shell Script
6 3 (6.82%) Python
6 3 (6.82%) Ruby
6 3 (6.82%) VB.NET
7 1 (2.27%) Data Mining Extensions (DMX)
7 1 (2.27%) PowerShell
7 1 (2.27%) R
7 1 (2.27%) Scala
Qualifications
1 19 (43.18%) Degree
Quality Assurance & Compliance
1 4 (9.09%) QA
System Software
1 4 (9.09%) Apache ZooKeeper
1 4 (9.09%) HDFS
Systems Management
1 7 (15.91%) Microsoft Clustering
Vendors
1 14 (31.82%) Microsoft
2 7 (15.91%) VMware
3 4 (9.09%) Red Hat
4 2 (4.55%) Cognos
4 2 (4.55%) IBM
5 1 (2.27%) Baan
5 1 (2.27%) Oracle
5 1 (2.27%) SAP
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 2 days ago