Senior Database Engineer - PostgreSQL - Montana or Remote

  • onXmaps, Inc.
  • Hybrid (Bozeman, MT, USA)
  • Jan 04, 2023
Full time Engineering Senior Level

Job Description

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@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 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.
  • Experience with PostGIS.
  • 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 in data warehouse solutions such as BigQuery.
  • Experience with working with a distributed team.
  • Experience in a high-growth technology company.