Database Specialist - Senior Level

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

• Lead and execute end-to-end database migration from SQL Server/Azure SQL to PostgreSQL/Aurora PostgreSQL, covering database assessment, schema conversion, data migration, validation, cutover, and post migration stabilization.
• Analyze existing database architecture, identify migration risks, dependencies, compatibility issues, and define appropriate migration strategies.
• Perform database performance tuning and optimization, including query execution plans, indexing strategies, configurations, and resource utilization.
• Handle database troubleshooting, performance bottlenecks, data integrity issues, and application integration challenges.
• Collaborate with .NET developers to identify and resolve database connectivity and compatibility issues.
• Provide technical guidance to customers, prepare migration documentation, and conduct knowledge transfer to ensure smooth project handover.

Requirements

• Minimum 7 years of experience as a Database Administrator (DBA), Database Engineer, or Database Consultant, with at least 3 years of hands on experience in cross database engine migration.
• Proven experience leading at least one large scale, multi terabyte (TB) migration project from SQL Server to PostgreSQL, including successful go live and post migration stabilization.
• Strong technical expertise in Microsoft SQL Server/Azure SQL and PostgreSQL/Aurora PostgreSQL, including database architecture, administration, and migration processes.
• Hands-on experience with T-SQL, query execution plans, Change Data Capture (CDC), schema conversion, data validation, and database performance tuning.
• Familiarity with AWS database services, cloud database architecture, monitoring, security, and EKS connectivity.
• Working knowledge of .NET application architecture, Entity Framework Core, and Npgsql to troubleshoot database integration and connectivity issues.
• Strong analytical and problem solving skills, particularly in handling complex database migration challenges and production issues.
• Excellent communication and stakeholder management skills, with the ability to provide technical explanations and guidance to customers in both Bahasa Indonesia and English.