Who am I?
My name is Andy Hayes
What do I do?
I am a Database Administrator (DBA).
My background and current position
I have been working in IT since 1997 and as a DBA since 2003. Since I became a DBA, I have been working predominantly with Microsoft SQL Server in versions 2000, 2005 and 2008. However in the last 7-8 years I have also been managing MySQL servers (version 5 and 5.5), working with Oracle’s Endeca product, Solr and more recently MongoDB, a product which I am now a certified DBA in.
My current role is split between managing my team and being a DBA. As a DBA, I help to manage all of the administration across the servers including backup, replication, security and performance tuning. I also help design and build data integration solutions using SQL Server Integration Services (SSIS).
Why am I writing this blog?
When I started working with database software, it quickly became apparent just how much there is to learn and how quickly the industry is moving. SQL Server is not just a database engine for storing and retrieving data. There is so much more which a database professional can do to provide a solution to the business. SSIS, SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) provide powerful ways of transforming, reporting and analysing data and one can become an expert in any of these categories alone.
I wanted to start a blog as a way of noting down my experiences so that others could benefit from them either simply because they were interested or that they have a problem which they are trying to solve. This blog will also help me develop my skills as a database professional as I research and write about new topics which I have not touched upon before.
I welcome contributions to my blog in the form of comments and guest posts. If you want to write a guest post, please get in touch.
Keep in Touch
I know I will enjoy writing this content and I hope you enjoy reading it and find it useful.