Northramp

Mainframe DB2 Database Administrator

MO, USPosted 30 days ago

Job Description

The Mainframe DB2 Database Administrator and Application Architect will support complex enterprise systems across development, test, and production environments. This role requires strong technical depth in DB2 for z/OS, application architecture design, system integration, and problem-solving within a federal contracting environment. The DBA will work closely with analysts, developers, and technical leads to ensure system reliability, performance, and alignment with organizational standards.

This role is remote, with the expectation of participating in after-hours or weekend deployments and support activities when necessary.

Key Responsibilities

* Mainframe – DB2 Database Administration (DBA) * + Manage, configure, and maintain DB2 for z/OS databases across Development, Test, and Production. + Refresh datasets and environments to support testing cycles. + Develop database conversion routines to support new projects or modernization efforts. + Optimize system and application performance by tuning SQL queries, identifying bottlenecks, and monitoring resource consumption. + Plan and execute DB2 utilities such as REORG, RUNSTATS, LOAD, UNLOAD, COPY, and REBUILD INDEX. + Implement structural database changes (DDL), stored procedure modifications, and bind plans/packages. + Research and resolve abends, performance issues, and production defects. + Develop and execute SQL as needed to correct data issues. + Define and maintain backup and recovery strategies, perform DR drills, and ensure the integrity of data assets * Application Architecture & Design * + Define enterprise application architecture inclusive of systems, web services, integration patterns, and data models. + Provide development support and mentorship to technical teams, conducting code and architecture reviews as needed. + Produce technical documentation including data models, process flows, and specifications for system changes. + Ensure solutions align with architectural sta...

Apply for this role

Keep looking

Similar Remote IT And Developer Jobs