Database Migration Engineer III

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 [email protected]. 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 [email protected] 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.