Senior Database Migration Engineer

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
• Migrating data to Aurora Postgres or PostgreSQL
• Migrating data from Oracle and/or SQL Server
• 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