Ubique Systems is seeking an experienced IBM IMS Consultant to design, develop, and manage highly complex, scalable mainframe database systems that support organizational objectives. This fully remote position requires deep technical expertise and active involvement across all phases of database lifecycle management, including performance tuning, disaster recovery, and data migration.
What You'll Do
- Possesses extensive knowledge of one or more mainframe database systems, and is capable of hands-on work in all phases of database design and management.
- Design, develop, and implement infrastructure to provide highly-complex, reliable, and scalable database to meet the organization's objectives and requirements.
- Analyzes organization's business requirements for database design, and implements changes to database as required.
- Performs systems analysis on database, and resolves performance, capacity, and replication issues as necessary.
- Provides detailed design and specification documentation, including flowcharts, for all aspects of the databases.
- Works with the application support staff to develop methodologies, report views, queries, and table replications.
- Ensures that all the data is in the proper format.
- Participates in the identification, prioritization, and development of technical initiatives and strategies.
- Develops and maintains database standards and naming conventions.
- Keeps up-to-date on relevant mainframe emerging database architectures, technologies, and methodologies, and attends training classes as necessary.
- Actively participates in the extract and load of IMS and DB2 data for all Disaster Recover Exercise Programs.
- Actively participate in the Disaster Recovery effort if required.
- Assist as directed in the data conversion effort to a new Benefits application database.
What We're Looking For
- Extensive knowledge of one or more mainframe database systems
- Hands-on experience in all phases of database design and management
- Ability to design, develop, and implement complex, reliable, and scalable database infrastructure
- Experience analyzing business requirements for database design and implementing required changes
- Experience performing systems analysis on databases and resolving performance, capacity, and replication issues
- Ability to provide detailed design and specification documentation, including flowcharts
- Experience working with application support staff to develop methodologies, report views, queries, and table replications
- Ensures data is in the proper format
- Participates in identification, prioritization, and development of technical initiatives and strategies
- Develops and maintains database standards and naming conventions
- Keeps up-to-date on emerging mainframe database architectures, technologies, and methodologies
- Attends training classes as necessary
- Active participation in extract and load of IMS and DB2 data for Disaster Recovery Exercise Programs
- Willingness to actively participate in Disaster Recovery efforts when required
- Ability to assist in data conversion efforts to a new Benefits application database
Technical Stack
- IMS
- DB2
- Mainframe database systems
- Disaster Recovery systems
- Data conversion tools
- Database design and modeling tools
- Performance and replication monitoring tools
Work Mode
Fully Remote
Ubique Systems is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or veteran status.