Database Migration Engineer

Insight Global; São Paulo; Presencial; BRL 120.000 - 160.000; Tempo integral

Resumo da oferta

A technology solutions firm is seeking an experienced Senior Database Migration Engineer to lead the migration of a significant number of SQL Server databases to AWS Aurora PostgreSQL for a vital legal accounting platform. The ideal candidate has over 5 years of hands-on SQL Server experience and proven expertise in executing large-scale migrations while ensuring data integrity and application performance. Knowledge of AWS services and PostgreSQL is essential.

Qualificações

• 5+ years of hands-on SQL Server experience (2012-2022).
• Proven experience with AWS Database Migration Service (DMS).
• Led at least one large-scale SQL Server to PostgreSQL migration (500+ databases).

Responsabilidades

• Lead the migration of 2,600+ SQL Server databases to AWS Aurora PostgreSQL.
• Execute large-scale, zero-downtime migrations while maintaining data integrity.

Conhecimentos

Hands-on SQL Server experience

AWS Database Migration Service (DMS)

AWS Schema Conversion Tool (SCT)

PostgreSQL architecture knowledge

PostgreSQL query planner knowledge

Descrição da oferta de emprego

JOB DESCRIPTION

We are seeking an experienced Senior Database Migration Engineer to lead the migration of 2,600+ SQL Server databases to AWS Aurora PostgreSQL for a mission‑critical legal accounting platform. This role requires deep expertise in both SQL Server and PostgreSQL, AWS database migration services, and the ability to execute large‑scale, zero‑downtime migrations while maintaining data integrity and application performance.

REQUIRED SKILLS AND EXPERIENCE

• 5+ years of hands‑on SQL Server experience (2012‑2022) - Proven experience with AWS Database Migration Service (DMS) - Hands‑on experience with AWS Schema Conversion Tool (SCT) - Led at least one large‑scale SQL Server to PostgreSQL migration (500+ databases) - Strong knowledge of PostgreSQL architecture and query planner

NICE TO HAVE SKILLS AND EXPERIENCE

• Experience with RDS Proxy or connection pooling solutions - Understanding of PostgreSQL performance tuning (EXPLAIN, pg_stat_statements) - Experience working with .NET applications and Entity Framework Core