AI-Driven Cloud DB Migration Lead (Oracle/SQL to PostgreSQL)

Guidewire Software; Toronto; On-site; CAD 120,000 - 180,000; Full time

Benefits offered by this job

Hybrid work model

Health benefits

Paid time off

Career growth

Market pay

Job summary

Guidewire Software in Toronto is seeking a Senior Database Migration Engineer to lead complex migrations from legacy Guidewire systems to Guidewire Cloud Platform, ensuring performance and data integrity.

You will design automation, tune PostgreSQL, and coordinate with PDO, Professional Services and cloud operations to minimize downtime and deliver measurable value for insurers upgrading to Guidewire Cloud.

Qualifications

• Bachelor's degree in Computer Science or related STEM field or equivalent practical experience.
• 8+ years of experience in database engineering, including at least 2 years in production data migrations.
• Experience migrating Oracle/SQL Server to PostgreSQL and resolving related issues.
• Strong PostgreSQL expertise, including performance tuning and operational best practices in cloud/hybrid environments.
• Proficiency with UNIX/Linux scripting (bash, Python) to automate migrations, monitoring, and validation tasks.
• Experience with cloud platforms (AWS/Azure) and networking basics in cloud/hybrid setups.
• Clear, concise English communication and cross-functional collaboration.
• Willingness to work 30-50% of weekends with advance notice.

Responsibilities

• Design and execute end-to-end database migrations from Oracle/SQL Server to PostgreSQL for Guidewire Cloud.
• Optimize data transfer and runtime performance to meet demanding SLAs.
• Develop, maintain, and improve migration tooling and automation using bash and Python.
• Configure and use data replication tools (AWS DMS, Oracle GoldenGate, SQL Server replication) for low-downtime migrations.
• Troubleshoot migration, performance, and connectivity issues across DB, app, and network layers with cross-team collaboration.
• Apply AI-assisted coding to accelerate root-cause analysis, script development, and validation workflows.
• Rigorously validate data before/after migrations via checks, controls, and reconciliation processes.
• Support a culture of curiosity and responsible use of AI to enhance productivity.

Skills

AI in migrations

English communication

Cloud platforms (AWS/Azure)

Unix/Linux scripting (bash, Python)

Database migration experience

Oracle

SQL Server

PostgreSQL

Education

Bachelor’s degree in Computer Science or related field

Tools

AWS DMS

Oracle GoldenGate

SQL Server replication

PostgreSQL tooling

Terraform

GitHub Actions

Job description

Guidewire Software in Toronto is seeking a Senior Database Migration Engineer to lead complex migrations from legacy Guidewire systems to Guidewire Cloud Platform, ensuring performance and data integrity.

You will design automation, tune PostgreSQL, and coordinate with PDO, Professional Services and cloud operations to minimize downtime and deliver measurable value for insurers upgrading to Guidewire Cloud.