Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
Access Control
Auditing
Backup
Business Operations
Cloud Computing
Collaboration
Communication
Computer Hardware
Conflict Resolution
Data Archiving
Database
Database Administration
Database Performance Tuning
Disaster Recovery
Documentation
Encryption
FOCUS
IBM
IBM DB2
IBM I
IBM iSeries
Informatica
Management
Master Data Management
Mobile Device Management
MySQL
Node.js
Operating Systems
Oracle
Performance Tuning
Problem Solving
Query Optimization
Recovery
Regulatory Compliance
SQL
Storage
Stored Procedures
Job Details
IBMi Developer - AS400 Developer
Chicago, IL
12+ Months Contract
Position Type-1099/W2
Exp Level- 8+Years
Req Skills- Database Administrator, IBM i (AS/400), DB2 for I, IBM i operating system (OS/400), database management, IBM Navigator for i, STRSQL, performance tuning, backup, recovery, security
Key Responsibilities:
- Database Management: Install, configure, and maintain IBM i-based databases (DB2 for i, etc.) and ensure they are optimized for performance.
- Backup and Recovery: Implement and maintain backup and disaster recovery strategies for IBM i-based databases.
- Performance Tuning: Continuously monitor and optimize the performance of IBM i database systems, including query optimization, indexing, and system resources management.
- Security and Compliance: Implement security measures to protect sensitive data, including user access control, auditing, and encryption. Ensure compliance with regulatory requirements.
- System Upgrades: Plan and execute database upgrades and patches on IBM i platforms with minimal disruption to business operations.
- Troubleshooting: Diagnose and resolve database-related issues, including system performance, connectivity, and integrity issues.
- Database Maintenance: Perform regular database maintenance tasks, including reorganization, index rebuilds, and data archiving.
- Collaboration: Work with developers to design and optimize database schemas, stored procedures, and queries. Assist in database-related development and deployment tasks.
- Documentation: Maintain comprehensive documentation related to database configurations, procedures, and policies.
Required Skills and Qualifications:
- Proven experience as a Database Administrator, specifically with IBM i (AS/400) and DB2 for i.
- In-depth knowledge of IBM i operating system (OS/400), database management, and tools like IBM Navigator for i, STRSQL, etc.
- Expertise in database performance tuning, backup, recovery, and security.
- Strong understanding of SQL and relational database management principles.
- Experience with IBM i system hardware, memory, and storage configurations.
- Familiarity with IBM i job management, work management, and system resources.
- Strong problem-solving, troubleshooting, and communication skills.
- Ability to work independently as well as part of a team.
- Knowledge of industry best practices and regulatory compliance standards related to database management.
Preferred Qualifications:
- IBM i Certifications (e.g., IBM Certified Database Administrator DB2 for i).
- Experience with other database technologies (e.g., MySQL, Oracle) is a plus.
- Familiarity with IBM Power Systems hardware.
- Familiarity with Cloud Computing, Nodejs, any other IBM MDM tools (Informatica).
Education and Experience:
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
- 10+ years of experience as a Database Administrator, with a focus on IBM i systems and DB2 for i.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.