Configure and troubleshoot CDC (Change Data Capture) pipelines for near-zero downtime cutover.
Collaborate with data engineering/ETL teams to validate data integrity, referential consistency, and volume reconciliation post-migration.
Resolve data type mismatches, truncation issues, and encoding/collation conflicts.
Performance Optimization & Cloud Tuning
Analyze query execution plans and refactor migrated queries for optimal PostgreSQL performance.
Design and implement effective indexing strategies and leverage PostgreSQL-specific features.
Tune Aurora PostgreSQL parameters and advise on instance sizing.
Benchmark and stress-test migrated workloads; provide performance sign-off before production cutover.
Automation, Support & Documentation
Develop and maintain migration automation scripts (SQL, shell, Python, etc.) to streamline conversions and validations.
Provide L2/L3 support during migration, cutover, and post-go-live phases.
Document migration standards, conversion guidelines, and PostgreSQL development best practices.
Mentor internal teams on PostgreSQL development patterns and migration considerations.
Ensure all migrated objects comply with organizational security and compliance policies.
Preferred Qualifications
4+ years of experience in database development, with at least 3 years focused on PostgreSQL.
Proven track record in large-scale, heterogeneous migrations (SQL Server → PostgreSQL/Aurora PostgreSQL).
Strong proficiency in
o PL/pgSQL, advanced SQL (window functions, CTEs, JSON/JSONB)
o AWS DMS, SCT, pg_dump/pg_restore, pgLoader, or similar tools
o Query performance tuning & execution plan analysis
o Version control (Git) and CI/CD integration for database changes (e.g., Liquibase, Flyway)
Familiarity with cloud infrastructure (AWS RDS/Aurora, IAM, VPC, security groups).
Experience with monitoring tools (CloudWatch, pg_stat_statements, pgBadger, Datadog).
Nice-to-Have
Exposure to other source platforms (Oracle, MySQL, Sybase) for a broader heterogeneous migration context.
Knowledge of database DevOps (GitOps, automated testing, drift detection).
AWS Certified Database – Speciality or PostgreSQL professional certifications.
