Effizotech
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. #J-18808-Ljbffr
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. #J-18808-Ljbffr