What are the responsibilities and job description for the Informix Database Administrator position at SMI Management, LLC?
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. We’re All About Opportunity From career growth and training to volunteerism and mentorship, we want our entire team to be the best they can possibly be. That means ensuring that we provide as many opportunities as we can for development and learning, and encourage curiosity and capability at every turn. SMI is a leading provider in government payment solutions, developing state-of-the-art solutions and running complex human services operations. We are focused on serving our government clients and their end-customers: some of the most in-need families and individuals in the United States. Our mission is to “Go the Extra Mile with a Passion to Serve”. With over 53 years in operation as a family-owned and operated business, SMI has grown to over 600 employees across the country, SMI considers its employees and customers as part of our extended family. We are truly a family, serving families. SMI recruits individuals who are technical, creative, innovative, customer-focused, and most importantly willing to Go the Extra Mile. Our culture is one of teamwork, dedication, empowerment, and a strong emphasis on work-life balance. We offer an optimal atmosphere for career growth and achievement, while remaining competitive in compensation and benefits. We depend on the expertise of our SMI team to develop and support the very best systems and product lines in the industry. If you are looking for a meaningful and fulfilling career, we hope you will join us, at SMI.