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
• 5+ years of experience with database engineering, including 2+ year 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

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.