Informix DBA

Description

Duties: Responsible for analyzing, developing, and administering our clients’ complex RDBMS database system based on the Informix database architecture. Responsible for database architecture, physical and logical database design, backup and recovery, and performance tuning of Informix databases. Monitor and develop database performance profiles, including monitoring and ensuring security and integrity of multi-platform database systems and environments. Perform key database administration functions including database instance creation, data migration, database replication, as well as initialization, configuration and administration of Informix systems and SQL provisioning and capacity planning to address database warehousing capabilities for large-scale reservations data management. Perform technology assessment audits, data structure tuning, database/table reorganization and utilities and scripts execution and monitoring. Employ scripting knowledge in Perl, csh, ksh, sh to develop solutions in disaster recovery, scripting and all other real-time, high availability and performance monitoring procedures. Support database backup failure, review SQL queries for performance issues, and analyze space reports and response query alerts. Plan Informix data warehousing server capacity upgrades while also troubleshooting all database system failures and performance issues. Collaborate with cross-functional to design and develop new database-driven software and enhance existing software applications. Ensure and deliver on high availability and uptime of our products and processes, and study, research, and recommend new database solutions for improvements in database infrastructure effectiveness and overall performance.