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 *