Solved

Database architect

Posted on 2012-04-03
4
333 Views
Last Modified: 2012-04-03
Experts -

I've to prepare few question to ask this DB Architect we going to hire. We've oracle/SQLserver and MySQL.  Looking for some tips.

Thanks,
Sve.
0
Comment
Question by:sventhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 23

Accepted Solution

by:
David earned 300 total points
ID: 37802438
1.  There are thousands of suggested interview questions/discussions in E-E and the Web, for example:
https://forums.oracle.com/forums/thread.jspa?threadID=1025822
http://www.coolinterview.com/type.asp?iType=52

That said, any individual cannot answer every question, and missed/wrong answers are not indicative of whether the candidate can do the job.  For that matter, past performance does not guarantee future performance.  More of a win-win approach may include show-me scenarios, such as "how to diagnose a real-time problem" might show you whether the candidate can think on their feet, and be able to correctly perform root cause analysis (RCA).  What resources would the person turn to?

2. DB Architect is a very, very, very broad title.  The candidate, and you, must turn to specific metrics of what is necessary to be successful.  It's terribly easy to have assumption gaps that s/he understands what you understand.

3.  Specific RDBMS versions may have different answers.

4.  Were I hiring, I consider tech knowledge searchable and thus fairly easy to pick up on-the-job knowledge.  I value honestly (don't hide problems), personal integrity (don't steal or cheat with lazing off), perseverance, communication, and initiative.
0
 
LVL 18

Author Comment

by:sventhan
ID: 37802473
Thanks DVZ and well said.  I'll keep those in mind. I would like to approach this little different and looking for the ideas.
0
 
LVL 15

Assisted Solution

by:gplana
gplana earned 100 total points
ID: 37802484
Also you can ask some questions such as "What kind of table is better in MySQL?"

MySQL has two main kinds of tables: InnoDB and MyISAM. MyISAM are faster, but InnoDB are better from a consistency point of view, and it supports transactions and foreign keys.

Also, you can ask things like "What is SGA in Oracle" which is a set of buffers Oracle has in memory.

For SQL-Server you can ask something like "What is dbo".

Also you can ask some generical questions about to solve SQL queries, about when is good to create an index, etc...
0
 
LVL 45

Assisted Solution

by:Kent Olsen
Kent Olsen earned 100 total points
ID: 37802648
Hi Sve.

There is a world of difference in an OLTP and an OLAP database.  The OLTP is optimized for write operations (logging) while the OLAP is opimized for reads (queries).  Make sure that your architect is capable of designing the type of database that you need.

The OLAP is generally the greater challenge.  A data warehouse (a specific type of OLAP database) requires the most focused skills, but perhaps the largest skill set.

The point is, if you want your architect to build you a data warehouse, don't entrust it to someone that has built 100 OLTP systems and assures you that "they are almost the same thing".


Kent
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This video shows how to recover a database from a user managed backup
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question