Novalink Solutions LLC
Job Description
Job Description
Required Experience: 10+ years DB2 experience
Description
Design and maintain DB2 Database applications which have the following characteristics:
·Design for high availability.
·Design for maximum performance.
·Maintain and develop techniques and proceduresto provide 24x7 availability.
·Provide production and test database support ina complex environment.
Perform all functions which are performed by a DB2 Database Administrator, such as:
·SQL code reviews.
·Performance Monitoring and Tuning DB2 at theapplication database level.
·Enforce appropriate DB2 security standards.
·Collaborate with the DB2 systems programmingstaff to appropriately manage DSNZPARM settings.
·Create, manage and support DB2 StoredProcedures, DB2 Triggers, and DB2 Referential Integrity.
·Create Change Requests, Resolve ServiceRequests, Provide 24x7 On call support.
·Provide DB2 Connect configuration access supportfor individual users and distributed systems.
·Coordinate with team members on technicaldecisions and directions.
·Work with Management to develop projectschedules.
·Provide Database performance and tuning whichtypically involves collaboration between Data Center, Technical
Operations,Database
Design and Administration, and the various software development areas.
·Responsible for the evaluation and creation ofappropriate backup and recovery strategies for new database requirements.
·Participate in Disaster Recovery planning.
Qualifications
Excellent knowledge of DB2 z/OSDatabase Support, including but not limited to the following:
z/OS DB2 12 for zOS or higher in a production environment with high transaction rates
High availability 24x7 designs and techniques
Managing large data stores
DB2 V10 utilities setup and execution
DB2 performance and tuning
Data Modeling expertise – logical and physical design
Complex SQL coding / tuning
Data Warehouse design with an understanding of OLAP design and query solutions
·DB2
attachments/interfaces
include DRDA, DB2Connect
·DB2 tools skill set will include, but is notlimited to the following:
·IBM Data Studio
·IBM DB2 Administration Tool
·IBM DB2 Automation Tool
·IBM DB2 Explain
·IBM DB2 Query Monitor
·IBM OPTIM Workload Query Tuner
·IBM File Manager
·IBM Tivoli OMEGAMON
·QMF
z/OS Mainframe skills, but notlimited to the following:
TSO and ISPF
JCL
DFSORT and /or ICETOOL
REXX
z/OS Utilities
Additional Desired Skills:
Problem solving and analytical skills
Ability to organize and prioritize workflow and projects
Excellent written and oral communication skills
DB2 V9 or V10 Certification preferred
IMS Database experience
IMS Database Utilities (IBM, BMC, NEON, etc.)
ETL tools experience (InfoShere, Informatica, etc.)
Requirements
Skill Required / Desired Amount of Experience 10+ years DB2 experience Required 10 Years Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following- Required 10 Years z/OS DB2 12 for zOS or higher in a production environment with high transaction rates Required 10 Years High availability 24x7 designs and techniques Required 10 Years Managing large data stores Required 10 Years DB2 V10 utilities setup and execution Required 10 Years DB2 performance and tuning Required 10 Years Data Modeling expertise – logical and physical design Required 10 Years Complex SQL coding / tuning Required 10 Years Data Warehouse design with an understanding of OLAP design and query solutions Required 10 Years DB2
attachments/interfaces
include DRDA, DB2 Connect Required 10 Years DB2 tools skill set will include, but not limited to the following: QMF & IBM (Data Studio, OPTIM Workload Query Tuner, File Manager, Tivoli OMEGAMON) Required 10 Years DB2 tools skill set will include, but not limited to the following: IBM DB2 (Administration Tool, Automation Tool, Explain, Query Monitor) Required 10 Years z/OS Mainframe skills, but not limited to the following: TSO & ISPF, JCL, DFSORT &/or ICETOOL, REXX, z/OS Utilities Required 10 Years
Job Description
Required Experience: 10+ years DB2 experience
Description
Design and maintain DB2 Database applications which have the following characteristics:
·Design for high availability.
·Design for maximum performance.
·Maintain and develop techniques and proceduresto provide 24x7 availability.
·Provide production and test database support ina complex environment.
Perform all functions which are performed by a DB2 Database Administrator, such as:
·SQL code reviews.
·Performance Monitoring and Tuning DB2 at theapplication database level.
·Enforce appropriate DB2 security standards.
·Collaborate with the DB2 systems programmingstaff to appropriately manage DSNZPARM settings.
·Create, manage and support DB2 StoredProcedures, DB2 Triggers, and DB2 Referential Integrity.
·Create Change Requests, Resolve ServiceRequests, Provide 24x7 On call support.
·Provide DB2 Connect configuration access supportfor individual users and distributed systems.
·Coordinate with team members on technicaldecisions and directions.
·Work with Management to develop projectschedules.
·Provide Database performance and tuning whichtypically involves collaboration between Data Center, Technical
Operations,Database
Design and Administration, and the various software development areas.
·Responsible for the evaluation and creation ofappropriate backup and recovery strategies for new database requirements.
·Participate in Disaster Recovery planning.
Qualifications
Excellent knowledge of DB2 z/OSDatabase Support, including but not limited to the following:
z/OS DB2 12 for zOS or higher in a production environment with high transaction rates
High availability 24x7 designs and techniques
Managing large data stores
DB2 V10 utilities setup and execution
DB2 performance and tuning
Data Modeling expertise – logical and physical design
Complex SQL coding / tuning
Data Warehouse design with an understanding of OLAP design and query solutions
·DB2
attachments/interfaces
include DRDA, DB2Connect
·DB2 tools skill set will include, but is notlimited to the following:
·IBM Data Studio
·IBM DB2 Administration Tool
·IBM DB2 Automation Tool
·IBM DB2 Explain
·IBM DB2 Query Monitor
·IBM OPTIM Workload Query Tuner
·IBM File Manager
·IBM Tivoli OMEGAMON
·QMF
z/OS Mainframe skills, but notlimited to the following:
TSO and ISPF
JCL
DFSORT and /or ICETOOL
REXX
z/OS Utilities
Additional Desired Skills:
Problem solving and analytical skills
Ability to organize and prioritize workflow and projects
Excellent written and oral communication skills
DB2 V9 or V10 Certification preferred
IMS Database experience
IMS Database Utilities (IBM, BMC, NEON, etc.)
ETL tools experience (InfoShere, Informatica, etc.)
Requirements
Skill Required / Desired Amount of Experience 10+ years DB2 experience Required 10 Years Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following- Required 10 Years z/OS DB2 12 for zOS or higher in a production environment with high transaction rates Required 10 Years High availability 24x7 designs and techniques Required 10 Years Managing large data stores Required 10 Years DB2 V10 utilities setup and execution Required 10 Years DB2 performance and tuning Required 10 Years Data Modeling expertise – logical and physical design Required 10 Years Complex SQL coding / tuning Required 10 Years Data Warehouse design with an understanding of OLAP design and query solutions Required 10 Years DB2
attachments/interfaces
include DRDA, DB2 Connect Required 10 Years DB2 tools skill set will include, but not limited to the following: QMF & IBM (Data Studio, OPTIM Workload Query Tuner, File Manager, Tivoli OMEGAMON) Required 10 Years DB2 tools skill set will include, but not limited to the following: IBM DB2 (Administration Tool, Automation Tool, Explain, Query Monitor) Required 10 Years z/OS Mainframe skills, but not limited to the following: TSO & ISPF, JCL, DFSORT &/or ICETOOL, REXX, z/OS Utilities Required 10 Years