DB2 Database Administrator

rose international; Salem (OR); On-site; USD 90,000 - 120,000; Full time

Job summary

Rose International, based in Salem, Oregon, is seeking an experienced z/OS DB2 Database Administrator. The role involves developing and maintaining database policies, resolving performance issues, and requires a strong background in DB2-z/OS and SQL.

The ideal candidate has a minimum of eight years of experience, as well as a Bachelor's degree in a related area. Join a dynamic environment committed to employee development and success.

Qualifications

• Minimum of eight years experience as a z/OS DB2 Database Administrator.
• Working knowledge of DB2 LUW (Linux, Unix, Windows).
• Experience with database connectivity to DB2 z/OS from various systems.

Responsibilities

• Develop and maintain database policies and procedures.
• Resolve database performance and capacity issues.
• Plan and accomplish data administration tasks.

Skills

DB2-z/OS Experience

SQL Construction and Optimization

Database Connectivity

Web Services Construction

Performance Monitoring Tools

Education

Bachelor's degree in a related area

Tools

CA Detector

Omegamon for DB2

Toad

Job description

Founded in 1993, Rose International is a leader in providing Workforce Solutions and Information Technology Solutions nationwide. We have 19 offices across the U.S., and offer thousands of opportunities across the industries we service.

Rose International is an employee oriented company. We offer challenging assignments, and strive to be with our employees long–term. We are committed to quality people and service. At Rose, we offer our employees the opportunity to join a highly skilled, professional team and provide continuous professional development.

Responsibilities

• Develop, implement, administer, and maintain policies and procedures for ensuring the security and integrity of the company database.
• Implement data models, database designs, data access and table maintenance codes.
• Resolve database performance, capacity, replication, and other distributed data issues.
• Plan and accomplish goals using experience and judgement.
• Perform a variety of data administration tasks requiring creativity and latitude.

Qualifications

• Minimum of eight years experience as a z/OS DB2 Database Administrator.
• Bachelor's degree in a related area.
• Strong DB2‑z/OS experience.
• Working knowledge of DB2 LUW (Linux, Unix, Windows).
• Knowledge of SQL construction and optimization.
• Knowledge of OMVS, MVS, CICS, JCL, Cobol, Cobol source code migration, compile and bind, REXX, and CLIST utilities in a DB2 Z/OS environment.
• Experience with database connectivity to DB2 z/OS from SQL‑Server, Oracle, Websphere, ColdFusion, Business Objects, DB2‑LUW, MS‑Access, Toad or others.
• Web services construction, implementation and migration within a Z/OS environment running CICS and DB2.
• Familiarity with performance and exception monitoring tools such as CA Detector, Omegamon for DB2, Omegamon for CICS.
• Experience with IBM DB2 for Z/OS utilities for LOAD, REORG, COPY, RESTORE, UNLOAD, CHECK DATA.
• Methods and procedures for designing, developing, monitoring and maintaining databases.
• Tools for constructing database structures.
• Experience determining efficient design of data structures and software applications.
• AIX security, scripting and monitoring experience.
• Information systems architecture knowledge.
• Experience identifying scope and managing complexity of projects.
• Experience in de‑identifying data and obfuscation.
• Experience in source code management.
• Experience with naming standards.

Additional Information

Rodger Martin

RDA

Phone: [phone], Ext.: 6721