The first table below looks at the demand for OLTP skills in IT jobs advertised for the Scotland region. Included is a guide to the average salaries offered in IT jobs that have cited OLTP over the 3 months to 17 May 2013 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category for the Scotland region.

Location
3 months to
17 May 2013
Same period 2012 Same period 2011
Online Transaction Processing (OLTP)
Rank 146 152 155
Rank change year-on-year
+6 +3
Permanent jobs citing OLTP 11 2 1
As % of all permanent IT jobs located in Scotland 0.351% 0.058% 0.029%
As % of the Database & Business Intelligence category 1.079% 0.228% 0.098%
Number of salaries quoted 5 0 0
Average salary £65,000 - -
UK excluding London average salary £44,000 £38,875 £42,500
% change year-on-year
+13.18% -8.52%
All Database & Business Intelligence
Scotland
Permanent IT job ads with a match in the
Database & Business Intelligence category
1019 877 1021
As % of all permanent IT jobs located in Scotland 32.56% 25.50% 29.70%
Number of salaries quoted 613 672 757
Average salary £40,000 £35,000 £38,500
Average salary % change year-on-year
+14.28% -9.09%
90% offered a salary of more than £28,000 £27,500 £30,000
10% offered a salary of more than £57,500 £55,000 £50,000
UK excluding London average salary £38,500 £37,500 £37,500
% change year-on-year
+2.66% -
OLTP
UK

OLTP
Jobs Demand Trend

This chart provides a 3-month moving total of permanent IT jobs citing OLTP across the Scotland region as a proportion of the total demand within the Database & Business Intelligence category.

Scotland OLTP Jobs Demand Trend

OLTP
Salary Trend

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

Scotland OLTP Salary Trend

OLTP
Salary Histogram

This chart provides a salary histogram for IT jobs citing OLTP across the Scotland region over the 3 months to 17 May 2013.

Scotland OLTP Salary Histogram

OLTP
Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLTP within the Scotland region over the 3 months to 17 May 2013. 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 each for more statistics)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
West Lothian - 5 - -
Glasgow - 2 £50,000 -
Stirling - 2 £100,000 -
Edinburgh +1 1 £65,000 -
OLTP
UK

OLTP
Top 30 Related IT Skills

For the 6 months to 17 May 2013, IT jobs across the Scotland region citing OLTP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP.

1 11 (100.00%) Oracle
2 9 (81.82%) Data Management
3 8 (72.73%) SQL
4 7 (63.64%) Degree
5 6 (54.55%) Oracle RAC
5 6 (54.55%) Oracle 11g
5 6 (54.55%) PL/SQL
5 6 (54.55%) UNIX
5 6 (54.55%) RDBMS
5 6 (54.55%) Oracle 10g
6 5 (45.45%) Oracle 9i
6 5 (45.45%) Data Warehouse
6 5 (45.45%) Shell Script
6 5 (45.45%) Sun
6 5 (45.45%) Volume Testing
6 5 (45.45%) Project Planning
6 5 (45.45%) Performance Management
6 5 (45.45%) Root Cause Analysis
7 4 (36.36%) Finance
8 3 (27.27%) Data Modelling
8 3 (27.27%) ETL
8 3 (27.27%) Business Intelligence
8 3 (27.27%) Java
8 3 (27.27%) Master Data Management
9 2 (18.18%) Hedge funds
9 2 (18.18%) Data Visualisation
9 2 (18.18%) Data Quality
9 2 (18.18%) Data Migration
9 2 (18.18%) Data Architecture
9 2 (18.18%) Visualisation

OLTP
Top Related IT Skills by Category

For the 6 months to 17 May 2013, IT jobs across the Scotland region citing OLTP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLTP. Up to 20 skills are shown per category.

Application Development
1 2 (18.18%) XML
1 2 (18.18%) Middleware
Application Platforms
1 1 (9.091%) Oracle Coherence
Database & Business Intelligence
1 6 (54.55%) RDBMS
1 6 (54.55%) Oracle 10g
1 6 (54.55%) Oracle 11g
2 5 (45.45%) Oracle 9i
2 5 (45.45%) Data Warehouse
Development Applications
1 2 (18.18%) JDeveloper
General
1 4 (36.36%) Finance
Job Titles
1 5 (45.45%) DBA
1 5 (45.45%) Oracle DBA
2 2 (18.18%) Oracle Developer
2 2 (18.18%) Head of Architecture
2 2 (18.18%) Oracle SOA Developer
2 2 (18.18%) SOA Developer
2 2 (18.18%) Java Developer
2 2 (18.18%) Developer
3 1 (9.091%) Data Architect
3 1 (9.091%) Designer
3 1 (9.091%) Architect
Miscellaneous
1 2 (18.18%) Visualisation
1 2 (18.18%) Hedge funds
2 1 (9.091%) Clustering
Operating Systems
1 6 (54.55%) UNIX
2 1 (9.091%) Solaris
2 1 (9.091%) Red Hat Enterprise Linux
Processes & Methodologies
1 9 (81.82%) Data Management
2 5 (45.45%) Performance Management
2 5 (45.45%) Project Planning
2 5 (45.45%) Volume Testing
2 5 (45.45%) Root Cause Analysis
3 3 (27.27%) Data Modelling
3 3 (27.27%) ETL
3 3 (27.27%) Business Intelligence
3 3 (27.27%) Master Data Management
4 2 (18.18%) SOA
4 2 (18.18%) BPEL
4 2 (18.18%) Information Management
4 2 (18.18%) Migration
4 2 (18.18%) Investment Management
4 2 (18.18%) Data Migration
4 2 (18.18%) Data Architecture
4 2 (18.18%) Data Visualisation
5 1 (9.091%) Analytics
5 1 (9.091%) Agile Software Development
5 1 (9.091%) Configuration Management
Programming Languages
1 8 (72.73%) SQL
2 6 (54.55%) PL/SQL
3 5 (45.45%) Shell Script
4 3 (27.27%) Java
5 1 (9.091%) Perl
5 1 (9.091%) Korn
Qualifications
1 7 (63.64%) Degree
Quality Assurance & Compliance
1 2 (18.18%) Data Quality
System Software
1 6 (54.55%) Oracle RAC
2 1 (9.091%) Oracle RMAN
Systems Management
1 1 (9.091%) Data Guard
Vendors
1 11 (100.00%) Oracle
2 5 (45.45%) Sun
3 1 (9.091%) Veritas