Informix Database Administrator Role
The primary objective of this role is to ensure the optimal performance, security, and availability of IBM Informix database environments. As a key member of our team, you will be responsible for managing and maintaining these environments to support our regulatory platform.
Key Responsibilities:
* Database Administration: Install, configure, upgrade, and patch Informix database server software to ensure seamless operation.
* Monitor and optimize database performance by analyzing metrics related to memory, CPU, I/O, and storage.
* Implement robust backup and disaster recovery strategies to minimize data loss and downtime.
* Troubleshoot complex database issues, identifying root causes and providing effective resolutions.
* Design and maintain database objects, including tables, views, indexes, and stored procedures, to ensure efficient data access.
* Manage user access, roles, and permissions to maintain data security and compliance.
* Automate database maintenance tasks using shell scripts or other tools to enhance efficiency.
* Support application development teams with schema design, tuning, and query optimization to improve system performance.
* Perform capacity planning and ensure high availability and disaster recovery readiness to mitigate potential risks.
Requirements: Proven experience as an Informix DBA in production environments, proficiency in Informix tools (dbaccess, onstat, oncheck, ontape, onbar), and knowledge of SQL tuning, indexing strategies, and replication techniques. Strong UNIX/Linux skills, including shell scripting, are also essential. Additionally, familiarity with Informix Storage Manager (ISM) and monitoring tools is required. Australian Citizenship with Baseline security clearance is mandatory.