Database Migration Specialist--Sybase and MySQL to PostgreSQL or Redshift

Database Migration Specialist--Sybase and MySQL to PostgreSQL or Redshift
Boston MA
Long Term
Contract

We are seeking an experienced Database Migration Specialist to lead the migration of databases from Sybase and MySQL to PostgreSQL and Amazon Redshift. The successful candidate will be responsible for planning, executing, and optimizing the migration process while ensuring data integrity, performance, and minimal downtime. This role requires a deep understanding of both transactional (PostgreSQL) and analytical (Redshift) database platforms, as well as hands-on experience with large-scale data migration projects.

Key Responsibilities

1. Migration Planning and Strategy

Analyze the existing Sybase and MySQL environments, including schema structures, stored procedures, triggers, and dependencies.

Develop a detailed migration strategy, determining the best fit for PostgreSQL (transactional workloads) and Redshift (analytical workloads).

Plan for minimal downtime, data validation, and rollback strategies in case of migration issues.

1. Schema and Data Migration

Use tools like AWS Schema Conversion Tool (SCT), pgLoader, Ora2Pg, and AWS Data Migration Service (DMS) to automate schema conversion and data migration.

Customize migration scripts to handle complex schema conversions, such as views, functions, and triggers.

Ensure data accuracy and integrity through robust data cleansing, transformation, and validation processes.

1. Performance Optimization

Optimize PostgreSQL databases for transactional performance by fine-tuning indexes, partitioning, and query plans.

Enhance Redshift performance by optimizing distribution keys, sort keys, and using compression techniques.

Design and implement efficient ETL pipelines for Redshift using tools like AWS Glue, Matillion, or custom scripts.

1. Testing and Validation

Develop and execute comprehensive testing plans, including functional testing, data validation, and performance benchmarking.

Validate data accuracy and integrity between source and target systems.

Address performance bottlenecks and ensure all applications and reporting tools work seamlessly post-migration.

1. Post-Migration Support and Documentation

Provide ongoing support post-migration, including performance tuning and issue resolution.

Document migration processes, configurations, and best practices for future reference.

Train and mentor teams on the use of PostgreSQL and Redshift, including query optimization and database maintenance.

Qualifications

Technical Skills

Deep expertise in Sybase ASE/IQ, MySQL, PostgreSQL, and Amazon Redshift.

Proficiency with database migration tools such as AWS SCT, pgLoader, Ora2Pg, and AWS DMS.

Strong SQL and scripting skills (e.g., Python, Bash, Perl) for custom data migration and automation tasks.

Knowledge of PostgreSQL-specific features like PL/pgSQL, partitioning, and JSON.

Experience with Redshift performance tuning, including distribution styles, sort keys, and query optimization.

Familiarity with ETL tools and data pipeline orchestration (e.g., AWS Glue, Apache Airflow, Talend).

Experience

5+ years of experience in database administration, development, or migration.

Proven experience in migrating databases from Sybase and MySQL to PostgreSQL and/or Redshift.

Hands-on experience with large-scale data migration projects, including both OLTP and OLAP systems.

Soft Skills

Strong problem-solving and analytical skills to troubleshoot migration and performance issues.

Excellent communication and collaboration skills to work with cross-functional teams.

Ability to manage complex projects and meet tight deadlines.

Munesh

,

CYBER SPHERE LLC

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Database Migration Specialist--Sybase and MySQL to PostgreSQL or Redshift
Boston MA
Long Term
Contract

We are seeking an experienced Database Migration Specialist to lead the migration of databases from Sybase and MySQL to PostgreSQL and Amazon Redshift. The successful candidate will be responsible for planning, executing, and optimizing the migration process while ensuring data integrity, performance, and minimal downtime. This role requires a deep understanding of both transactional (PostgreSQL) and analytical (Redshift) database platforms, as well as hands-on experience with large-scale data migration projects.

Key Responsibilities

1. Migration Planning and Strategy

Analyze the existing Sybase and MySQL environments, including schema structures, stored procedures, triggers, and dependencies.

Develop a detailed migration strategy, determining the best fit for PostgreSQL (transactional workloads) and Redshift (analytical workloads).

Plan for minimal downtime, data validation, and rollback strategies in case of migration issues.

1. Schema and Data Migration

Use tools like AWS Schema Conversion Tool (SCT), pgLoader, Ora2Pg, and AWS Data Migration Service (DMS) to automate schema conversion and data migration.

Customize migration scripts to handle complex schema conversions, such as views, functions, and triggers.

Ensure data accuracy and integrity through robust data cleansing, transformation, and validation processes.

1. Performance Optimization

Optimize PostgreSQL databases for transactional performance by fine-tuning indexes, partitioning, and query plans.

Enhance Redshift performance by optimizing distribution keys, sort keys, and using compression techniques.

Design and implement efficient ETL pipelines for Redshift using tools like AWS Glue, Matillion, or custom scripts.

1. Testing and Validation

Develop and execute comprehensive testing plans, including functional testing, data validation, and performance benchmarking.

Validate data accuracy and integrity between source and target systems.

Address performance bottlenecks and ensure all applications and reporting tools work seamlessly post-migration.

1. Post-Migration Support and Documentation

Provide ongoing support post-migration, including performance tuning and issue resolution.

Document migration processes, configurations, and best practices for future reference.

Train and mentor teams on the use of PostgreSQL and Redshift, including query optimization and database maintenance.

Qualifications

Technical Skills

Deep expertise in Sybase ASE/IQ, MySQL, PostgreSQL, and Amazon Redshift.

Proficiency with database migration tools such as AWS SCT, pgLoader, Ora2Pg, and AWS DMS.

Strong SQL and scripting skills (e.g., Python, Bash, Perl) for custom data migration and automation tasks.

Knowledge of PostgreSQL-specific features like PL/pgSQL, partitioning, and JSON.

Experience with Redshift performance tuning, including distribution styles, sort keys, and query optimization.

Familiarity with ETL tools and data pipeline orchestration (e.g., AWS Glue, Apache Airflow, Talend).

Experience

5+ years of experience in database administration, development, or migration.

Proven experience in migrating databases from Sybase and MySQL to PostgreSQL and/or Redshift.

Hands-on experience with large-scale data migration projects, including both OLTP and OLAP systems.

Soft Skills

Strong problem-solving and analytical skills to troubleshoot migration and performance issues.

Excellent communication and collaboration skills to work with cross-functional teams.

Ability to manage complex projects and meet tight deadlines.

Munesh

,

CYBER SPHERE LLC

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.