Andy Hill

Current

• Assistant Database Administrator at Murray State University

Past

• Web Analyst/Programmer at City of Owensboro, KY
• Interactive Programmer at Gragg Advertising
• Academic Support Specialist at Murray State University

see less...

Education

• Murray State University
• Murray State University

Recommended

1 person has recommended Andy

Connections

38 connections

Industry

Information Technology and Services

Andy Hill’s Summary

I'm passionate about information technology. I believe information technology can make our world a better place.

Particularly interested in relational database design, virtualization, VMware, project management, KPI & metrics, data mining, emerging technologies, python/djagno, SQL, online advertising/marketing, business continuity, disaster planning, web analytics, ecommerce, and social graphs.

Recent accomplishments:

- Planned and implemented migration of 30+ SQL Server 2000 databases to SQL Server 2005

- Salvaged e-commerce project and increased online sales over 100%

- Coordinated and performed hardware/software upgrades to ESX Servers drastically increasing performance and fault tolerance

- Published by VMware @ Planet V12N for virtualization blog "Virtual Andy"

- Implemented a Disaster Recovery contract

Andy Hill’s Specialties:

relational database design, virtualization, VMware, success metrics, data mining, emerging technologies, SQL, online advertising/marketing, business continuity, ETL, disaster planning, web analytics, ecommerce, and social graphs

Andy Hill’s Experience

• Assistant Database Administrator

  Murray State University

  (Educational Institution; 1001-5000 employees; Higher Education industry)

  November 2007 — Present (2 years 1 month)

  Responsibilities:
  
  Database Administrator: SQL Server 2000, SQL Server 2005, MySQL and DB2
  
  Virtual Infrastructure Administrator: VMware ESX 3.5 (4 hosts, ~35 VMs)
  
  Accomplishments:
  
  - Planned and executed the migration of 40+ databases from SQL Server 2000 to SQL Server 2005
  
  - Updated/managed ETL processes from mainframe to DB2/SQL Server 2000/SQL Server 2005.
  
  - Planned and executed the upgrade of Virtual Infrastructure adding network, storage, and hardware redundancy to ESX hosts

• Web Analyst/Programmer

  City of Owensboro, KY

  (Information Services industry)

  December 2006 — November 2007 (1 year )

  Redesigned local Utility Company's Online Bill Payment site for greater ease of use and cross browser compatibility
  
  Overhauled 5 websites simultaneously while performing routing updates/revisions to existing sites
  
  Designed, Developed and Launched Property Tax Payment website for citizens to make online bill payments
  
  Created several interactive maps related to citizens needs
  
  Used existing APIs such as Flickr/Google Maps to reduce cost and development time
  
  Configured Apache/PHP to use unixODBC to connect to IBM iSeries machine (which used DB2) to interact with legacy applications
  
  Developed custom PHP/MySQL CMS with LDAP integration for website management
  
  Migrated web server from PHP4 to PHP5, MySQL 3.x MySQL 5, dynamically configured virtual hosts with Apache 2 and SSL Certificates

• Interactive Programmer

  Gragg Advertising

  (Privately Held; 11-50 employees; Marketing and Advertising industry)

  July 2006 — November 2006 (5 months)

  Designed, implemented, and reported on Direct Response E-mail Marketing Campaigns down to client ROI
  
  Developed an online shopping cart using a heavily modified osCommerce, PHP, and MySQL
  
  Wrote custom job to migrate store data to client's proprietary shipping/packing system
  
  Increased client sales by over 100% with highly optimized checkout process
  
  Reported on client sales by geographic location, dollars spent, and advertising campaign ROI
  
  Worked with creative department to create attractive convertible websites
  
  Analyzed all client and internal website traffic by search engine referral
  
  Optimized internal and client websites for higher search engine visibility

• Academic Support Specialist

  Murray State University

  (Educational Institution; 1001-5000 employees; Higher Education industry)

  August 2001 — May 2006 (4 years 10 months)

  Developed inventory system to aid purchasing decisions in Microsoft Access and ColdFusion
  
  Coded a statistics system which led to intelligent business decisions that saved public computer labs over $25,000
  
  Spearheaded the migration of over 300 pieces of legacy content to a standards-compliant redesign which emphasized accessibility (US Govt Section 508 Compliance), usability and uniformity
  
  Produced a Clock in/Clock out system for computer lab workers which minimized timecard discrepancies
  
  Taught training workshops for faculty and students on Dreamweaver, Microsoft Access, Blogging, and other high-tech topics

Andy Hill’s Education

• Murray State University

  Masters of Science , Information Systems , 2008 — 2010 (expected)

• Murray State University

  Bachelors of Science , Business, Computer Information Systems , 2001 — 2006

  (E-Commerce Emphasis) AACSB Accredited

Additional Information

Andy Hill’s Interests:

relational databases, performance metrics, linux, data models, website analytics, ETL processes, software development methodologies, disaster recovery/business continuity, technology evangelism, the social graph/social software, python, vmware, esx, virtualization

Andy Hill’s Contact Settings

Interested In:

• reference requests
• getting back in touch