as the title says, I'm interviewing for a job as a SQL Server DBA next week and I'm looking for some tips on what to expect and how to best prepare.
I've worked with MS SQL Server and MS Access (unfortunately it's primarily the latter) for the past 16 years, building BI solutions, but I've mostly been working alone (only IT "specialist" in a Finance dept.) so I've had no team to work with and spar with.
I'm competent writing SQL statements and I'm comfortable with Indexing, PK/FK etc., but I've little experience with SSMS, backup & restore etc. Basically most of my knowledge comes from MS Access.
The requirements for the role is as below:
SQL Server 2005-2012
Create, Review & Tune T-SQL
Database Administration, Optimization, Design, Installation & Maintenance
Management & Maintain Security, Access, Back-ups & Recovery
Performance Monitoring & Reporting
Detailed knowledge of SQL Server 2005-2012
Expert in Transact-SQL