My name is Derik Hammer. I’m a Database Administrator in Virginia Beach, VA. Most of my experience is focused on your traditional or maintenance related tasks of database administration. Like many of you, I didn’t wake up one day with a sudden urge to work with data.
It started when I was a freshman in high school. I had more free periods than I knew what to do with. I’d pace around, waiting for my next class to start. One day, a friend inquired why I was wandering the halls. He invited me into a key-pad locked room.
Inside was heaven.
The room wasn’t large, but it was big enough for several computer workstations. We spent the entire period playing Doom and Quake.
With this new utopia discovered, I had to gain regular access. I learned the room was used by the student technology club. Anyone could join and enjoy the perks, provided one actively participates in some type of technology project, as a group or individually. I joined immediately.
At first, I helped with the public access broadcasting studio because it was a project without end. I could get my participation credit working as a wire monkey. Soon after, I was hanging out with the other members socially. That’s when I got the spark for programming. There were a few kids in the club that to this day, I consider geniuses. Two of them loved coding in C++ and VB6.
Through high-school and my Naval career, I honed my skills in QBASIC, VB6, VB.NET, C++, C#, PHP, etc. By end of my Naval contract, I realized I had always avoided graphical projects. I was certainly capable, but artistic work never appealed to me. I wanted to deal with the back-end. Even when I began a project for a text-based game, I coded the support engines and databases before the project fell off my radar.
That was when I made the choice to become a DBA. At the time, I hadn’t had a paid programming job or database work, but I knew it was for me. Every day, my passion continues to thrive and I’m convinced this is the proper field for me.
My database related skills:
- Microsoft SQL Server 2000 / 2005 / 2008 / 2008 R2 / 2012
- High-Availability (Windows Clustering)
- Disaster Recovery
- Data Backup planning, maintenance, and implementation
- MS SQL Server Replication
- MySQL Replication
- Log Shipping
- Database Mirroring
- Configuring and Developing with SQL Server Integration Services
- Configuring SQL Server Reporting Services
- Configuring SQL Server Analysis Services
- T-SQL DDL / DML
- Data Extraction, Transforming and Loading (ETL) using SSIS and Bulk Insert
- SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
- Trigger based Auditing
- Query Tracing
- Policy Based Management