Only Data Warehousing jobs?

  • I have several years experience as a dba/developer and I have been looking for a job for 2-3 months. There only seem to be high-level data warehousing jobs available for SQL Server, Oracle, and DB2. Was there some kind of shift I missed while I was busy working and not taking classes?

    I feel like I missed the boat!!! Obviously, Data Warehousing is totally different than normal dba work, data modeling, and app dev for even large-scale complex projects. It's a totally different animal. While I know I have the aptitude, no one seems to want to give me a chance. I've seen a ton of good dba's turned down for jobs recently because they don't have this experience.

  • I've seen a similar trend as well. One thing you can do on your own time is get familiar with Analysis Services and some of the data mining capabilities that are present in SQL 2000. Then you can honestly list it as a skill on your resume. Also, if you think back to your projects you've worked on within the last 2-3 years, I'm sure some were really warehousing efforts, though that term wasn't used at the time.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • I just accepted a database development job that includes working with Data Warehousing and SQL Server Analysis Services. But I took a pay cut to get into it. Also, my business background (I used to be an accountant and I have an accounting degree) helped a lot in getting this job. Soft skills and reasonable salary expectations also helped me in getting a permanent job.

    Diane

  • I'm in the same boat as many of you are. I'm use to working with high volume severs with tons of smaller tables and hundreds of concurrent users, now I find myself working in mostly data wearhouse projects dealing with terabytes of data and only a hand full of users. It takes a little time to switch gears, don't be scared you already have a huge skill set that will apply. Go buy some books on analysis services and OLAP. If you can, setup a development envionrment and work through some of the projects Microsoft has available you will find yourself picking it up in no time.

    Wes

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply