Posted by: acbel44 May 21, 2008
SQL Problems n Tips
Login in to Rate this Post:     0       ?        

Stylish:

It is always good to start with Developer. I started my career as a BA and then Oracle Dev/DBA and then now in both SQL and Oracle.

there are few standard things that you have to do as a DBA:

1. Writing Scripts such as restore db, backup db, sps to generate reports of several jobs in the server, script to monitor the performacne of the database, finding size, growth of the databases to find the bottlenecks, and etc.

2. SPs and sheel script to maintain, manage and tune the database.

3. Backup the DBs.

4. Restore the DB.

5. Check the jobs every day to make sure they are running properly and fix them if failed..

6. Make database up and running.

7. Tune and optimize the database.

 

These are standard jobs i do as a DBA. There will be a whole list.

Let me know if you have any specific questions from Database perspective, i will be more than happy to answer or help you out whatever i know. Thank you and good luck

 

Read Full Discussion Thread for this article