📍 Job Overview

• Job Title: Database Migration Engineer III
• Company: Guidewire Software
• Location: Curitiba, Paraná, Brazil (Remote)
• Job Type: Hybrid (Toronto, Canada or Curitiba, Brazil)
• Category: Database Administration, DevOps
• Date Posted: June 25, 2025
• Experience Level: 5-10 years
• Remote Status: Hybrid

🚀 Role Summary

• Key Responsibilities: Optimize data transfer and runtime database performance, conduct migration dry runs and rehearsals, assist customers with data validation, and develop/maintain migration tooling.
• Key Technologies: Oracle, SQL Server, Postgres, cloud services (AWS, Azure), data replication tools (MS SQL Server transactional replication, Oracle Golden Gate, AWS DMS), UNIX, ANSI SQL, and scripting (bash, python).

📝 Enhancement Note: This role requires a strong background in database engineering and migration, with a focus on optimizing data transfer and runtime performance. Experience with cloud services and data replication tools is essential for success in this position.

💻 Primary Responsibilities

• Database Optimization: Optimize data transfer and runtime database performance using techniques such as query optimization, indexing, and partitioning.
• Migration Rehearsals: Conduct migration dry runs and rehearsals to ensure smooth data transfer and minimal downtime.
• Customer Support: Assist customers with data validation and address any issues that may arise during the migration process.
• Tool Development: Develop and maintain tooling to automate migration activities, improving efficiency and reducing manual effort.
• Collaboration: Work closely with cross-functional teams, including developers, QA, and project managers, to ensure successful migration projects.

📝 Enhancement Note: This role requires strong problem-solving skills and the ability to work well under pressure, particularly during critical migration phases. Experience with infrastructure management tools and programming languages can be beneficial for developing and maintaining migration tooling.

🎓 Skills & Qualifications

Education: Bachelor’s Degree in Computer Science or a related STEM field, or equivalent experience.

Experience: 5+ years of experience with database engineering, including 2+ years in data migration.

Required Skills:

• Deep knowledge of Oracle and/or SQL Server databases
• Database Migration from Oracle and/or SQL Server to Postgres
• 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

Preferred Skills:

• Infrastructure management tools such as Terraform
• Programming experience using languages like Java, C, Kotlin, Go
• Jira and/or Salesforce for managing work requests
• Source control such as Git

📝 Enhancement Note: While the required skills are essential for this role, candidates with additional experience in infrastructure management, programming, or source control may have an advantage in the application process.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

• Demonstrate experience with database optimization, migration, and tool development through relevant projects and case studies.
• Showcase problem-solving skills and the ability to work under pressure by presenting successful migration projects and any challenges overcome.
• Highlight any experience with cloud services, data replication tools, or infrastructure management tools through project examples.

Technical Documentation:

• Provide documentation of database optimization techniques, migration processes, and tool development for past projects.
• Include any relevant code snippets, scripts, or configuration files that demonstrate your technical proficiency.

📝 Enhancement Note: While a portfolio is not explicitly required for this role, providing relevant examples of your work can help demonstrate your skills and experience more effectively.

💵 Compensation & Benefits

Salary Range: The salary range for this role in Brazil is approximately R$12,000 - R$18,000 per month, based on experience and qualifications. This estimate is based on market research and industry standards for database engineers with similar experience in the region.

Benefits:

• Competitive salary and benefits package
• Flexible work arrangement (Hybrid)
• Opportunities for professional growth and development
• A dynamic and inclusive work environment

Working Hours: Standard 40-hour work week, with weekend work required (30-50% of weekends). Commensurate comp time is given flexibly the following week after a weekend is worked.

📝 Enhancement Note: The salary range provided is an estimate based on market research and may vary depending on the candidate's experience, qualifications, and the company's internal compensation structure.

🎯 Team & Company Context

🏢 Company Culture

Industry: Guidewire is a leading provider of software products for the property and casualty (P&C) insurance industry, serving over 540 customers in 40 countries.

Company Size: Guidewire has over 5,000 employees worldwide, providing a large and diverse team environment.

Founded: Guidewire was founded in 2000 and has since grown to become a global leader in its industry.

Team Structure:

• The Database Migration team works closely with cross-functional teams, including developers, QA, and project managers, to ensure successful migration projects.
• The team is responsible for optimizing data transfer and runtime database performance, conducting migration rehearsals, and assisting customers with data validation.

Development Methodology:

