Skills SQL Server DBA Database Administration

Used at:...

  Used at: 
  Allen & Overy
  Five Guys
  Bluecrest Capital

Performance tuning

Used at:...

  Used at: 
  Autodata
  Bluecrest Capital
  ING Investment Management

/indexing/statistics

Query hints

SQL Profiler / server-side traces

Query plans / Actual execution plans

SQL 2008 Best Practices Analyzer

Performance Dashboard

Locks, blocking, and deadlocks

Capacity planning

Used at:...

  Used at: 
  Autodata

Capacity planning

SQL Licencing

Security

Used at:...

  Used at: 
  Autodata
  Bluecrest Capital
  ING Investment Management

user accounts

orphaned users

Failed logins

SQL Agent

Used at:...

  Used at: 
  Allen & Overy
  ING Investment Management

SQL Agent

SQL Scheduled jobs

Alerts

Backups and restores

Used at:...

  Used at: 
  Autodata
  Bluecrest Capital

SQL Server database backups, differential, incremental backups, transaction log backups, simple vs full recovery models.

SQL Server database restores

Moving databases by detaching, moving, and reattaching their .mdf and .ldf files.

Data Migration

Source directories for source files

Staging tables

ETL

ELT

Fact, dimension tables

Trigger files

Header rows (in files).

Duplicate rows

File and data concatenation (joining of the content of one file with the next)

SQL Server upgrades

Used at:...

  Used at: 
  Autodata
  ING Investment Management

SQL Server version upgrades & downgrades

SQL Server versions

SQL Server versions:

• 2000
• 2005
• 2008
• 2012
• 2016
• 2017
  

Database mirroring and log shipping

Used at:...

  Used at: 
  Autodata

Database mirroring and log shipping

Transactional Replication

Transactional Replication Log Reader Distribution database Merge replication

Synonyms

Used at:...

  Used at: 
  MUFG Securities
  Autodata

Synonyms

Other

Out of hours support

Logging

Testing

TEMPDB database