DBA with Data Migration

Job Title: DBA with Data Migration

Location: Plano, TX | (Onsite)

Job Type: Fulltime

Job Description

Must Have Technical/Functional Skills

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• Proven experience as a Database Administrator and/or Data Engineer, with a focus on data migration projects.
• Hands‑on experience with Aurora PostgreSQL, MongoDB, and Oracle databases.
• Strong expertise in data modeling tools and techniques.
• Proficiency in ETL tools and scripting languages (e.g., Python, SQL, Shell scripting).
• Familiarity with microservices architecture and associated data‑management challenges.
• Experience with cloud platforms (AWS preferred) and cloud‑native database services.
• Strong problem‑solving skills and attention to detail.
• Excellent communication and collaboration skills.

Roles & responsibilities

• Analyze existing legacy data systems and understand data structures, dependencies, and quality issues.
• Design and develop scalable, efficient data models aligned with the microservice‑based SOR architecture.
• Plan and execute data migration strategies, including extraction, transformation, and loading (ETL) from legacy systems to the new platform.
• Develop and optimize database schemas and queries in Aurora PostgreSQL, MongoDB, and Oracle DB.
• Collaborate with software architects, developers, and business analysts to ensure data requirements are met.
• Develop scripts, stored procedures, and automation tools to facilitate data migration and validation.
• Monitor and optimize database performance, ensuring data consistency and integrity throughout the migration process.
• Implement data validation and reconciliation processes to verify successful migration.
• Document data models, migration processes, and best practices.
• Provide ongoing support and troubleshooting during and after migration.
• Ensure compliance with data governance, security policies, and regulatory requirements.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.