DB2 DBA and Database Performance Tuning Expert

eTeam; Selangor; On-site; MYR 80,000 - 110,000; Full time

Job summary

A technology consulting firm is looking for a DB2 DBA and Database Performance Tuning Expert in Malaysia, Selangor. The ideal candidate will have at least 5 years of experience in DB2 administration on Linux/Client-Unix technologies and will be responsible for performance tuning, troubleshooting, and ensuring database availability. Strong communication skills and the ability to optimize SQL queries are essential. This role will involve collaborating with the application development team to enhance overall application performance.

Qualifications

• Minimum 5 years of DB2 Database administration experience on Linux/Client-Unix.
• Ability to communicate effectively with stakeholders and management.
• Familiarity with best practices of database management and security.

Responsibilities

• Perform DB2 DB bottleneck analysis and outage prevention.
• Manage database capacity planning and recovery plans.
• Collaborate with application development team for efficient SQL.

Skills

DB2 bottleneck analysis

DB2 configuration support of SAP ISU, CRM, and PI

SQL optimization

Database performance tuning

Communication skills

Knowledge of performance monitoring tools

Tools

IBM tools

OPM

Job description

DB2 DBA and Database Performance Tuning Expert

Role: DB2 DBA and Database Performance Tuning Expert.

• Proven experience in DB2 DB bottleneck analysis, outage prevention/resolution, advance server/database performance improvements and troubleshooting.
• Hands‑on DB2 configuration support of SAP ISU, CRM, and PI applications.
• Handle database capacity planning, performance tuning and backup and recovery plan to ensure availability of database services.
• The candidate must have advanced knowledge base of relational database performance and tuning such as: proper use of indexes, database statistics/reorgs, de‑normalization concepts, memory management, database configurations, etc.
• Take part in technical and business discussion, share ideas and provide feedback in continuing the improvement of the database support and performance issues.
• Working with the application development team to ensure that appropriate and efficient SQL is being coded and tested.

Requirements

• Minimum 5 years of experience of DB2 Database administration on Linux/Client-Unix Technology is a must.
• Highly skilled in optimization of SQL queries or stored procedures to improve application effectiveness and performance.
• Strong written and communication skills to effectively communicate with stakeholders and senior management.
• Familiar with best practices and principles of database management, security, accesses and regulations.
• Engineering on New DB2 features and IBM tools.
• Knowledge on performance monitoring tools like OPM.