{"id":5916,"date":"2018-11-28T12:49:37","date_gmt":"2018-11-28T12:49:37","guid":{"rendered":"http:\/\/www.garysieling.com\/blog\/?page_id=5916"},"modified":"2018-11-28T12:49:37","modified_gmt":"2018-11-28T12:49:37","slug":"postgres-consulting","status":"publish","type":"page","link":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/","title":{"rendered":"Postgres Consulting"},"content":{"rendered":"<p>I&#8217;ve been working as a software developer for over 15 years, and have a strong interest in database technology.<\/p>\n<p>At each job I&#8217;ve held, I&#8217;ve done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres.<\/p>\n<p><b>Contact:<\/b> gary.sieling@gmail.com<\/p>\n<h2>Work History<\/h2>\n<p><b>Wingspan, an IQVIA Company: Life sciences Platform<\/b><br \/>\nI&#8217;ve worked on many projects over 10 years at Wingspan. I built a data warehousing and reporting system for a Life Sciences product for a top tier Pharma, using an Oracle database.<\/p>\n<p>I helped migrate this application to a self-hosted SaaS product on Postgres.<\/p>\n<p>I made major contributions to the data architecture of the product around auditing, and invented a way to dramatically improve the scalability of ACLs using techniques based on compression.<\/p>\n<p>I introduced Docker to the company &#8211; writing scripts to snapshot and reconstruct internal environments.<\/p>\n<p>I did the backend research to add full text indexing to our Postgres database and to the processes used to index data to Solr.<\/p>\n<p><i>&#8220;Gary has always been one of the most trusted and valued members of our software engineering organization.&#8221;<\/i> &#8211; from a performance review<\/p>\n<p><b>Thomson Reuters<\/b><br \/>\nWorked on a data warehousing app that generated statistics across all U.S. litigation for use in law firm marketing. My role was a cross between front-end UI developer and building an ORM layer over the data warehouse.<\/p>\n<h2>Public Speaking<\/h2>\n<p>I&#8217;ve spoken at several meetups and conferences:<\/p>\n<p><b>Solr\/Lucene Revolution:<\/b> <a href=\"https:\/\/www.youtube.com\/watch?v=e_ia1DRz3l8\">Indexing Videos in Solr<\/a><\/p>\n<p><b>AI With The Best:<\/b> &#8220;Building a Discovery Engine with Machine Learning&#8221;<\/p>\n<p><b>Philly Area Scala Enthusiasts:<\/b> &#8220;Exploring Word2vec in Scala&#8221;<\/p>\n<p><b>Philly Java Users Group:<\/b> <a href=\"https:\/\/www.meetup.com\/PhillyJUG\/events\/246497520\/\">GPU Programming for Java Developers<\/a><\/p>\n<p><b>Postgres Open, 2011:<\/b> <a href=\"https:\/\/www.youtube.com\/watch?v=vpMf5JkZ5Zs\">Immutable Data in Postgres<\/a><\/p>\n<p>Contact: gary.sieling@gmail.com<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been working as a software developer for over 15 years, and have a strong interest in database technology. At each job I&#8217;ve held, I&#8217;ve done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres. Contact: gary.sieling@gmail.com Work History Wingspan, an IQVIA Company: Life sciences Platform I&#8217;ve &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Postgres Consulting&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"I&#039;ve been working as a software developer for over 15 years, and have a strong interest in database technology. At each job I&#039;ve held, I&#039;ve done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres. Contact: gary.sieling@gmail.com Work History Wingspan, an IQVIA Company: Life sciences Platform I&#039;ve\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Gary Sieling - Software Engineer\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Postgres Consulting - Gary Sieling\" \/>\n\t\t<meta property=\"og:description\" content=\"I&#039;ve been working as a software developer for over 15 years, and have a strong interest in database technology. At each job I&#039;ve held, I&#039;ve done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres. Contact: gary.sieling@gmail.com Work History Wingspan, an IQVIA Company: Life sciences Platform I&#039;ve\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-11-28T12:49:37+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2018-11-28T12:49:37+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Postgres Consulting - Gary Sieling\" \/>\n\t\t<meta name=\"twitter:description\" content=\"I&#039;ve been working as a software developer for over 15 years, and have a strong interest in database technology. At each job I&#039;ve held, I&#039;ve done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres. Contact: gary.sieling@gmail.com Work History Wingspan, an IQVIA Company: Life sciences Platform I&#039;ve\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/postgres-consulting\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.garysieling.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/postgres-consulting\\\/#listItem\",\"name\":\"Postgres Consulting\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/postgres-consulting\\\/#listItem\",\"position\":2,\"name\":\"Postgres Consulting\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog#listItem\",\"name\":\"Home\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#organization\",\"name\":\"Gary Sieling\",\"description\":\"Software Engineer\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/postgres-consulting\\\/#webpage\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/postgres-consulting\\\/\",\"name\":\"Postgres Consulting - Gary Sieling\",\"description\":\"I've been working as a software developer for over 15 years, and have a strong interest in database technology. At each job I've held, I've done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres. Contact: gary.sieling@gmail.com Work History Wingspan, an IQVIA Company: Life sciences Platform I've\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/postgres-consulting\\\/#breadcrumblist\"},\"datePublished\":\"2018-11-28T12:49:37+00:00\",\"dateModified\":\"2018-11-28T12:49:37+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/\",\"name\":\"Gary Sieling\",\"description\":\"Software Engineer\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Postgres Consulting - Gary Sieling","description":"I've been working as a software developer for over 15 years, and have a strong interest in database technology. At each job I've held, I've done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres. Contact: gary.sieling@gmail.com Work History Wingspan, an IQVIA Company: Life sciences Platform I've","canonical_url":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.garysieling.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/#listItem","name":"Postgres Consulting"}},{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/#listItem","position":2,"name":"Postgres Consulting","previousItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog#listItem","name":"Home"}}]},{"@type":"Organization","@id":"https:\/\/www.garysieling.com\/blog\/#organization","name":"Gary Sieling","description":"Software Engineer","url":"https:\/\/www.garysieling.com\/blog\/"},{"@type":"WebPage","@id":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/#webpage","url":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/","name":"Postgres Consulting - Gary Sieling","description":"I've been working as a software developer for over 15 years, and have a strong interest in database technology. At each job I've held, I've done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres. Contact: gary.sieling@gmail.com Work History Wingspan, an IQVIA Company: Life sciences Platform I've","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.garysieling.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/#breadcrumblist"},"datePublished":"2018-11-28T12:49:37+00:00","dateModified":"2018-11-28T12:49:37+00:00"},{"@type":"WebSite","@id":"https:\/\/www.garysieling.com\/blog\/#website","url":"https:\/\/www.garysieling.com\/blog\/","name":"Gary Sieling","description":"Software Engineer","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.garysieling.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Gary Sieling - Software Engineer","og:type":"article","og:title":"Postgres Consulting - Gary Sieling","og:description":"I've been working as a software developer for over 15 years, and have a strong interest in database technology. At each job I've held, I've done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres. Contact: gary.sieling@gmail.com Work History Wingspan, an IQVIA Company: Life sciences Platform I've","og:url":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/","article:published_time":"2018-11-28T12:49:37+00:00","article:modified_time":"2018-11-28T12:49:37+00:00","twitter:card":"summary_large_image","twitter:title":"Postgres Consulting - Gary Sieling","twitter:description":"I've been working as a software developer for over 15 years, and have a strong interest in database technology. At each job I've held, I've done significant performance tuning efforts and worked on both OLAP and data warehouses in both Oracle and Postgres. Contact: gary.sieling@gmail.com Work History Wingspan, an IQVIA Company: Life sciences Platform I've"},"aioseo_meta_data":{"post_id":"5916","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2023-02-04 16:01:42","updated":"2026-07-06 00:37:34","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.garysieling.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tPostgres Consulting\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.garysieling.com\/blog"},{"label":"Postgres Consulting","link":"https:\/\/www.garysieling.com\/blog\/postgres-consulting\/"}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/pages\/5916"}],"collection":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/comments?post=5916"}],"version-history":[{"count":0,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/pages\/5916\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/media?parent=5916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}