I?m trying to find info on average or ?acceptable? staff levels to run a data warehouse and end services. We are taking on a lot of new business and I?m having a battle with management on what I need. I?ve included a current profile below. Any info would be greatly appreciated.
My Section of 28 staff includes BA?s, testers, DBA?s, techo?s for M/f cobol/JCL/prism, SQL, smartclient, web, c#, MS Reporting Services and other sundry.
We source data from around 12 m/f and SQL applications as well as a few external sources. The application development division numbers around 300, expected to grow to 450 over the next 6-12 months. Some stats follow;
3-4 million transactions per day
2 Terabytes, soon to start growing around 1tb a month
Several thousand users Australia-wide
Full near real time replication
Daily, weekly and monthly destructive updating
2nd level support
Software License management (SAS, Brio/Hyperion, Cognos/SuperStar)
Architecture/Infrastructure management
Ad-hoc data services
Report development and maintenance (currently 200 external and 400 internal report/cubes).
5 web and .net/smartclient external-facing applications (built and maintained in-house)
Internal poller/scheduler and Portal (built and maintained in-house)