Jeff Moden - Tuesday, September 5, 2017 3:10 PM

Avi1 - Tuesday, September 5, 2017 2:11 PM

In small organization of course one resource may have to do all the tasks related to SQL. But in my experience I have seen mostly expectation is installing SQL Server, managing server performance including disk space utilization, managing backups, controlling access and user’s rights/roles, managing replication and always-on / multiple fail over clusters and performance tuning/indexes, sql jobs, alerts, database mail, releasing db scripts. Even most of the time DBAs have assumed that these are the roles they have to perform. All development is for SQL developer or ETL developers. But I believe a DBA should have a good hands-on SQL development experience as well, this helps tuning and review for better practices

Heh... on that note, I'll tell you that I stopped counting the number of supposedly senior DBAs with supposedly 10 years or more experience (many also claiming code performance tuning) at 20 out of 22 that didn't know how to get the current date and time using T-SQL.  It's really amazing that anyone would claim to be a DBA and not know how to do that.  I originally started asking the question as a non-threating, easy to answer, ice-breaker of a question to demonstrate that I don't ask trick or esoteric questions during a person's interview.  It turned out to be a litmus strip test as for how the rest of the interview was going to go... mostly pitiful.