DBA Services breakdown

Can I ask from a low-tech non DBA standpoint, when you offer DBA or DB Hosting services, what sub sections of DBA are you offering. I think you may refer to these as services, but can you list out what a good DBA service offering actually does for the Database, 2 initial ideas where backup/restore, patching, but what else? Can you provide some sort of list so I can see the overall responsibilities and package a DBA will be involved with on your databases.

I dont know if they can be easily grouped into titles but just getting an idea on what when you outside database administration they should be doing would be a great insight...
LVL 3
pma111Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ramesh Babu VavillaConnect With a Mentor Commented:
High Availability and Disaster Recovery
index Rebuild,database Check ,
Maintenance Jobs
Capacity Planning
Server Performance Monitoring
Database Performance tunning
0
 
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
Data cleansing / ETL
Data Warehousing / archival storage for legal compliance
Data Integrity / Data Reliability / Data Availability
Triage
0
 
pma111Author Commented:
Can I ask what exactly falls into "Maintenance Jobs" and "Capacity Planning", in laymans terms>?
0
 
DavidSenior Oracle Database AdministratorCommented:
Capacity planning is to track the storage consumption of accumulated data.  IOW if you are storing 10 Mb per month, that's probably no big deal.  At 100 Gb per month, one needs to carefully project when existing disks will be filled -- and ensure that solutions are in place.

In like manner, when a database instance grows in concurrent users, or perhaps the applications become more complex -- is the RAM adequate?

Maintenance jobs, broadly, are the tasks to manage the stored data.  Backups, data purges, and data partitioning fall into this category.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.