Jun 2010 – Present · 15 yrs 11 mos · United States

• I make databases go faster.

Apr 2008 – Jun 2010 · 2 yrs 2 mos

Jan 2007 – Present · 19 yrs 4 mos

• Speaker - presented at many PASS Summit conferences, regional SQLSaturday conferences, and local user group chapters.

Mar 2006 – Mar 2008 · 2 yrs

• Microsoft SQL Server 2000 and 2005 performance tuning including index tuning, query modifications, partitioning and hardware optimization. Database administration for databases up to 2 terabytes, including T-SQL coding, stored procedures, backup/recovery, high availability. SAN administration for nearly 100 terabytes of storage.

Oct 2005 – Mar 2006 · 5 mos

• Managed 200gb sales & inventory data warehouse on SQL Server 2000, migrated to 2005.
• Designed and populated data mart reporting tables, views and stored procedures.
• Wrote stored procedures to audit and cleanse incoming data from other enterprise systems including AS400, DataStage.
• Worked with BusinessObjects developers to optimize their queries, test their reports, and validate their logic.
• Linked customer data with TDLinx / ACNielsen demographic data for better sales reporting.
• Implemented automatic source code control so that all database schema changes were logged in Visual Source Safe every 4 hours.
• Used partitioning in SQL Server 2000 to handle tables with 150+ million rows of data.
• Created and tested migration plan for SQL Server 2005.
• Responsible for backups & restores across production, QA and development servers.
• Data modeling & design using Case Studio.
• Wrote technical documentation for other developers and the client’s network teams.

Oct 1999 – Oct 2005 · 6 yrs

• Grew & tuned database servers to handle rapid growth from a single machine handling a few dozen web clients to a pair of replicated SQL servers handling thousands of logins per day with 24/7 uptime to service clients around the world.
• Reinvented company reporting from shipping tens of thousands of monthly paper reports to thousands of hotels, to using web-based reports available instantly. Customer satisfaction went up, printing and shipping expenses disappeared, and profit increased.
• Created new web-based tools being used by hundreds of hotels like The Venetian, Colonial Williamsburg, Intrawest Resorts. Reinvented traditional hotel paper comment cards: these hotels now email the guest within 24 hours of checkout, email the guest's feedback to the hotel immediately, and respond quickly.
• Created a company intranet that controlled everything from help desk requests, customer supply orders, printing & shipping, software development requests.

Sep 1997 – Oct 1999 · 2 yrs 1 mo

• Created web-based sales management tool for marketing staff to manage daily productivity
• Wrote, designed and produced internet-based data transmission system to get financial numbers to headquarters within 30-60 seconds rather than 1-2 hours.
• Designed company web sites and intranet in ASP and SQL Server 7.
• Implemented Windows NT Servers & Workstations to replace Unix terminals, including purchasing & installation.
• Managed 30-computer network at corporate office, plus networks at over 25 hotels, including purchasing, choosing contractors for repairs, and internet services.
• Trained company staff on accounting, computer use. Led presentations at company-wide conferences.
• Wrote company internal audit and accounting manual.
• Responsible for ensuring license compliance and training staff.
• Reported directly to Chief Financial Officer.

Aug 1994 – Sep 1997 · 3 yrs 1 mo

• Wrote, designed and produced company budget spreadsheets for hotels and imported them into the accounting system.
• Managed 20-node Novell Netware network and Windows workstations.
• Designed & maintained company web site.
• Was instrumental in regional managers investigating ways to cut costs and increase efficiencies in hotel budgets.
• Reported directly to Vice President of Operations.