Hi all,
I haven't posted in here in a millennia … or so it seems! I took a 2 year hiatus from DBA'ing and now am interviewing for a Sr. DBA role at a local firm. I have over 20 years of SQL experience and 10+ years of DBA experience. I need to brush up on a few things though and am looking for ideas from the peanut gallery 😉
The obvious:
Backup/Restore
Security
Profiling
Tuning
I appreciate any and all feedback!
DevOps would be another area I'd suggest.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 23, 2020 at 4:24 pm
While I appreciate your sentiment, and I of course already did that, I thought I'd approach our community to see what others felt was important, not just some regurgitated blog post.
Thanks
June 23, 2020 at 4:48 pm
While I appreciate your sentiment, and I of course already did that, I thought I'd approach our community to see what others felt was important, not just some regurgitated blog post.
Thanks
I assume that was directed at me. I also assume that you were referring to my signature, which, of course, is not directed at any one person in particular, and not to the actual content of my message.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 23, 2020 at 5:30 pm
Unfortunately, the only reply I see is Phil's latest one. The one before that was flagged as SPAM.
But Phil is well known on this forum, so I doubt his reply was actually SPAM.
But to me, the things you listed are the skills a DBA should have, not specifically a senior DBA. Even a junior DBA should be able to handle backup and restore and I know database developers that know how to profile (extended events and profiler).
My opinion, a Sr. DBA should have years of experience under his or her belt and should be able to do all of the basics as well as mentor the Jr's to get to a higher level. On top of that, you should be able to handle disaster situations and be available on-call. You should be able to defend your RTO and RPO to the upper management. You are likely going to be the first one called in the event of a disaster and going to be accountable in the event the RTO and RPO cannot be met. Plus all the other fun things that come with DR. You should be able to recommend new tools, products, and services to help improve their databases, their monitoring, their development, etc. You should be aware of the features in the newer versions of the databases and know how to implement them, or at the very least, know where to reliably research it to determine if it is a good fit for that company.
On top of the above, it depends on which company you go with. It MIGHT be that the company you are applying to expects you to be a BI expert and a database developer and know how to write C# all on top of the DBA work. Or they may want you to ONLY be a DBA and not touch any development work. You may be the OS admin as well as the SQL Server admin in which case you should know a bit about networking, firewalls, windows updates, etc.
I really wish I could see Phil's response so I'd know if I am just repeating what he said or if I was actually adding new content :/.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 23, 2020 at 5:45 pm
Brian, thanks for the vote of confidence.
Despite obviously having the desire to suggest that the OP consider purchasing from Nike's latest product line, instead I suggested that adding 'DevOps' to their list would be a worthwhile idea.
And that is about all my message contained. Your post is much more expansive and well thought-out.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 23, 2020 at 6:43 pm
Thank you both for your responses. I did not mean to mark your reply as spam, there was something odd posted under it, I thought that was what I flagged.
Anyway, yes, DevOps is a good idea, and Brian, your list is very helpful for me getting my head around what to present at an interview.
With so many years of experience it is tough to determine what the 'best' things are to put forward. Since I've been away from it for almost 2 years in a developer role I just wanted to refresh my old memory and concentrate on things that seem the most relevant right now. I know Azure and AWS is huge, unfortunately I have very little experience in that arena.
I really like the viewpoint that the Sr DBA is a mentor, planner, and all around leader for database initiatives. Every place is a bit different, you're both spot on. I never had a singular role, so DBA for me meant literally, everything.
Thanks again, sorry for my accidental marking!
Cheers
June 23, 2020 at 10:48 pm
Unfortunately, the only reply I see is Phil's latest one. The one before that was flagged as SPAM.
But Phil is well known on this forum, so I doubt his reply was actually SPAM.
But to me, the things you listed are the skills a DBA should have, not specifically a senior DBA. Even a junior DBA should be able to handle backup and restore and I know database developers that know how to profile (extended events and profiler).
My opinion, a Sr. DBA should have years of experience under his or her belt and should be able to do all of the basics as well as mentor the Jr's to get to a higher level. On top of that, you should be able to handle disaster situations and be available on-call. You should be able to defend your RTO and RPO to the upper management. You are likely going to be the first one called in the event of a disaster and going to be accountable in the event the RTO and RPO cannot be met. Plus all the other fun things that come with DR. You should be able to recommend new tools, products, and services to help improve their databases, their monitoring, their development, etc. You should be aware of the features in the newer versions of the databases and know how to implement them, or at the very least, know where to reliably research it to determine if it is a good fit for that company.
On top of the above, it depends on which company you go with. It MIGHT be that the company you are applying to expects you to be a BI expert and a database developer and know how to write C# all on top of the DBA work. Or they may want you to ONLY be a DBA and not touch any development work. You may be the OS admin as well as the SQL Server admin in which case you should know a bit about networking, firewalls, windows updates, etc.
I really wish I could see Phil's response so I'd know if I am just repeating what he said or if I was actually adding new content :/.
I would disagree with one thing: You should be able to defend your RTO and RPO to the upper management. DBAs should not be dictating the RTO/RPO. That should be a business decision where the DBA should be consulted and their opinion solicited and considered.
I had a heated discussion with network services at a previous employer when they moved to a new tape library system and they were going from changing tapes daily to weekly. With that change I was pushing hard to get at least one file server off-site where I could write copies of backup files should a disaster strike in the server room and destroy the tape library system.
I got my off-site file server.
I basically told them that I was not going to explain to the CFO we lost a weeks worth of data because of a decision made by Network Services because of an upgrade in hardware. RTO/RPO are not just a part of a simple DR strategy but also a Business Continuity strategy.
June 24, 2020 at 10:09 am
Lynn's post leads on to another aspect of Senior DBA - dealing with people.
The higher you climb up the food-chain, the more your people skills become important. You have to deal with a variety of 'grades' of people as a Senior DBA, be able to communicate at an appropriate level and deal with the difficult discussions that can result.
It's an unfortunate truth that the better you get at a skill, the more removed from it you can become. Just knowing the technical aspects isn't necessarily enough.
June 24, 2020 at 10:32 am
Phil suggested DevOps, which I heartily, vociferously, and vigorously agree with.
For some reason it was marked as Spam. I unmarked it.
I'll add PowerShell. Automate all the things.
Also, you said tuning, which is fine, but, I'd argue, as strongly as for DevOps, that a modern, senior level, DBA-type, should be using Extended Events. So learn that too. You need it for all new functionality any way.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply