Mainframe Database Administrator

Company Information

PACCAR is a Fortune 500 company established in 1905. PACCAR Inc is recognized as a global leader in the commercial vehicle financial and customer service fields with internationally recognized brands such as Kenworth Peterbilt and DAF trucks. PACCAR is a global technology leader in the design manufacture and customer support of high-quality light- medium- and heavy-duty trucks under the Kenworth Peterbilt and DAF nameplates. PACCAR designs and manufactures advanced diesel engines andalso provides customized financial services information technology and truck parts related to its principal business.

Whether you want to design the transportation technology of tomorrow support the staff functions of a dynamic international leader or build our excellent products and services you can develop the career you desire with PACCAR. Get started!

Division Information

PACCARs Information Division (ITD) located in Renton WA utilizes cutting-edge technology to provide systems development consulting voice and data communications services to the entire Corporation which has high visibility in the technology sector.

Requisition Summary

We are looking for an experienced Database Administer with an ability to manage hundreds enterprise level databases in a scalable database solution. The ideal candidate is enthusiastic about learning new technologies and implementing solutions using these technologies to empower internal customers and scale the existing platform. The ideal candidate demonstrates solid business and communication skills and ability to work with business and technical this role you will serve as the expert at designing implementing and maintaining stable scalable low cost database solutions. The Database Administrator will design develop implement test document and operate large-scale high-volume high-performance database structures. Implement data structures using best practices in data modeling. He/she will be tuning performance on queries running over millions of rows of data. The person in this position should be analytical have an extremely high level of customer focus and a passion for process improvement. The Database Administered should be motivated self-starter that can work independently in a fast paced ambiguous environment and should have excellent business acumen and communication skills to be able to work with business owners to develop and define key business questions.

Job Functions/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.

• Good understanding of relational data modeling including physical database design using ERWin data modeler or other similar tool.

• Provide database support estimate for new projects.

• Provide on-going database support for Agile projects.

• Adhere to and enforce database standards.

• Introduce and deploy new database features.

• Ensure security is integrated into all data solutions to meet compliance standards.

• Perform onsite database recovery/restore as required.

• Experience with Disaster Recovery procedure and validation.

• Support DB2/IMS database upgrades.

• Design develop and migrate IMS databases to DB2.

• Assist Data Engineer in moving data from IMS/DB2 to distributed systems using an ETL tool such as Qlik Replicate.

Qualifications

• 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.
• Expertise with SQL and relational database systems.
• Knowledge of data warehousing concepts.
• Knowledge of data mining ETL etc. and using databases in a business environment with large-scale complex datasets.

Education

• Bachelors degree in Computer Science or related field

PACCAR Benefits

As a U.S. PACCAR employee you have a full range of benefit options including:

• 401k with up to a 5% company match
• Fully funded pension plan that provides monthly benefits after retirement
• Comprehensive paid time off minimum of 10 paid vacation days (additional days are provided with additional seniority/years of service) 12 paid holidays and sick time
• Tuition reimbursement for continued education
• Medical dental and vision plans for you and your family
• Flexible spending accounts (FSA) and health savings account (HSA)
• Paid short-and long-term disability programs
• Life and accidental death and dismemberment insurance
• EAP services including wellness plans estate planning financial counseling and more

Diversity and Inclusion

PACCAR is an Equal Opportunity Employer/Protected Veteran/Disability corporation. Having a diverse and inclusive work environment ensures PACCAR has the talent needed to conduct business today and in the future by leveraging different backgrounds skills and viewpoints. We believe diversity in the workplace increases innovation results in better decisions and increases employee engagement.

PACCARs IT Division promotes Diversity and Inclusion through mentorship events celebrations and affinity groups. The IT Division has an active Diversity Council and supports initiatives and activities for all. PACCAR supports women through the PACCAR Womens Association (PWA) Women in Trucking and Women in Technology International (WITI). Educational awareness programs such as Unconscious Bias Male Allyship and Inclusive Leadership are just a few of many trainings offered. PACCAR is a supporter of PRIDE and celebrates many different multi-cultural events.

Additional Job Board Information

PACCAR is an Equal Opportunity Employer/Protected Veteran/Disability. At PACCAR we value talent and promote growth and development. We carefully consider numerous compensation factors including your education training or experience. The salary range for the Database Administrator is $100100 - $156600 annually. Additionally this role is eligible for a full range of benefit options listed above. This position is also eligible for a holiday gift.