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
Solved

Database architect

Posted on 2012-04-03
4
329 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
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

840 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