DB2 LUW Database Administrator

Join to apply for the DB2 LUW Database Administrator role at Blue Pearl

2 days ago Be among the first 25 applicants

Join to apply for the DB2 LUW Database Administrator role at Blue Pearl

Get AI-powered advice on this job and more exclusive features.

Job Description

We are seeking a skilled DB2 LUW (Linux, UNIX, Windows) Database Administrator to design, maintain, and optimize our DB2 databases to ensure high performance, availability, and security. The ideal candidate will have hands-on experience managing DB2 LUW databases, implementing database solutions, and working closely with application and infrastructure teams to support critical business operations. Key Responsibilities : 1. Database Administration : o Install, configure, and upgrade DB2 LUW database servers and related tools. o Perform daily administration, maintenance, and monitoring of DB2 databases to ensure optimal performance. o Ensure database performance, integrity, and availability are always maintained. 2. Performance Tuning and Optimization : o Analyse and optimize SQL queries, indexes, and database configurations for maximum efficiency. o Continuously monitor database performance and resource utilization, ensuring optimal operation. o Identify performance bottlenecks and implement improvements for enhanced database efficiency. 3. Backup and Recovery : o Develop and manage comprehensive backup, recovery, and disaster recovery plans to safeguard critical data. o Perform database restoration and recovery testing to ensure compliance with Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs). 4. Security and Compliance : o Implement and maintain database security best practices, including access control measures and data encryption. o Conduct regular audits to ensure data integrity and compliance with internal and external regulations. 5. Database Design and Development : o Design and optimize logical and physical database structures, including tablespaces, schemas, and indexes. o Collaborate in database modelling, partitioning, and developing strategies to enhance database performance and scalability. 6. Automation and Scripting : o Develop and implement scripts for automating database monitoring, maintenance tasks, and alerts. o Utilize scripting languages such as Shell, Perl, or Python to streamline database management and improve efficiency. 7. Collaboration and Support : o Work closely with application developers and system administrators to optimize database integration. o Provide expert-level database support for application deployments, system upgrades, and troubleshooting. 8. Documentation : o Maintain comprehensive and up-to-date documentation of database environments, configurations, processes, and standards

Job Description

We are seeking a skilled DB2 LUW (Linux, UNIX, Windows) Database Administrator to design, maintain, and optimize our DB2 databases to ensure high performance, availability, and security. The ideal candidate will have hands-on experience managing DB2 LUW databases, implementing database solutions, and working closely with application and infrastructure teams to support critical business operations. Key Responsibilities : 1. Database Administration : o Install, configure, and upgrade DB2 LUW database servers and related tools. o Perform daily administration, maintenance, and monitoring of DB2 databases to ensure optimal performance. o Ensure database performance, integrity, and availability are always maintained. 2. Performance Tuning and Optimization : o Analyse and optimize SQL queries, indexes, and database configurations for maximum efficiency. o Continuously monitor database performance and resource utilization, ensuring optimal operation. o Identify performance bottlenecks and implement improvements for enhanced database efficiency. 3. Backup and Recovery : o Develop and manage comprehensive backup, recovery, and disaster recovery plans to safeguard critical data. o Perform database restoration and recovery testing to ensure compliance with Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs). 4. Security and Compliance : o Implement and maintain database security best practices, including access control measures and data encryption. o Conduct regular audits to ensure data integrity and compliance with internal and external regulations. 5. Database Design and Development : o Design and optimize logical and physical database structures, including tablespaces, schemas, and indexes. o Collaborate in database modelling, partitioning, and developing strategies to enhance database performance and scalability. 6. Automation and Scripting : o Develop and implement scripts for automating database monitoring, maintenance tasks, and alerts. o Utilize scripting languages such as Shell, Perl, or Python to streamline database management and improve efficiency. 7. Collaboration and Support : o Work closely with application developers and system administrators to optimize database integration. o Provide expert-level database support for application deployments, system upgrades, and troubleshooting. 8. Documentation : o Maintain comprehensive and up-to-date documentation of database environments, configurations, processes, and standards

Requirements

Qualifications and experience

• Proven experience as a DB2 LUW Database Administrator in enterprise environments.
• In-depth knowledge of DB2 LUW versions 10.5 / 11.x / 12.x and related tools.
• Strong SQL query optimization and performance tuning skills.
• Experience with HADR (High Availability Disaster Recovery) setup and troubleshooting.
• Familiarity with database backup and recovery techniques.
• Proficiency in Linux / UNIX systems and scripting languages like Shell, Python, or Perl.
• Hands-on experience with tools like IBM Data Studio, db2top, or related utilities.
• Understanding of database security principles and auditing.
• Bachelor’s degree in computer science, Information Technology, or a related field.
• Equivalent work experience in database administration may be considered.
• 5+ years of experience as a DB2 LUW Database Administrator in an enterprise environment

check(event) ; career-website-detail-template-2 =>

apply(record.id,meta)" mousedown="lyte-button =>

check(event)" final-style="background-color : #187B9E;border-color : #187B9E;color : white;" final-class="lyte-button lyteBackgroundColorBtn lyteSuccess" lyte-rendered="">

Seniority level

Seniority level

Not Applicable

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

Industries

IT Services and IT Consulting

Referrals increase your chances of interviewing at Blue Pearl by 2x

Sign in to set job alerts for “Database Administrator” roles.

Johannesburg, Gauteng, South Africa 1 week ago

Johannesburg, Gauteng, South Africa 3 days ago

Midrand, Gauteng, South Africa 3 weeks ago

Johannesburg, Gauteng, South Africa 1 month ago

Johannesburg, Gauteng, South Africa 1 week ago

Johannesburg Metropolitan Area 1 week ago

Sandton, Gauteng, South Africa 1 month ago

Insights & Visualization Engineer (Finance) - South Africa

Johannesburg, Gauteng, South Africa 1 week ago

Insights & Visualization Engineer (Finance) - South Africa

Johannesburg, Gauteng, South Africa 4 days ago

Johannesburg, Gauteng, South Africa 1 month ago

Mainframe Database Administrator (DB2 / IDMS)

Sandton, Gauteng, South Africa 1 month ago

Johannesburg Metropolitan Area 3 days ago

Johannesburg Metropolitan Area 7 hours ago

Senior Mainframe IDMS Database Administrator

City of Johannesburg, Gauteng, South Africa 2 weeks ago

Johannesburg, Gauteng, South Africa 3 days ago

Johannesburg, Gauteng, South Africa 1 week ago

Rand West City, Gauteng, South Africa 6 months ago

Johannesburg, Gauteng, South Africa 1 month ago

Johannesburg, Gauteng, South Africa 1 day ago

Personal and Private Banking (PPB) Software Engineer Graduate Programme

Johannesburg, Gauteng, South Africa 1 month ago

Johannesburg, Gauteng, South Africa 2 days ago

Randburg, Gauteng, South Africa 2 weeks ago

Mathematics Expertise Sought for AI Training (South Africa)

Randburg, Gauteng, South Africa 1 day ago

Johannesburg, Gauteng, South Africa 1 day ago

City of Johannesburg, Gauteng, South Africa 1 week ago

Sandton, Gauteng, South Africa 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr