| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2009-01-20 : 09:11:09
|
Dear Gurus, AS Iam working as a JDBA,My Task is to Maintain the Script related to our .NETProduct and Maintain the Backups.Does a DBA need to write Procedures,Views,Functions,Triggesr in his daily Task. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-20 : 09:14:52
|
| Yup..Depending on what you want to achieve, you may have to write any of them. |
 |
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-01-20 : 09:32:09
|
| Thanks Visakh, But iam working as a Production DBA,and the developers are writing all those content,iam updating it in databases |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-20 : 09:33:18
|
| then isnt it just a matter of executing them? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-01-20 : 09:34:05
|
| DBA may not have to write SPs or functions but when the need arises, he may need to optimize them or review them and suggest design level changes.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-20 : 09:36:33
|
quote:
Originally posted by harsh_athalye
DBA may not have to write SPs or functions but when the need arises, he may need to optimize them or review them and suggest design level changes.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
what about ones for db maintainene activities? |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-01-20 : 09:38:40
|
| Thanks to Visakh&harsh,My Task involve1)Receiving requests from developers through internal mail regarding creation of Table,View,Procedure,function.All these are created by the developer and they send me by using internal mail2)I will update them in the Databases,and maintain the script in the Team Foundation Server(Source Control)3)Give Backup and recovery of DataBases when ever needed,schedule jobs(Hourly,day to day backups) |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-01-20 : 09:40:10
|
| Yes, absolutely. A DBA is not just about restoring backups, adding files to the database, setting up object-level permissions etc. Writing a hardcore code is a must for DBA, even though he may not have to write it as frequently as a developer.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-20 : 09:44:06
|
quote:
Originally posted by DBA007
Thanks to Visakh&harsh,My Task involve1)Receiving requests from developers through internal mail regarding creation of Table,View,Procedure,function.All these are created by the developer and they send me by using internal mail2)I will update them in the Databases,and maintain the script in the Team Foundation Server(Source Control)3)Give Backup and recovery of DataBases when ever needed,schedule jobs(Hourly,day to day backups)
4.performance monitor dbs,find bottlenecks and optimize the queries/processes that causes bottlenecks5.creating & implementing maintainence plans... |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-01-20 : 09:45:37
|
| Actually, there are two kinds of DBA roles:1) Admin DBA2) Developer DBAIf you are an ADMIN DBA, you are mainly responsible for maintaining a database such as administering backups, setting up replication, access control etc.But if you are a developer DBA, you are more closely associated with actual T-SQL code and performance tuning.In some organizations, there is no such categorization and a DBA is responsible for both duties. However, as visakh pointed out, even if you are a Admin DBA you may need to write DB maintainace scripts. So getting your hands on SQL programming is always good.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-01-20 : 09:58:43
|
Thanks for visakh&harsh for ur valiable suggestions and time. |
|
|
|
|
Regarding Quries