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.