Informix DBA

Mandatory Skills-
• Daily monitoring of database activity and performance.
• Administer, support and maintain all Informix database systems.
• 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.
• 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.
• Write weekly DBA task reports for input to activity highlights.