DB2 Database Administrator

Job Title: DB2 Administrator – AS400 / IBM i
Location: Woodland Hills CA

Technical Skills: IBM DB2, AS400, IBM iSeries, Database Administration

 10 or higher year of exp

Job Summary

We are looking for an experienced DB2 Database Administrator with strong expertise in IBM DB2 database administration on AS400 (IBM iSeries) platforms. The candidate will be responsible for database installation, configuration, maintenance, performance monitoring, troubleshooting, backup and recovery, and database security.

The ideal candidate should have hands-on experience managing DB2 databases in production environments, ensuring database availability, reliability, security, and optimal performance. The role involves close collaboration with development, infrastructure, and operations teams to support business-critical database environments.

Key Responsibilities

1. DB2 Database Administration

• Install, configure, administer, and maintain IBM DB2 databases on AS400 / IBM i systems.
• Manage database objects, configurations, and routine maintenance activities.
• Monitor database health, availability, and reliability.
• Ensure database environments operate efficiently and meet business requirements.
• Maintain database standards, documentation, and operational procedures.

2. Performance Monitoring & Optimization

• Monitor database performance and identify potential bottlenecks.
• Perform database performance tuning, indexing, and query optimization.
• Analyze database workloads and recommend performance improvements.
• Conduct capacity planning and proactively address performance issues.
• Ensure optimal database resource utilization.

3. Backup, Recovery & Disaster Recovery

• Perform regular database backup, recovery, and restore operations.
• Develop and maintain backup and recovery strategies.
• Support high availability (HA) and disaster recovery (DR) initiatives.
• Participate in disaster recovery testing and recovery planning.
• Ensure business continuity and minimize database downtime.

4. Database Security & Compliance

• Implement and maintain database security controls.
• Manage user access, permissions, and authorization.
• Ensure compliance with organizational security policies and standards.
• Monitor database access and support security audits.
• Identify and address potential database security risks.

5. Troubleshooting & Production Support

• Troubleshoot and resolve DB2 database incidents and production issues.
• Perform root cause analysis and implement permanent fixes.
• Provide database support for critical production environments.
• Collaborate with application development and infrastructure teams.
• Support database design, deployment, and release activities.

Required Skills & Experience

• Strong experience in IBM DB2 Database Administration.
• Hands-on experience with AS400 / IBM iSeries administration.
• Good understanding of IBM i architecture and DB2 for i.
• Experience in database installation, configuration, and maintenance.
• Strong knowledge of database performance tuning and optimization.
• Experience with database backup, recovery, and restore procedures.
• Understanding of database security administration and access management.
• Strong troubleshooting skills for DB2 database and production issues.
• Experience with query optimization, indexing, and performance monitoring.
• Knowledge of high availability and disaster recovery concepts.
• Excellent communication, documentation, and problem-solving skills.

Desirable Skills

• Experience managing large-scale enterprise production environments.
• Knowledge of HA/DR solutions and strategies on IBM AS400.
• Experience in database capacity planning and performance management.
• Familiarity with IBM i system administration and operational best practices.
• Experience working with development, infrastructure, and application support teams.
• Strong stakeholder management and cross-functional collaboration skills.

Key Competencies

• Strong technical and analytical skills.
• Production support and incident management.
• Database performance management.
• Problem-solving and root cause analysis.
• Effective communication and stakeholder management.
• Ability to work independently in business-critical environments.

Ideal Candidate: A DB2 Database Administrator with strong hands-on experience in IBM DB2 on AS400 / IBM iSeries platforms, capable of managing production databases, optimizing performance, ensuring database security, and supporting backup, recovery, and high-availability requirements.