Database Migration Specialist

Start smart: PLM built for the way your business really works.

A Database Migration Specialist is responsible for planning, executing, and validating the transfer of data between databases, platforms, or environments while ensuring accuracy, performance, and minimal downtime.

This role blends DBA expertise, strong SQL skills, and data engineering knowledge.

Virtual, US-based

+ 5 years

• Advanced SQL syntax knowledge
• RDBMS experience (Oracle, SQL Server, Postgre
  
  SQL, MySQL)
• Schema design and normalization
• Performance tuning
• Indexing strategies
• ETL tools
• Scripting

• Data integrity & constraints
• Backup & recovery
• Security & access controls
• Cross-platform database compatibility

• Work directly with industry-leading manufacturers undergoing digital transformation
• Join a specialized PLM consultancy with deep expertise and long-standing customer relationships
• Competitive compensation and comprehensive benefits package
• Opportunities for growth into solution leadership roles
• Collaborative, flexible, and high-impact team environment
• To apply for this position complete the form on this page.

Domain Systems, Inc, is an Equal Opportunity Employer and does not discriminate on the basis of race, national origin, religion, color, gender, sexual orientation, age, non-disqualifying physical or mental disability, or any other basis covered by law. Employment decisions are based solely on skills and business needs. Applicants must be legally authorized to work in the United States without current or future employer sponsorship.

• Assess source and target database environments
• Analyze schemas, data structures, constraints, and dependencies
• Identify compatibility issues between platforms (e.g., Oracle → SQL Server)
• Create migration strategy (full migration, phased, incremental, etc.)

• Develop transformation scripts to align data structures
• Cleanse and normalize data before migration
• Map legacy fields to new schema designs

• Perform data transfers using:
  • ETL tools
  • Custom SQL scripts
  • Data pump / export-import utilities
  • Cloud migration tools
• Monitor migration jobs for errors and performance issues

• Reconcile record counts and data integrity