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 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
- Execute 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 experience
- 5+ years of relevant technology experience listed below
- Database Skills:
- RDBMS; specifically Oracle, DB2, Sybase mandatory
- NoSQL knowledge like Hadoop, Impala, Iceberg optional
- Maintaining / supporting very large database platform working with other stakeholders
- Data Modeling:
- Knowledge in data modeling, STAR / Snowflake schema, normalized and denormalized data models
- Prior knowledge in data modeling tools like Power Designer and Erwin preferred but not mandatory
- Database Application Development Skills:
- Writing views and Stored procedures
- Strong concepts in creating end to end data pipelines
- Scripting in shell, Python
- ETL:
- Informatica mapping creation; using maps to move data from one platform to another.
- ADS Management:
- Foundational knowledge on data domain and ADS management
- Data lineage
- Data analysis
- Soft Skills:
- Strong communication skills
- Strong stakeholder management skills
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
Bachelors degree in Computer Science or equivalent EngineeringShift:1st shift (United States of America)
Hours Per Week: 40
Pay Transparency detailsUS - 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.
