DB2 Engineer - w2

About the role

Design and implement scalable, secure, and high-performing IBM DB2 environments. Architect database solutions aligned with enterprise standards. Install, configure, upgrade, and patch DB2 instances. Implement HADR (High Availability Disaster Recovery) and replication strategies. Plan and execute database migrations and capacity planning. Develop backup and recovery strategies (Full, Incremental, Rollforward). Perform performance tuning and optimization tasks including monitoring and tuning DB2 databases for performance and scalability. Optimize SQL queries, indexing strategies, and database structures. Analyze explain plans and troubleshoot performance bottlenecks. Implement proactive monitoring solutions.

Responsibilities

• Strong hands-on experience in UNIX environments (AIX/Linux/Solaris).
• Shell scripting for automation and operational efficiency.
• Performance monitoring at OS level (CPU, Memory, I/O, Disk).
• Troubleshoot system-level issues impacting database performance.

Requirements

Required:

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Minimum 5 years of experience in DB2 database engineering and architecture.
• Experience with HADR (High Availability Disaster Recovery) and replication strategies.
• Experience with database migration and capacity planning.
• Experience with backup and recovery strategies (Full, Incremental, Rollforward).
• Experience with performance tuning and optimization.
• Experience with SQL query optimization and indexing strategies.
• Experience with analyzing explain plans and troubleshooting performance bottlenecks.
• Experience with implementing proactive monitoring solutions.

Qualifications

Preferred:

• Master's degree in Computer Science, Information Systems, or related field.
• Experience with AIX, Linux, and Solaris operating systems.
• Experience with shell scripting for automation and operational efficiency.
• Experience with performance monitoring tools at the OS level (CPU, Memory, I/O, Disk).
• Experience with troubleshooting system-level issues impacting database performance.

Skills

Skills:

• DB2 Database Engineering & Architecture.
• UNIX System Engineering.
• Shell scripting.
• Performance monitoring at OS level.
• Troubleshooting system-level issues.

Benefits

N/A

Pay

N/A

Schedule

N/A

Contact

Email: rachael@sidramtech.com
Direct: 4705239688

Employer

Rachael IT Services | Development | Staffing

URL

http://www.sidramtech.com