Database Engineer – GIS Migration (AWS RDS / Aurora PostgreSQL)

GKP Solutions, Inc.; Jakarta Pusat; On-site; IDR 360,000,000 - 720,000,000; Full time

Job summary

GKP Solutions, Inc. seeks an experienced Database Engineer to lead migration and modernization of GIS databases to Amazon RDS and Aurora PostgreSQL. You will migrate from Oracle/SQL Server, configure PostGIS, and design HA/DR for large-scale deployments.

You will collaborate with cloud, application, and GIS teams to deliver a robust, scalable platform with zero-downtime migration strategies.

Qualifications

• Hands-on experience with AWS RDS PostgreSQL and Amazon Aurora PostgreSQL.
• Proven track record migrating Oracle/SQL Server to PostgreSQL.
• Experience configuring and supporting PostGIS environments.
• Deep knowledge of PostgreSQL performance tuning and optimization.
• Experience with replication, failover, backup and recovery strategies.
• Strong understanding of change management and release processes.
• Excellent communication and problem-solving skills.

Responsibilities

• Design and implement database solutions using RDS PostgreSQL and Aurora PostgreSQL.
• Lead schema and data migrations from legacy databases to PostgreSQL.
• Configure and optimize PostGIS for GIS workloads.
• Perform database performance tuning, monitoring, and troubleshooting.
• Architect HA/DR solutions and automated failover strategies.
• Develop and execute change management for production deployments.
• Plan blue/green deployments, logical replication, and near-zero downtime migrations.
• Collaborate with cloud, application, and GIS teams to modernize the platform.

Skills

AWS RDS PostgreSQL

Amazon Aurora PostgreSQL

PostGIS configuration

PostgreSQL performance tuning

Replication, failover, backup & DR

Release management & change control

Communication & problem solving

GIS, geospatial familiarity

Tools

AWS RDS PostgreSQL

Amazon Aurora PostgreSQL

PostGIS

Job description

We are seeking an experienced Database Engineer to lead the migration and modernization of GIS database platforms to Amazon RDS and Amazon Aurora PostgreSQL. This role requires deep expertise in PostgreSQL architecture, AWS database services, high availability design, and large-scale database migrations from legacy platforms such as Oracle and SQL Server.

Key Responsibilities

• Design and implement database solutions using Amazon RDS PostgreSQL and Amazon Aurora PostgreSQL.
• Lead schema and data migrations from legacy databases (Oracle, SQL Server, etc.) to PostgreSQL.
• Configure and optimize PostGIS for GIS and spatial data workloads.
• Perform database performance tuning, optimization, monitoring, and troubleshooting.
• Architect and implement High Availability and Disaster Recovery (HA/DR) solutions using:
• Automated Failover Strategies
• Develop and execute database change management processes to support seamless production deployments.
• Plan and implement:
• Blue/Green Deployments
• Logical Replication
• Rollback Strategies
• Near-Zero Downtime Migrations
• Collaborate with cloud, application, and GIS teams to ensure successful platform modernization.

Required Qualifications

• Strong hands-on experience with AWS RDS PostgreSQL and Amazon Aurora PostgreSQL.
• Proven track record migrating enterprise databases from Oracle and/or SQL Server to PostgreSQL.
• Experience configuring and supporting PostGIS environments.
• Deep knowledge of PostgreSQL performance tuning and database optimization.
• Experience with database replication, failover, backup, and recovery strategies.
• Strong understanding of database change management and release processes.
• Excellent communication and problem-solving skills.

Preferred

• GIS, geospatial, or mapping platform experience.
• AWS certifications.
• Experience supporting large-scale cloud modernization initiatives.