Database Architect Interview Questions


Database Architect interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Mode Media
Senior Database Architect was asked...12 April 2011

how to handle the corrupted record scenario?

2 Answers

the answer is export & import the particular table

Collect Corrupted records, do the special API to handle it. ie. Regain from Database, Retry and Finally Analyse why it corrupted. Less


did not given interview there?

1 Answers


TSYS|Total System Services

What is the first step you apply in setting up a new database system?

1 Answers

The first thing to do, which does not involve writing any code, is put on my hat as a systems analyst. An architect must have an understanding of each phase of the process ranging from first collecting information from the current system in place, talking to each person involved in that current system, sitting down and doing some of the work of some of those people (this provides very valuable information that was not submitted earlier, as it was not considered valuable), and basically learning to understand and appreciate the data. Knowing the data is the first and most crucial step, otherwise, the models and subsequent work based on it will be useless and can cost a company resources it cannot afford. Knowing the data well provides the architect with perspectives that the company may not be considering. That is, there may be better options available that have not been considered that could exceed their objectives. It is the objectives that are key in the entire process. A basic developer will resolve a specific issue concentrating on the key, but the architect must have an understanding of the entire forest, so to speak, and must concentrate on understanding the data and the company's current and future objectives. Less

Arizona Department of Corrections, Rehabilitation & Reentry

Puzzle "Three Light Bulbs & Switches in a Room": A windowless room contains three identical light fixtures, each containing an identical light bulb or light globe. Each light is connected to one of three switches outside of the room. Each bulb is switched off at present. You are outside the room, and the door is closed. You have one, and only one, opportunity to flip any of the external switches. After this, you can go into the room and look at the lights, but you may not touch the switches again. How can you tell which switch goes to which light?"

1 Answers

I had no clue. Later I've found this Puzzle online. The right answer: "Switch on switches 1 & 2, wait a moment and switch off number 2. Enter the room. Whichever bulb is on is wired to switch 1, whichever is off and hot is wired to switch number 2, and the third is wired to switch 3." Less

Jama Software

Can you read a data model and talk to it?

1 Answers

Yes I can and I did.


How did you determine and test that your solution was going to solve the issue?

1 Answers

I answered honestly, that we looked at metrics, looked at processes running, and decided to adjust instance type. The problem did not recur. But he kept asking me over and over "How did you test this? How did you verify?" and I kept answering "We solved the problem, it did not happen, we watched the metrics and saw we were not hitting limits as before" Less


How are you going to help this manager meet his daily operational needs?


What is one thing you have accomplished that added value to an organization you've worked with/for?

Viewing 1 - 10 of 27 interview questions

See Interview Questions for Similar Jobs

sql server developersql developerdatabase programmeretl architectdata architectdatabase engineerdatabase managerdatabase administratordatabase developerdb2 dba

Glassdoor has 27 interview questions and reports from Database architect interviews. Prepare for your interview. Get hired. Love your job.