Snapshot of a DBAGooner

I read a post from Brent Ozar today titled “Write a Note and Shoot Yourself Today” in which he describes looking back at an old photo of himself and remembering everything about his 9-year-younger self.  A great idea as I am in my first 3 months as a “Junior DBA” and this is a great time to annotate my growth thus far and a baseline of where I’ll be heading over the next few years.

So here I am, May 20, 2013.  3 Months into my DBA Career.
Me_Today_May_20_2013_cropped

 

Our current system is odd to me.  Until this year our user interface has been developed solely in MS Access Forms.  Our older plants use Oracle Rdb through OpenVMS.  Our newer plants use SQL Server, and our future plants will use SQL Server, with the goal that one day all plants will be moved to SQL.  We’re currently in SQL Server 2008, but my project is to upgrade them to 2012 this year.

I’m comfortable with most DDL & DML.  I enjoy figuring out how to pull the information people request and getting it to them in a format that makes sense.

I’m uncomfortable with with the Admin side of the job.  I haven’t done enough restores to be confident in the process.  I am not yet comfortable defining fields, or I guess I’m not really comfortable with the current system / schemes / conventions to feel like I can jump in and start developing tables / databases without the current DBA’s guidance.

This year I want to learn how to completely manage my databases.  Backups, Restores, current Triggers, replication, jobs…  By this time next year I want to know everything about our SQL Server environment, and feel confident answering Dev questions.

These past few months I’ve taken some training courses to prepare for MS Exams 70-461, 462, 463, 464 & 465. I’ve learned a lot.

My goal for the next 12 months is to take exams 461, 462, and 463 to earn my MCSA.

My accomplishment so far has been to write a C# application which helps in database restoration by generating scripts based on transaction logs that are to be restored.

 

So that’s a snapshot of me today!  My interest is piqued in what this will look like next year!  I’ve just scheduled an update on my calendar for 5/19/2014

  5 comments for “Snapshot of a DBAGooner

  1. May 20, 2013 at 1:15 pm

    Oooo, I love the idea of updating the snapshot once a year. Good luck on your journey, man!

    • Ryan @DBAGooner
      May 21, 2013 at 1:36 pm

      Thanks Brent. The journey is just starting and I have a long way to go but plenty of time to get there. I appreciate you popping in.

  2. May 21, 2013 at 1:44 pm

    Great of you to do this, and good luck in your path to getting certified and building your career.

    • Ryan @DBAGooner
      May 21, 2013 at 2:13 pm

      Thanks Glenn. I’m excited to get started, and love the support of the community.

Leave a Reply

Your email address will not be published. Required fields are marked *