I was in the same boat as you, short term consulting jobs, generally in a Data Analyst position. My primary database skill set is Microsoft in SQL Server and Access however my last position was in an Oracle environment and with the analyst position, as long as you have a good grounding in SQL, it really doesn't matter since the data is usually extracted then analyzed in an external program. What I have done is focus on knowing the differences between the two systems especially with basic functions that I use a lot.
I've also done some reading and experimenting with Business Intelligence and especially the Star Schema of BI database design since I was working with an Enterprise Data Warehouse that was done using the the Star Schema.
I am fortunate to have obtained a position where I have been for the last two months and it is SQL Server based. It is a manufacturing company that creates automated conveyor / picking / and palletizing solutions which use robots as part of the system. My job is to work with the data from potential clients, ETL it to SQL Server for use in the proprietary software we use to create the pallets. I then analyze the data and provide my analysis to the engineers who build a proposed system in Autocad based on the data I give them. Our proprietary software is programmed in .NET. While not a primary programmer, I do use .NET to create / modify reports and also go in and modify the config files to connect to the data with which I am working.
The company encourages cross training and I have been making friends with the guys who program the robots to work with the in-house. I plan to find out what additional training I need to do what they do.
Discussion on:
Message 3 of 7

































