Database developers
-
Do you have database developers at your shop?
If yes:
Are they also the DBA's?
What ratio are your database developers to your front end developers?
If no:
Who does the database code, the front end developers?
What kind of training do they have?
And to wrap it up:
Do you think database development is an actual position unto itself, or just a subset of DBA responsibilities?
In your experience, have you seen too few (or too many) database developers?
Just kind of an informal survey of sorts, interested in learning how some of the other shops operate.
Thanks!
-
In my not so humble opinion good data structure design is every bit as important as good UI design. I've been in this game for over 30 years. For me, I do all three: Front end work, database design, database (server) administration.
Some of my customers are Oracle shops. One such has a person who approves all database structures. This person makes sure that best database design practices are followed. They are in a touchy industry and the compliance requirements are exhaustive.
I've worked in places where the customers had no tech staff at all. They relied on us for all standards issues.
Good database design helps the software work better. Bad design causes you to have to join four tables just to produce a daily warehouse stock on hand report.
The best mix for any particular organization has to be based on many factors. Each shop should have at least one DBA. That person might do other things as well but there needs to be at least one just to do sanity checks.
We had one developer that hated NULL's as bad as I do. He stored all of his dates in varchar fields defaulted to blank. It also avoided having those "messy time values" in there. Doing proper reports was a nightmare.
ATBCharles Kincaid
-
In our shop, we work as DBAs, database developers and applications developers. There are two of us who perform this job.Our IT department is pretty small (about 12 people, mostly Help Desk personnel). Thanks.
Chris
Well, that was the case. When I got here, there were 2 of us. The guy that was here before me left. I worked alone for a bit. Then we hired someone else. He stayed for a year or so and then left. Again, I'm now the sole DBA, database developer and application developer, with there being no plans to hire an additional person - the role is now pretty much a 1-person role.
-
In our shop we are two DBA's who are responsible for almost everything that is related to SQL somewhat. Administration, optimising, T-SQL coding and helping developer to code SQL etc. If your workload is not too much you can handle all.
I think there must be some SQL developer between DB and the application code. Because sometimes application coders really forget that they have to think in SQL logic! These sql-developers (at least one depending on your procedure usage) should be focused on table design and procedure coding.
By the way, if you are an admin DBA I strongly recommend not to have ANY mission critical tasks (like coding for a project that is close to end-date) other than DBAing as you have enough strees to stand
Cheers
-
Here our development team consists of 3 with varying experience.
I personally tend to work with the full product range including database design, business analysis and the majority of the front-end, business and data access code - aswell as dba on internal systems and live client sites.
We have 1 developer who knows v.little SQL/RDBMS but sufficient enough at front-end/business logic programming.
We have 1 other "coder" who knows v.little about anything GUI and has learnt enough about T-SQL to be able to get by when I'm not here - although good at documentation.
No real structure to the development team with no management as such (only top level MD) so I tend to spend a lot of time managing the team and helping out where they require it.
Above this we have 2 system testers with a test manager and a dozen or so customer support staff (telephone support)
Ian Ashworth
Applications Developer
Mirage Software
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply