Senior Informix Database Architect/Specialist

Description :Job Summary :We are seeking a highly experienced and expert-level Informix Database Architect/Specialist to design, implement, migrate, and maintain our critical database infrastructure. This role requires deep, hands-on expertise across the entire Informix product suite, with a strong focus on advanced administration, performance optimization, and modernization initiatives, including migrations and high-availability solutions.Missing Key Details :Detail Placeholder :Job Title : Senior Informix Database Architect/SpecialistExperience : 8-10 required years of experience.Core Responsibilities :- Database Architecture & Migration : Lead the design and execution of complex database upgrade and modernization projects, including migrations from older Informix versions (e.g., XPS) to the latest IDS (Informix Dynamic Server).- Performance Optimization : Proactively identify and resolve database performance bottlenecks. This includes deep experience in rewriting and optimizing complex SQL queries, stored procedures, triggers, and views. Conduct regular performance tuning and health checks.- High Availability & Replication : Design, configure, and manage high-availability and disaster recovery solutions using Informix HDR (High Availability Data Replication), ER (Enterprise Replication), CM (Connection Manager), RSS (Remote Secondary Server), and SDS (Shared Disk Secondary).- Development Support : Provide expert support and guidance to application developers working with Informix 4GL and ESQL/C code, ensuring efficient database interaction.- Automation & Scripting : Develop and implement automation tools and scripts using Python and other AI/automation techniques to streamline routine database administration, deployment, and monitoring tasks.- Installation & Configuration : Lead the installation, configuration, and patching of all core Informix components, including Informix Server, Informix Client SDK, and Informix 4GL Tools.- Data Capture : Demonstrate proficiency with Change Data Capture (CDC) concepts and implementation to support data integration and warehousing initiatives.- Backup and Recovery : Implement, test, and manage robust backup and recovery strategies using native Informix tools like ontape and onbar.Required Technical Skills (Must-Have) :- Informix Mastery : Expert-level knowledge of the Informix database suite, specifically Informix Dynamic Server (IDS) and Informix Extended Parallel Server (XPS).- Development Languages : Strong development knowledge of Informix 4GL and ESQL/C.- Advanced DBA Skills : Proven experience with DB upgrade and design for large-scale Informix environments.- Migration Experience : Specific expertise in managing and executing Design/Migrations from old Informix versions and XPS to IDS.- Scripting & Automation : Proficiency in Python for database automation and administration, along with general scripting knowledge.- SQL & Tuning : Extensive experience with rewriting and optimizing complex SQL queries, stored procedures, triggers, and views for improved performance.- Availability : Hands-on experience configuring and managing Informix solutions : HDR, ER, CM, RSS, and SDS.- Backup & Installs : Deep knowledge of Informix backup using ontape and onbar, and practical experience with product installation (4GL Tools, Server, Client SDK).- Data Concepts : Well versed with CDC (Change Data Capture) concepts.Desirable Skills (Nice-to-Have) :- Replication Deep Dive : Advanced experience with complex Informix Enterprise Replication (ER) topologies.- Clustering : Exposure to implementing and troubleshooting Informix clustering solutions : HDR, SDS, and RSS.- Cloud Deployment : Experience deploying and managing Informix environments on cloud platforms such as Azure, AWS, IBM Cloud, or OpenShift Container Platform (OCP).- Cross-RDBMS Knowledge : Familiarity with other major RDBMS platforms like DB2, Oracle, or SQL Server, particularly in the context of migration or integration projects.- Specialized Datablades : Knowledge of Informix datablades like Timeseries and Geo Spatial. (ref:hirist.tech)