Just accepted a Sr. DBA job. Time for a gut check?
-
I think you're on the right track with the "meds", get them and relax a bit, or meet with a therapist 😀 Then again after reading your mini-novel, maybe both might do you some good...
You're definitely over-thinking it. Again, just R-E-L-A-X. Nobody goes through a 3-hour interview without having a decent knowledge of something.
Embrace the challenge. Sounds like you'll get a lot of exposure to things you haven't done before...and that's always good thing. Read up on the newer technologies, asks questions, and work on things at home until you feel somewhat comfortable.
Enjoy your new job.
Respectfully,
Abby
😎
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
-
Honestly it sounds like a great opportunity. There is obviously quite a lot of experience in the company already and as such I would think they are wanting to break you in gently.
You are unlikely to be put in charge of anything that you have no experience of at the start and I would think they will buddy you up with the those that know the most for those tasks they are looking to give you maybe the key is to ensure that you are honest with them if you think you may struggle with a task.
I've been in a few small businesses where the work is extremely difficult. It can be very difficult to hire staff as people get scared of the responsibility. In one particular company the owner was just glad to get decent talented people committed to giving it a go while obviously putting in precautionary measures.
The great thing about those kind of companies are the BS level is very low and you aren't hindered by not being able to speak directly or pointless meetings.
cloudydatablog.net
-
I'd have to say that you should have some confidence in the people who offered you the job--they've given you three hours of questioning and discussion and have decided you're the person they're looking for; surely that has to count for something? As for failing a Microsoft test, it's not really relevant--they chose you for your specialist skills, not for the more general SQL knowledge you'd need to pass a Microsoft certification. When the developers come to you asking the questions and *you know the answers* (which it sounds like you will from your background) then that'll be the moment you realise you can do the job.
After moving away from a job you've been doing for 10 years a few nerves are to be expected. Just do the job to the best of your ability and I'm sure you'll realise why they hired you.
-
As everyone else has said they wouldn't have hired you if they didn't think you were up to the job.
as it is if they have as many servers as you suggest then you're going to spend a month getting to know their location, history, etc, and that's on top of picking up the company standard best practices.
_________________________________________________________________________
SSC Guide to Posting and Best Practices -
You said it yourself, they're hiring you mostly for your development experience of which you have 10 years. (yes, I read the whole thing. I can prove it by pointing out that you pasted a sentence twice in the paragraph beginning with 'So why leave?')
The other DBA isn't worried about you, so you shouldn't worry about you. So long as you are motivated to learn, you'll be fine.
You will get use to the scale of the business, you'll learn the different applications, you'll research and get comfortable with the replication setup, you'll learn all the performance tips, you'll be a DBA with a strong development background. Plus, you'll get to work with another DBA which is great!
Take your meds, sleep well, and let us know how it goes!
-
First and foremost, you have the ability to do this job. Your past, and diverse experience shows you have the ability to adapt and to learn. The fact that you post here and ask questions and you realize what you don't know...it is a good sign. What you are experiencing is the fact you've been on cruise control for a long time on rural roads, and you just hit a big city with lots of traffic construction and you are a bit lost. Culture shock.
This is said in Hindsight, but always remember that in an interview, you need to interview them as well. If you are going to give any merit to the opinions of the people who hired you, you need to determine if they are worthy of that merit. There are many times where you will be interviewed by someone who knows way less of the subject matter than you do, but still has the same weight as everyone else when it comes to hiring decision. Plus face to face, most people are horrible at interviewing (even moreso in IT).
With that said, you got your foot in the door, now it's time to hit the ground running. Keep learning, keep asking questions, etc. The next 2-3 months you should be spending 75-85% your free time mastering your new craft. You are going to make mistakes along the way, the key thing is a) do not sit on them, communicate it to people asap, and b) learn everything you need to know to make sure you never make that mistake again. Another part of the culture shock is that you're used being a senior/expert and you've been doing daily 4 mile runs for years, but now you have to learn how to walk all over again. It will take some humility and patience but you will be fine.
Good luck to you! We better see a bunch of questions posted by you in the next few months 🙂
FYI - If you can't sleep at night, pick up a SQL book. It'll knock you right out. 🙂
-
In December of last year I took a new position after being at the same company for over 16 years. It is totally natural to feel nervous because you are leaving the comfort of what was familiar for the unknown. I'm not sure why they hired you as a Sr. DBA when your experience sounds more like a Sr. developer or developer/DBA. That isn't meant to be an insult, jut an observation. Xanax will help with the panic attacks so give that a thought and relax. If you were totally honest with all who interviewed you and you passed then they know what they are buying and you should do fine. If you sold yourself as something you are not then you would need to be scared but that isn't the case. Relax.
At my last company I was also a Sr. DBA but I did loads of development and I was the network admin, Exchange admin and on and on. What I know about SQL Server is great but it is what I don't know is what scares me. Where I am now we use log shipping, replication and some of the tables have over a billion rows in the different databases across multiple servers. Where I was before a million rows was huge and I just used mirroring for failover and we didn't have a DR site (company wouldn't spend a dime to do something right) so there was no need for log shipping. The apps used here are complicated and setting up test systems are all but impossible though we do have test areas. The point is that a mistake can mean screwing up something in production and that makes me nervous for obvious reasons. But you know what? It's all cool and I can handle it.
At my prior company I could come and go as I pleased, wear shorts to work, etc but here it is more formal. Here it is also much more stable financially and is certainly much more professional. I left a place where I could get away with murder but it was a toxic place and I had to get away. My fist day I was very nervous but you are only the new guy once so it didn't eat me up. Also remember that since you are not being forced to be a jack of all trades in your new position it means you are going to have time to learn more, test things more before plugging them in and on and on. Its great being able to focus on your profession and spend your time only on that but it can leave you feeling like you aren't doing enough to earn your money. Take it from me that if the company hired you to perform specific tasks and that is all you focus on then you are doing your job.
Good luck in the new position.
Cheers
-
A few years ago, I left a secure position where I was just shy of 15 years. There's definitely some trepidation involved in such a move. I now work for a much smaller company and find it much nicer than the large company I used to work for. There's less stress and less office politics.
So what if you don't have 27 years of experience as a DBA? Do you know absolutely everything about every aspect of SQL Server? Probably not, but technology changes very quickly, so is it really necessary to know everything? You've accepted the position and are moving into the great unknown. Have some confidence in yourself and embrace the challenge. I consider myself blessed in my job. I learn something new almost every day.
The bottom line this that nobody survives a 3-hour interview and gets an offer unless the people doing the interview are sufficiently impressed with your skill set. So what if you don't have 27 years of experience as a DBA? You said they were sizing up your personality and aptitude. This is possibly one of the most important points you brought up. This means that they want someone who's a good fit for their company first and a skill set second. If you're the best DBA in the world and can't get along with anyone, you're not going to last. This is why personality is so important. Chances are they've done this before, so give them some credit for making a good decision.
-
Exactly on surviving the 3 hour interview. Mine ran nearly 3 1/2 and it was the day before Thanksgiving. Nobody wants to do anything on days like that but when the interview ran so long I knew it was going very well and it only involved meeting my potential boss and a co-worker. No tour of the building, meeting with 100 devs or anything like that. Just talking to two people.
Cheers
-
1. The scale: there will be many servers to manage, much more than I've had to work with in the past.
2. The size of the instances: While the company is MUCH smaller than where I was, they have massive amounts of data. My tables maybe held 10's of thousands of rows, but some of their production databases hold 100's of thousands of rows.
3. They utilize a HA set up on a cluster; I don't have any experience with those.
4. They have replication set up on a few of the production databases to create an instance for the BI and operations teams to query; I've never set up or changed replication schemes.
Also, I've always been the person who's had to develop the application code as well as the TSQL code to support it, I've never really had to troubleshoot major performance issues; that's not to say that I don't understand query execution plans, but I haven't had to use database tuning adviser, or SQL Server profiler to really dig into a query issue. If something wasn't working I could pretty easily identify where an index was needed or a procedure that needed re-written. So I don't have a firm grasp on what the "best" way to troubleshoot performance issues are.
1. Practice scripting and automating everything you can. I've single-handedly supported dozens of instances, and the only way to really do it is to automate all you can, and divide servers into levels of support. Not everything can be a "tier 1"/"level 1" support when you have too many instances.
If you're used to using TSQL to do things, you've got a great starting basis. If you're not, start using TSQL now to do everything you can for standard DBA tasks! No more GUI for backing up dbs, creating tables, etc..
2. 100Ks of rows is not that bad, although performance can of course still be an issue. First tune tempdb, if needed. Then the main thing is to get the proper clustered indexes on critical tables (first; other tables over time), and that won't always be easy. But do that first, and a lot of the other perf issues go away.
3. You'll have to spend some time early on to brush up on that, as actual experience is required in that area. If you need to, use voluntary overtime: that's some payback to the company for having the faith to give you the job.
4. You can practice with that on your own at home. If the company won't get you a SQL Developer Edition, get one yourself, it's dirt cheap. Because replication is, like HA, something that must actually be worked with to be learned.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
-
I can understand your nerves regarding this new role, but it sounds like a great opportunity for you. You're going to get exposure to a lot of aspects of SQL Server, the company obviously really like you and (for me this is the main part) you will have the support and expertise of the other DBAs you'll be working beside. You're not going to be left alone to work it out yourself. Well done on getting this!
-
Congratulations, first off!
Your reaction to leaving your job of 10 years is understandable. Everybody doubts themselves when they start a new job, everybody. You spend the first 6 months-1 year, waiting to be 'found out'; it is inevitable. They will 'see right through you' any day now. You have 'thrown away' a secure job where you were the go-to guy for everything. Very soon your boss at the new place will call you to one side, tell you you're not quite who they wanted after all, sorry. They thought you were better than this. You will lose your home and your car...
Right ;-)?
This is all totally normal, and we all go through it. The reality is that although you will be expected to hit the ground running and get stuck in straight away, you will not be expected to be familiar with their set-up and with their particular idiosyncrasies for quite some time yet. There's another DBA there already so this is a great learning opportunity for you. It might feel like a baptism of fire, but the best opportunities usually do.
Good luck.
-
Beatrix Kiddo (3/5/2013)
Congratulations, first off!Your reaction to leaving your job of 10 years is understandable. Everybody doubts themselves when they start a new job, everybody. You spend the first 6 months-1 year, waiting to be 'found out'; it is inevitable. They will 'see right through you' any day now. You have 'thrown away' a secure job where you were the go-to guy for everything. Very soon your boss at the new place will call you to one side, tell you you're not quite who they wanted after all, sorry. They thought you were better than this. You will lose your home and your car...
Right ;-)?
This is all totally normal, and we all go through it. The reality is that although you will be expected to hit the ground running and get stuck in straight away, you will not be expected to be familiar with their set-up and with their particular idiosyncrasies for quite some time yet. There's another DBA there already so this is a great learning opportunity for you. It might feel like a baptism of fire, but the best opportunities usually do.
Good luck.
+ 100 at least
I have always found I am my own worst enemy and forget that I went through a grilling (not as bad as yours) to get the job I'm in now - where my employers trust me.
Well done and good luck
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx -
Heartiest congrats. 🙂
I agree with all the people's comments. No one crack a three hour long interview without knowing anything. Remember you are not replacing the DBA but working with him ? At times, interviewer also checks what kind of variety you bring to the environment and probably thats what you are going to provide. You have been a mix of development plus administration [little bit] and knowledge on other dev stuff as well.
Also it will be a very good platform for you to learn new aspects of SQl and definitely the forum people [deifnitely me] would like to know about your challenges and how you overcame them
By best wishes with you. 🙂
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply