Mainframe DB2 Database Engineer

Position: DMS 2200 Database Administrator (DBA)

Location: Remote

Full Time

Clearance: Active MBI Clearance

Environment: UNISYS ClearPath OS 2200 Mainframe
Database Type: DMS 2200 (Network/Hierarchical Database)

Position Summary

The DMS 2200 Database Administrator is responsible for the administration, maintenance, performance tuning, and operational support of the DMS 2200 network database system operating on a UNISYS OS 2200 mainframe. This role supports mission-critical legacy applications, ensures data integrity and reliability, and collaborates closely with system administrators, developers, and operations teams.

Key Responsibilities

Database Administration & Maintenance

• Install, configure, and maintain DMS 2200 database structures, schemas, subschemas, and sets.
• Manage hierarchical and network database relationships, record types, and access paths.
• Perform routine database health checks, reorganization, cleanup, and optimization.
• Maintain journaling, recovery, and backup processes to ensure data integrity and system stability.

Performance Monitoring & Optimization

• Monitor database performance, identify bottlenecks, and implement tuning strategies to enhance throughput and efficiency.
• Optimize buffering, indexing, and access methods for batch and online workloads.
• Work with application teams to refine data access logic for improved performance.

Security & Compliance

• Administer user access rights, permissions, and database-level security functions.
• Ensure compliance with organizational and federal data protection standards.
• Monitor and audit database activity for security and operational consistency.

Support for Application Development

• Provide technical guidance to developers working in COBOL, ALGOL, FORTRAN, or other OS 2200-supported languages.
• Assist in designing efficient subschemas and data calls for transactional and batch applications.
• Troubleshoot database-related issues in production, test, and development environments.

Data Migration & Modernization (as applicable)

• Support data conversion efforts from DMS 2200 to relational or cloud databases when modernization projects are initiated.
• Map hierarchical/network structures to relational schemas.
• Assist with ETL extraction, transformation, and integration workflows.

System Collaboration

• Work closely with OS 2200 system administrators to coordinate updates, performance tuning, and operational scheduling.
• Participate in change control processes and maintain documentation for database configurations and procedures.

Required Qualifications

• 5+ years of experience administering DMS 2200 or similar hierarchical/network database systems.
• Hands-on experience with UNISYS ClearPath OS 2200 mainframe environments.
• Strong understanding of DMS 2200 indexing, sets, subschemas, record locking, journaling, and recovery.
• Familiarity with COBOL and other legacy languages commonly used on OS 2200.
• Experience with performance analysis, debugging, and system tuning on mainframe platforms.
• Ability to troubleshoot complex database issues in production environments.

Preferred Qualifications

• Experience supporting modernization or migration projects from DMS 2200 to relational databases (Oracle, SQL Server, PostgreSQL, etc.).
• Knowledge of ETL processes and data mapping between hierarchical and relational structures.
• Background in high-availability, mission-critical operational systems in government or regulated environments.
• Strong documentation, communication, and coordination skills.

Soft Skills

• Analytical problem-solving and attention to detail.
• Ability to work independently and in cross-functional teams.
• Strong communication with both technical and non-technical stakeholders.
• Adaptability to legacy environments and modernization challenges.

Thanks,

Afrah Faiza

Arthur Grand Technologies Inc

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)

All your information will be kept confidential according to EEO guidelines.

Arthur Grand Technologies (www.arthurgrand.com) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team of professionals who worked for big 5 consulting firms for 20+ years.

We are a minority owned staff augmentation and technology consulting company
To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits and provide continued opportunities for professional growth.