Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q4KQa-0004aZ-6v for pgsql-jobs@arkaria.postgresql.org; Wed, 31 May 2023 11:55:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q4KQZ-0003Or-2H for pgsql-jobs@arkaria.postgresql.org; Wed, 31 May 2023 11:55:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q4BTO-0004ij-1V for pgsql-jobs@lists.postgresql.org; Wed, 31 May 2023 02:22:02 +0000 Received: from mail-ot1-x32f.google.com ([2607:f8b0:4864:20::32f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q4BTK-003BQT-5Z for pgsql-jobs@postgresql.org; Wed, 31 May 2023 02:22:01 +0000 Received: by mail-ot1-x32f.google.com with SMTP id 46e09a7af769-6af6f4a0e11so3964244a34.0 for ; Tue, 30 May 2023 19:21:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=getstoreconnect.com; s=google; t=1685499716; x=1688091716; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=NtdyxDGbfCwhWGLkHuOecd1OzTX4E2uZdSlz4GNPWuM=; b=AU/3zzZGpLh3O2Zj1BVRGaG/s+Q4B9Rrx0z5QuIMFwKdjk5BNGhm8msvyAw6/uNRHR wJOX/ZX7FmZVebk/GkKaqgrGZKun83OlOuAWCTwM8mV59zpy9KREv7kQ7UVCYKFgRMh8 9ejLVnFXg13xPeotQGBIehCbV3RP7fYv9QExJD9Lw3spkouVjhSztXdCbud4dpAlIgj7 0F6An7HbKM4gZf9bbT5xQvyO3y2k/SkDX3jEdaJC9qrPJ20T67UBZjj4XFs2NVotlSpc 63GziX1B+jEpqzSo27O1zedVQAqhZOthSmK72+faw1nG8erJbe7sUz8rao7eFpE/OU+z QH1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685499716; x=1688091716; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=NtdyxDGbfCwhWGLkHuOecd1OzTX4E2uZdSlz4GNPWuM=; b=QoHi4zrcQHjRsnh1LcvkjADS8uQVwHmH2dePDyMPf8zlsghRhZ0BpU77cp4hu8FEL2 iwprrYPZRi8gR92sBYBWWEq+6H/mGXMgqf+9vnwT25Wqm2MSnN0MlXtlrwz0dtazYZU6 rOEeGwGbATZhMvJRL7zzegzSORDxv42IDKPpxsJwGrqHXimk+2MrAqcJ9UNHj62wzg8B IBKbYhygszfSZgzI4NK4xk73f/gBBpu6EvBXYJD9hvzbxYXUK18tB3hmUnLgO7m32K1+ DCsKWeAhuGNQknJsD++45S9BkvLogxR1F8jPk3LlOtdkF8fT/jqLoOp0aX2a6lpdz7em Ujew== X-Gm-Message-State: AC+VfDwxGnJOy3G262o+1QqbA6pWbau45duE6VYOHvEoQkg3KMaVs6uV j+dFApCS1TNEgMRHuby2Mv2lGczYsztWt3WtJXq4BiTwwnXMH4hqJYA= X-Google-Smtp-Source: ACHHUZ6QjNDXOer68uK7t3G1dSTYznjkrkJL7R9IxFtgI1fGY8qLozbipHcjEj446SUSsgLfscmfmXlVoWh2T+g4YeU= X-Received: by 2002:a05:6358:9312:b0:127:8ab0:31f4 with SMTP id x18-20020a056358931200b001278ab031f4mr253175rwa.16.1685499716232; Tue, 30 May 2023 19:21:56 -0700 (PDT) MIME-Version: 1.0 From: Kate Gee Date: Wed, 31 May 2023 12:21:45 +1000 Message-ID: Subject: Looking for Contracted Part Time PostgreSQL Expert - 100% Remote To: pgsql-jobs@postgresql.org Content-Type: multipart/alternative; boundary="000000000000db083705fcf3fb37" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000db083705fcf3fb37 Content-Type: text/plain; charset="UTF-8" # Job Description:StoreConnect (https://getstoreconnect.com) are looking for a senior PostgreSQL contractor to help one of our team members improve the performance and reliability of our database triggers and process as well as improve our PostgreSQL related automated tests and pipeline.StoreConnect is an eCommerce system built on top of Salesforce, we synchronise changes from Salesforce into and from individual and multi tenanted PostgreSQL databases for our public facing eCommerce application to read and write to. This process relies heavily on PostgreSQL triggers to ensure that the right records are updated and that dependent records and views are updated. We also plan to use tooling such as pg_notify to trigger events within the public facing website to trigger pre-caching of important views and content.Our team is very familiar with PostgreSQL, but we are hitting the limits of our internal knowledge, and we would like an expert to come in and pair with our lead developer on this project to identify and fix performance issues and provide knowledge transfer to improve our internal teams skills.We are currently using PostgreSQL version 15.3.# Required Skills:You need to be the expert on all things PostgreSQL for us. Deep knowledge in triggers, materialised views, pg_notify and the like are core to what we are looking for. You also need to be the sort of person that loves sharing your knowledge and working with an existing developer to get them up to speed.# Optional Skills:If you know or have worked with Ruby on Rails, Salesforce at a database level or Heroku Connect, that is definitely a bonus, but really not required.# Location:You can work from anywhere you want and be flexible with hours, with as little as 2-3 per day if needed. The developers you will be working with are in GMT+8 and GMT+10. Excellent spoken English is a must to ensure smooth operation.# Term:Initially this will be a short project to improve the performance of the existing triggers (perhaps 4-6 weeks) and see where we can improve further for future work. But there is the potential for this to become a longer term or regular engagement. We can start on this as soon as you are ready.# Compensation:Price will be dependant on seniority, but we are budgeting a $5-6k per week as a short term consultant full time rate.# About StoreConnect:StoreConnect is a 100% remote work company with developers and team members across the world. We are developer friendly and know that you get your best work done when left alone to focus on that work. Our meeting motto is "a short meeting is a good meeting" and we work hard to avoid meetings for meetings sake. We are a Salesforce AppExchange solution and you can read more about us at https://getstoreconnect.com/# How to ApplyPlease email me at hr@getstoreconnect.com with your resume and why you think you'd be good for the role. -- Kind Regards, Kate Gee Establishment Manager *Get Store**Connect* | https://getstoreconnect.com --000000000000db083705fcf3fb37 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

# Job Description:StoreConnect (https://getstoreconn= ect.com) a= re looking for a senior PostgreSQL contractor to help one of our team membe= rs improve the performance and reliability of our database triggers and pro= cess as well as improve our PostgreSQL related automated tests and pipeline= .StoreConnect is an eCommerce syst= em built on top of Salesforce, we synchronise changes from Salesforce into = and from individual and multi tenanted PostgreSQL databases for our public = facing eCommerce application to read and write to.=C2=A0 This process relie= s heavily on PostgreSQL triggers to ensure that the right records are updat= ed and that dependent records and views are updated.=C2=A0 We also plan to = use tooling such as pg_notify to trigger events within the public facing we= bsite to trigger pre-caching of important views and content.<= span style=3D"color:rgb(29,28,29);font-family:Slack-Lato,Slack-Fractions,ap= pleLogo,sans-serif;font-variant-ligatures:common-ligatures;background-color= :rgb(255,255,255)">Our team is very familiar with PostgreSQL, but we are hi= tting the limits of our internal knowledge, and we would like an expert to = come in and pair with our lead developer on this project to identify and fi= x performance issues and provide knowledge transfer to improve our internal= teams skills.We are currently using Post= greSQL version 15.3.# Required Skills:You need to be the expert on all things Post= greSQL for us. Deep knowledge in triggers, materialised views, pg_notify an= d the like are core to what we are looking for.=C2=A0 You also need to be t= he sort of person that loves sharing your knowledge and working with an exi= sting developer to get them up to speed.= # Optional Skills:If you know or have wor= ked with Ruby on Rails, Salesforce at a database level or Heroku Connect, t= hat is definitely a bonus, but really not required.# Location:You can work from a= nywhere you want and be flexible with hours, with as little as 2-3 per day = if needed. The developers you will be working with are in GMT+8 and GMT+10.= Excellent spoken English is a must to ensure smooth operation.# Term:Initially th= is will be a short project to improve the performance of the existing trigg= ers (perhaps 4-6 weeks) and see where we can improve further for future wor= k. But there is the potential for this to become a longer term or regular e= ngagement.=C2=A0 We can start on this as soon as you are ready.# Compensation:Pric= e will be dependant on seniority, but we are budgeting a $5-6k per week as = a short term consultant full time rate.= # About StoreConnect:Stor= eConnect is a 100% remote work company with developers and team members acr= oss the world. We are developer friendly and know that you get your best wo= rk done when left alone to focus on that work. Our meeting=C2=A0motto is &q= uot;a short meeting is a good meeting" and we work hard to avoid meeti= ngs for meetings sake.=C2=A0 We are a Salesforce AppExchange solution and y= ou can read more about us at=C2=A0https://getstoreconnect.c= om/# How to ApplyPlease email me at=C2=A0hr@getstoreconnect.com=C2=A0with your res= ume and why you think you'd be good for the role.

-- <= br>
Kind Regards,<= /div>
Kate Gee
Establishment Manager

=
Get StoreConnect= =C2=A0|=C2=A0https://getstoreconnect.com
--000000000000db083705fcf3fb37--