Data Architect (DB2, Oracle)

About the role

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. This role is responsible for the development of data architectural solutions for complex initiatives within one or more lines of business and control functions. The Database Migration Specialist / Database Architect will execute end-to-end DB2 Sailfish to Cloud Rack migration activities, including environment validation, data migration, intensive testing, and security/compliance assurance.

Responsibilities

• Establishes data solutions and architecture for large, complex initiatives that align with the enterprise data architecture strategy and technology and platform decisions.
• Provides clear and concise responses to questions regarding the enterprise data architecture strategy.
• Contributes to multiple priorities in a matrixed environment with attention to detail and accuracy.
• Communicates effectively to influence agreement between partners and escalates items, as needed, to ensure execution activities remain on track.
• Ensures all relevant risk, financial, and compliance policies and standards are met.
• Creates an inclusive and healthy working environment to resolve organizational impediments and blockers.
• Shares enterprise data architectural principles, processes, and routines.
• Executes DB2 Sailfish to DB2 Cloud Rack migrations including environment and configuration validation.
• Validates infrastructure, database configuration, network connectivity, and access controls.
• Performs functionality, performance, stress, scalability, and failover testing.
• Executes data migration, reconciliation, and integrity validation.
• Works closely with application, infrastructure, IBM, and security teams to resolve issues.
• Develops migration runbooks, validation reports, and sign-off documentation.
• Supports cutover execution and post-migration stabilization.

Requirements

• 7-10 years of applicable experience.
• Strong hands-on experience with IBM DB2 (LUW) or Oracle database platforms.
• Proven delivery of large-scale database or platform migrations.
• Strong testing mindset with data validation and reconciliation experience.
• Experience working across multiple technical and vendor teams.
• Large scale database migration experience.
• Strong knowledge and skills in database technologies.
• Data migration and reconciliation knowledge.
• Performance engineering, performance, and volume testing experience.
• Ability to work in a large team environment with various skills and stakeholders.

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

Schedule

1st shift (United States of America), 40 hours per week.