Senior Informix Database Migration Consultant
Location: Dallas, TX
Work Arrangement: 100% Onsite – Mandatory
Experience: 8+ Years
Job Summary
We are seeking an experienced Senior Informix Database Migration Consultant with strong hands-on expertise in IBM Informix database administration, modernization, and migration.
The candidate will be responsible for assessing legacy Informix database environments, developing migration strategies, and executing both homogeneous and heterogeneous database migrations to cloud-hosted target platforms, including PostgreSQL and MySQL.
The ideal candidate should have experience supporting large-scale enterprise database modernization initiatives, along with strong knowledge of Linux environments and database migration processes.
Key Responsibilities
Assess existing Informix database environments and develop comprehensive migration roadmaps.
Perform database schema conversion, data extraction, transformation, and migration activities.
Execute heterogeneous database migrations from IBM Informix to PostgreSQL and/or MySQL.
Support homogeneous Informix database version upgrades, where applicable.
Conduct migration testing, data validation, performance tuning, and database optimization.
Collaborate with application teams to identify and implement application code changes required for database migration.
Develop migration runbooks, rollback plans, and cutover strategies.
Support cloud-based database deployments on Linux environments, including RHEL/Rocky Linux, and AWS EC2 platforms.
Work closely with infrastructure, application, and testing teams to ensure successful migration delivery.
Participate in technical assessments and due diligence activities for potential migration candidates.
Troubleshoot database migration issues and ensure data integrity and performance throughout the migration lifecycle.
Required Skills and Qualifications
8+ years of experience in database administration and database migration.
Strong hands-on experience with IBM Informix database administration and architecture.
Proven experience migrating Informix databases to PostgreSQL and/or MySQL.
Experience with database schema conversion, ETL processes, and data validation.
Strong understanding of Linux administration, particularly RHEL and Rocky Linux.
Experience with database backup, recovery, performance tuning, and high availability.
Experience supporting large-scale enterprise database migration and modernization programs.
Strong troubleshooting, analytical, and problem-solving skills.
Excellent communication and stakeholder management skills.
Preferred Qualifications
AWS cloud migration experience, particularly with AWS EC2.
Experience working on enterprise transformation and database modernization programs.
Familiarity with database migration and automation tools.
Previous experience in telecom industry database migration initiatives.
Key Technical Skills
IBM Informix | PostgreSQL | MySQL | Database Migration | Database Administration | Schema Conversion | ETL | Data Validation | RHEL | Rocky Linux | AWS EC2 | Linux Administration | Performance Tuning | Backup & Recovery | High Availability
Ideal Candidate Profile
The ideal candidate will be a hands-on Informix Database Migration Consultant with proven experience executing Informix-to-PostgreSQL or Informix-to-MySQL migrations. Candidates should have strong database administration fundamentals, Linux expertise, and experience delivering enterprise-scale database modernization projects.