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:
- Robust 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