Job Title: Mainframe DB2 Admin
Location: Woodland Hills, CA (Onsite)
Experience: 8-10 years
Skills: IT IS_AMS_Mainframe_DB2 Administration
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.
Required Skills:
• 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.
