PACCAR is looking to solve the problem of managing hundreds of enterprise-level databases in a scalable database solution, and is seeking a Database Administrator to design, implement, and maintain stable, scalable, low-cost database solutions.
Requirements
- 8+ years relevant experience as a DB2 DBA in a z/OS environment using IBM utilities, including experience with z/OS JCL, REXX/CLIST, evaluating dump output, and TSO/ISPF is required.
- IMS DBA experience in a CICS / DBCTL environment is required.
- Proven database design and development experience in a z/OS and enterprise COBOL environment is required (preferably including DB2, IMS/DB and CICS).
- Working knowledge in both Unix and windows platforms including cross-platform data access is desirable.
- Experience with DB2 stored procedures required.
- ISPW, ERwin, EZTRIEVE are all pluses.
- Experience with Qlik Replicate is a plus.
Responsibilities
- Experience in a complex IBM z/OS DB2 and IMS database environment.
- Assist developers with debugging and tuning of CICS and batch DB2/IMS programs.
- Design, implement, and support DB2/IMS databases in online transaction and batch environments.
- Ability to tune DB2 queries using EXPLAIN.
- Generate scripts to migrate DB2 schema changes between environments using IBM DB2 admin tools.
- Familiar with DevOps methodology to automate database deployment.
- Experience with DB2 native SQL procedures.
Other
- Bachelor's degree in Computer Science, or related field
- Ability to work with business and technical teams.
- Excellent business acumen and communication skills to be able to work with business owners to develop and define key business questions.
- Must be a motivated self-starter that can work independently in a fast-paced, ambiguous environment.
- Must have a high level of customer focus and a passion for process improvement.
