Michael P. Murphy

Database Administrator / Architect / Analyst

Specializing in Microsoft SQL Server and associated technologies. 8644 SW Reese Street

Arcadia, FL 34269

612-***-****

ad0rd7@r.postjobfree.com

EDUCATION

University of Minnesota

Bachelor’s Degree - Computer Science - 1990

Bachelor’s Degree - Business/Economics - 1990

EXPERIENCE

Senior Database Administrator — Bridgetower Media

7/2011 -3/2023

• Administration – Responsible for all aspects of MS SQL Server database server administration including installation, DB creation, DB object creation, profiling, troubleshooting.

• Design and Architecture – Lead application architect and database designer for all customer-facing web applications based on .Net, ColdFusion, WordPress, SOLR, and more.

• Development – Lead developer for all backend SQL Server data transfer systems as well as creation of data abstraction layers using hundreds of SQL Server stored procedures for use in Public Notice and Project Central web applications.

• Operations – Responsible for all day-to-day SQL Server operations such as performance monitoring and enhancement, disaster recovery systems utilizing NetApp snapshot backups across multiple data centers, and tier 1 database service desk related issues.

Database and Application Architect — Polaris Industries 8/2008 -4/2011

• Responsible for all aspects of the Oracle Data Warehouse including data import/export, programming, and data mining tools such as Sales Analyzer and Discoverer.

• Responsible for all import and export jobs to the Polaris CRM environment using Scribe Insight Server and other assorted tools.

• Completed Microsoft course 6234A - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services and subsequently designed and implemented an Analysis Services pilot project for PG&A sales reporting.

• Created a SQL Server data warehouse to hold traffic and usage data from the World Wide Web at Polaris.com. Used SSAS to create searchable data cubes for consumption by end-users via Excel and Sharepoint services.

CORE COMPETENCIES

Microsoft SQL Server

- Server Administration

- Disaster Recovery

- Indexing

- Performance Monitoring

- Security

- Replication

T-SQL

- Stored Procedures

- Functions

- Triggers

Data Modeling

Database Architecture

ETL

- Remote DB

- ODBC

- API

- FTP / SFTP

- Flat Files

Microsoft Office (Word, Excel, etc.)

ANCILLARY TECHNOLOGIES

Oracle

MySQL

Microsoft Access

AWS

BlueConic CDP

APT Falcon

Sharepoint

API

ERWin

Toad

RedGate

NetApp

DNS Administration

SQL Server Consultant —Infocomm Information Resources 5/2007 -6/2008

• Migrated all production SQL Server databases from SQL Server 7 to SQL Server 2005.

• Created jobs for production databases to automatically clean and archive.

• Designed and implemented database structures to maintain tradeshow records. (New market)

• Re-wrote manufacturer and dealer on-line reports to relate web traffic information to customers.

• Created jobs to automatically import and export customer information. SQL Server Consultant —Bridgetower Media

2/2007 -5/2007

• Designed and implemented new data structures as needed by the Bridgetower development team.

• Audited, analyzed, and supported hundreds of database replication schemes across the enterprise.

• Maintained and supported all corporate SQL Server ETL functions.

• Designed, implemented, and supported new database maintenance plans on all production servers.

• Monitored, profiled, and improved performance of production servers.

• Routine backup and restores as requested by the Bridgetower development team.

• Administered SQL Server security in conjunction with active directory. SQL Server Consultant —Montage Inc.

12/2006 -2/2007

• Created Data Transformation Services (DTS) packages to gather customer data.

• Re-wrote stored procedures for cleaning customer data.

• Redesigned warranty import procedures.

• Designed logging functions to help Montage IT staff troubleshoot future problems.

• Performance tests and load balancing on production servers to enhance performance. 1990 - 2006

Upon graduation from college, my first job was a customer service representative for SPEED>S Corporation, an electronic tax filing organization. I quickly moved from that position to a Systems Integrator position. Two years later, I moved to Amcom Software, a voicemail, messaging, and call accounting software developer. I worked there two years installing and integrating systems, then I moved on to Premier One Consultants as a Systems Integrator. This is the position that allowed me to transition my career and utilize the database expertise that was the focus of my degree in college. After a year of systems integration, I was promoted to Project Manager and a year later to Senior Project Manager. As Senior Project Manager I took on the added responsibility of database design for the WorldTrak suite of Customer Relationship Management products. In 1998, I joined the Northwest Airlines Y2K program office and spearheaded a companywide program to certify and remediate all computer systems worldwide. After the year 2000, I spent four years as the Database Administrator/Architect for Infocomm Information Resources and then onto a host of consulting engagements including one for TFG Direct, a telemarketing firm that needed a database system to house marketing programs as well as record calls and responses. That database is still in use today.

Contact this candidate