- Maintain and optimize DB2 databases to ensure high performance, availability, and security.
- Work closely with application and infrastructure teams to support critical business operations.
- Database Administration: Install, configure and upgrade DB2 database servers and related tools.
- Perform daily administration, maintenance, and monitoring of DB2 databases to ensure optimal performance.
- Ensure database performance, integrity, and availability are always maintained.
- Performance Tuning and Optimization: Analyse and optimize SQL queries, indexes, and database configurations for maximum efficiency.
- Continuously monitor database performance and resource utilization, ensuring optimal operation.
- Identify performance bottlenecks and implement improvements for enhanced database efficiency.
- Backup and Recovery: Develop and manage comprehensive backup, recovery, and disaster recovery plans to safeguard critical data.
- Perform database restoration and recovery testing to ensure compliance with Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs).
- Security and Compliance: Implement and maintain database security best practices, including access control measures and data encryption.
- Database Design and Development: Design and optimize logical and physical database structures, including tablespaces, schemas, and indexes.
- Collaborate in database modelling, partitioning, and developing strategies to enhance database performance and scalability.
- Automation and Scripting: Develop and implement scripts for automating database monitoring, maintenance tasks, and alerts.
- Utilize scripting languages such as Shell, Perl, or Python to streamline database management and improve efficiency.
- Collaboration and Support: 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.
- Documentation: Maintain comprehensive and up-to-date documentation of database environments, configurations, processes, and standards.
Minimum Requirements:
Qualifications & experience required:
- Matric plus IT degree/diploma OR relevant IBM certification and good work experience.
- MUST HAVE: IBM Certified Administrator on IBM Db2 12 for z/OS.
- Must have 5 years minimum work experience as an IBM DB2 DBA/Engineer.
Technical skills required:
- IBM DB2 Database Administration (5 years’ experience required).
- 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.
- Experience required with IBM Z (mainframe), IBM AS/400, Linux, UNIX and/or Windows.
- Scripting languages like Shell, Python, or Perl.
- Understanding of database security principles and auditing.
- Monitoring tools (IBM Data Management Console – DMC) or Nagios or Zabbix.
Desired Skills:
- DB2 DBA
- IBM DB2 DBA
- DB2 Database Administrator