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.
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