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 1okqG9-0000dR-5s for pgsql-jobs@arkaria.postgresql.org; Tue, 18 Oct 2022 17:20:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1okqG7-0003Xw-Lj for pgsql-jobs@arkaria.postgresql.org; Tue, 18 Oct 2022 17:20:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1okq9j-0002eK-68 for pgsql-jobs@lists.postgresql.org; Tue, 18 Oct 2022 17:13:31 +0000 Received: from mail-vs1-xe36.google.com ([2607:f8b0:4864:20::e36]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1okq9f-0004zs-9u for pgsql-jobs@postgresql.org; Tue, 18 Oct 2022 17:13:30 +0000 Received: by mail-vs1-xe36.google.com with SMTP id h29so15382221vsq.9 for ; Tue, 18 Oct 2022 10:13:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=onxmaps-com.20210112.gappssmtp.com; s=20210112; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=q0HRrHNu2GMxwyyLzDlZBzsk5Sy2wWuFyQdGHXXYkQY=; b=THGcT5OnEkL01BsERt0TikgVSgLhIAibnFK+est0Am6vtVt9A2F6T6lIIk5QOCVogV bqtXdHMpT80jWUlBGZpkvlDr+RcntjdP8i90L8qJDJRhYvpuDMFrzGnYyTdTMLDnPE+j 3+crm+4ccFq01+GFhRescrV8En1N8S0Bx+X+K4O5I2FRRCheWqlo7YYVP8ICw+z08xYt Oldxq3jqmKB85Y/DhMuBE3x6SLnDGKsNQC6kBK6PPGAIKzWW53Jhyt2P+SI6/mYEBB9t dNaHBxmDGlAQlZO6yGwNRlARk0V2GQ/tSTFhCVMTdNX7MZky4RjtxBfe3GteScOipFLq 6K/Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=q0HRrHNu2GMxwyyLzDlZBzsk5Sy2wWuFyQdGHXXYkQY=; b=1feJBrhovoE74/yWIVdt1QmowrwfeabULAzhMpYCzLi0TcGeql4rtQqOzNWUUoj/1V AYZd88U8w6wdBU01u8Rt0sV2VWZpDC0IRtSF2OXpCH1hRpre7J//weLWnd1VJnECA20s BDGjnsbWk/wLqLoQpg17nbA8Rxqh9DW+JvN1n0mbk5JW4I1QDFGJNeaG4BacgHR7J4bJ bCLUxz91e07mYh3jx1N3HcaY7eAfjE/oQ4tVARsPxbdjdpzgTFAP6RiXmaZ5s/sgiZto 3QEyoFf6qc6sn1AHR715G5JUgNH7hu7etqZJn9MUbqrACAXoiMzYYKvElJfvlA9KsJW/ zhTQ== X-Gm-Message-State: ACrzQf3KTlEw2tkMP2d3mvbaqDLEp+88JCZ1VRdRCT+EkBFhXNtUbwjO ED5XHY4hxhxWmTfkxKar99+XeMIKlSGoedxNdbqYQsuqpXTQSRaxFxXDyzblMD7cA7q/WLZOq38 VTvLU9IpcgMwddBFSaNkgs/Fa4zx1z/+HL6NHNw== X-Google-Smtp-Source: AMsMyM71gv/QeTHM/r4ukh17dkN+W2WcS5sL9oBMWjq1r0inWzZ6iXu0KdOB9gSXtca3YNisPJLbGKwzANhbRX5aFIs= X-Received: by 2002:a67:cf48:0:b0:3a7:d599:32e5 with SMTP id f8-20020a67cf48000000b003a7d59932e5mr2141538vsm.47.1666113205686; Tue, 18 Oct 2022 10:13:25 -0700 (PDT) MIME-Version: 1.0 From: Spencer Houskeeper Date: Tue, 18 Oct 2022 11:13:14 -0600 Message-ID: Subject: Senior PostgreSQL Engineer - Remote USA To: pgsql-jobs@postgresql.org Content-Type: multipart/alternative; boundary="000000000000c7e71405eb52352c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c7e71405eb52352c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable onX maps is looking for a Senior PostgreSQL Engineer to join our team. (Remote USA) If you are interested you can apply at this link: https://onxmaps.hrmdirect.com/employment/job-opening.php?req=3D2248051 *ABOUT onX* onX is a pioneer in digital outdoor navigation. With offices in Missoula and Bozeman, Montana, we are inspired by the landscapes that surround us. We bring our outdoor passion to work every day with a singular goal=E2=80= =93to awaken the adventurer in everyone. We do this by engineering industry-leading technology, and by crafting dynamic outdoor experiences. Through multiple years of growth, we haven=E2=80=99t lost our entrepreneuri= al ethos at onX. We offer a fast-paced, tech-forward environment where ownership and accountability are essential. *WE ARE LOOKING FOR* onX is seeking a *Senior PostgreSQL Engineer *with experience in PostgreSQL and Google Cloud Platform. As an onX PostgreSQL Engineer, you will create, maintain and execute improvements to our databases as we scale our systems to meet product demand. Your focus will be on maintaining database integrity, monitoring performance, troubleshooting incidents, diagnosing root causes, and performing optimization before they become major problems. This is a great opportunity to be a part of a dynamic growing company focused on making an impact on the business and owning highly critical databases. You will be responsible for maintaining our databases in the cloud and working closely with the product development teams to maintain and improve database performance, resolve data problems, and establish standards for database development. This position will report to the Engineering Manager of our Data Automation team. *LOCATION* *Hybrid from Montana or fully remote from select locations.* onX=E2=80=99s corporate offices are located in Missoula and Bozeman, Montana. This position can be performed near a corporate office or remotely from one of onX=E2=80=99s =E2=80=9CBasecamps,=E2=80=9D which are emerging locations whe= re our remote onXers cluster for work and adventure. onX=E2=80=99s current Basecamps are located= within a 120-mile radius of the following: Austin, TX; Denver, CO; Minneapolis, MN; Portland, OR; Salt Lake City, UT; and Seattle, WA. Software Engineering applicants outside of these locations will be considered on an individual basis and still encouraged to apply, *except* f= or AK, HI, IL, MA, NY, ND, OH, WY, and Washington DC. For more information, please contact recruitment@onXmaps.com. Additionally, being authorized to work in the U.S. is a precondition of employment. We do *not* sponsor work visas (of any kind ) for this position at this time. *RESPONSIBILITIES* *(Essential Job Duties)* - Create, maintain and execute improvements to our databases and database standards as we scale our systems to meet growing data and product deman= d. - Build, manage and maintain PostgreSQL databases in the cloud. - Manage the development and implementation of the data model. - Monitor, diagnose, and troubleshoot database incidents, performance issues, and query optimization before they become major problems. - Maintain and upgrade Postgres instances and maintain their integrity. - Own highly critical databases and ensure database security, availability, system performance, optimization, and recoverability. - Manage start/shutdown/back up of database, user permissions/access, query optimization, upgrade/migration of data, write database code. - Collaborate in architectural decisions to guide system design to address database limitations and best practices and work with developers to offe= r recommendations for optimization. - Implement and manage data policy for databases, data warehouses, data caches, and data archives. - Research and implement emerging database technologies to support a growth-focused product and its data needs. - Be available for on-call support as needed. - Collaborate with engineers, SRE, stakeholders, technology vendors, and partners. *REQUIRED QUALIFICATIONS* - Bachelor=E2=80=99s degree in Computer Science, Information Technology,= or equivalent experience. - Familiarity with PostgreSQL in managed services like GCP or cloud infrastructure and working with a large dataset. - Minimum of 5 years of experience in PostgreSQL database administration, information technology, database architecture, or a rela= ted field. - Strong command of SQL and SQL server tools. - Creating stored procedures, triggers, functions, packages, and Logical and Physical database design. - Knowledge of tools used for running queries, performing DB schema changes, and analyzing database activity/performance. - Advanced knowledge of database security, backup and recovery, server setup/operation/configuration, performance diagnostics, and monitoring standards. - Experience in Database Administration for PostgreSQL. - Understanding of replication and how to set up and maintain. - Hands-on experience working with JSON files and Postgres JSON functions and operators. - Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels. - Familiarity with Kubernetes. - Proficient (Solid experience) with Python. - Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels. - Ability to efficiently write database code without compromising data quality, privacy or security. - Technical skills in data analysis, schema design, and data modeling. - You have experience building and debugging distributed, scalable architectures. *PREFERRED QUALIFICATIONS* - Experience with popular Postgres utilities. - PL/pgSQL (a strong plus for other extension languages). - Writing advanced SQL, analyzing developer SQL, and making recommendations for performance tuning SQL, rewriting SQL or adding inde= xes for efficiency, and creating/updating stored procedures. - Experience with databases processing ETL pipeline. - Experience with PostGIS. - Experience in data warehouse solutions such as BigQuery. - Experience with working with a distributed team. - Experience in a high-growth technology company. *PHYSICAL WORKING CONDITIONS* *The following physical requirements represent those that are required to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.* - Sitting - [90%] - Standing - [0%] - Walking - [10%] - Bending - [Occasionally] - Kneeling - [Some] - Lifting - [Up to 25 pounds] - Reaching - [Regularly] - Telephone Use - [Yes] - Computer Use/Manual Dexterity - Yes - Ability to travel - Depends on location, otherwise not anticipated; remote employees typically travel to Montana twice per year. *WHAT WE ARE OFFERING YOU* - Competitive salaries, annual bonuses, equity, and opportunities for growth - Comprehensive health benefits including a no-monthly-cost medical plan - Parental leave plan of four or six weeks fully paid - 401k matching at 100% for the first 3% you save and 50% from 3-5% - Company-wide outdoor adventures and amazing outdoor industry perks - Annual =E2=80=9CGet Out, Get Active=E2=80=9D funds to fuel your active= lifestyle in and outside of the gym - Flexible time away package that includes PTO, STO, VTO, quiet weeks, and floating holidays *onX COMPANY VALUES* *Our principles guide the decisions making of our company. They define the culture at onX, what we have learned through experience, and are the code by which we operate. They are fundamental, enduring, and actionable=E2=80= =93a benchmark by which we measure the team behavior and performance. * We put the *customer *first. We are *passionate*. We win as a *team*. We take *ownership*. We work with *urgency*. We are *curious *and seek the truth. We *innovate *& take risks. *Important Note*: To make sure that our emails always come straight to your inbox, we encourage you to take a moment and designate ClearCompany as a safe sender. All system emails are sent from *@clearcompany.com *or *@email.clrco.com *. Position open until filled. *At onX, we believe that diversity makes us better. *Bringing together a diverse set of backgrounds, ideas, and opinions helps us to achieve our mission to awaken the adventurer in everyone. We are proud to be an equal opportunity employer. onX is committed to equal opportunity not only in our hiring practices but also in our employment practices, including but not limited to development, compensation, and promotion. We strive to build an inclusive work community where everyone can be their authentic self, and together, we win as a team. Come join us! onX is committed to providing reasonable accommodations for individuals in our job application process. If you need assistance or an accommodation, please contact us at --=20 *Spencer Houskeeper* Senior Technical Recruiter Missoula Headquarters 46=C2=B051=E2=80=9911.0272=E2=80=9DN 114=C2=B000=E2=80=9943.6398=E2=80=9DW onXmaps.com --=20 This e-mail message may contain confidential or legally privileged=20 information and is intended only for the use of the intended recipient(s).= =20 onX is not responsible for errors or omissions in this message and denies= =20 any responsibility for any damage arising from the use of e-mail. Any=20 opinion and other statement contained in this message and any attachment=20 are solely those of the author and do not necessarily represent those of=20 the company. --000000000000c7e71405eb52352c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

onX maps is= looking for a Senior PostgreSQL Engineer to join our team. (Remote USA)=C2= =A0

If you are int= erested you can apply at this link:=C2=A0https://onxmaps.hrmdirect.com/employmen= t/job-opening.php?req=3D2248051


ABOUT onX<= /strong>

onX is a pioneer in digit= al outdoor navigation. With offices in Missoula and Bozeman, Montana, we ar= e inspired by the landscapes that surround us. We bring our outdoor passion= to work every day with a singular goal=E2=80=93to awaken the adventurer in= everyone. We do this by engineering=C2=A0industry-leading technology, and = by crafting dynamic outdoor experiences.=C2=A0

Through multiple years of growth, we haven=E2=80=99t lost our = entrepreneurial ethos at onX. We offer a fast-paced, tech-forward environme= nt where ownership and accountability are essential.

WE ARE LOOKING FOR=

onX is seeking a=C2=A0Senior PostgreSQL Engineer=C2=A0with experience in PostgreSQL and Google Cloud Platform.=C2=A0 As an onX = PostgreSQL Engineer, you will create, maintain and execute improvements to = our databases as we scale our systems to meet product demand. Your focus wi= ll be on maintaining database integrity, monitoring performance, troublesho= oting incidents, diagnosing root causes, and performing optimization before= they become major problems. This is a great opportunity to be a part of a = dynamic growing company focused on making an impact on the business and own= ing highly critical databases. You will be responsible for maintaining our = databases in the cloud and working=C2=A0closely with the product developmen= t teams to maintain and improve database performance, resolve data problems= , and establish standards for database development. This position will repo= rt to the Engineering Manager of our Data Automation team.

LOCATION

Hybrid from Montana or fully remote from select locations.=C2=A0onX=E2=80=99s corporate offices are located in Missoula and Bozeman= , Montana. This position can be performed near a corporate office or remote= ly from one of onX=E2=80=99s =E2=80=9CBasecamps,=E2=80=9D which are emergin= g locations where our remote onXers cluster for work and adventure. onX=E2= =80=99s current Basecamps are located within a 120-mile radius of the follo= wing: Austin, TX; Denver, CO; Minneapolis, MN; Portland, OR; Salt Lake City= , UT; and Seattle, WA.=C2=A0

Softw= are Engineering applicants outside of these locations will be considered on= an individual basis and still encouraged to apply,=C2=A0except=C2= =A0for AK, HI, IL, MA, NY, ND, OH, WY, and Washington DC. For more informat= ion, please contact recruitment@onXmaps.com.=C2=A0

Additionally, being authorized to work in the U.S. is a pr= econdition of employment. We do=C2=A0not=C2=A0sponsor work visas (of= any kind ) for this position at this time.

RESPONSIBILITIES

(Essential Job Duties)

=

  • Create, maintain an= d execute improvements to our databases and database standards as we scale = our systems to meet growing data and product demand.

  • Build, manage and maintain PostgreSQL databases in the = cloud.

  • Manage the development and i= mplementation of the data model.

  • Mo= nitor, diagnose, and troubleshoot database incidents, performance issues, a= nd query optimization before they become major problems.

  • Maintain and upgrade Postgres instances and maintain = their integrity.

  • Own highly critica= l databases and ensure database security, availability, system performance,= optimization, and recoverability.=C2=A0

  • Manage start/shutdown/back up of database, user permissions/access, q= uery optimization, upgrade/migration of data, write database code.

    • =

  • Collaborate in architectural decisions to g= uide system design to address database limitations and best practices and w= ork with developers to offer recommendations for optimization.

  • =

    Implement and manage data policy for databases,= data warehouses, data caches, and data archives.

  • Research and implement emerging database technologies to sup= port a growth-focused product and its data needs.

  • Be available for on-call support as needed.

  • Collaborate with engineers, SRE, stakeholders, tech= nology vendors, and partners.

REQUIRED QUALIFICATIONS

  • Bachelor=E2=80=99s degree in Computer Scie= nce, Information Technology, or equivalent experience.
  • Familiarity = with PostgreSQL in managed services like GCP or cloud infrastructure and wo= rking with a large dataset.
  • Minimum of 5 years of experience in Pos= tgreSQL database administration, information technology, database architect= ure, or a related field.
  • Strong command of SQL and SQL server tools= .
  • Creating stored procedures, triggers, functions, packages, and Lo= gical and Physical database design.
  • Knowledge of tools used for run= ning queries, performing DB schema changes, and analyzing database activity= /performance.
  • Advanced knowledge of database security, backup and r= ecovery, server setup/operation/configuration, performance diagnostics, and= monitoring standards.
  • Experience in Database Administration for Po= stgreSQL.
  • Understanding of replication and how to set up and mainta= in.
  • Hands-on experience working with JSON files and Postgres JSON f= unctions and operators.
  • Knowledge of database design principles, qu= ery optimization, index management, integrity checks, statistics, and isola= tion levels.
  • Familiarity with Kubernetes.
  • Proficient (Solid= experience) with Python.
  • Knowledge of database design principles, = query optimization, index management, integrity checks, statistics, and iso= lation levels.
  • Ability to efficiently write database code without c= ompromising data quality, privacy or security.
  • Technical skills in = data analysis, schema design, and data modeling.
  • You have experienc= e building and debugging distributed, scalable architectures.

PRE= FERRED QUALIFICATIONS

  • Experience wi= th popular Postgres utilities.
  • PL/pgSQL (a strong plus for other ex= tension languages).
  • Writing advanced SQL, analyzing developer SQL, = and making recommendations for performance tuning SQL, rewriting SQL or add= ing indexes for efficiency, and creating/updating stored procedures.
    • Experience with databases processing ETL pipeline.
  • Experience wit= h PostGIS.
  • Experience in data warehouse solutions such as BigQuery.=
  • Experience with working with a distributed team.
  • Experienc= e in a high-growth technology company.

PHYSICAL WORKING CONDITION= S

The following physi= cal requirements represent those that are required to successfully perform = the essential functions of this position. Reasonable accommodations may be = made to enable individuals with disabilities to perform the essential funct= ions.

  • Sitting - [90%]
  • Standing = - [0%]
  • Walking - [10%]
  • Bending - [Occasionally]
  • Kne= eling - [Some]
  • Lifting - [Up to 25 pounds]
  • Reaching - [Regu= larly]
  • Telephone Use - [Yes]
  • Computer Use/Manual Dexterity = - Yes
  • Ability to travel - Depends on location, otherwise not antici= pated; remote employees typically travel to Montana twice per year.=C2=A0

WHAT WE ARE OFFERING YOU

  • C= ompetitive salaries, annual bonuses, equity, and opportunities for growth
  • Comprehensive health benefits including a no-monthly-cost medical pl= an=C2=A0
  • Parental leave plan of four or six weeks fully paid
    • 401k matching at 100% for the first 3% you save and 50% from 3-5%Company-wide outdoor adventures and amazing outdoor industry perksAnnual =E2=80=9CGet Out, Get Active=E2=80=9D funds to fuel your active lif= estyle in and outside of the gym
  • Flexible time away package that in= cludes PTO, STO, VTO, quiet weeks, and floating holidays

onX COM= PANY VALUES

Our princ= iples guide the decisions making of our company.=C2=A0 They define the cult= ure at onX, what we have learned through experience, and are the code by wh= ich we operate. They are fundamental, enduring, and actionable=E2=80=93a be= nchmark by which we measure the team behavior and performance.=C2=A0

We put the=C2=A0customer=C2=A0first.

We are=C2=A0passionate= .

We win as a=C2=A0team.

We take=C2=A0ownership.=C2=A0

We work with=C2=A0<= strong style=3D"color:rgb(255,51,0)">urgency.

We are=C2=A0curi= ous=C2=A0and seek the truth.

We=C2=A0innovate=C2=A0&a= mp; take risks.

=C2=A0

Imp= ortant Note:=C2=A0To make sure that our emails always come st= raight to your inbox, we encourage you to take a moment and designate Clear= Company as a safe sender. All system emails are sent from=C2=A0@clearcompany= .com=C2=A0or=C2=A0@email.clrco.com.

=C2=A0

P= osition open until filled.=C2=A0

<= strong style=3D"color:rgb(255,51,0)">At onX, we believe that diversity make= s us better.=C2=A0Bringing together a diverse set of backgrounds, = ideas, and opinions helps us to achieve our mission to awaken the adventure= r in everyone. We are proud to be an equal opportunity employer. onX is com= mitted to equal opportunity not only in our hiring practices but also in ou= r employment practices, including but not limited to development, compensat= ion, and promotion. We strive to build an inclusive work community where ev= eryone can be their authentic self, and together, we win as a team. Come jo= in us!

onX is committed to providi= ng reasonable accommodations for individuals in our job application process= . If you need assistance or an accommodation, please contact us at

=
--
Spencer Houskeeper
Senior = Technical Recruiter


Missoula = Headquarters
<= span style=3D"color:rgb(0,0,0);font-family:-apple-system,system-ui,"Se= goe UI",Helvetica,Arial,sans-serif;font-size:15px">46=C2=B051=E2=80=99= 11.0272=E2=80=9DN=C2=A0
114=C2= =B000=E2=80=9943.6398=E2=80=9DW

This e-mail message m= ay contain confidential or legally privileged information and is intended o= nly for the use of the intended recipient(s). onX is not responsible for er= rors or omissions in this message and denies any responsibility for any dam= age arising from the use of e-mail. Any opinion and other statement contain= ed in this message and any attachment are solely those of the author and do= not necessarily represent those of the company. --000000000000c7e71405eb52352c--