OPS_Database Standard Operations List

Database Standard Operations List

1.       DB Development standard

l  Database is only a storage , do not depend too much on database

l  Build a standard workflow for who ,when , how regarding different object levels

l  Make a standard permission control for who should have which right

l  Training and let all know who is the right person(dba, leaders) when they have any problem

 

2.       Data Performance Collection standard

l  Make sure it does not impact db performance too much or impact other business

l  Make sure that only use one or two collection platform

l  Make sure the collection schedule is reasonable

l  Make sure the collected is real useful

l  Make sure it’s easy configured and managed (disable ,enable)

3.       Data Report standard

l  Automatically report standard

ü  Build standard for what , how ,when, who for daily report , weekly report and monthly report

ü  Make sure it is real useful info and they have time to handle

ü   Make a tracking for each report and make sure it is improved

l  Manually report standard

ü  Analyze historical info then improve our performance in high level

ü  Make sure dba and ops to find a solution together then improve it

4.       DB Enhancement standard

l  Make sure enhanced plan is prepared ready ,before do anything

l  Make sure the enhancement solve our problem really and has the compared list between before and now

5.       Disaster recovery

l  Make sure every solution we have tested more and it has loged what happen