DB2 Database Administrator Job Description
This position involves working as a DB2 Database Administrator in a mainframe environment. The successful candidate will be responsible for ensuring database performance, reliability, and security for business-critical systems operating 24/7.
Main Responsibilities
1. Database Administration & Performance
* Ensure the availability, performance, and stability of the DB2 database environment.
* Perform regular database backups, recovery procedures, user management, and security management.
* Conduct database upgrades, patches, and capacity planning.
2. Monitoring & Optimization
* Proactively monitor database and batch job performance to identify bottlenecks and implement solutions.
* Implement tuning strategies to improve query and workload performance.
* Diagnose and resolve DB2-related issues affecting batch job processing.
* Provide Level 2 and Level 3 support for mainframe-based applications and batch processes.
* Participate in Major Incident Management (MIM) and problem resolution efforts.
3. Design & Implementation
* Design and implement DB2 schemas, tables, indexes, and stored procedures.
* Support database design efforts for new or enhanced batch processing applications.
4. Security & Compliance
* Apply and manage database security measures according to corporate standards and regulatory compliance requirements.
* Conduct access audits and manage user privileges appropriately.
5. Batch Processing Support
* Maintain, run, and monitor batch job schedules end-to-end with an emphasis on after-hours processing.
* Collaborate with internal teams and third-party vendors to resolve batch failures or issues.
* Implement and validate changes to batch processes.