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 DescriptionWe 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 DescriptionWe 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 standardsRequirementsQualifications and experienceProven 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