DBA Core Area.

Daily maintenance,

Back up and restore

Maintenance plan,

Disaster recovery.

Automating back up jobs 

TSQL statements 

Traits of an Excellent DBA

Consistence practices and figure out the problem, find a solution and create an awareness that it won’t happen again.

  

For practice download

SQl server Evaluation edition ; Free

SQL server Development edition ; $45.00 

Learn the core DBA stuffs such as:

Setting a database recovery model

Take back ups, full, differential, transaction log and tail log back up

Restore Database such as full restore and point in time restore

Setting up SQL agent jobs like

Automating the back up

Checking for corruption

Index/ update statistics maintenance

Create a test environment to practice them.

Self trained and tested, (have someone to quiz you on each area)

Invest time in practicing core DBA skills, when u don’t have the work experience.

Search for job @ Career.stackoverflow.com

SQlpass.org

SQl Saturday.com

Brent ozar