Kendra here– we’re really excited to announce that we’ve hired Erik Darling on to join our team as a consultant. Erik’s first day is today.
To introduce Erik, we’re sharing some of his answers to our call for job applications. We were so impressed, we knew we had to talk to him right away.
What are your favorite things about your DBA job?
Getting a 10 production server/100tb of data environment configured to best practices and maintained and (WEEKLY) DBCC checked.
Migrating legacy apps to new VMs.
Helping the devs with in-house applications and reports (lots of code and index tuning).
Setting up Failover Clusters, install and config SQL.
Learning, learning, learning.
Being the only DBA.
What parts of the DBA job do you not enjoy?
Filling out paperwork, archiving to tape, being on call from 7am to midnight seven days a week, being the only DBA.
Tell us about a time you broke a production server.
So this one time I had to move a 5tb database to a near-line SATA LUN, and I was all like, “GUI? GU you! I’m gonna PoSH this ogre to icy hell.”
That’s when I found out that the Move-Item command basically eats like all the memory it can if you don’t have LPIM set up for SQL, and this dual 12, 512GB behemoth basically churned to a halt, couldn’t RDP, couldn’t VNC, nothing.
On the plus side, I could use PowerShell to kill the PowerShell process remotely.
After that I just restored a copy of the database to the new LUN and dropped the old one. That went a lot better.
Why would you be great at this job?
I like solving big problems. I like teaching people how to solve little problems. I once taught a developer who barely spoke English how to cross apply with a drawing. It may or may not have been a New Order album cover. I can talk about SQL all day. Most of it is right, too, especially if I think about it first. I am all self taught and have never had anyone senior to me, so I have plenty of straight up horribly grim determination to learn things and put them into practice.
What do you think will be the hardest part of this job for you?
Not sneaking onto Jeremiah’s Twitter account to change his name to Bodega Mayonnaise.
Brent says: I swear, we didn’t just hire him because of the tattoos. But I’m not going to say they weren’t a contributing factor.
Jeremiah says: I’m glad to have a co-worker who shares my appreciation of plaid, tattoos, and crazy T-SQL.