Role: Informix DBA
Location: Leeds, UK
Type: Contract
Required Experience:
- Informix DBA with Informix Database Migration experience.
- 6+ years experience in the management and administration of IBM Informix IDS v 14.x v11.x, v10.x and v9.x database systems on UNIX OS - MUST
- Experience in database migration from Legacy to v11.x/v14 - MUST
- Experience installing and configuring IBM Informix products and tools. - MUST
- Proficiency with IBM Informix database tools and utilities. - MUST
- Experience in Backup and Recovery operations using various backup and restore methods. - MUST
- Expertise in SQL tuning and debugging. - MUST
- Solid analysis and troubleshooting skills.
- Experience on UNIX environment using Sun Solaris and HPUX .
- 24x7 support when needed.
- Bachelor's degree in Computer Science, Information Systems, or related technical field.
Responsibilities:
- Own and deliver the Version migration from Legacy to current versions of Informix Administer, support and maintain all Informix database systems.
- Daily monitoring of database activity and performance.
- Create, update and document database configurations.
- Tune databases, as required, to ensure optimal performance and response time.
- Plan and manage space allocations.
- Gather statistics on database usage.
- Complete database, and other IBM Informix software, installs and upgrades.
- Perform migrations, conversions, and data reorganizations of databases, as needed.
- Develop, incorporate, and maintain database security procedures.
- Write Unix Scripts, SQL, Stored Procedures, Triggers, as required.
- Set up automated alerts and reporting.
- Deliver timely and quality response to service requests.
- Perform system and database troubleshooting and problem resolution.
- Provide technical guidance to Applications Developers.
- Implement database changes through development, test and production environments.
- Ensure database archives and other backups are performed on a scheduled basis.
- Restore/Refresh databases as needed/requested.
*Applicants should ideally have Informix DBA experience within the last 4-5 years.