Database Migration Engineer III

Guidewire Software; Mississauga; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Guidewire is seeking a Database Migration Engineer III to lead the migration of customer databases to our Cloud Platform. The role requires optimization of data transfer and a thorough understanding of Oracle and SQL Server, among other technical skills. This hybrid position in Mississauga combines remote flexibility with essential on-site collaboration to drive successful migrations for our clients.

Qualifications

• 4-6 years of experience with database engineering, including 2+ years in data migration.
• Knowledge of Oracle and SQL Server databases is essential.
• Experience with data replication tools and cloud services.

Responsibilities

• Optimize data transfer and runtime database performance.
• Perform migration dry runs and assist customers with data validation.
• Develop tooling to automate migration activities.

Skills

Database Optimization

Data Migration

Oracle

SQL Server

Postgres

Cloud Services (AWS, Azure)

Data Replication Tools

Scripting (bash, python)

ANSI SQL

Network Troubleshooting

Education

Bachelor’s Degree in Computer Science or related field

Tools

Terraform

Git

Job description

Database Migration Engineer III page is loaded

Database Migration Engineer III

Apply remote type Hybrid locations Canada - Mississauga, ON time type Full time posted on Posted Today time left to apply End Date: September 30, 2025 (30+ days left to apply) job requisition id JR_13335

Summary

Guidewire is looking for a collaborative, proactive, and results-oriented Database Migration Engineer. As Guidewire’s SAAS offering matures, we are facilitating migration of increasing numbers of customers' databases as well as databases with larger volumes and more complex data from legacy Guidewire systems into our Cloud Platform.

Job Description

Successful Database Migration Engineers at Guidewire perform a variety of duties:

• Optimization of data transfer

• Runtime database performance optimization

• Migration dry runs/rehearsals

• Production go-lives

• Assisting customers with data validation

• Developing and maintaining tooling to automate migration activities

Required Experience:

• Bachelor’s Degree in Computer Science or a related STEM field, or equivalent experience

• 4-6 years of experience with database engineering, including 2+ years data migration

• Deep knowledge of Oracle and/or SQL Server databases

• Database Migration from Oracle and/or SQL Server to Postgres

• Postgres database optimization (query plans, etc)

• One or more cloud services (AWS, Azure, etc)

• Data replication tools (MS SQL Server transactional replication, Oracle Golden Gate, AWS DMS, etc)

• UNIX general administration skills, including scripting with bash, python etc

• ANSI SQL Language

• network connectivity and troubleshooting

Desired Experience:

• Infrastructure management tools such as Terraform

• Programming experience using languages likes Java, C, Kotlin, Go

• Jira and/or Salesforce for managing work requests

• Source control such as Git

Personal Qualities and Soft Skills:

• Strong work ethic and a positive, can-do attitude

• Strong follow-through and commitment to customers and colleagues

• Speak your mind and defend ideas based on merit, yet humility and hunger to learn from others

• Read, write, and speak English fluently

Job Location & Hours:

• Hybrid - Toronto, Canada or Curitiba, Brazil - partly office/partly remote

• Standard 40 hour work week.

• Weekend work is required. Expect to work 30-50% of weekends. Commensurate comp time is given flexibly the following week after a weekend is worked.

Disability Accommodations and Guidewire’s Appeals Process. Guidewire provides accommodations to the hiring process to create a fair opportunity for candidates with disabilities to contend for open positions. Accommodation requests should be directed to [e-mail]. If things do not go as hoped, we invite you to use our appeals process. Guidewire promises to independently review any denied accommodation and any decision not to offer you the position. The appeals process is the same in either case. Within five business days of receiving a notice of denial of an accommodation, or receiving a notice of your non-selection for a vacancy, e-mail [e-mail] to make an appeal. Guidewire will assign a new decision-maker to review the request and/or hiring decision, who will then notify you in writing of a decision within 10 business days.

About Guidewire

Guidewire is the platform P&C insurers trust to engage, innovate, and grow efficiently. We combine digital, core, analytics, and AI to deliver our platform as a cloud service. More than 540+ insurers in 40 countries, from new ventures to the largest and most complex in the world, run on Guidewire.

As a partner to our customers, we continually evolve to enable their success. We are proud of our unparalleled implementation track record with 1600+ successful projects, supported by the largest R&D team and partner ecosystem in the industry. Our Marketplace provides hundreds of applications that accelerate integration, localization, and innovation.

For more information, please visit www.guidewire.com and follow us on Twitter: @Guidewire_PandC.

Guidewire Software, Inc. is proud to be an equal opportunity and affirmative action employer. We are committed to an inclusive workplace, and believe that a diversity of perspectives, abilities, and cultures is a key to our success. Qualified applicants will receive consideration without regard to race, color, ancestry, religion, sex, national origin, citizenship, marital status, age, sexual orientation, gender identity, gender expression, veteran status, or disability. All offers are contingent upon passing a criminal history and other background checks where it's applicable to the position.

About Guidewire

Guidewire is the platform P&C insurers trust to engage, innovate, and grow efficiently. We combine digital, core, analytics, and AI to deliver our platform as a cloud service. More than 540+ insurers in 40 countries, from new ventures to the largest and most complex in the world, run on Guidewire.

As a partner to our customers, we continually evolve to enable their success. We are proud of our unparalleled implementation track record with 1600+ successful projects, supported by the largest R&D team and partner ecosystem in the industry. Our Marketplace provides hundreds of applications that accelerate integration, localization, and innovation.

For more information, please visit www.guidewire.com and follow us on Twitter: @Guidewire_PandC.

Guidewire Software, Inc. is proud to be an equal opportunity and affirmative action employer. We are committed to an inclusive workplace, and believe that a diversity of perspectives, abilities, and cultures is a key to our success. Qualified applicants will receive consideration without regard to race, color, ancestry, religion, sex, national origin, citizenship, marital status, age, sexual orientation, gender identity, gender expression, veteran status, or disability. All offers are contingent upon passing a criminal history and other background checks where it's applicable to the position.