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