Mainframe Admin

Artifintech; Woodland (CA); On-site; USD 110,000 - 165,000; Full time

Job summary

Artifintech in Woodland, CA is seeking an experienced IBM DB2 DBA to install, configure, and maintain DB2 databases on AS400/IBM i. You will monitor performance, implement backups, and ensure high availability, security, and disaster recovery readiness.

You will collaborate with development and infrastructure teams, optimize queries, tune databases, and maintain documentation. Strong communication and problem-solving skills are essential, with a commitment to equal opportunity employment.

Qualifications

• Experience in IBM DB2 Database Administration on AS400/IBM i.
• Ability to perform backup, recovery, and disaster recovery planning.
• Strong knowledge of security controls and performance tuning.

Responsibilities

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

Skills

IBM DB2 DBA

AS400 administration

Performance tuning

Backup & DR

Security administration

Troubleshooting DB2

Query optimization

Documentation

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

• \"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.