Mainframe DB2 Database Engineer

  • Full-time

Company Description

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.

Job Description

 

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.