DB2 Admin

THEMESOFT; Los Angeles (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Themesoft Inc. is seeking a DB2 Administrator to install, configure, and maintain DB2 databases on AS400/IBM i systems in Woodland Hills, CA.

You will monitor performance, handle backups and recoveries, and implement security controls to ensure reliability and compliance. Join a team focused on performance tuning, high availability, and collaboration with development to optimize database design and deployment.

Qualifications

• 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

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

IBM DB2 DBA

AS400/IBM i

Performance tuning

Backup/recovery

Security administration

Troubleshooting

Query optimization

Documentation

Communication

Job description

Role Title: DB2 Admin Location: Woodland Hills , CA Duration: 6-12+ months Onsite Contract

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.

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.

Work Authorization Applicants must be legally authorized to work in the United States.

Themesoft Inc is an Equal Employment Opportunity employer. We consider qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected by applicable federal, state, or local law.