Skip to main content
Database Engineer (OpenStreetMap and PostgreSQL)

Job Details: Database Engineer (OpenStreetMap and PostgreSQL)

Job Description: Database Engineer (OpenStreetMap and PostgreSQL)

Position Id: G0723-0040
Job Type:1-3 months (contract)
Country: Spain
Location: Valencia
Pay Rate: Open
Contact Recruiter:+4972312839009

Job Description:

Trigyn has a contractual opportunity for a Database Engineer (OpenStreetMap and PostgreSQL). This resource will be working in Valencia, Spain

Job Responsibilities:

o Manage global OpenStreetMap (OSM) database replica based on PostgreSQL, including the design, implementation and enhancements as necessary.
o Monitor daily updates of the Planet.osm in-house replica through regular (daily) diffs.
o Optimize and improve the performance of databases and queries.
o Manage PostgreSQL objects (roles, permissions, tables, partitioned tables, views, materialized views, schemas, functions, procedures, triggers, backup, restore, data replication and synchronization mechanisms) and perform troubleshooting in case of issues
o Manage geodata using open-source geospatial routines such as: ogr2ogr, gdal, osmium, osmosis, imposm and osm2pgsql

• Skills/Experience:

o Expertise of PostgreSQL and PostGIS database administration is required.
o Proficiency in Linux, Linux Shell Scripting and Python is required.
o Expertise on OSM data model (geographic, historic, data formats) and other geospatial data is desirable.
o Proficiency in at least one of the GIS software (QGIS, ArcGIS Desktop) is desirable.
o Basic knowledge of Docker containers, LUA and R is desirable.

For Immediate Response, Please send your Resume to

TRIGYN TECHNOLOGIES is a multinational IT services company with resources deployed in 25 countries. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS) and CMMI Level 5 certified company. TRIGYN has offices in United States, Canada, Germany Switzerland and India.