DB2 on IBM i Mainframe Admin — Performance & DR Lead

Machine Learning Technologies, LLC; Woodland (CA); On-site; USD 110,000 - 150,000; Full time

Job summary

Machine Learning Technologies, LLC in Woodland, CA is seeking an experienced DB2 Database Administrator to install, configure, monitor, and maintain DB2 databases on AS400/IBM i systems. You will collaborate with development and infrastructure teams to ensure performance, reliability, and security.

The role focuses on backup, recovery, tuning, indexing, and query optimization, with a strong emphasis on security controls, HA/DR, and thorough documentation.

Qualifications

• Experience with IBM DB2 on AS/400 (IBM i) environments.
• Bachelor's degree in CS or related field.
• Strong communication and documentation skills.
• Ability to design and enforce database standards and procedures.

Responsibilities

• Install, configure, and maintain DB2 databases on AS400/IBM i systems.
• Monitor database performance, availability, and reliability.
• Perform database backup, recovery, and restore operations.
• Troubleshoot database incidents and production issues.
• Implement and maintain database security controls.
• Optimize database performance through indexing, tuning, and query optimization.
• Collaborate with development and infrastructure teams on database design and deployment.
• Maintain database documentation, standards, and operational procedures.
• Support high-availability and disaster recovery initiatives.

Skills

DB2 Administration

AS400/IBM i

Performance Tuning

Backup & DR

Security & Compliance

Troubleshooting

Documentation

Education

Bachelor's degree in Computer Science or related field

Tools

SQL

IBM i Navigator

Job description

Machine Learning Technologies, LLC in Woodland, CA is seeking an experienced DB2 Database Administrator to install, configure, monitor, and maintain DB2 databases on AS400/IBM i systems. You will collaborate with development and infrastructure teams to ensure performance, reliability, and security.

The role focuses on backup, recovery, tuning, indexing, and query optimization, with a strong emphasis on security controls, HA/DR, and thorough documentation.