mark wehmhoefer

SQL Server DBA with responsibilities for the monitoring, troubleshooting, administration and management of all SQL Servers.

SQL Server DBA III with responsibilities for the setup, automation, monitoring, troubleshooting, administration and management of all SQL Servers.

SQL Server DBA with responsibilities for the monitoring, troubleshooting, administration and management of the SQL Server environment for enterprise wide, high performance, web and client server applications for 50 plus systems.

* Work with project managers, developers, QA and technical support to implement latest database modifications. Translate business needs into scalable and reusable technical database specs. Evaluate and optimize inefficient T-SQL and suggest application logic modifications for better performance. * Development DBA: * Translate data models into a physical database design with an emphasis on performance * Create and maintain database objects such as stored procs, views, indexes and triggers * Support DBA: * Identify and resolve database system failures and performance problems at client sites * Solve and investigate third level support issues at client sites * Production DBA: * Perform SQL Server setup, configuration, installation and maintenance tasks * Ongoing performance tuning and monitoring of servers and databases for Disk space utilization, backup and recovery management * Deploy and roll out database projects from test to development to client production environments

MS SQL Server DBA for 4 remote locations, 31 database servers, 55 replication paths and over 5000 users. Expertise using SQL Admin Tools (Enterprise Manager, ISQL/w, MS Query, Access etc.). Worked as a team member with 5 DBA's to ensure 24 hour x 7 day support of all corporate databases.

* “Hands-on” manager of 6 people and several projects: Web e-commerce applications for customer ordering, inquiry, maintenance, and reporting * Extranet Customer Support and Activity Tracking System * built and maintained the Web FTP site * Y2K analysis and planning * development of an vehicle warranty tracking system. Other responsibilities included: DBA for all SQL Server development * managed and maintained customer PC based products * managed consultants and programmers on various client server & web based systems * maintained data interfaces with AS400.

Design thru implementation of a comprehensive physician referral system called LIFEMATCH. It was the most widely used PC based system in the Health Care industry. Established project schedules and completed 20 new software releases, all with zero downtime to clients. Managed internally requested enhancements to a 200+ PC workstation call center system in 3 cities. In 5 years, I personally designed, programmed and implemented 2000+ enhancements and changes to meet internal and external customer needs. Re-engineered an incoming call center legacy system written in COBOL to a client server system using Visual Basic. The new system saved 25% of operator training time, reduced operator wrap-up time by 45% and sped up on call time by 35%.

Worked on several PC projects and Cobol projects.

Worked on several IBM mainframe Cobol projects for the payroll department.

Worked on many warehouse scheduling system projects in Cobol and IBM Assembler language.

Owner of IT consulting company providing independent contractors and consulting services for various IT projects. Clients included Baxter, Wirtz Corporation, Chicago Stadium and Chicago Blackhawks.