Visa: L2, TN, E2,(No H1B & OPT)
Experience: 15+ Years
Key Responsibilities:
Lead and execute end-to-end database migrations from Sybase ASE to PostgreSQL / Amazon Aurora PostgreSQL.
Assess database schemas, stored procedures, functions, triggers, SQL, and dependencies.
Perform schema conversion, SQL remediation, and compatibility fixes.
Execute data migration using AWS DMS, AWS SCT, CDC, and SQL.
Perform data validation, reconciliation, and migration troubleshooting.
Handle PostgreSQL performance tuning, query optimization, and indexing.
Develop cutover, rollback, backup/recovery, and production stabilization plans.
Manage database deployments and change management using Flyway.
Required Skills & Experience:
10+ years of overall database engineering / DBA experience.
5+ years of hands-on PostgreSQL experience.
Strong production experience with Sybase ASE to PostgreSQL migration (Mandatory).
At least one complete enterprise migration experience covering assessment, schema conversion, data migration, validation, cutover, and post-production support.
Hands-on experience with Amazon Aurora PostgreSQL, AWS DMS, AWS SCT, and CDC.
Strong knowledge of database performance tuning, HA/DR, backup/recovery, and troubleshooting.
Experience with Flyway or similar database change-management tools.
Good to Have:
Exposure to Oracle and SQL Server migrations.
Experience with Terraform, Python, and database migration automation.
Bachelor's degree in Computer Science, IT, Engineering, or equivalent experience.
Important: This is a hands-on technical architect position, not an advisory-only role. Candidates must have proven, real-world experience independently executing and troubleshooting Sybase-to-PostgreSQL migrations in production environments.