Database Migration Specialist - 6+ yrs

Job Title: Database Migration Specialist

Experience Required: Min 8 Years

Location: Remote/Hybrid

Employment Type: Full-Time

Job Summary:

We are looking for an experienced Database Migration Specialist to lead and execute complex migration projects from SQL Server, DB2, and Oracle to PostgreSQL. The ideal candidate will have deep expertise in data modeling, schema conversion, performance tuning, and automation of migration workflows.Hands-on experience as a PostgreSQL DBA, particularly in AWS environments such as RDS or Aurora, is essential. The role also requires strong skills in data validation and integrity checking to ensure the accuracy and reliability of all migrated systems

Key Responsibilities:

• Analyze legacy databases (SQL Server, DB2, Oracle) to identify schemas, data, stored procedures, and dependencies.

• Plan and execute seamless database migrations to PostgreSQL with minimal downtime.

• Use tools such as AWS DMS, ora2pg, pgloader, or native scripts to automate and manage migrations.

• Convert and optimize PL/SQL or T-SQL procedures/functions to PL/pgSQL.

• Conduct thorough data validation, integrity checks, and reconciliation post-migration.

• Tune queries, indexing strategies, and PostgreSQL configurations for optimal performance.

• Serve as a PostgreSQL DBA, including AWS RDS administration, configuration, monitoring, and troubleshooting.

• Collaborate with application and infrastructure teams to support the entire migration lifecycle.

• Document migration processes, encountered issues, and applied mitigation strategies.

• Design and implement rollback strategies and disaster recovery procedures during migration phases.

Required Skills and Qualifications:

• Min 6 years of experience in database migration and administration.

• Proven track record of migrating databases from SQL Server, DB2, or Oracle to PostgreSQL.

• Strong knowledge of SQL, PL/SQL, T-SQL, and PL/pgSQL.

• Hands-on experience with PostgreSQL performance tuning, indexing, and replication.

• Experience with migration tools like AWS DMS, ora2pg, pgloader, SQL Developer, etc.

• Practical experience working with Linux environments.

• Proficient in data validation, integrity checking, and ensuring consistency in migrated datasets.

• Strong scripting skills in Bash, Python, or similar for automation and transformation tasks.

• Solid understanding of ETL processes, data pipelines, and schema refactoring.

• Excellent communication, documentation, and problem-solving skills.

• Experience as a PostgreSQL DBA, particularly with AWS RDS or Aurora PostgreSQL.

Preferred Qualifications:

• Experience with cloud database migration, especially AWS RDS for PostgreSQL or Aurora.

• Exposure to DevOps tools, CI/CD pipelines, and version control systems like Git.

• Familiarity with PostgreSQL extensions such as PostGIS, pg_partman, etc.

• Certifications in PostgreSQL or cloud platforms like AWS or Azure.