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)

Additional Information :

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

Remote Work :

Yes

Employment Type :

Full-time