Request ID: 115064-1
Title: DB2 Database Administrator (IBM i / AS400)
Location: Woodland hills, CA
Pay Rate: $55.00-62.00/hr on W2/C2C (All Inclusive)
Experience Requested - 07+ Years of Experience Mandatory
Duration: 06+ Months with Possible Extension.
We are seeking an experienced Senior DB2 Database Administrator with strong expertise in IBM DB2 Database Administration and AS400 (IBM iSeries) environments. The ideal candidate will be responsible for database administration, performance tuning, backup and recovery, security management, high availability, disaster recovery, and production support activities. The role requires hands-on experience managing mission-critical enterprise databases in large-scale production environments.
Key Responsibilities
- Install, configure, administer, and maintain DB2 databases on IBM i (AS400) platforms.
- Manage database availability, reliability, integrity, and performance across production environments.
- Perform backup, restore, recovery, and disaster recovery activities.
- Monitor database health, storage utilization, and system performance.
- Troubleshoot and resolve database incidents, outages, and performance bottlenecks.
- Implement database security policies, access controls, auditing, and compliance requirements.
- Optimize database performance through indexing, query tuning, and resource management.
- Support capacity planning, database growth forecasting, and scalability initiatives.
- Collaborate with development, infrastructure, and application teams on database design and deployments.
- Implement and support High Availability (HA) and Disaster Recovery (DR) solutions.
- Create and maintain database operational procedures, documentation, and runbooks.
- Provide production support and participate in on-call support activities when required.
Required Skills
- 10+ years of experience in IBM DB2 Database Administration.
- Strong experience with IBM AS400 / IBM iSeries administration.
- Expertise in DB2 database installation, configuration, and maintenance.
- Advanced knowledge of performance tuning, query optimization, and indexing strategies.
- Experience with backup, recovery, and disaster recovery planning.
- Strong understanding of database security, user access management, and compliance.
- Experience troubleshooting database performance and production issues.
- Knowledge of database monitoring and capacity planning.
- Experience managing mission-critical enterprise production environments.
- Strong communication, stakeholder management, and documentation skills.
Preferred Skills
- Experience with IBM Power Systems infrastructure.
- Knowledge of DB2 HADR (High Availability Disaster Recovery) solutions.
- Experience with PowerHA, MIMIX, or similar HA/DR tools.
- Exposure to automation and scripting (CL, Shell, Python, PowerShell).
- Experience in Banking, Financial Services, Insurance, Retail, or Manufacturing domains.
- ITIL-based Production Support experience.