Mainframe DB2 Database Engineer

Arthur Grand Technologies Inc-posted 7 days ago
Full-time • Mid Level
Remote • Washington, DC
11-50 employees
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

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.

  • 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.
  • 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.
  • 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.
  • 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.
Track Jobs with Teal

Job Search Resources

•
AI Resume Builder
•
Database Architect Resume Examples
•
Database Architect Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service