• Guidewire follows Agile development methodologies, with a focus on continuous improvement and collaboration.
• The company uses Jira for project management and tracking, and Git for source control.

Company Website: www.guidewire.com

📝 Enhancement Note: Guidewire's size and global presence provide opportunities for professional growth and exposure to diverse projects and teams. The company's focus on Agile methodologies and cross-functional collaboration fosters a dynamic and innovative work environment.

📈 Career & Growth Analysis

Database Migration Career Level: This role is at the senior level, requiring a deep understanding of database optimization, migration, and tool development. The successful candidate will have a proven track record in database engineering and migration, with experience managing complex projects and teams.

Reporting Structure: The Database Migration Engineer III reports directly to the Database Migration Manager and works closely with cross-functional teams, including developers, QA, and project managers.

Technical Impact: The Database Migration Engineer III plays a critical role in ensuring successful data migration projects, minimizing downtime, and optimizing database performance for Guidewire's customers.

Growth Opportunities:

• Technical Growth: Expand your skills and expertise in database optimization, migration, and tool development by working on diverse projects and collaborating with experienced team members.
• Leadership Growth: Develop your leadership and mentoring skills by guiding junior team members and contributing to the team's overall success.
• Career Progression: Advance your career by taking on more complex projects, managing larger teams, or transitioning into a technical leadership role.

📝 Enhancement Note: Guidewire's size and global presence provide ample opportunities for professional growth and development. The company's focus on Agile methodologies and cross-functional collaboration fosters a dynamic and innovative work environment, encouraging continuous learning and skill development.

🌐 Work Environment

Office Type: Guidewire's office in Curitiba, Brazil, is a modern and collaborative workspace designed to facilitate team interaction and productivity.

Office Location(s): Curitiba, Brazil

Workspace Context:

• Collaboration: The office features open-plan workspaces, encouraging collaboration and communication among team members.
• Technology: Guidewire provides state-of-the-art technology and tools to support its employees' work, including high-performance workstations, multiple monitors, and testing devices.
• Flexibility: The hybrid work arrangement allows employees to balance their time between the office and remote work, promoting a healthy work-life balance.

Work Schedule: Standard 40-hour work week, with weekend work required (30-50% of weekends). Commensurate comp time is given flexibly the following week after a weekend is worked.

📝 Enhancement Note: Guidewire's modern and collaborative office environment, combined with its flexible work arrangement, fosters a productive and engaging work experience for its employees.

📄 Application & Technical Interview Process

Interview Process:

1. Phone Screen: A brief phone call to discuss your experience, qualifications, and expectations for the role.
2. Technical Assessment: A hands-on assessment of your database optimization, migration, and tool development skills. This may include coding challenges, system design discussions, or case study presentations.
3. Behavioral Interview: A conversation focused on your problem-solving skills, communication, and teamwork abilities. Be prepared to discuss your approach to challenging situations and your experience working in a collaborative environment.
4. Final Interview: A meeting with the hiring manager or a panel of team members to discuss your fit for the role and the company's culture.

Portfolio Review Tips:

• Highlight your experience with database optimization, migration, and tool development through relevant projects and case studies.
• Demonstrate your problem-solving skills and ability to work under pressure by presenting successful migration projects and any challenges overcome.
• Showcase your technical expertise by providing code snippets, scripts, or configuration files that demonstrate your proficiency in relevant technologies.

Technical Challenge Preparation:

• Brush up on your database optimization, migration, and tool development skills, with a focus on Oracle, SQL Server, Postgres, and relevant cloud services.
• Familiarize yourself with data replication tools and UNIX administration skills, including scripting with bash and python.
• Prepare for system design discussions and case studies by reviewing your past projects and identifying patterns, best practices, and areas for improvement.

ATS Keywords: [Provide a comprehensive list of relevant keywords for resume optimization, organized by category: database technologies, cloud services, data replication tools, UNIX administration, programming languages, and soft skills.]

📝 Enhancement Note: Guidewire's interview process is designed to assess your technical skills, problem-solving abilities, and cultural fit. By preparing thoroughly and showcasing your experience and expertise, you can increase your chances of success in the application process.

🛠 Technology Stack & Web Infrastructure

Database Technologies:

• Oracle
• SQL Server
• Postgres

Cloud Services:

• AWS
• Azure

Data Replication Tools:

• MS SQL Server transactional replication
• Oracle Golden Gate
• AWS DMS

UNIX Administration:

• bash
• python

Programming Languages:

• Java
• C
• Kotlin
• Go

Source Control:

• Git

Project Management:

