Senior Data Architect: DB2 to Cloud Migration

Hobbsnews; New Jersey; On-site; USD 120,000 - 136,000; Full time

Job summary

Bank of America is seeking a Database Migration Specialist / Database Architect to lead end-to-end DB2 Sailfish to Cloud Rack migrations, including environment validation, data migration, and extensive testing. You will collaborate with application, infrastructure, IBM, and security teams to ensure data integrity, security, and compliance while delivering migration runbooks and sign-off documentation.

This role requires deep experience with Oracle, DB2, and Sybase, data modeling, ETL, and data

Qualifications

• 10+ years of overall experience.
• 5+ years of relevant technology experience.
• Proficient with Oracle, DB2, and Sybase databases.
• Experience with data modeling: STAR/Snowflake, normalized/denormalized models.
• Experience with ETL: Informatica mappings.
• Foundational knowledge of ADS management, data lineage, and data analysis.
• Strong communication and stakeholder management skills.

Responsibilities

• Establishes data solutions and architecture for large, complex initiatives aligned with enterprise data architecture strategy.
• Provides clear responses regarding enterprise data architecture strategy.
• Contributes to multiple priorities in a matrixed environment with attention to detail.
• Communicates effectively to influence agreement between partners and escalate items as needed.
• Ensures risk, financial, and compliance policies are met.
• Creates an inclusive and healthy working environment to resolve impediments.
• Shares enterprise data architectural principles, processes, and routines.
• Executes DB2 Sailfish to DB2 Cloud Rack migrations including validation.
• Validate infrastructure, database configuration, network connectivity, and access controls.
• Perform functionality, performance, stress, scalability, and failover testing.
• Execute data migration, reconciliation, and integrity validation.
• Work closely with application, infrastructure, IBM, and security teams to resolve issues.
• Develop migration runbooks, validation reports, and sign-off documentation.
• Support cutover execution and post-migration stabilization.

Skills

Architecture

Business Analytics

Critical Thinking

Data Management

Data Visualization

Consulting

Data Modeling

Process Design

Regulatory Compliance

Risk Management

Cloud Solutions

Collaboration

Data Governance

Solution Delivery Process

Technical Strategy Development

Education

Bachelor's degree in Computer Science or equivalent

Tools

PowerDesigner

Erwin

Informatica

Python

Shell

Job description

Bank of America is seeking a Database Migration Specialist / Database Architect to lead end-to-end DB2 Sailfish to Cloud Rack migrations, including environment validation, data migration, and extensive testing. You will collaborate with application, infrastructure, IBM, and security teams to ensure data integrity, security, and compliance while delivering migration runbooks and sign-off documentation.

This role requires deep experience with Oracle, DB2, and Sybase, data modeling, ETL, and data