SysMind Tech
Mainframe DB2 Application DBA
SysMind Tech, Dublin, Ohio, United States, 43016
Job Title -
Mainframe DB2 Application DBA
IBM Optim SME
Location - Chicago, IL (onsite)
Relevant Experience
Skills Experience - 15+ years
Healthcare Experience - 15+ years with Healthcare Payers and 10+ years with Blues
Responsibilities:•Strong healthcare knowledge across the payer landscape such as members, providers & claims•Leverage deep healthcare knowledge to interact with various application teams to understand data needs•Collect data requirements per application and enable data sub setting•Conduct data sub setting and masking using IBM Optim•Responsibility for constructing and/or optimizing physical database designs tailored for the DB2 ZOS/MAINFRAME database environment in support of various strategic application development initiatives (database/table/object/index/view/trigger/package/procedure etc).•Supporting application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions.•Design & development Services - Physical database design and creation, partitioning, capacity planning, DDL creation update etc., view design and creation, stored procedure, trigger and query coding and tuning•Data Services - Data replication, reporting, adhoc query support, data correction, CDC/IIDR change tracking• MUST HAVE Performance and Tuning Services - Performance Profile baseline, database tuning, index reviews, query tuning.
o Explain
o Indexing
o Strong SQL
o Static SQL, Package binds
o Performance benchmarking
o DB2 accounting trace data
o Omegamon DB2
o Online monitor
o Near term history
o Historical tables
Mainframe DB2 Application DBA
IBM Optim SME
Location - Chicago, IL (onsite)
Relevant Experience
Skills Experience - 15+ years
Healthcare Experience - 15+ years with Healthcare Payers and 10+ years with Blues
Responsibilities:•Strong healthcare knowledge across the payer landscape such as members, providers & claims•Leverage deep healthcare knowledge to interact with various application teams to understand data needs•Collect data requirements per application and enable data sub setting•Conduct data sub setting and masking using IBM Optim•Responsibility for constructing and/or optimizing physical database designs tailored for the DB2 ZOS/MAINFRAME database environment in support of various strategic application development initiatives (database/table/object/index/view/trigger/package/procedure etc).•Supporting application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions.•Design & development Services - Physical database design and creation, partitioning, capacity planning, DDL creation update etc., view design and creation, stored procedure, trigger and query coding and tuning•Data Services - Data replication, reporting, adhoc query support, data correction, CDC/IIDR change tracking• MUST HAVE Performance and Tuning Services - Performance Profile baseline, database tuning, index reviews, query tuning.
o Explain
o Indexing
o Strong SQL
o Static SQL, Package binds
o Performance benchmarking
o DB2 accounting trace data
o Omegamon DB2
o Online monitor
o Near term history
o Historical tables