DB2 Administrator (DB2 Certified DBA for AS/400)
1 year experience required
724 Care Inc.
Mandaue City, Cebu
Details
The ideal Candidate will have had a strong developer background using the I-series platform, Cobol, Native file access (DDS),CL, and direct experience in management of the physical database, in terms of naming conventions, journaling, additions of new fields, new files, new views etc. The candidate will also have basic data modeling skills in terms of creating ERD diagrams.
Job duties:
• Create an ERD of the core existing physical files (approximately 100 out of a total of 917)
• Identify and document key relationships found thru analyzing the existing COBOL and DDS definitions.
• Support the development staff by ensuring all naming conventions are followed
• Model and document the creation of any new fields, and Physical files.
• Perform data mapping from the legacy Golden Rule mainframe VSAM files to the I-series • Perform impact analysis for file changes, and additions, modifications etc
• Assist with test data creation using Extract DB tool
Skills:
• Platform AS/400 (I-series) experience, with COBOL and DDS Knowledge required.
• Experience in Data Modeling and creation of basic ERD's
• Data mapping and transformation
• Query/400 or IQ
• Data replication tools such as MIMIX, ExtractDB, Symbiator, DB2 SQL and DDL, ILE Cobol
SQL server and associated tools
• Insurance Knowledge is an ADVANTAGE
0 comments:
Post a Comment