Demo

Database Migration Specialist

Lorven technologies
Boston, MA Full Time
POSTED ON 2/25/2025
AVAILABLE BEFORE 5/22/2025

Our client is looking for a Database Migration Specialist with a Long Term project in Boston, MA (Hybrid) below is the detailed requirement.

If you are interested kindly share your updated resume to proceed further.

Job Role : Database Migration Specialist

Location : Boston, MA (Hybrid)

Mode of Hiring : Long Term

Position Overview

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.

Job Description :

  • Bachelor's Degree in related field required; advanced degree in Business or Engineering preferred, with minimum 12 Years of relevant experience.
  • 7 years of experience in database administration, 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.
  • 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).

Preferred Qualifications

  • Certifications such as AWS Certified Solutions Architect or AWS Certified Data Analytics Specialty.
  • Experience with real-time data replication and CDC (Change Data Capture) tools like Debezium or Kafka.
  • Knowledge of cloud infrastructure and services, particularly in AWS (e.g., EC2, S3, IAM).
  • Familiarity with containerized environments (Docker, Kubernetes) for database deployment and testing.
  • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Database Migration Specialist?

    Sign up to receive alerts about other jobs on the Database Migration Specialist career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $150,731 - $188,044
    Income Estimation: 
    $176,131 - $238,730
    Income Estimation: 
    $172,979 - $241,697
    Income Estimation: 
    $113,076 - $148,099
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $115,719 - $153,093
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $120,390 - $162,969
    Income Estimation: 
    $66,897 - $84,160
    Income Estimation: 
    $74,161 - $98,561
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $88,359 - $121,264
    Income Estimation: 
    $113,076 - $148,099
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Lorven technologies

    Lorven technologies
    Hired Organization Address Hartford, CT Full Time
    Our client is looking for a Automation Engineer for Long Term Contract project in Hartford, CT (Hybrid) below is the det...
    Lorven technologies
    Hired Organization Address Nashville, TN Full Time
    Job Title: System Administrator Location: Nashville, TN 37243 (Hybrid) Duration: 12 Months Contract Job Description This...
    Lorven technologies
    Hired Organization Address Raritan, NJ Full Time
    Job Details Hi, Our client is looking for a SAP QM with a Long-Term Contract project in Raritan, NJ below is the detaile...
    Lorven technologies
    Hired Organization Address Raritan, NJ Contractor
    Hi, Our client is looking for a SAP PP/QM with a Long-Term Contract project in Raritan, NJ below is the detailed require...

    Not the job you're looking for? Here are some other Database Migration Specialist jobs in the Boston, MA area that may be a better fit.

    Senior Account Executive

    Database USA, Wakefield, MA

    AI Assistant is available now!

    Feel free to start your new journey!