About this role
Job Description:
At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day.
Being a Great Place to Work and providing a culture of caring is core to how we drive Responsible Growth. We are intentional about fostering an inclusive workplace where every teammate has the opportunity to succeed, build a career and contribute to our shared success. This includes attracting and developing exceptional talent, recognizing and rewarding performance, and supporting our teammates' physical, emotional, and financial wellness through affordable, competitive and flexible benefits.
We value the unique perspectives individuals bring from all backgrounds and career paths - whether shaped by military service, community college education, or a wide range of work and life experiences. These journeys foster resilience, leadership and innovation, strengthening our workforce and positively impact the communities we serve.
Bank of America is committed to an in-office culture that supports collaboration, engagement, and career development. Our approach includes clear in-office expectations, while providing an appropriate level of flexibility based on role-specific responsibilities and business needs.
At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!
Job Description: This job is responsible for the development of data architectural solutions for complex initiatives within one or more lines of business and control functions. Key responsibilities include assisting solution-driven discussions, supporting adherence to the enterprise data management policy and standards, and supporting architecture design reviews to ensure integration of data architecture principles in technology solutions. Job expectations include understanding enterprise data architectural principles and data management processes and routines.
Position Summary:
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 decisionsProvides clear and concise responses to questions regarding the enterprise data architecture strategyContributes to multiple priorities in a matrixed environment with attention to detail and accuracyCommunicates effectively to influence agreement between partners and escalates items, as needed, to ensure execution activities remain on trackEnsures all relevant risk, financial, and compliance policies and standards are metCreates an inclusive and healthy working environment to resolve organizational impediments and blockersShares enterprise data architectural principles, processes, and routinesExecute DB2 Sailfish to DB2 Cloud Rack migrations including environment and configuration 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 of runbooks, validation reports, and sign-off documentation.Support cutover execution and post-migration stabilization. Required Qualifications:
10+ years of overall experience5+ years of relevant technology experience listed belowDatabase Skills:RDBMS; specifically Oracle, DB2, Sybase mandatoryNoSQL knowledge like Hadoop, Impala, Iceberg optionalMaintaining / supporting very large database platform working with other stakeholdersData Modeling:Knowledge in data modeling, STAR / Snowflake schema, normalized and denormalized data modelsPrior knowledge in data modeling tools like Power Designer and Erwin preferred but not mandatoryDatabase Application Development Skills:Writing views and Stored proceduresStrong concepts in creating end to end data pipelinesScripting in shell, PythonETL:Informatica mapping creation; using maps to move data from one platform to another.ADS Management:Foundational knowledge on data domain and ADS managementData lineageData analysis Soft Skills:Strong communication skillsStrong stakeholder management skills Skills:
ArchitectureBusiness AnalyticsCritical ThinkingData ManagementData VisualizationConsultingData ModelingProcess DesignRegulatory ComplianceRisk ManagementCloud SolutionsCollaborationData GovernanceSolution Delivery ProcessTechnical Strategy Development Bachelors degree in Computer Science or equivalent Engineering
Shift: 1st shift (United States of America)
Hours Per Week: 40
Pay Transparency details
US - NJ - Jersey City - 101 Hudson St - 101 Hudson (NJ2101), US - NJ - Pennington - 1500 American Blvd - Hopewell Bldg 5 (NJ2150)
Pay and benefits information
Pay range
$120,000.00 - $136,100.00 annualized salary, offers to be determined based on experience, education and skill set.
Discretionary incentive eligible
This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company.
Benefits
This role is currently benefits eligible. We provide industry-leading benefits, access to paid time off, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.