Preparing for SQL DBA Interview

Preparing for SQL DBA Interview

Preparing for SQL DBA Interview

This article list out few tips on “Preparing for SQL DBA Interview” If you are reading this article which means you must be a Database Administrator/professional or getting ready for entering into DBA world. In today’s corporate world attending or taking a technical interview is mandatory whether it’s for a new role in current organization, new customer/client or for a new organization. Preparing for SQL DBA Interview is always a challenge. We have randomly chosen SQL Server database professionals from three different experience levels and had a deep discussion on “Preparing for SQL DBA Interview”.

  • Fresher/Junior – Should know the basics of process and technology
  • Mid-Level – Should be able to expertise in one or two areas and know the process
  • Senior Level – Should be expertise in technology and able to drive the process

There are few points everyone should follow to get succeed in an interview. Below are the key points which can be helpful in “Preparing for SQL DBA Interview”

    • Profile

    • Preparation

    • Communication

    • Interview Process

  • Preparing a Topic

Profile

This is the first piece of information that tells about you so please be careful in preparing your profile:

  • Don’t add the generic skill-set: Include only the topics that you are experienced or learned.
  • Add your professional experience, key skills, education details, your achievements, certifications, training and projects.
  • Number of pages should be restricted to 3 or 4.
  • Maintain a profile on professional network like LinkedIn and add a link to your profile (I have seen a lot of opportunities are hitting through professional networks)
  • Remember you should know / learn / prepare / experience each and everything you mentioned in your profile as the interview questions are always depends on summary points that you showcase in your profile.

Preparation

When you are not prepared for an interview you will not be going to make a WIN. Preparation makes you to feel more confident and plays the main role in your success.  Prepare a self-reference guide with all your experiences, your tough times, difficult technical issues you faced, complex requirements and resolutions and your own interview experiences. Now we’ll see WHAT should be in our preparation list:

 Top Questions:

Prepare top 10 questions in each category, let’s say you mentioned you are experienced in Performance Tuning, DBA daily activities, Replication and Clustering. You must be ready to answer top 10 questions from these categories. TOP 10 is different from person to person let’s say you are mostly handles SQL Server AlwaysOn Failover Cluster installations, person B might be expert in troubleshooting clustering issues and Person C mostly experienced in RCA and Performance Tuning in clusters. Based on your experience prepare your own list and see this is just a onetime activity and you can use the reference guide throughout your career.

 Environment:

This is the most critical area where 80% failures in answering the questions. This is the primary area to test your experience, so prepare well. Environment includes different things that one can learn only through experience. We’ll see the common questions on environment:

 Versions:

Remember the versions you worked on:

  • Prepare at least few new features added in the latest version you worked in (Ex: 2012 when compared to 2008 R2).
  • Have a look at new features added in latest SQL Server version. Ex: 2016
  • You might be asked SQL Server components, try to remember few major components

Servers / Instances / Databases:

If you are experienced you must be confident in answering the question “How many total windows / SQL servers/Instances and Databases available in your previous work environment?”. Below we are giving an average values that we got from various professionals working in different organizations. It always depends on business Application requirement

 Number of SQL Servers / Instances:

  • Enterprise Big Environment: 100 to 800
  • Mid-Level: 50 to 100
  • Small: 10 to 60

 Number of databases:

We always have an average figure as an answer for this question, because we can’t know the exact count as we maintain databases for different environments. For example an application can require 4 databases, then the same number of databases may require for DEVELOPMENT, TESTING, STAGING and in PRODUCTION. If any DR / HA is configured then those replicas should also be considered. Thereof we usually do not count the number of databases but yes we can see inventories for database details. Here are the average counts:

  • Big Environments: 1000 to 4000
  • Mid-Level Environments: 500 to 1000
  • Small Environments: 100 to 500

 Database Size:

  • Big Enterprise:
    • OLTP: 50 GB – 2 TB
    • OLAP: 600 GB – 12 TB
  • Mid-Level Enterprise:
    • OLTP: 10 GB – 2 TB
    • OLAP: 100 GB – 5 TB
  • Small Environment:
    • OLTP: 1 GB – 200 GB
    • OLAP: 50 GB – 1 TB

 Team Size:

  • Enterprise Environments: 50 to 100
  • Mid-Level: 5 to 20
  • Low Level: 1 to 5

