City of London Transact-SQL Contracts

This section looks at the demand for Transact-SQL (T-SQL) skills within the City of London region with a comparison to our Programming Languages category. Included is a guide to the contractor rates offered in IT jobs that have cited Transact-SQL over the 3 months to 25 July 2008 with a comparison to the same period last year.

Transact-SQL (T-SQL)
Location Banbury Barnet Basingstoke Bath Bedfordshire Belfast Berkshire Birmingham Bishop's Stortford Blackpool Bradford Brighton Bristol Buckinghamshire Cambridge Cambridgeshire Canary Wharf Cardiff Channel Islands Chatham Chelmsford Cheltenham Chertsey Cheshire Chester City of London County Antrim Crawley Croydon Derby Derbyshire Docklands, London Dorking Dorset Durham East Anglia East Midlands East of England East Sussex Edinburgh England Essex Farnham Glamorgan Glasgow Gloucester Gloucestershire Guildford Halifax Hampshire Hemel Hempstead Herefordshire Hertfordshire Kent Lancashire Leeds Leicestershire Liverpool Livingston London Manchester Marlow Merseyside Middlesex Midlands Milton Keynes Newcastle Newcastle Upon Tyne Newport Norfolk North East North West North Yorkshire Northamptonshire Northern Ireland Norwich Nottingham Nottinghamshire Oxford Oxfordshire Peterborough Portsmouth Reading Redhill Scotland Sheffield Sidcup Slough Somerset South Coast South East South Wales South West South Yorkshire Southampton Staffordshire Staines Stoke-on-Trent Surrey Swindon Thames Valley Tonbridge Tyne and Wear UK Uxbridge Wales Ware Warrington Warwickshire Watford West Lothian West Midlands West Sussex West Yorkshire Wiltshire Woking Worcester Worcestershire York Yorkshire	3 months to 25 Jul 2008	Same period last year
Rank	97	101
Rank change on same period last year	+4
Matching contract IT job ads	135	100
As % of all UK contract IT job ads sampled	0.180 %	0.101 %
As % of the category below	3.801 %	3.038 %
Daily rates quoted	89	51
Average minimum daily rate	£398	£415
Average daily rate	£432	£449
% change on same period last year	-3.77 %
Average maximum daily rate	£466	£483
UK excluding London average daily rate	£309	£322
% change on same period last year	-3.95 %
Hourly rates quoted	10	5
Average minimum hourly rate	£26.60	£15.00
Average hourly rate	£28.90	£16.30
% change on same period last year	+77.30 %
Average maximum hourly rate	£31.20	£17.60
UK excluding London average hourly rate	£35.88	£34.64
% change on same period last year	+3.57 %
Programming Languages City of London
Matching contract IT job ads	3552	3292
As % of all UK contract IT job ads sampled	4.735 %	3.331 %
Daily rates quoted	2058	1558
Average minimum daily rate	£424	£472
Average daily rate	£464	£507
% change on same period last year	-8.51 %
Average maximum daily rate	£505	£543
UK excluding London average daily rate	£332	£334
% change on same period last year	-0.41 %
Hourly rates quoted	82	47
Average minimum hourly rate	£29.44	£25.73
Average hourly rate	£31.53	£27.82
% change on same period last year	+13.34 %
Average maximum hourly rate	£33.63	£29.91
UK excluding London average hourly rate	£33.38	£33.07
% change on same period last year	+0.95 %
Transact-SQL London

We calculate average IT contractor rates directly from the figures quoted and do not attempt to derive hourly rates from daily rates or vice versa.

Transact-SQL
Demand Trend

The chart provides a 3-month moving total beginning in 2004 of IT contractor jobs citing Transact-SQL across the City of London region as a proportion of the total demand within the Programming Languages category.

Transact-SQL
Daily Rate Trend

The chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing Transact-SQL across the City of London region.

Transact-SQL
Daily Rate Histogram

The chart provides a histogram of daily rates quoted in contract IT jobs citing Transact-SQL across the City of London region over the 3 months to 25 July 2008.

Transact-SQL
Hourly Rate Trend

The chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing Transact-SQL across the City of London region.

Transact-SQL
Hourly Rate Histogram

The chart provides a histogram of hourly rates quoted in contract IT jobs citing Transact-SQL across the City of London region over the 3 months to 25 July 2008.

Transact-SQL
Top 30 Related IT Skills

For the 6 months to 25 July 2008, IT contractor jobs across the City of London region citing Transact-SQL 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 contract IT job ads sampled that cited Transact-SQL.

1 288 (98.63 %) SQL 2 167 (57.19 %) SQL Server 3 110 (37.67 %) Banking 4 107 (36.64 %) Sybase 5 91 (31.16 %) .NET 6 87 (29.79 %) C# 6 87 (29.79 %) SQL Server 2005 7 85 (29.11 %) UNIX 8 84 (28.77 %) Investment Banking 9 78 (26.71 %) Finance 10 65 (22.26 %) SQL Server 2000 11 58 (19.86 %) ASP.NET 12 51 (17.47 %) Java 13 48 (16.44 %) XML 14 41 (14.04 %) Oracle

15 39 (13.36 %) Perl 16 38 (13.01 %) JavaScript 16 38 (13.01 %) Shell Script 17 33 (11.30 %) HTML 18 32 (10.96 %) CSS 18 32 (10.96 %) SQL Server Integration Services 19 31 (10.62 %) Windows 19 31 (10.62 %) Datawarehouse 20 29 (9.932 %) VB.NET 21 25 (8.562 %) ASP 22 24 (8.219 %) DTS 23 23 (7.877 %) User Acceptance Testing 24 22 (7.534 %) SQL Server Analysis Services 24 22 (7.534 %) Migration 25 21 (7.192 %) Front Office

Transact-SQL
Top Related IT Skills by Category

For the 6 months to 25 July 2008, IT contractor jobs across the City of London region citing Transact-SQL also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Transact-SQL. Up to 20 skills are shown per category.

