Senior PostgreSQL Engineer - Remote USA

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=2248051

*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–to
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’t lost our entrepreneurial 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’s
corporate offices are located in Missoula and Bozeman, Montana. This
position can be performed near a corporate office or remotely from one of
onX’s “Basecamps,” which are emerging locations where our remote onXers
cluster for work and adventure. onX’s 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* for
AK, HI, IL, MA, NY, ND, OH, WY, and Washington DC. For more information,
please contact recruitment(at)onXmaps(dot)com(dot)

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 demand.
-

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 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 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’s 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 related
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 indexes
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 “Get Out, Get Active” 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–a
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 *(at)clearcompany(dot)com
<http://clearcompany.com> *or *(at)email(dot)clrco(dot)com <http://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

--
*Spencer Houskeeper*
Senior Technical Recruiter

Missoula Headquarters
46°51’11.0272”N
114°00’43.6398”W
onXmaps.com

--
This e-mail message may contain confidential or legally privileged
information and is intended only for the use of the intended recipient(s).
onX is not responsible for errors or omissions in this message and denies
any responsibility for any damage arising from the use of e-mail. Any
opinion and other statement contained in this message and any attachment
are solely those of the author and do not necessarily represent those of
the company.