Hardware specs (CPU, Memory, and Storage):

CPU:  Processors: Most of the servers use processor from AMD, DELL or Intel X series

Cores: It’s the most important thing as SQL Server licenses based on the number of cores. It’s starting from 4 and 16, 64 etc.

Memory:

Minimum: 4 GB (We still see in some small instances in DEV and QA)

Medium: 64 to 128 GB

Maximum: 512 GB+ (For a premium prod server)

Storage:  SAN, SMB, NFS, iSCSI, EBS – if it’s AWS, Virtual Volumes – If it’s VMware etc.

 Software & Tools:

  • Make a note on third party tools you used in your environment ex: LITESPEED, REDGATE etc.
  • Also make a note on how licensing happening for SQL Server in your environment
  • Make a note on version number of names for ticketing and monitoring tools Ex: SCOM, TFS, and SVN etc.

Processes:

This is one of the most important key points. Processes related questions can be from:

  • How request handling happening in your environment if you are working on ITIL
  • Timeframe and other details on SPRINT / SCRUM if you are into agile
  • Documenting process
  • Inventory management
  • Onsite Offshore communication
  • How frequently you communicate with your client
  • How an incident is handled
  • What is bridge call?
  • Escalation Matrix: How escalation happens in your environment etc.
  • SLA: What is the Service Level Agreement for acknowledging the critical alerts?
  • Policies: What are the Backup policies for PROD, QA and DEV environments?
  • Experiences: Make a quick notes on strange / bad / good experiences from your daily routine
  • Projects: Know something about your projects / actual business

Responsibilities:

  • Be prepared to answer the question “what are your current job responsibilities?”
  • Prepare the details on Daily / Weekly / Monthly / Quarterly maintenance tasks

Behavioral Questions:

When you are targeting a critical role with a “Big IT Giant”, you should be prepared the answers for these questions as well:

  • Your next 5 years plan?
  • Most difficult situation you handled?
  • The situation you failed in?
  • Why you are leaving the current role?
  • Any innovative idea you initiated?
  • How do you define the success?
  • Best / Worst day in your life?
  • What are your top 3 wishes if god gives you a chance?
  • Most difficult person you faced in your work place?
  • Your manager is submitting a wrong bill to company, how do you react?
  • You got 3 offers: 1. Dream Company, 2. Dream location, 3. Dream Salary. Which one you choose and why?
  • Your strength and weakness
  • Who is your role model and Why?
  • When the last time you made a controversy in working place?
  • You have an emergency in your office and family what’s your priority and why?
  • Why this company?
  • Why we should hire you?

SQL The One Image

Communication

I have seen people blaming themselves “I am not great in English” yes that’s true you can’t be great in English unless English is your mother tongue. But you can be good in any language with some practice. So practice well let’s practice answering the first question “Tell me about yourself” and also practice answering the top 10 questions. Take some breath time and answer the questions. Remember communication plays 60% role in your success.

Preparing a Topic

Here we’ll see how to prepare a specific topic. Let’s say you have added “Replication, Clustering, Performance Tuning are your strong points”.  Now we’ll see  how to prepare the topic “Replication”:

Replication Components: Replication Agents, Methodology, advantages etc.

Types and Differences: Types of replication typologies and differences between them

Common Issues / Scenarios & Resolutions: Found duplicate records in subscriber, No-records found at subscriber, Log is getting full at Publisher, adding a new article without generating new snapshot etc.

New Features: Try to remember at least one new feature added in replication on the latest version in your experience Example: 2012 / 2014 / 2016.

Monitoring: A very common question “How to monitor replication health?”, Replication Monitor, Tracer Tokens, DMV etc.

Top 5 Questions: You should be prepared the top 5 common questions on topic replication. For example Different types of replications, implementations (Advantages) of Transnational and Merge, Can we issue TRUNCATE command on publisher, How to monitor replication, Replication Agents etc.

Interview Process