Application Development 1 91 (31.16 %) .NET 2 58 (19.86 %) ASP.NET 3 48 (16.44 %) XML 4 33 (11.30 %) HTML 5 32 (10.96 %) CSS 6 25 (8.562 %) ASP 7 13 (4.452 %) AJAX 8 12 (4.110 %) Struts 8 12 (4.110 %) WebServices 9 11 (3.767 %) JDBC 9 11 (3.767 %) J2EE 10 9 (3.082 %) ASP.NET 2.0 11 8 (2.740 %) J2SE 12 7 (2.397 %) XML Schema 13 5 (1.712 %) XSLT 13 5 (1.712 %) BAPI 13 5 (1.712 %) ADO.NET 13 5 (1.712 %) COM+ 13 5 (1.712 %) .NET Framework 13 5 (1.712 %) MDX	Application Platforms 1 10 (3.425 %) SharePoint 2 6 (2.055 %) Tomcat 2 6 (2.055 %) ColdFusion 2 6 (2.055 %) LiveLink 3 4 (1.370 %) BizTalk Server 3 4 (1.370 %) IIS 4 3 (1.027 %) Documentum 4 3 (1.027 %) CMS 5 2 (0.685 %) SharePoint Server 2007 6 1 (0.342 %) Flash Media Server 6 1 (0.342 %) Exchange Server 2000 6 1 (0.342 %) SharePoint Portal Server 6 1 (0.342 %) SmartSockets 6 1 (0.342 %) MQSeries 6 1 (0.342 %) MS Exchange
Applications 1 14 (4.795 %) MS Excel 2 9 (3.082 %) MS Office 3 4 (1.370 %) MS Project 4 2 (0.685 %) InfoPath 5 1 (0.342 %) Spreadsheet	Business Applications 1 5 (1.712 %) SAP R/3 2 1 (0.342 %) Summit 2 1 (0.342 %) Cerner Millennium 2 1 (0.342 %) Murex MxG2000 2 1 (0.342 %) BusinessWorks
Communications & Networking 1 11 (3.767 %) Internet 2 8 (2.740 %) Intranet 3 2 (0.685 %) Broadband 3 2 (0.685 %) TCP/IP 3 2 (0.685 %) DNS 4 1 (0.342 %) ATM 4 1 (0.342 %) X.500	Database & Business Intelligence 1 167 (57.19 %) SQL Server 2 87 (29.79 %) SQL Server 2005 3 65 (22.26 %) SQL Server 2000 4 32 (10.96 %) SQL Server Integration Services 5 31 (10.62 %) Datawarehouse 6 24 (8.219 %) DTS 7 22 (7.534 %) SQL Server Analysis Services 8 18 (6.164 %) SQL Server Reporting Services 9 17 (5.822 %) ETL 10 15 (5.137 %) Microsoft Analysis Services 11 13 (4.452 %) OLAP 12 11 (3.767 %) Oracle 10g 13 9 (3.082 %) SQL Server 7 14 8 (2.740 %) Crystal Reports 14 8 (2.740 %) Oracle Discoverer 14 8 (2.740 %) Sybase ASE 15 6 (2.055 %) Oracle OWB 15 6 (2.055 %) BusinessObjects 16 5 (1.712 %) RDBMS 16 5 (1.712 %) EDRMS
Development Applications 1 7 (2.397 %) Visual Studio 1 7 (2.397 %) PowerBuilder 2 6 (2.055 %) Subversion 3 5 (1.712 %) Ant 4 4 (1.370 %) VSS/SourceSafe 4 4 (1.370 %) Eclipse 5 3 (1.027 %) Flash 5 3 (1.027 %) JUnit 5 3 (1.027 %) ProC 6 2 (0.685 %) NUnit 6 2 (0.685 %) ClearCase 6 2 (0.685 %) IntelliJ 7 1 (0.342 %) Oracle Forms 7 1 (0.342 %) CruiseControl 7 1 (0.342 %) LSMW 7 1 (0.342 %) JProbe 7 1 (0.342 %) Optimizeit 7 1 (0.342 %) Log4Net	General 1 110 (37.67 %) Banking 2 84 (28.77 %) Investment Banking 3 78 (26.71 %) Finance 4 21 (7.192 %) Front Office 5 19 (6.507 %) Insurance 6 8 (2.740 %) Back Office 7 7 (2.397 %) Construction 8 5 (1.712 %) Financial Institution 8 5 (1.712 %) Health 8 5 (1.712 %) Legal 8 5 (1.712 %) General Ledger 9 4 (1.370 %) Marketing 9 4 (1.370 %) Government 10 3 (1.027 %) Retail 11 2 (0.685 %) Law 11 2 (0.685 %) Education 11 2 (0.685 %) Telecoms 11 2 (0.685 %) Corporate Banking 12 1 (0.342 %) Online Banking 12 1 (0.342 %) Auditing
Job Titles 1 181 (61.99 %) Developer 2 53 (18.15 %) Analyst 3 52 (17.81 %) SQL Developer 4 46 (15.75 %) DBA 4 46 (15.75 %) .NET Developer 5 37 (12.67 %) C# Developer 6 28 (9.589 %) Sybase Developer 7 25 (8.562 %) SQL DBA 7 25 (8.562 %) Support Analyst 8 21 (7.192 %) SQL Server DBA 8 21 (7.192 %) SQL Server Developer 9 20 (6.849 %) Java Developer 10 18 (6.164 %) Web Developer 11 16 (5.479 %) ASP.NET Developer 12 15 (5.137 %) Sybase DBA 13 14 (4.795 %) Senior Analyst 14 12 (4.110 %) .NET Web Developer 14 12 (4.110 %) C#/ASP.NET Developer 15 10 (3.425 %) Perl Developer 15 10 (3.425 %) Analyst Developer	Miscellaneous 1 15 (5.137 %) Credit Risk 2 11 (3.767 %) Market Risk 2 11 (3.767 %) Fixed Income 3 9 (3.082 %) Foreign Exchange (FX) 3 9 (3.082 %) Derivative 4 8 (2.740 %) Replication 4 8 (2.740 %) Computer Science 5 7 (2.397 %) Management Information System 6 5 (1.712 %) Credit Derivative 7 4 (1.370 %) Equities 7 4 (1.370 %) Mathematics 7 4 (1.370 %) N-Tier 8 3 (1.027 %) Physics 8 3 (1.027 %) Equity Derivative 9 2 (0.685 %) Grid Computing 9 2 (0.685 %) NHS 9 2 (0.685 %) Data Integration 10 1 (0.342 %) Multithreading 10 1 (0.342 %) Data Conversion 10 1 (0.342 %) AS400
Operating Systems 1 85 (29.11 %) UNIX 2 31 (10.62 %) Windows 3 16 (5.479 %) Linux 4 10 (3.425 %) Solaris 5 7 (2.397 %) Windows 2000 5 7 (2.397 %) Windows NT 6 2 (0.685 %) AIX 7 1 (0.342 %) Windows Server 2003	Processes & Methodologies 1 23 (7.877 %) User Acceptance Testing 2 22 (7.534 %) Migration 3 19 (6.507 %) Data Migration 4 18 (6.164 %) Workflow 5 15 (5.137 %) OO 6 11 (3.767 %) Data Modelling 7 10 (3.425 %) Asset Management 8 8 (2.740 %) UML 8 8 (2.740 %) Scrum 9 7 (2.397 %) BCP 9 7 (2.397 %) Quality Management 9 7 (2.397 %) TDD 10 6 (2.055 %) Electronic Trading 10 6 (2.055 %) Document Management 11 5 (1.712 %) Data Analysis 11 5 (1.712 %) Workflow Management 11 5 (1.712 %) Agile Software Development 11 5 (1.712 %) Business Intelligence 11 5 (1.712 %) Security Cleared 12 4 (1.370 %) Investment Management
Programming Languages 1 288 (98.63 %) SQL 2 87 (29.79 %) C# 3 51 (17.47 %) Java 4 39 (13.36 %) Perl 5 38 (13.01 %) JavaScript 5 38 (13.01 %) Shell Script 6 29 (9.932 %) VB.NET 7 18 (6.164 %) VBScript 8 16 (5.479 %) C++ 8 16 (5.479 %) DHTML 9 15 (5.137 %) VB 10 14 (4.795 %) C 11 13 (4.452 %) PL/SQL 12 9 (3.082 %) VBA 13 6 (2.055 %) ABAP 14 5 (1.712 %) SAPscript 15 4 (1.370 %) VB6 16 3 (1.027 %) Korn 16 3 (1.027 %) JCL 17 2 (0.685 %) AWK	Qualifications 1 14 (4.795 %) Degree 2 2 (0.685 %) Microsoft Certification 3 1 (0.342 %) Oracle Certification 3 1 (0.342 %) MCAD 3 1 (0.342 %) MCSD 3 1 (0.342 %) Postgraduate
Quality Assurance & Compliance 1 2 (0.685 %) QA 2 1 (0.342 %) SLA 2 1 (0.342 %) Sarbanes-Oxley 2 1 (0.342 %) Basel II 2 1 (0.342 %) MiFID	System Software 1 2 (0.685 %) Oracle RMAN 2 1 (0.342 %) MSMQ
Systems Management 1 14 (4.795 %) AutoSys 2 1 (0.342 %) MIIS	Vendors 1 107 (36.64 %) Sybase 2 41 (14.04 %) Oracle 3 16 (5.479 %) Microsoft 4 8 (2.740 %) Murex 5 7 (2.397 %) Informatica 6 6 (2.055 %) Business Objects 6 6 (2.055 %) SAP 6 6 (2.055 %) Hummingbird 7 3 (1.027 %) Open Text 7 3 (1.027 %) Sun 8 2 (0.685 %) Trillium 8 2 (0.685 %) TIBCO 8 2 (0.685 %) Infragistics 8 2 (0.685 %) Bloomberg 9 1 (0.342 %) Primavera 9 1 (0.342 %) ESRI 9 1 (0.342 %) Perforce 9 1 (0.342 %) Teradata 9 1 (0.342 %) Reuters 9 1 (0.342 %) VERITAS