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@xxxxxxxxxxx.
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 @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
46°51’11.0272”N
114°00’43.6398”W
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.