• Jira

📝 Enhancement Note: Familiarity with the technologies listed above is essential for success in this role. Candidates with experience in additional relevant technologies may have an advantage in the application process.

👥 Team Culture & Values

Database Migration Values:

• Customer Focus: Prioritize customer needs and ensure successful data migration projects that minimize downtime and optimize database performance.
• Collaboration: Work closely with cross-functional teams, including developers, QA, and project managers, to ensure successful migration projects.
• Continuous Learning: Stay up-to-date with the latest database optimization, migration, and tool development techniques and best practices.
• Innovation: Contribute to the development of new tools and processes that improve the efficiency and effectiveness of data migration projects.

Collaboration Style:

• Cross-functional Integration: Work closely with developers, QA, and project managers to ensure successful migration projects and minimize downtime.
• Code Review Culture: Collaborate with team members to review and improve code, scripts, and configuration files.
• Knowledge Sharing: Share your expertise and experience with junior team members and contribute to the team's overall success.

📝 Enhancement Note: Guidewire's focus on customer focus, collaboration, continuous learning, and innovation fosters a dynamic and engaging work environment for its employees. The company's cross-functional integration and knowledge-sharing culture encourage teamwork and professional growth.

⚡ Challenges & Growth Opportunities

Technical Challenges:

• Database Optimization: Develop and implement strategies to optimize data transfer and runtime database performance for complex and large-scale databases.
• Migration Complexity: Plan and execute migration projects for databases with large volumes and complex data structures, minimizing downtime and ensuring data integrity.
• Cloud Migration: Migrate databases from legacy Guidewire systems to the company's Cloud Platform, optimizing performance and minimizing downtime.
• Emerging Technologies: Stay up-to-date with the latest database optimization, migration, and tool development techniques and best practices, and incorporate them into your work.

Learning & Development Opportunities:

• Technical Skill Development: Expand your skills and expertise in database optimization, migration, and tool development by working on diverse projects and collaborating with experienced team members.
• Conference Attendance: Attend industry conferences and events to learn from experts and network with peers in the database engineering and migration community.
• Certification: Pursue relevant certifications to demonstrate your expertise and commitment to continuous learning.
• Mentorship: Seek guidance and support from experienced team members to develop your leadership and technical skills.

📝 Enhancement Note: Guidewire's focus on technical challenges and learning opportunities provides ample opportunities for professional growth and development. The company's commitment to staying at the forefront of the industry encourages continuous learning and skill development.

💡 Interview Preparation

Technical Questions:

• Database Optimization: Prepare for questions about database optimization techniques, query performance, indexing, and partitioning.
• Migration Process: Be ready to discuss migration strategies, data validation, and downtime minimization techniques.
• Tool Development: Expect questions about your experience with tool development, automation, and scripting.

Company & Culture Questions:

• Company Culture: Research Guidewire's company culture, values, and mission to demonstrate your fit for the role and the organization.
• Team Dynamics: Prepare for questions about your experience working in a collaborative environment and your ability to contribute to the team's success.
• Problem-Solving: Be ready to discuss your approach to challenging situations and your experience working under pressure.

Portfolio Presentation Strategy:

• Project Selection: Choose relevant projects that demonstrate your experience with database optimization, migration, and tool development.
• Storytelling: Prepare a compelling narrative that highlights your problem-solving skills, technical expertise, and the impact of your work on past projects.
• Visual Aids: Use visual aids, such as diagrams, flowcharts, or screenshots, to illustrate your points and enhance your presentation.

📝 Enhancement Note: Guidewire's interview process is designed to assess your technical skills, problem-solving abilities, and cultural fit. By preparing thoroughly and showcasing your experience and expertise, you can increase your chances of success in the application process.

📌 Application Steps

To apply for this Database Migration Engineer III position:

1. Submit Your Application: Click the application link and submit your resume, highlighting your relevant experience and qualifications.
2. Prepare Your Portfolio: Customize your portfolio with relevant projects and case studies that demonstrate your experience with database optimization, migration, and tool development.
3. Research Guidewire: Learn about Guidewire's company culture, values, and mission to ensure a strong fit for the role and the organization.
4. Prepare for Technical Assessment: Brush up on your database optimization, migration, and tool development skills, and prepare for hands-on challenges and case studies.
5. Practice Behavioral Interview Questions: Reflect on your problem-solving skills, communication, and teamwork abilities, and prepare for behavioral interview questions that assess your fit for the role and the company's culture.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and database engineering industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.