Informix Database Administrator
It's fun to work in a company where people truly BELIEVE in what they're doing! We're committed to bringing passion and customer focus to the business. SMI Management, LLC SMI Management delivers enterprise asset-management solutions. Our flagship SMILE system support HR and Financial needs of the Georgia Division of Family and Child Services (DFCS). The system supports thousands of users and processes millions of dollars of transactions daily, on behalf of state employees, vendors, adoptive parents and foster care providers. Role Overview Reporting to the lead DBA, you’ll help manage our IBM Informix V14 primary & hot-standby and development instances in GA and TX. You’ll develop and maintain the SMILE application stack (Four Js Genero, ESQL-C, C, shell scripts, Informix iSQL/ACE reports) across HPUX and RHEL platforms—and support the migration of our legacy C/Informix/shell application from HPUX to Red Hat alongside our offshore teams. Key Responsibilities: • DBA Support: Assist the primary DBA with daily tasks: user management, performance monitoring, patching, routine maintenance using Informix toolset • Informix Administration & DR: • Manage IBM Informix primary, DR and development instances on Red Hat RHEL V8+ • Monitor integrity, performance and availability of all environments • Configure new and existing instances as required • Provision raw and cooked disk storage as required • Migration Support: • Collaborate with offshore teams to migrate legacy C, Informix SQL (ACE/Perform), and shell scripts from HPUX to RHEL 9 • Validate migrated code, troubleshoot platform-specific issues, document procedures • Performance & Tuning: Monitor SQL; tune indexes, buffer pools, memory, and I/O • DR, Backup & Recovery: Design and test ontape backup/restore procedures to meet RTO/RPO targets • Schema & Stored Procedures: Define database schemas and write Informix SPL stored procedures • Web & Middleware: Configure/install Apache servers and enforce web-application security best practices • Source Control & DevOps: Manage code in Subversion; track work in Azure DevOps • Platform Operations: Deploy, patch, and troubleshoot on HPUX 11.31 and RHEL 8/9 Required Qualifications/Experience • 4+ years hands-on Informix DBA experience (Workgroup or Enterprise) with DR, ontape backups, and log-shipping • Proven ability to define database schemas and develop Informix stored procedures • Proficiency in ESQL-C, C, and Unix Korn and Linux Bash shell scripting • Strong SQL tuning skills; buffer-pool & index optimization experience • Familiarity with one or more of Four JS Genero, Informix iSQL and ACE reporting • Experience using source management system, Subversion preferred • Experience using work tracking system, Microsoft Devops preferred • Comfortable on HPUX 11.31 and Linux (RHEL 8/9) • Strong communicator; able to collaborate with onshore/offshore teams • Bachelor’s degree in CS, IS, or related is a plus—but not required Preferred Qualifications/Experience • IBM Informix certification (e.g., IBM Certified DBA) • Experience installing/configuring Apache and securing web applications • Experience with Microsoft Azure DevOps • Experience migrating or integrating applications in cloud and geographically distributed environments • Scripting in Python or PowerShell for automation Location: Remote (occasional travel to company HQ in Carrollton, GA). Must reside in USA We are an Equal Opportunity Employer. We are a drug-free workplace. Apply tot his job