• Our organisation traditionally had two SQL elements, one dealt with setting up databases, permissions, managing the introduction of thrid party system databases into our environment, clust performance etc, whilst the other SQL element dealt with managing data extracts (ODS, SSIS, DTS), along with managing the databases for our locally built applications which involved a lot of SP (T-SQL) script writing etc.

    A few years ago they merged both elements into one team. However it has become apparent that the skills are really very different. As a result they are now on the cusp of splitting them both out again into separate teams where the SQL DBA looks after the clusters, backups, permissions, setting up third party databases etc and the SQL Developers handle the SQL script writing, SSIS packages, ODS creation etc.

    There is a lot of confusion about what a SQL DBA should be doing as this is often confused with SQL Developer work which I believe is a different role. This confusion is really happenning at the top level in organisations where team structures and job roles are decided.