• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

What Does a Database Administrator Actually Do?

March 5, 2012 by John Sansom 11 Comments

Most people in your organisation, never mind everyone else, have no real clue as to what it is you do.

It’s not because you don’t actually do anything, at least I hope not, it’s because the domain of responsibility for a DBA is both vast and varied. Ask any two DBAs what it is they do exactly and you can expect to get two broadly different answers.

For those new to the event, #mememonday is the community creation of Thomas LaRock (Blog|Twitter), the driving force of which is to encourage the SQL community to put virtual pen to paper. This months theme “List out all the little things you do as a DBA, since the term DBA means so many different things in each shop.”

In the spirit of adding to the confusion, here are some of the things that I do in my current role as a “DBA”.

  • project management
  • consulting
  • server builds
  • troubleshooting
  • backups
  • restores
  • security
  • compliance
  • change control
  • change management
  • develop a hobby, preferably a full contact sport, to vent
  • server specification and hardware procurement
  • development consulting
  • database design
  • solution design
  • team mentoring
  • customer liaison
  • release package development and deployment
  • capacity planning
  • ignore as many of the competing communication channels as possible
  • wrestle daily with email volume and rules
  • administer all database platforms not just SQL
  • research emerging database technology
  • ensure platform availability
  • continually review existing solutions and processes for improvement
  • devising elaborate methods to synchronise and initialize overly complex replication topologies

The astute reader amongst you will have noticed a degree of sarcasm sprinkled throughout the list. A sense of humour is a valuable character trait for a DBA, a survival skill that can see you through troubled times.

If you really want to learn more about the DBA game and what it takes, head on over to the How To Become A SQL Server DBA area on the blog. There’s a wealth of great content there from both myself and other community sources. As always if you cannot find the answer to your question let me know.

In the spirit of #mememonday I encourage you to put virtual pen to paper and add to the confusion by sharing some of the little things you do as a DBA.

Filed Under: SQL Server Community, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Database Administrator, DBA Responsibilities

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy