$3$:$21$

$5G+$

SQL DBA

$q,$

Test Que

Done

Screening Test$/$Interview Questions for SQL Database Administrator $($Remote$)$ Position

Instructions: Please precede all your answers with the question you are answering. Use acronyms only after you've explained them.

Use correct spelling and grammar.

Be sure to write your name and the interviewer's name.

Candidate's Name:

Interviewer's Name: David Mills

Are you currently employed?

How do you ensure to maintain the security of an SQL server database?

What are the different types of Upgrades that can be performed in SQL Server?

What action plan should be followed if an SQL server isn't responding?

Due to some maintenance being done, the SQL Server on a failover cluster needs to be brought down. How do you bring the SQL Server down?

Do you work better alone or as part of a team?

What are the different types of database compression introduced in SQL Server $2008?$

Describe a time when you had a conflict at work.

What do you feel is important to make sure work gets done efficiently?

Could you walk me through your portfolio? What are you most proud of$,$ and why?

Tell me about yourself and your last$/$current job$/$class$.$

What are your strengths and weaknesses?

What is the difference between dropping a database and taking a database offline?

How much will you request per hour if you are hired?

DUTIES:

Manage SQL Server databases

Configure and maintain database servers and processes

Monitor the system's health and performance

Ensure high levels of performance, availability, sustainability and security

Analyze, solve, and correct issues in real time

Provide suggestions for solutions

Refine and automate regular processes, track issues, and document changes

Assist developers with query tuning and schema refinement

Provide support for critical production systems

Perform scheduled maintenance and support release deployment activities after hours

Can you handle all of these duties effectively?