DB2 Database Administrator

TechClub Inc; Los Angeles (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

TechClub Inc. in Los Angeles, CA is seeking an experienced DB2 Administrator to manage IBM DB2 on AS400/IBM i systems.

You will be responsible for installation, configuration, maintenance, performance monitoring, and security to ensure high availability of production databases. The ideal candidate has 10+ years of experience and a proven track record in disaster recovery, backup strategies, and cross-functional collaboration with development and operations teams.

Qualifications

• Strong experience in IBM DB2 Database Administration.
• Hands-on AS400 / IBM iSeries administration.
• Understanding of IBM i architecture and DB2 for i.
• Experience with database installation, configuration, and maintenance.
• Experience with backup, recovery and disaster recovery.
• Knowledge of database security administration and access management.
• Troubleshooting DB2 database and production issues.

Responsibilities

• DB2 database installation, configuration and maintenance.
• Monitor database health, availability and performance.
• Implement backup, recovery, and disaster recovery strategies.
• Ensure security controls and access management.
• Collaborate with development, infrastructure and operations teams.
• Provide production support and troubleshooting for critical environments.

Skills

DB2 Administration

AS400 / IBM i

Performance tuning

Backup & recovery

Security administration

Troubleshooting

Capacity planning

Documentation

Cross-team collaboration

Communication

Job description

Job Title: DB2 Administrator - AS400 / IBM i
Location: Woodland Hills CA10 or higher year of exp
Job SummaryWe 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

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