Job Description :
iSeries Database Engineer
Location: Framingham-MA or Broomfield-CO

This role will be involved in data replication from iSeries to Hadoop
The tool we use to move data is Golden Gate but any replication tool experience is fine.
Must have DB2, iSeries and data replication experience

Administer and maintain the security and integrity of DB2 for i databases on iSeries/AS400 platform. Design database maintenance, upgrade and replication processes and provide incident/problem management support. Develops processes, procedures and defines metrics to review for capacity management. Resolve database performance issues, database capacity issues and any distributed data issues. This role serves as a Subject Matter Expert (SME) for complex systems and takes a lead role in the resolution of the most complex incidents and problems.

Responsibilities
Provide broad support of the iSeries platform, including but not limited to:
o data collection in support of replication requests
o Database object management (reorgs)
o Development/testing/review of infrastructure scripts/processes
Ensure that the application, and any enhancements, interact efficiently with the database
Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities and capacity planning
Plan for and execute any required database upgrades and migration activity (patches, etc
Provide off hours support and be part of the on-call rotation as required

Requirements
Bachelor Degree (typically in Computer Science, Information Technology or Computer Engineering) with a minimum of 8 years of equivalent work experience, or a Master''s Degree (within relative discipline) with a minimum of 6 years of equivalent work experience, or 12 years of equivalent work experience.
iSeries application development experience
iSeries 7.1 or similar experience
o Familiarity with Green Screen
o iSeries commands (eg. dspfd, Rgzpfm)
o Write CL (Command Line) programs
o RPG development experience preferred
o SQL experience
o iSeries Navigator experience
o Familiarity to install software
Experience with DBU (Database Utility)
Familiarity with Golden Gate or other replication technology
Shell scripting familiarity
ODBC familiarity into iSeries
Unix/Linux experience
Ability to created technical documentation

Preferred
Familiarity with HA/Failover scenarios and MIMIX replication software
Proficiency with MicroSoft Excel
Change Management (Service Now) knowledge
Basic Oracle experience
Deep Golden Gate experience