Informix Database Administrator

Job not on LinkedIn

October 8

⛰️ Colorado – Remote

Although this job is listed in Colorado, this company may be open to hiring remote in other states.

+2 more states

⛰️ Colorado – Remote 🌾 Iowa – Remote 🏖️ New Jersey – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

📀 Database Administrator

Apply Now

Receive Emails with Similar Jobs

Systems & Methods, Inc. (SMI)

WebsiteLinkedInAll Job Openings

Fintech • B2B • Government

Systems & Methods, Inc. (SMI) is a family-led business dedicated to enhancing the quality of life for families through innovative financial solutions. For over 50 years, SMI has provided critical funds to families by developing custom disbursement systems that cater to the unique needs of state and local agencies across the U. S. By leveraging advanced technology and a relationship-focused approach, SMI excels in delivering precise payment processing and comprehensive financial management services. Their offerings include child support processing, prepaid cards, and online banking solutions designed to ensure security, flexibility, and user-friendly experiences for individuals and families.

501 - 1000 employees

Founded 1971

💳 Fintech

🤝 B2B

🏛️ Government

📋 Description

• Reporting to the lead DBA, help manage IBM Informix V14 primary & hot-standby and development instances in GA and TX. • Develop and maintain the SMILE application stack across HPUX and RHEL platforms. • Support the migration of the legacy C/Informix/shell application from HPUX to Red Hat alongside offshore teams. • Assist the primary DBA with daily tasks: user management, performance monitoring, patching, routine maintenance. • 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. • 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. • Monitor SQL; tune indexes, buffer pools, memory, and I/O. • Design and test ontape backup/restore procedures to meet RTO/RPO targets. • Define database schemas and write Informix SPL stored procedures. • Configure/install Apache servers and enforce web-application security best practices. • Manage code in Subversion; track work in Azure DevOps. • Deploy, patch, and troubleshoot on HPUX 11.31 and RHEL 8/9.

🎯 Requirements

• 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.

🏖️ Benefits

• Health insurance • 401(k) matching • Paid time off • Professional development opportunities