Duration: 03 - 06 Months (possibilities of extension)
Description:
Mainframe IMS (must have Fast Path) and DB2zOS.
Must be able to work independently strong analytical skills.
Partner with the product teams to understand business data requirements, identify data needs and data sources to create data architecture
Documents data requirements/data stories and maintains data models to ensure flawless integration into existing data architecture
Leads data assets as per the enterprise standards, guidelines and policies
Documents processing requirements inclusive of data and transaction volumes, scalability, security and performance requirements
Creates and maintains detailed information about the data being stored in the database
Understands the database requirements and translate into physical database design
Follows data placement procedures and re-use of existing databases when possible
Builds and enhances database design and infrastructure required to support the Business portfolio
Performs database design review and supports database testing
Provides production environment support for database systems and processes
Communicates and works reciprocally with business and product teams to support changes and implementation
Write instructions to guide database operators during production runs
Work on assigned database features for ongoing sprints and lead database requirements based on industry trends, new technologies, known defects, and issues
Partner with delivery architects and engineers to design optional data tier solutions to meet platform objectives and goals
Function as an active member if an agile team through consistent development practices (tools, components, and documentation)
Find opportunities to adopt innovative technologies
Skills:
Strong analytical skills with a validated ability to understand and document business data requirements in complete, accurate, extensible and flexible logical data models using data modeling tools - ErStudio, ErWin
Able to facilitate discussions between small groups of Technology and business people, recognize issues of conflict and inconsistency between data requirements and pursue a resolution of these issues
Understands XML/JSON and schema development/reuse, Open Source and NoSQL will be an added advantage
Able to establish, modify or maintain data structures and associated components according to design
Understands Metadata Management and Database Management concepts
Creates data models using the relevant tools and frameworks
Partners with Sr. Data Engineers and Sr. Data architects to create platform level data models and database design
Technical knowledge of DBMS products and ecosystem - e.g. storage formats, access algorithms, data management processes, administration, data maintenance, replication, high availability, encryption, etc
Ability to monitor and tune database and DBMS's to reach high performance - e.g. use data monitoring and analysis tools, tune configuration parameters, alter physical designs, benchmark, etc.
Has working knowledge of the range of tools used in the planning, analyzing, designing, building, testing, configuring and maintaining of assigned applications
Able to participate in assigned team's software delivery methodology (Agile, Scrum, Agile XP, Test-Driven Development, Waterfall, etc)
Understands and has practical experience with infrastructure technologies and components like servers, jvms and networking concepts