Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««89101112

Common questions asked in SQL Server DBA Interview Expand / Collapse
Author
Message
Posted Friday, February 8, 2013 1:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 1:51 PM
Points: 5, Visits: 62
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
Posted Tuesday, February 25, 2014 12:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 3:45 AM
Points: 71, Visits: 153
Check out below link for Interview Questions and answers for SQL Server DBA

http://www.sqlserverquest.com/p/sql-server-dba-interview-questions.html


Randheer Singh

----------------------------------
CheckOut My Blog for SQL Server Realated Topics and Interview Questions for SSIS , SSRS and TSQL.

http://SQLServerQuest.blogspot.com
Post #1544782
Posted Saturday, April 5, 2014 6:25 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 36,759, Visits: 31,214
Randheer (2/25/2014)
Check out below link for Interview Questions and answers for SQL Server DBA

http://www.sqlserverquest.com/p/sql-server-dba-interview-questions.html


The link didn't work even when I copied and pasted it. I did, however, find the questions on your site.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1558802
« Prev Topic | Next Topic »

Add to briefcase «««89101112

Permissions Expand / Collapse