Database Architect, IRS MBI Clearance Required
3M Consultancy
ETLMongoDBOraclePostgresSQL
Informix Database Administrator
Systems & Methods, Inc. (SMI)
full-time
Posted on:
Location Type: Remote
Location: Remote • Colorado, District of Columbia, Iowa, New Jersey • 🇺🇸 United States
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
ApacheAzureJavaScriptLinuxShell ScriptingSQLSubversionUnix
About the role
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
IBM Informix V14CESQL-CUnix KornLinux BashSQL tuningInformix SPLontape backupslog-shippingdatabase schemas
Soft skills
strong communicatorcollaborationtroubleshootingdocumentation
