ASCII Group - Portland, OR
posted 2 months ago
The IBM DB2 LUW Database Administrator position is a critical role that requires extensive experience in managing and optimizing DB2 LUW databases. The successful candidate will be responsible for the installation and configuration of DB2 LUW database software on servers, ensuring that the database environment is secure, efficient, and compliant with relevant regulations. This role involves performance tuning, where the administrator will monitor and optimize database performance to ensure efficient operation. Additionally, the candidate will be tasked with understanding and testing backup and recovery procedures to safeguard data integrity, as well as developing and testing disaster recovery plans to minimize data loss in the event of a system failure. The position also requires strong experience in High Availability Disaster Recovery (HADR) environments and Dynamic Partitioned File (DPF) environments. The administrator will need to troubleshoot any DPF issues and drive MIM/P1/P2 bridge calls as necessary. Security management is another key responsibility, where the candidate will manage user access and ensure database security through proper authentication and authorization processes. The role includes diagnosing and resolving database-related issues, including errors, performance bottlenecks, and connectivity problems. Patch and version management is essential, as the administrator will apply patches and updates to keep the database system current and secure. Capacity planning is also a critical aspect of the role, requiring the candidate to estimate future database growth and plan for additional capacity as needed. Comprehensive documentation of database configurations, procedures, and troubleshooting guides is expected to be maintained. Collaboration with other IT professionals, such as system administrators and application developers, is necessary to ensure smooth integration and optimal performance. The administrator will also implement automation scripts and tools for routine tasks to enhance efficiency and set up monitoring tools to proactively identify issues and trends. Training and support for end-users and colleagues on database-related matters will be part of the responsibilities, along with providing detailed status reports to management regarding tasks and difficulties encountered.