How many kinds of DBA are there, anyway?
Pete, October 04, 2016 - 4:39 am UTC
I like the "database specialist" concept. Where I work, the "production" DBA (me) is responsible for infrastructure design, storage management, backups, security, and general performance tuning. I provide an environment for the application DBA to do their job, which centers more around what happens inside the database - working with objects, stored procedures, ETL operations, etc. I'm more of an administrator, and they are more towards the developer end of the spectrum. It is important to note that to be effective we each need to know something about what the other does. Our experience, our "specialities" should complement each other, which sometimes means that the lines that separate parts of our jobs can get a little blurry. My personal experience has also been that whatever "kind" of DBA I have been, I have often had to be more of an IT Jack-of-all-trades than most of my co-workers. Labels like production DBA or application DBA can be limiting; don't ever get stuck thinking "this is all I can do" just because of some arbitrary job title.
October 04, 2016 - 11:24 am UTC
yup. 100% agree.
You press the wound
A reader, October 04, 2016 - 4:41 am UTC
Super answer Connor.
I was investigation on a Pl job for a performance matter as dba application accessing only development environment. Send a ticket to production Dbas asking refreshing uat environment " plesae make an export of My_schema (6 tables) excluding mail column named T.C ". Given info about server, db, instance ..
Dba answer : " provide command or script ; we do not do sql / plsql. .."
- " but I am not asking you to write sql.. just an export. Get the dump and I ask later for import "
- " sorry we don't act without providing the command export "
Am I a fool or something else wrong ?
I know lot of opinion there but that's exactly the conversation was. Being working for 15 years on oracle never had such response.
All the best
From the WayBack Machine
Duke Ganote, October 04, 2016 - 4:51 pm UTC
One more time...
Duke Ganote, October 04, 2016 - 4:55 pm UTC