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.
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.
