Base Career helps you apply smarter for this job.
Key skills for this role
What you’ll do
• Design 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
Design 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.
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
Bengaluru, IND
Bengaluru, IND
Bengaluru, IND
, CAN
Guidewire is seeking a Technical Program Manager to lead complex security programs, roadmap execution, and security maturity initiatives across cloud and enterprise environments. The role requires 5+ years of technical s
Bengaluru, IND
Bengaluru, IND
Bengaluru, IND
Bengaluru, IND
, CAN
Toronto, CAN
, CAN
London, GBR
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.
Required
Demonstrated 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, 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 day‑to‑day 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, cross‑functional 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 follow‑through for customers and colleagues, with the humility and curiosity to learn from others.
Preferred
Experience with infrastructure‑as‑code 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, mission‑critical, or high‑availability environments, ideally within financial services or insurance technology.
Exposure to large‑scale, multi‑tenant cloud platforms and data‑intensive workloads.
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.
Verified company details for this employer are not available yet.
Full-time
Senior · 8+ years experience
Hybrid
Apply faster on company sites with our extension.