- Convert SQL, stored procedures, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
- Work through AWS SCT findings, flagging limitations that need senior review.
- Maintain the Flyway migration codebase, including versioned scripts and rollbacks.
- Identify and troubleshoot database-related application bugs.
- Support query optimization for PostgreSQL through execution plans and indexing.
- Monitor AWS DMS during load and CDC phases.
- Validate and reconcile data between source and target databases.
- Collaborate with application teams to align SQL behavior and performance expectations.
PostgreSQLSQLMicrosoft SQL Server+1 more