Senior DB Migration Lead: SQL Server to PostgreSQL

PT IDstar Cipta Teknologi (IDstar); Jakarta Pusat; On-site; IDR 600,000,000 - 900,000,000; Full time

Job summary

PT IDstar Cipta Teknologi (IDstar) seeks an experienced Database Specialist to lead end-to-end migrations from SQL Server/Azure SQL to PostgreSQL/Aurora PostgreSQL. You will assess architecture, define migration strategies, and optimize performance across large-scale projects.

You will troubleshoot data integrity and connectivity issues, collaborating with .NET teams and delivering thorough migration documentation for a smooth handover. Bahasa Indonesia and English communication is required.

Qualifications

• 7+ years as a DBA/DBA engineer or consultant with cross-engine migration experience.
• Led at least one large multi-terabyte SQL Server to PostgreSQL migration with go-live.
• Deep SQL Server/Azure SQL and PostgreSQL architecture and migration know-how.

Responsibilities

• Lead end-to-end migration from SQL Server/Azure SQL to PostgreSQL/Aurora PostgreSQL.
• Assess architecture, risks, and define migration strategies.
• Tune performance, plans, and resource usage; optimize queries.
• Troubleshoot data integrity, performance bottlenecks, and integration issues.
• Collaborate with .NET developers to resolve connectivity issues.
• Prepare migration docs and transfer knowledge to ensure smooth handover.

Skills

Migration leadership

Cross-DB migration

Query performance tuning

Troubleshooting

Documentation

Communication (BI Indonesia & English)

Tools

SQL Server

Azure SQL

PostgreSQL

Aurora PostgreSQL

T-SQL

CDC

Entity Framework Core

Npgsql

AWS

Job description

PT IDstar Cipta Teknologi (IDstar) seeks an experienced Database Specialist to lead end-to-end migrations from SQL Server/Azure SQL to PostgreSQL/Aurora PostgreSQL. You will assess architecture, define migration strategies, and optimize performance across large-scale projects.

You will troubleshoot data integrity and connectivity issues, collaborating with .NET teams and delivering thorough migration documentation for a smooth handover. Bahasa Indonesia and English communication is required.