If you are in crisis or targeting a role in your dream company then take it seriously and follow the tips:

  • Be on time at interview venue
  • I don’t see people coming in formal dresses in today’s interviews, that’s not an issue but try to be a professional.
  • For the first question “Introduce Yourself”, give your experience details, your achievements and then education if still you have time and they are listening then continue with other details
  • If you guessed the answer you can tell that are guessing “This is just a guess from my analysis”
  • Drive the interview process. If you want to drive the process you should be prepared well which means if you say “I am good in Performance Tuning” please do not expect a question like “What is an index” rather you can expect “Why indexed view when filter index is there?”.
  • Remember that in most of the cases your next question is based on the current question answer isn’t it? Let’s say if you are asked “What are the common issues with TEMPDB?”, if you answer something like, TEMPDB full, Space issue, Version store full, forced to shrink, Latch Contention etc. Then the next question will be on one of these 5 reasons. You might be asked “What is Latch Contention?” and then “How do you troubleshoot it?” etc.
  • Be focused and hear the question completely, try to give the straight answer unless you are asked to explain in detail.
  • Ask the right questions for which we need to do some research required on that organization, role.
  • We can ask for the answer if you can’t answer any question.
  • Don’t be dumb when you don’t aware of something. See I have seen people kept silent or try to cover with the false answers. If you are asked a scenario based question in replication, but you don’t know answer then you can accept that by saying “I am really not sure how to handle this but I have seen similar kind of issue when duplicates are inserted in subscribers and that time we did give XXXX resolution”.
  • If something is really strange you are asked about that you can frankly express that you don’t aware of that.
  • Remember no one knows everything, you are asked scenario based questions to check how you are reacting and using your analysis to get the answer.
  • Never ever blame your previous / current work place or colleagues
  • Do not reveal previous clients information Ex: You can say I worked with world’s largest bank instead of XXXXX Bank.
  • Do the proper follow up on post interview

Final note:

Interview process is not just to test your technical knowledge instead throughout the interview process you are tested in analytical skills, stress management, management skills, problem solving skills, way of thinking, attitude, experience and of course your technical knowledge.  Prepare well, be confident and get the success in your next interview.

You might be interested in:

Database Job Openings

SQL Server DBA Responsibilities

Database Career Paths

How to become an Expert in your Career

SQL Server Interview Questions and Answers

Posted in Interview Q&A, Miscellaneous, SQL Server DBA | Tagged , , , , , | 18 Comments
Subscribe
Notify of
guest
18 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Bharath reddy
Bharath reddy
8 years ago

Such a Nice article and info for DBA’s in-terms of Freshers and Mid level Employees You are doing a fabulous Job Uday..garuu!!! You just rocking and sharing the knowledge to the world Not only for India.

Thanks & All the best for your future en-devour.

sateesh
sateesh
7 years ago

Excellent Brother,
this helps a lot for those who are looking for the career path of SQL DBA.

Thanks a lot and ‘GOD BLESS YOU BROTHER’

Thank you
Sateesh

ramesh k
ramesh k
7 years ago

i am searching a job on sql dba,it is useful for me for real time scenarious

Swapna
Swapna
7 years ago

Nice Blog Uday, what is your experience? just curious.

siddhartha
siddhartha
7 years ago

Hi Uday, I am following your blog from the last 2 years, I wondered the information what you collect and share your experience on DBA. after I following your blog I referred so many of my friends to go through your blog and clarify the confusions. I bought your book SQL THE ONE. What a book man you are a genius in that. all my friends and I bought this book. So nice to see the book like this first time in the market. Finally.. the word you wrote on the book “this books is dedicated to Sr.NTR” Loving it… Read more »

Anilkumar
6 years ago

Hi Uday,

I want script for databases backups to different drives,when we have to run jobs or maintanaceplanc ..

Nagaraj
Nagaraj
6 years ago

Excellent uday ji..keep rocking..

prem
prem
4 years ago

Hi Bro,

superb work done by you , it helps all the SQL dba community.

Balaji rajendran
Balaji rajendran
3 years ago

Thanks team! It’s really helpful to us.

Anil
Anil
1 year ago

excellent uday your drafting articles..!!