Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pavankumar.dba
Starting Member
1 Post |
 Posted - 2008-12-08 : 03:38:18
|
| Dear Friends , Plz tell me what are the main roles and responsibilities of junior dba. Thanks from Pavan kumarPAVANKUMAR |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-12-08 : 09:52:28
|
| There is nothing like Jr.DBA has to know these things & Sr.DBA has to know these things.As a DBA(Jr or Sr) you have to know some basic things.1.Installation & Configuaration2.About databases3.Backup & Restore4.Performance Tuning5.Monitoring when you start working,you will know lot of things . |
 |
|
|
crosan
Starting Member
13 Posts |
Posted - 2008-12-08 : 10:53:33
|
| I'm sure the responsibilities will vary from company to company. The JR dbas I've had in the past typically spend a majority of their time in a ticketing system working on the "low hanging fruit" type of issues that are easy and quick to finish, but can take a lot of time to finish due to sheer quantity. This gives them a good grasp on the types of issues a Sr level DBA might have to plan for in the future. They have monitored the event logs for abnormal error messages, these can range from failed disk messages to security violations. They should be able to remedy some of these, more advanced issues they should know to alert Sr staff of a potential problem. Also, they should be working with a mentor/Sr DBA to get ramped up on performance troubleshooting and activly monitoring the database. Performance tuning both physical and logical database designs can be considered an art that will take time to grasp fully. Ideally a Jr DBA would have someone they could work with daily to get a handle on these concepts as well as other critical Sr DBA type responsibilities. |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2008-12-08 : 12:16:32
|
| I'd say Performance Tuning is often the main one. |
|
|
|
brianjensen
Starting Member
22 Posts |
Posted - 2008-12-10 : 07:58:27
|
quote:
Originally posted by swekik
There is nothing like Jr.DBA has to know these things & Sr.DBA has to know these things.As a DBA(Jr or Sr) you have to know some basic things.1.Installation & Configuaration2.About databases3.Backup & Restore4.Performance Tuning5.Monitoring when you start working,you will know lot of things .
/agree |
|
|
|
|
|
|
Roles of DBA