Mainframe Admin

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

• "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.
• Stay current with DB2 and IBM i platform best practices. "

SKILLS REQUIRED:

• "Strong experience in IBM DB2 Database Administration.
• Hands-on experience with AS400 (IBM iSeries) system administration.
• Database performance tuning and optimization.
• Backup, recovery, and disaster recovery planning.
• Database security administration and compliance.
• Troubleshooting and resolving DB2 database issues.
• Query optimization and performance monitoring.
• Excellent communication and documentation skills"

DESIRABLE SKILLS:

• "Experience with large-scale production environments.
• Knowledge of HA/DR solutions on IBM AS400.
• Experience with capacity planning and performance management.
• Strong stakeholder management and communication skills."

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.