Senior PostgreSQL Engineer - (Local or Remote) - Remote

  • onXmaps, Inc.
  • Nov 23, 2021
Full time Computer Science Engineering Software

Job Description

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 cloud database infrastructure (GCP, AWS, Azure), database design, database development, PostgreSQL tuning, service delivery, incident tracking, management of large datasets, and ETL processes for business intelligence, reporting, and change management. This is a great opportunity to be a part of a dynamic growing company focused on providing the richest and most innovative mapping experiences and guidebook content to inform your every adventure. This position will report to a Manager, Software Development.

LOCATION

Missoula, MT; Bozeman, MT; or remote from the USA only. 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 on improvements to our databases and database standards as we scale our systems to meet growing data and product demand

  • Ensure security and optimization of data storage and maintain integrity and performance of database systems 

  • Monitor, diagnose, and troubleshoot database incidents, performance issues, and query optimization before they become major problems

  • Collaborate in architectural decisions to guide system design to address database limitations and best practices and work with development 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

  • Assist in the creation, deployment, and management of services in Kubernetes

  • Be available for on-call support as needed

  • Collaborate with other team members, SRE, stakeholders, and technology vendors and partners

  • Embody our company values

REQUIRED QUALIFICATIONS

  • Bachelor’s degree in Computer Science, or Information Technology, or equivalent experience 
  • Minimum of five (5) years of experience in PostgreSQL database administration, information technology, database architecture, or a related field
  • Familiarity with GCP (other cloud infrastructure) and working with large datasets
  • Proficient experience with Python and C/C++  
  • Strong command of SQL and SQL server tools
  • Advanced knowledge of database security, backup and recovery, and performance monitoring standards
  • Experience with performance diagnostics, performance tuning, capacity planning, and monitoring.
  • Collaborate with other team members and stakeholders
  • Familiarity with Kubernetes
  • Strong technical skills with a proven record of architecture & design experience in building large-scale distributed systems/databases.
  • Technical skills in data analysis, schema design, and data modeling.
  • You have experience building and debugging distributed, scalable architectures
  • You’ve worked with microservices and have a strong computer science foundation
  • You are well-versed in modern API design and development
  • You believe that your profession is a craft and you’re driven to improve every day
  • You are an advocate for the customer and their experience
  • You want to work with other happy, talented engineers
  • You write great code and take ownership

PREFERRED QUALIFICATIONS

  • Experience with geospatial databases such as 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 - [25%]

WHAT WE ARE OFFERING YOU

  • Competitive salary and opportunities for growth
  • Comprehensive medical, insurance, and wellness benefits
  • Four weeks paid family leave 
  • 401k matching at 100% the first 3% you save and 50% from 3-5%
  • Company-wide outdoor adventures twice per year
  • Amazing outdoor industry discounts
  • Summer hours for salaried employees

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.