Database Specialist Senior Level
2 days ago
East Jakarta, Java, Indonesia
PT IDstar Cipta Teknologi (IDstar)
Penuh waktu
Gratis dengan email atau Google
Simpan pekerjaan ini dan atur pencarian Anda
Buat akun gratis untuk menyimpan pekerjaan, membuat peringatan dan kembali ke daftar ini dari dasbor Anda.
Gratis dengan email atau Google
Dengan melanjutkan, Anda menyetujui Ketentuan & Kebijakan Privasi.
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.
• 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.