未加星标

Preparing for SQL DBA Interview

字体大小 | |
[数据库(综合) 所属分类 数据库(综合) | 发布者 店小二05 | 时间 2016 | 作者 红领巾 ] 0人收藏点击收藏
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 Que

本文数据库(综合)相关术语:系统安全软件

主题: SQLCPUAMDSQL ServerTIDUUCEBSCSILinkedIn
分页:12
转载请注明
本文标题:Preparing for SQL DBA Interview
本站链接:http://www.codesec.net/view/480271.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(综合) | 评论(0) | 阅读(29)