Analysis of Geographic distribution for operating systems and databases

I have long noticed that some kinds of software, some operating systems and some databases are more popular in certain regions than in others. I have wondered if this was the truth or just my opinion. I tried, without much success, to find some statistics on these regional differences. There is a web site that I like from TIOBE Software which scans the Internet to see what programming languages people are currently talking about. TIOBE illustrates the buzz with a monthly scan created with the Google search engine. I looked for something similar that would show the geographic distribution of software and databases. Not much success in my searching, so I gave it a limited try on my own. My favourite web site for software jobs searching -- at least for American jobs -- is DICE.com. Originally it was strictly for software contract positions. Now it includes a lot of more permanent jobs. It still has a preponderance of serious real jobs. Some other software job web sites include a lot of part-time jobs and low-paid stay-at-home employment. In my search today I looked at some languages and computer systems that I use myself. These include some of my personal skills sets. This gave me some hints as to where I should concentrate on for my software skill upgrades and sales promotion efforts. I concentrated on both West Coast states and several large states where I expected to find software contracts. Click Here to see my Results Table[Now deleted]. 

Some Conclusions I was reminded today how good I am at general data analysis. Too bad that I can't get a job doing just that. (Hint. Hint. If anyone is hiring). The key to looking at the data in this table is comparing the percentage that the states are of the entire US population to the percentage of that state's software jobs are to the whole. The population percentages are in the bottom row. The first thing that I noticed is just how few jobs are in the states close to my Vancouver, BC home. For example, while Washington is a major software centre, it has just 2% of the US population. In this one time sample there are less than 2% of the total jobs for some of my best skills such as Delphi, Visual Basic and PL/SQL. So where are the jobs? In Illinois and California the percentage of open jobs is higher than the population percentage in almost every category. This might be because it is harder to get people to move to San Francisco and Chicago for work; or it might simply be because there is more actual work there or it might be because the employers there have greater need for these particular skills. I also see that there is very little demand for some of skills that I know well. It is amazing just how few jobs there are for Delphi programmers. I see a lot of Java and Oracle PL/SQL jobs and I should concentrate my training there. Another surprise was the approximately 3 to 1 ratio of COBOL to RPG jobs. I do like doing AS/400 (iSeries) RPG but there are darn few jobs out there. It would be nice to create a system to automatically update a database like this and put it on the web each month. It could be more general and have more states. (Let me know if there is any demand for this). 

  The Canadian Picture I did a similar analysis for BC, Alberta and Ontario using data from the Canadian site Workopolis.com. The conclusions are similar when looking at the number of RPG vs Delphi vs Java positions. (I had better brush up on my COBOL and Java knowledge). It was a bit of a surprise just how many software jobs there are in Ontario. For example there were 32 'SQL Server' jobs in BC, 56 in Alberta (which has a smaller population) and 247 positions in Ontario which has less than 3 times the population of BC. Today's analysis brings more strong incentive to hit the road if I don't find a good job soon. There is so much more demand in Alberta and Ontario.

Software Language Code Convergence

It is interesting how software programming languages are converging in so many ways. To be more exact, the underlying structure and functionality might be wildly different but the front end appearance of the language code all seems to converge. 

 In the old days of computer languages there were vast differences between the grid placement of RPG, the free form nature of BASIC and the wordiness of COBOL. One could tell them apart in an instance. Now all the languages strive to be free-form and object-oriented. They all pile on as many built-in functions and abilities as possible. 

 Once one language designer decides on a need for a CASE statement they all need one. Once one language uses a // for line comments then all the others have to do the same thing. I have been recently learning and working with JavaScript and Java. I have been told for years that they were quite different concepts and Wikipedia says that they have quite different syntax. But gee, they both do a lot of {block} operations and both try to be as succinct at possible. 

 I was wondering why all these languages are based on English. I know that French tends to be wordy and other some human languages have much more complicated verge structure; but I do wonder why one never sees a computer language based on something like POUR .. SUIVANT ... FINI instead of IF .. THEN ... END. 

 Surely there must be some computer languages based on non English verbs and nouns? This is awfully ethnocentric don't you think? Or am I being simply human species-centric instead of being a truly digital thinker?

Data is what I do

I am a software contractor. I am currently working on a 6-month contract scheduled to end in January 2007. I have Oracle SQL, IBM RPG, Delphi Oracle and other skills.

My Software Summary

Oracle PL/SQL programming -- at least years experience plus Oracle education

Have completed 3 Oracle Education SQL and PL/SQL courses with programming exams

Have programmed procedures, functions and triggers

Other SQL experience includes IBM's DB2/400, Microsoft SQL Server and Access SQL

Experienced with Toad for Oracle development tools

Borland Delphi versions 1, 2, 3, 5, 6, 7 and 2006 -- 10+ years experience.

Expertise using QuickReports, ReportBuilder, Rave, InfoPower and FirstChoice components

Have developed front end applications for several Oracle SQL and SQL Server projects

An 18 month contract involved production control software for truck / auto assembly

My 2003 year-end job involved Delphi / SQL Server development and extensive travel

2005 contract was with console batch applications in a mixed environment

Currently learning and working with Borland Developer Suite 2006

Internet programming and development -- 10 years experience

HTML, Active Server Pages (ASP), VB.Net, VBScript, JavaScript, Macromedia

Designed, developed and maintain several web sites that rate high in Google searches

Microsoft SQL Server:

2003 to 2005 SQL programming and database design -- 1 year experience

IBM iSeries / System i / AS/400 mid-range computers: RPG, COBOL, SQL, DDS, Embedded Queries, DB2 and CL programming -- 3 years experience

Up to date RPG and CL skills. Worked on current V5R3 version in mid-2006.

Maintained IBM System/36: RPG II programs -- 1 year experience

Borland Paradox for Windows versions 4, 5 and 7 -- 2+ years experience

Year 2000 (Y2K) Conversion Analysis and programming -- 3 years experience

C Programming: VMS C, Pro C and Borland C Builder -- 1 year experience

dBase versions: II, III, III+, IV and dBXL -- 3 years experience

PICK Basic, Revelation and Advanced Revelation -- 2 years experience

Microsoft Office Applications and Tools

Have worked with several versions in last 10 years. Did a lot of VBA and Access development. Skilled with macros, scripts and batch programming. Have done Excel automation using OLE and Activex.