Database Administrator

I have been an IT professional since 1979 and a MySQL database administrator since 2005. I have worked at several companies with large, complex MySQL installations: Impact Telecom, Hoovers.com and Indeed.com.

Most recently I have been employed by Impact Telecom as the Senior MySQL Database Administrator and am responsible for a large number of very active databases. I maintain database installations on about 60 different servers, all Linux. These servers, which include many replication slaves, collectively hold about 36 Terabytes of data.

The various replication configurations I have handled include simple master-slave, cascading master-slave, and master-master. Some of the databases are running partial replication. As the database administrator I also review queries that prove to be unexpectedly long-running and adjust them to be more efficient.

I am also a programmer, specializing in database programming and writing database-backed web pages. I have written hundreds of scripts to maintain databases, display information, and trim tables on a regular basis. I program almost entirely in Perl and PHP on Linux servers using cron to schedule my jobs. Several of my web pages are heavily used by IT personal because they give insight into what is happening with the databases in terms of replication, disk space usage, number of tables, and memory usage.