Mainframe Admin

Valiant Technologies LLC; Woodland (CA); On-site; USD 110,000 - 160,000; Full time

Job summary

Valiant Technologies LLC in Woodland, CA seeks an experienced IBM DB2 Database Administrator to install, configure, and maintain DB2 databases on IBM i (AS/400). You will monitor performance, manage backups and DR, ensure security, optimize queries, and collaborate with development and infrastructure teams.

Strong communication and documentation are essential. Responsibilities include incident troubleshooting, high availability support, and maintaining standards and procedures while keeping

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

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.