Senior Database Migration Engineer
SummaryGuidewire’s Product Development & Operations (PDO) builds and runs the cloud platform and products that power how P&C insurers operate worldwide. We focus on secure, reliable, and efficient SaaS delivery, with a culture grounded in collaboration and continuous improvement. You’ll work closely with engineers across operations and applications to deliver safe, high‑quality outcomes for our customers.As a Senior Database Migration Engineer, you will lead complex customer database migrations from legacy Guidewire systems into Guidewire Cloud Platform, ensuring performance, data integrity, and minimal downtime. You’ll combine deep database expertise with a practical, customer‑focused mindset to design, automate, and execute repeatable migration patterns. This role is critical to how PDO delivers cloud‑platform adoption at scale, helping insurers modernize and realize measurable value from Guidewire’s solutions.Job DescriptionWhat you’ll doDesign and execute end‑to‑end database migration strategies from Oracle and/or SQL Server to PostgreSQL for Guidewire Cloud, including planning, dry runs, cutover, and post‑go‑live 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 low‑downtime, phased, and high‑volume 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 AI‑assisted coding and analysis tools (such as Claude Code) to accelerate root‑cause 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 AI—empowering our teams to continuously leverage emerging technologies and data‑driven insights to enhance productivity and outcomes. What you’ll bring RequiredDemonstrated ability to embrace AI and apply it to your current role as well as data‑driven insights to drive innovation, productivity, and continuous improvement.Bachelor’s degree in Computer Science, a related STEM field, o...