Banner Image

All Services

Programming & Development

Database Design

$47/hr Starting at $25

Hello, I have worked on many different database projects from small optimizations of queries to designing a complete system to drive your website with efficient data. I can troubleshoot complex queries and refactor them into more optimal execution plans. My longest query to date is over 1000 lines long, generates 126 columns of data and executes in under 1 minute. This query is one report (of many) that run across a dataset of over 50 million rows (comprising 50+ GB of data) across 113 tables on a high-availability MS SQL 2012 clustered database. I can help you - reach out to me and let's get your problems solved. Thanks.

About

$47/hr Ongoing

Download Resume

Hello, I have worked on many different database projects from small optimizations of queries to designing a complete system to drive your website with efficient data. I can troubleshoot complex queries and refactor them into more optimal execution plans. My longest query to date is over 1000 lines long, generates 126 columns of data and executes in under 1 minute. This query is one report (of many) that run across a dataset of over 50 million rows (comprising 50+ GB of data) across 113 tables on a high-availability MS SQL 2012 clustered database. I can help you - reach out to me and let's get your problems solved. Thanks.

Skills & Expertise

Data BackupData ModelingHigh AvailabilityIndexingLinuxMicrosoft SQL ServerMsMySQLServer AdministrationSQLT SQLT SQL Stored ProceduresTroubleshootingWindowsWindows Server

19 Reviews

  • AOSWebWorks says,

    Quick 1 page CSS job, and Paul was terrific. He got it donefast; great quality; great communication. We'd hire him again!

    for CSS needed for 1 page on Mar 26, 2009

  • Beatrice_Vergano says,

    Absolutely fantastic. He called to confirm we were happy AND sent us "the fix" via email so we knew what had happened and how to fix it. PLUS, he responded in less than 24 hours! Paul is simply fabulous and we will use him and refer him! What a delightful exchange!

    for joomla corrections on Mar 20, 2009

  • Bryan_Hendricks says,

    this guy rocks! quick and efficient - I got a thorough explanation of what was going on - will use again for any project!

    for IPNMonitor & PHPMailer; "bareLF" error on Mar 05, 2009

  • Jeffrey_Hotz says,

    Paul was great to work with - very available when I needed help, very patient when other things got higher priority and very knowledgeable about LAMP and Security.

    for LAMP Website Security Review/Advisor on Mar 04, 2009

  • Tom_Haney1 says,

    Paul Hirsch solved a web problem that we had. His cost was reasonable, and the work was excellent. He was able to accomplish the work in the timeframe discussed, and most importantly, it worked the way it was suppose to work. I will certainly work with guru and Paul again for future projects.

    for Simple code needed on Mar 01, 2009

Sign up or Log in to see more.