木匠的微型博客 Charlie Twitter

    follow me on Twitter

    Friday, September 22, 2006

    Habits of Highly Effective DBA

    干了12年Oracle DBA, 职位到了 Data Architect.
    今天写一篇关于DBA技术之外的技能和职业艺术

    1) Seven Habits of Highly Effective DBA
    http://www.dmreview.com/editorial/newsletter_article.cfm?articleId=1062133

    2) The Non-Technical Art of Being a Successful DBA
    http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-09-10.8657066083

    Hope you have time to read them.

    Here is something what I learned.
    • Change control
    • SLA (360-Degree Review Process)
    • Design review + communication with business unit
    • Naming convention
    • Document
    o Repeatable Processes
    o Corrective Action Reports

    And what I did and am doing,
    • The Foot Rule of Thumb (experiment and create your own rules of thumb)
    o test, experiment and learn
    • Instrument the code

    * Binding
    * Set based process
    * Benchmark

    The answer is as always, find the better way, benchmark it, and the numbers will speak for themselves.
    Ref from: On HTML DB, Bulking Up, and Speeding - Ask Tom

    No comments: