Mainframe DB2 Application DBA
Apply NowCompany: SysMind Tech
Location: Dublin, OH 43017
Description:
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
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