Senior Database Migration Engineer

Summary

Job Description

• Design and execute endtoend database migration strategies from Oracle and/or SQL Server to PostgreSQL for Guidewire Cloud including planning dry runs cutover and postgolive stabilization.

• Optimize data transfer and runtime database performance using techniques such as query plan tuning indexing strategies partitioning batching and connection/throughput optimization to meet demanding SLAs.

• Develop maintain and improve migration tooling and automation (e.g. scripts utilities pipelines) using bash Python workflow and related technologies to make migrations faster safer and more repeatable across customers.

• Configure and use data replication tools (such as AWS DMS SQL Server transactional replication or Oracle GoldenGate) to support lowdowntime phased and highvolume database migrations.

• Troubleshoot complex migration performance and connectivity issues across database application and network layers in collaboration with PDO Professional Services and cloud operations teams including planned weekend cutovers aligned to customer needs.

• Apply AIassisted coding and analysis tools (such as Claude Code) to accelerate rootcause analysis script/tool development performance investigations and validation workflows and share best practices that raise the bar for the team.

• Rigorously validate and reconcile data before and after migrations by defining and executing checks controls and reconciliation processes that give customers and internal stakeholders confidence in data completeness accuracy and consistency.

• At Guidewire we foster a culture of curiosity innovation and responsible use of AIempowering our teams to continuously leverage emerging technologies and datadriven insights to enhance productivity and outcomes.
  

Required

Demonstrated ability to embrace AI and apply it to your current role as well as datadriven insights to drive innovation productivity and continuous improvement.

• Bachelors degree in Computer Science a related STEM field or equivalent practical experience.

• 8 years of experience in database engineering including at least 2 years focused on data/database migration in production environments.

• Deep hands-on experience with Oracle and/or Microsoft SQL Server including schema design indexing performance tuning and daytoday operations.

• Proven experience migrating databases from Oracle and/or SQL Server to PostgreSQL including resolving compatibility performance and operational issues.

• Strong PostgreSQL expertise including query plan analysis performance optimization and operational best practices in a cloud or hybrid environment.

• Proficiency with UNIX/Linux administration and scripting (bash Python) to automate migration monitoring and validation tasks.

• Experience with at least one major cloud platform (such as AWS or Azure) plus solid understanding of networking fundamentals connectivity and troubleshooting in cloud and hybrid environments.

• Familiarity with data replication technologies (for example AWS DMS SQL Server transactional replication or Oracle GoldenGate) and their use in migration or cutover scenarios.

• Clear concise communication in English (written and spoken) with the ability to collaborate across distributed crossfunctional teams

• Available to work 30-50% of weekends with advance notice and flexible compensation time off.

• Strong work ethic proactive ownership mindset and commitment to followthrough for customers and colleagues with the humility and curiosity to learn from others.
  

Preferred

• Experience with infrastructureascode or environment automation tools such as Terraform.

• Programming skills in one or more languages such as Java Kotlin C or Go.

• Experience with Workflow tools such as GitHub Actions Argo Workflows KubeVela Workflows or Temporal.

• Experience using work management tools such as Jira and source control systems such as Git.

• Background working in SaaS missioncritical or highavailability environments ideally within financial services or insurance technology.

• Exposure to largescale multitenant cloud platforms and dataintensive workloads.
  

We believe in clarity and setting you up for your first six months you will lead several customer migration projects endtoend: assessing legacy databases shaping migration and cutover plans optimizing PostgreSQL performance and driving rigorous data validation so customers can confidently run their business on Guidewire Cloud. Youll measure success through smooth data migrations reduced downtime improved performance and reusable automation that accelerates future migrations. Over time your data migration optimization and tooling will enable Guidewire to scale and efficiently serve more customers contributing to our broader mission of transforming how P&C insurers do business.

The people we employ give their all and in return we offer flexibility wherever we can such as:

• Flexible work environment and hybrid working model.

• Health and wellness benefits.

• Paid time off programs including volunteer time off.

• Marketcompetitive pay and incentive programs.

• Continual development and internal career growth opportunities including access to cuttingedge AI cloud and data projects aligned to our Your Career. Your Adventure. philosophy.

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 and follow us on Twitter: @GuidewirePandC.

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 its applicable to the position.