Database Specialist Senior Level

2 days ago

East Jakarta, Java, Indonesia PT IDstar Cipta Teknologi (IDstar) Penuh waktu
Senior Database Specialist SQL Server to PostgreSQL Migration Responsibilities
• 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.