Common questions asked in SQL Server DBA Interview

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Career » Employers and Employees » Common questions asked in SQL Server DBA...

111 posts, Page 12 of 12

«««8 9 10 11 12

Common questions asked in SQL Server DBA Interview

Rate Topic

Display Mode

Topic Options

Author

Message

TheAccidentalDBA

Posted Friday, February 08, 2013 1:40 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 9:07 AM
Points: 2, Visits: 53

I was recently asked to provide questions to be asked for a production DBA. There are no good or bad answers, the person must have encountered most of the scenario’s with understanding on how things work & very quick to react on a highly stressful environment. Below are the questions I provided:Hope it helps

Database Back ups:
** What are the different types of database backups and specify the scenario that you have used in your experience?

High Availability:
** What are the high availability methods ?.Specify your experience and set up required for SQL Server in a clustered environment

DR :
** Specify your DR strategy experience and details for SQL server.
** Specify the steps to take when a database is corrupted (or) server is down (or) harddrive is corrupted.

Performance Tuning :
** All of a sudden a query is running slowly and there are no changes made to application/network or server environment. Based on your experience, specify the steps to debug the issue.

Maintenance Plan:
** Specify based on your experience what maintenance plans are required for a typical database.

Replication:
** Specify your experience in Transaction replication?. Provide details on issues encountered and how to resolve it.

Data Dump:
** How do you migrate data from Prod to QA to Dev environment?

Design:
** How do you carve/select storage for each of the files below:
TempDB
Data file
Log file
backup file

** How do you determine the size of a database based on your experience?

Security:
** Have you worked with secure data?. If so, how do you protect/encrypt the data?

Different types :
** Have you worked in an OLTP and Data warehouse DB’s?. if so, how is the set up different for each type

Post #1417895

« Prev Topic | Next Topic »

111 posts, Page 12 of 12

«««8 9 10 11 12

Permissions