Database Migration Engineer

Yulista Holding, LLC; Falls Church (VA); On-site; USD 100,000 - 135,000; Full time

Job summary

STRAITSYS INC in Falls Church, VA is seeking a Database Migration Engineer to support EOIR modernization. You will analyze legacy data sources, map and transform data, and migrate it into modernized database environments while ensuring data integrity and security.

You will collaborate with government stakeholders, analysts, and developers across the SDLC, performing profiling, validation, troubleshooting, and cutover activities.

Qualifications

• US Citizen with ability to obtain DOJ Public Trust.
• Experience migrating data for enterprise applications.
• Experience with relational databases and SQL.
• Knowledge of data mappings, transformation, validation, and reconciliation.

Responsibilities

• Analyze legacy data sources, structures, and dependencies for migration planning.
• Develop data migration strategies, source-to-target mappings, and transformation rules.
• Extract, transform, and load data into modernized environments.
• Collaborate with stakeholders to define data quality criteria and validation.
• Perform data profiling to identify quality issues and migration risks.
• Design repeatable migration processes for multiple environments.
• Validate and reconcile migrated data to ensure integrity.
• Develop and maintain migration queries and utilities.
• Support cutover planning and post-migration validation.

Skills

SQL

Data profiling

ETL processes

Data mapping

Data quality

Troubleshooting

Education

Bachelor's degree

Relevant professional experience

Tools

MS SQL Server

Azure DevOps

Azure data technologies

Job description

STRAITSYS INC Regular PRIMARY FUNCTION

The Database Migration Engineer provides database engineering, data migration, and technical implementation support for enterprise application modernization efforts supporting the Executive Office for Immigration Review (EOIR). This individual is responsible for analyzing, mapping, transforming, migrating, validating, and reconciling data from legacy systems into modernized application environments. The Database Migration Engineer works closely with Government stakeholders, business analysts, functional subject matter experts, developers, solution architects, security personnel, and testing personnel to ensure data is accurately and securely migrated while preserving data integrity and supporting operational continuity. This individual supports migration activities throughout the system development lifecycle, including data discovery, migration planning, development, testing, cutover, validation, and post-migration support. This position is contingent up contract award.

ESSENTIAL FUNCTIONS

• Analyze legacy data sources, structures, schemas, relationships, and dependencies to support migration planning and execution.
• Develop and maintain data migration strategies, source-to-target mappings, transformation rules, scripts, and procedures.
• Extract, transform, and load data from legacy systems into modernized applications and supporting database environments.
• Collaborate with Government stakeholders, business analysts, and Functional SMEs to define data mappings, business rules, validation criteria, and data quality requirements.
• Perform data profiling and analysis to identify data quality issues, inconsistencies, duplicates, gaps, and migration risks.
• Develop processes to cleanse, normalize, transform, and prepare legacy data for migration.
• Design and execute repeatable migration processes to support development, testing, staging, and production environments.
• Perform data validation and reconciliation to verify the completeness, accuracy, consistency, and integrity of migrated data.
• Develop queries, scripts, utilities, and other technical components necessary to support migration and validation activities.
• Collaborate with application and integration developers to ensure migrated data aligns with target application structures, interfaces, and functionality.
• Support database schema mapping and modifications necessary to accommodate legacy data within modernized solutions.
• Work with Security Engineers and system administrators to ensure data is appropriately protected throughout extraction, transformation, transfer, storage, and migration activities.
• Support migration testing, including trial migrations, data validation, regression testing, and production readiness activities.
• Identify, document, track, troubleshoot, and resolve migration defects, data discrepancies, and technical issues.
• Support migration cutover planning and execution to minimize disruption to ongoing Government operations.
• Develop and support rollback, recovery, and contingency procedures associated with migration activities as required.
• Monitor migration performance and troubleshoot database, data transformation, and migration-related issues.
• Maintain technical documentation, including source-to-target mappings, transformation rules, migration procedures, validation results, reconciliation records, and known issues.
• Participate in technical reviews, migration readiness reviews, Agile activities, project meetings, and other implementation activities.
• Support post-migration validation, stabilization, knowledge transfer, and transition activities.

SUPERVISORY RESPONSIBILITIES

No

DESIRED KNOWLEDGE, SKILLS, & ABILITIES

• Experience supporting the Department of Justice (DOJ), EOIR, or other Federal civilian agencies.
• Experience performing data migration for enterprise application modernization or digital transformation initiatives.
• Experience analyzing and migrating data from legacy applications and databases to modern or cloud-based solutions.
• Experience with relational database technologies and SQL.
• Experience with data extraction, transformation, and loading (ETL) processes and tools.
• Knowledge of data mapping, transformation, cleansing, normalization, validation, and reconciliation techniques.
• Experience developing and executing complex database queries, scripts, and data migration utilities.
• Experience performing data profiling and identifying and resolving data quality issues.
• Familiarity with Microsoft SQL Server, Azure-based data technologies, or similar enterprise database platforms.
• Knowledge of database schemas, relationships, constraints, indexing, and data integrity principles.
• Experience conducting trial migrations and supporting production data migration and cutover activities.
• Familiarity with data security, access controls, and protection of sensitive Government information.
• Experience working within Agile software development and DevSecOps environments.
• Familiarity with Azure DevOps or similar development and work management tools.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to effectively collaborate with business, functional, technical, and Government stakeholders.
• SM & ABILITIES:

QUALIFICATIONS

• Must be a US Citizen.
• Must be able to successfully obtain and maintain the appropriate Department of Justice (DOJ) Public Trust Investigation (PTI) as required for the position.
• Bachelor's degree from an accredited college or university and relevant professional experience in database engineering, data migration, data management, software development, information technology, or a related discipline.
• Ability to successfully pass a pre-employment drug test and background check.

PLACE OF PERFORMANCE

The principal place of performance will be EOIR Headquarters located in Falls Church, VA.

PREFERENCE STATEMENT

Preference will be given to Calista shareholders and their descendants and to spouses of Calista shareholders, and to shareholders of other corporations created pursuant to the Alaska Native Claims Settlement Act, in accordance with Title 43 U.S. Code 1626(g).

EEO STATEMENT

Additionally, it is our policy to select, place, train and promote the most qualified individuals based upon relevant factors such as work quality, attitude and experience, so as to provide equal employment opportunity for all employees in compliance with applicable local, state and federal laws and without regard to non-work related factors such as race, color, religion/creed, sex, national origin, age, disability, marital status, veteran status, pregnancy, sexual orientation, gender identity, citizenship, genetic information, or other protected status. When applicable, our policy of non-discrimination applies to all terms and conditions of employment, including but not limited to, recruiting, hiring, training, transfer, promotion, placement, layoff, compensation, termination, reduction in force and benefits.

REASONABLE ACCOMMODATION

It is Calista and Subsidiaries' business philosophy and practice to provide reasonable accommodations, according to applicable state and federal laws, to all qualified individuals with physical or mental disabilities.

The statements contained in this job description are intended to describe the general content and requirements for performance of this job. It is not intended to be an exhaustive list of all job duties, responsibilities, and requirements. This job description is not an employment agreement or contract. Management has the exclusive right to alter the scope of work within the framework of this job description at any time without prior notice.

Thank you for your interest in Yulista! As you get to know Yulista, you'll discover that we encompass many subsidiaries, each offering unique and specialized capabilities within their respective fields. All our subsidiaries operate cohesively under the overarching Yulista umbrella. This allows us to leverage combined strengths, foster collaboration across diverse expertise areas, and provide comprehensive solutions to our customers. Since 2002, Yulista has leveraged our technical expertise to maintain aircraft and ground vehicles, advance aerospace technology and missile defense, support national security, and sustain base and maritime operations. In a fiercely competitive market, our agile teams embrace complex challenges, delivering mission-critical solutions. Yulista has been a trusted and preferred partner for mission-ready clients, renowned for consistently providing innovative expertise that drives success. Our greatest strength lies in the passion and commitment of our men and women who strive to make the impossible possible.