Basic Awareness on Ransomware

Posted on May 16, 2017 by uday arumilli

Basic Awareness on Ransomware

Basic Awareness on Ransomware

This post can help you to understand the Basic Awareness on Ransomware. Since Jan 2017 “Ransomware” has been taking the top position in the world’s technology security concern list. When it comes to hacking it’s a different story but this “Ransomware” can make an immediate effect on your business. After the recent malicious “WannaCrypt” software attack customers have been asking the question “Are we ready to handle Ransomware?” This is a just to provide basic awareness on “Ransomware” attack especially for the Database people.

Q. What is Ransomware?

Ans:

Highly speaking, Ransomware is malicious software that locks (Locker-ransomware) or encrypts (Crypto-ransomware) your data and demand money to get your data back (decrypt).

Q. How it actually attacks your machine?

Ans:

Continue reading →

Posted in Miscellaneous | Tagged , , , , | Leave a comment

SQL DBA Interview Experience with a Top MNC in Bangalore

Posted on April 23, 2017 by uday arumilli

SQL DBA Interview Experience with a Top MNC in Bangalore

SQL DBA Interview Experience with a Top MNC in Bangalore

SQL DBA Interview Experience with a Top MNC in Bangalore is a recent SQL DBA interview questions shared by one of the blog follower. Thank you so much Mr.Vijay Tripaati for sharing your experience. This is for a SQL DBA role with 5 to 7 years of experience.

First Interview – Telephonic

Interviewer: Can you tell me about yourself?

Vijay: I have been working as a DBA for XXXXX from the last 4 years. I totally have 6 years of experience in administrating SQL Server database systems. I am experienced in creating DR solutions, automation, process improvements, T-SQL Scripting, PowerShell Scripting, performance tuning and all other SQL DBA activities. Previously I worked with XXXXXX Company for the client XXXXXX. I am a graduate from XXXXX College.

Interviewer: What is your daily routine in your current role?

Vijay: I am currently with the DBA support team for XXXXX client. This comes under L2 support. I have been working in shifts. First thing in the shift I need to check for scheduled RFC (Change Requests). And then I work with Service Requests assigned to my queue. Along with these we need to handle the INCIDENT requests as and when required. Along with these we need to check the automated notifications and need respond emails.

Interviewer: Do you have any SLA with your clients?

Vijay: Yes! We have a clear Service Level Agreement with our client. As per the policy I can’t reveal the SLA details but we have something like SLA on response times for a service request, change request, emergency change which should link with an incident, Incident Request, response time when an email comes from a Director or higher level. Like these we have a list of conditions included in SLA.

Interviewer: I really didn’t see the email response time included in an SLA. This is the first time I am hearing. Any specific reason?

Vijay: Not sure! Our client is in different business areas but the applications that we are supporting have been generating the highest revenue. May be that’s the reason they considered these applications are critical.

Interviewer: How big is your current infrastructure environment?

Continue reading →

Posted in Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , | Leave a comment

SQL Server SME Interview Experience

Posted on March 29, 2017 by uday arumilli

SQL Server SME Interview Experience

SQL Server SME Interview Experience

This post “SQL Server SME Interview Experience” can help you in understanding and answering the most common question for a SQL Server DBA or Developer. A few days back I got an email from one of the follower; she has given an interview for one of the top product based company for the position SQL Server SME and product owner role in Toronto and shared the conversation which was happened with the interviewer. I just wanted to make it as a post which might help few people around.

She is 10+ years of experience in delivering enterprise database solutions using Microsoft SQL Server and applied for SQL Server SME with one of the world’s top product company. Initially she had two telephonic interviews and got invited for face to face. Below is the conversation with the interviewer:

SQL Server SME interview experience shared by a follower

Interviewer: Hi Good Morning

Me: Very Good morning, how are you today?

Interviewer: I am doing great, any questions?

Me: (Surprised) Hmm I have gone through the job role description but would like to know more about the responsibilities.

Interviewer: Well to simply describe the job role, SME will be taking care of the entire XXXXX product suite database systems. He or She should be the point of contact for all database development and administration activities. Also the role would be responsible for all product related technical escalations.

Me: Got it, but how a SQL Server SME can be a product owner? Apart from the technical point what other skill set you are looking for?

Interviewer: Well the SME will not responsible from the business or domain prospect. But the person should be able to handle all product related escalations, if any website is not working or the end customers facing a technical issue they would come to you and you need to take the ownership and should handle the problem with the help of concern technical team.

Me: I understand, in fact I am also working for a product development company. Other than the database activities I need to participate in product enhancements related technical discussions and brainstorming sessions.

Interviewer: Yes I knew that. In our environment you many need to attend the performance issues on frequent basis. Can we talk something about performance?

Continue reading →

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , | 2 Comments