Job Description

PostgreSQL Developer - Data migration

  • At least 5+ years of experience in designing, planning, and executing data migrations involving PostgreSQL databases
  • Strong hands-on experience with PostgreSQL architecture, performance tuning, indexing, and query optimization
  • Proven experience migrating data from legacy databases (Oracle, SQL Server, MySQL, etc.) to PostgreSQL
  • Experience defining and executing data migration strategies such as full load, incremental load, and minimal-downtime migrations
  • Hands-on experience with PostgreSQL migration utilities such as pg_dump, pg_restore, psql, logical replication, and foreign data wrappers
  • Ability to analyze source and target schemas, perform data mapping, and resolve data quality and data type issues
  • Experience validating migrated data for accuracy, completeness, and performance benchmarks
  • Strong SQL and PL/pgSQL skills, including stored procedures, functions, and query optimization
  • Experience working with cloud-based PostgreSQL solutions such as Amazon RDS for PostgreSQL or Aurora PostgreSQL
  • Working knowledge of AWS data services and architecture, with the ability to collaborate effectively with teams handling AWS Glue and ETL development
  • Experience coordinating with AWS Glue, S3, and related AWS services for data ingestion and migration workflows (Glue scripts developed and managed by separate teams)
  • Understanding of IAM roles, security groups, encryption, and network configurations related to PostgreSQL on AWS
  • Familiarity with CI/CD processes for database changes and migration execution
  • Experience supporting large-scale data migrations involving high data volumes and complex transactional systems
  • Strong understanding of SDLC, migration planning, cutover execution, and post-migration validation
  • Ability to troubleshoot data migration, performance, and connectivity issues across PostgreSQL and AWS environments
  • Self-motivated, able to work independently on critical tasks and collaboratively with cross-functional teams
  • Strong communication and stakeholder management skills across teams, regions, and domains
  • Order-to-Cash or similar enterprise business domain knowledge is strongly preferred
  • Bachelor's or Master's degree in Computer Science, Engineering, or equivalent experience

Apply for this Position

Ready to join ? Click the button below to submit your application.

Submit Application