Senior DB Engineer: SQL Server to PostgreSQL Migrations

Pro Integrate LLC; Indonesia; On-site; IDR 420,000,000 - 540,000,000; Full time

Job summary

Pro Integrate, a global AI and IT consulting firm, seeks a seasoned Database Specialist for WFO Jakarta. The role focuses on multi-TB migrations from SQL Server to PostgreSQL, cross-engine expertise, and bridging the gap between application and database layers.

You will work with AWS Aurora PostgreSQL, Azure SQL, and .NET/EF Core, communicating technical concepts in Indonesian and English to technical and managerial audiences.

Qualifications

• 7+ years of experience as a Database Engineer, DBA, or Database Consultant, including cross-engine migration projects.
• Led at least one large-scale, multi-terabyte (multi-TB) migration from SQL Server to PostgreSQL, including go-live and post-migration stabilization.
• Deep expertise in Microsoft SQL Server / Azure SQL, including T-SQL, execution plans, Change Tracking/CDC, and Azure SQL Database (PaaS).
• Deep expertise in PostgreSQL / Amazon Aurora PostgreSQL, including planning, indexing, VACUUM/ANALYZE, and parameter tuning.
• Solid understanding of AWS Aurora PostgreSQL, RDS Proxy, EKS, CloudWatch, and AWS Secrets Manager / IAM in database contexts.
• Understanding of .NET / .NET Core with EF Core and Npgsql to diagnose ORM-generated queries and optimize performance.
• Fluent communication in Bahasa Indonesia and English, both verbal and written.

Responsibilities

• Lead multi-TB database migration projects from SQL Server to PostgreSQL and ensure go-live stability.
• Bridge application and database layers by diagnosing ORM-generated patterns and recommending improvements.
• Manage AWS/Azure database services and ensure secure, scalable access for applications.
• Communicate technical concepts clearly to technical teams and management in both Indonesian and English.

Skills

Database migration

SQL Server / Azure SQL

PostgreSQL / Aurora PostgreSQL

AWS Ecosystem

.NET / EF Core

Npgsql

Communication (Indonesian & English)

Tools

SQL Server

PostgreSQL

Amazon Aurora PostgreSQL

Entity Framework Core

Npgsql

Job description

Pro Integrate, a global AI and IT consulting firm, seeks a seasoned Database Specialist for WFO Jakarta. The role focuses on multi-TB migrations from SQL Server to PostgreSQL, cross-engine expertise, and bridging the gap between application and database layers.

You will work with AWS Aurora PostgreSQL, Azure SQL, and .NET/EF Core, communicating technical concepts in Indonesian and English to technical and managerial audiences.