What does a DBA do really?

Good to have when the boss asks 🙂


  • Installations (Configuration/Disk/File placements/Maxdop/Memory/Collation/Version/Pachlevel/Cost threshold….)


  • Upgrades (See above…)


  • Configurations (Database options and instance configuration…….)


  • Sizing (SAN/Network/Memory/CPU/Have to be a hardware wiz too)


  • Performance tuning (Indexes/IO/CPU/Wait stats/SQL Plans/TSQL/EF/Plan cache/Buffer cache/…)


  • Backup (Time taken/IO Performance/Network Performance/Impact on Prod/Secondary backups/Configuration/Test/Disk/Networker/Scripts/Alarms/)


  • Restore (See backups, plus testing/Solve replication marker in log/logins/users/security/permissions/snapshots/Native/striped/Networker……)


  • Consistency (DBCC CheckDB/How to solve inconsistent database, a DBA’s biggest fear)


  • Clients (Advice/Run scripts/Configure instance-clients/Solve problems/Explain-Design-Architect solutions….answer all and any questions…)


  • Knowledge of (SAN/Disk/Network/CPU/Memory/Clients/Protocols/Problem solving/….)


  • Design databases (tables/hardware/firewall/indexes/triggers/views/stored procedures/functions/roles/……)


  • Security procedures and settings (Snapshot/sysadmin/dbo/read/write/….)


  • HA/DR solutions and how they work and their differences, see list below


  • AlwaysOn (2 or multiple nodes/differences Standard-Enterprise/Secondary reads/Secondary backups/Failover/Disaster recovery/Problem solving/

Readonly routing/Not synchronizing/Copy-only…….)


  • Replication (Merge/Transactional/Snapshot/When to use which and how to configure/Implications of moving a replicated database/Monitoring/Detecting problems)


  • Mirroring (Configure/Setup/Failover/Automated Failover Multiple DB’s/Monitor….)


  • Log shipping (Configuration/When to use/Fix issues….)


  • Stored Procedures(Coding/Speed up/Query Plans/”Parameter sniffing”/…)


  • Functions (When and when not to use/Performance/Coding/Fix/)


  • Sessions (Blocking processes/Deadlocks/How to solve them/How to monitor for them…)


  • Performance monitor (Perfmon/Spotlight/SQL Monitor/Scripts)


  • Compat mode (How it works/why/optimizer/TSQL compat)


  • Recovery mode (Full/bulk load/Simple and their respective implications)


  • Collations(tempdb/instance/how to fix (collate…) )


  • Tempdb (Number of files/trace flags/file placements/latch contention/full disk/…..)


  • Transactions (Explain to developers/track down long running/Fix long running)


  • TSQL (Understand developers code/Fix developers code/Make everything faster/…)


  • Isolations levels (read committed/read uncommitted/repeatable read/snapshot/serializable/…)


  • Differences between Standard and Enterprise edition (2005/2008/2008R2/2012/2014/2016/E.g. Rebuild clustered index online on a standard edition…)


  • Capacity planning (CPU/Disk/Network/Memory/PLE/Buffer cache/CLR/….)


  • Maintenance jobs (Backup/index update stats/index rebuild/index reorg/checkdb…..)

Leave a Reply

Your email address will not be published. Required fields are marked *