Data Migration Architect: DB2 Sailfish to Cloud

Bank of America; Pennington (NJ); On-site; USD 120,000 - 136,000; Full time

Benefits offered by this job

Discretionary incentive eligible

Industry-leading benefits

Annual discretionary plan

Job summary

Bank of America is seeking a Database Migration Specialist / Database Architect to lead end-to-end migration from DB2 Sailfish to Cloud Rack, including environment validation and data integrity testing.

The role requires deep data architecture expertise, experience with ETL, data modeling, and collaboration with application, infrastructure, IBM and security teams to ensure governance and risk controls are met.

Qualifications

• 10+ years of overall experience in data architecture and related roles.
• 5+ years of hands-on experience with database design, migration, and tooling.
• RDBMS expertise: Oracle, DB2, Sybase; NoSQL knowledge optional.
• Data modeling: STAR/Snowflake schemas, normalized and denormalized models.
• ETL and data integration: Informatica mapping and end-to-end pipelines.
• ADS data management, data lineage, and data governance knowledge.
• Strong communication and stakeholder management skills.

Responsibilities

• Establishes data solutions and architecture for large, complex initiatives.
• Supports enterprise data architecture strategy and governance.
• Executes DB2 Sailfish to DB2 Cloud Rack migrations.
• Validates infrastructure, database configuration, and access controls.
• Performs functional, performance, stress, and failover testing.
• Collaborates with application, infrastructure, IBM, and security teams.
• Develops runbooks, validation reports, and sign-off documentation.
• Supports cutover execution and post-migration stabilization.

Skills

Architecture

Data Modeling

Data Management

Data Visualization

Regulatory Compliance

Cloud Solutions

Solution Delivery Process

Technical Strategy Development

Collaboration

Risk Management

Education

Bachelor's degree in Computer Science or equivalent Engineering

Tools

Power Designer

Erwin

Job description

Bank of America is seeking a Database Migration Specialist / Database Architect to lead end-to-end migration from DB2 Sailfish to Cloud Rack, including environment validation and data integrity testing.

The role requires deep data architecture expertise, experience with ETL, data modeling, and collaboration with application, infrastructure, IBM and security teams to ensure governance and risk controls are met.