Senior GIS DB Engineer: AWS RDS/Aurora Migration & HA

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

Job summary

GKP Solutions, Inc. is seeking an experienced Database Engineer to lead the migration and modernization of GIS database platforms to Amazon RDS and Amazon Aurora PostgreSQL.

The role requires deep PostgreSQL expertise, AWS database services, high availability design, and large-scale migrations from Oracle and SQL Server. You will design and implement database solutions, oversee schema and data migrations, optimize PostGIS, and collaborate with GIS and cloud teams to deliver a robust, scalable

Qualifications

• Hands-on experience with AWS RDS PostgreSQL and Amazon Aurora PostgreSQL.
• Proven track record migrating enterprise databases from Oracle/SQL Server to PostgreSQL.
• Experience configuring and supporting PostGIS environments.
• Deep knowledge of PostgreSQL performance tuning and optimization.
• Expertise designing HA/DR solutions in AWS.
• Experience with replication, failover, backup, and recovery strategies.
• Strong understanding of database change management and release processes.
• Excellent communication and problem-solving skills.
• GIS, geospatial, or mapping platform experience preferred.
• AWS certifications.

Responsibilities

• Design and implement database solutions using AWS RDS PostgreSQL and Aurora PostgreSQL.
• Lead migrations from legacy databases (Oracle/SQL Server) to PostgreSQL.
• Configure and optimize PostGIS for GIS workloads.
• Tune, monitor, and troubleshoot database performance.
• Architect HA/DR solutions using Aurora Multi-AZ, Read Replicas, cross-region replication, and automated failover.
• Develop and execute change management for production deployments.
• Plan Blue/Green deployments and near-zero downtime migrations.
• Collaborate with cloud, application, and GIS teams for modernization.

Skills

AWS RDS PostgreSQL

Amazon Aurora PostgreSQL

PostGIS

HA/DR

Data migration

Blue/Green deploy

Logical replication

Cross-region replication

DB performance tuning

Release management

Oracle to PostgreSQL

Communication skills

AWS certifications

Job description

GKP Solutions, Inc. is seeking an experienced Database Engineer to lead the migration and modernization of GIS database platforms to Amazon RDS and Amazon Aurora PostgreSQL.

The role requires deep PostgreSQL expertise, AWS database services, high availability design, and large-scale migrations from Oracle and SQL Server. You will design and implement database solutions, oversee schema and data migrations, optimize PostGIS, and collaborate with GIS and cloud teams to deliver a robust, scalable