Senior DB2 DBA - Mainframe, Remote, DMV Systems

AHU Technologies Inc; Washington (District of Columbia); On-site; USD 130,000 - 190,000; Full time

Benefits offered by this job

Remote work option

Job summary

AHU Technologies Inc. seeks an experienced IBM DB2 Database Administrator to manage and maintain DB2 databases on mainframe platforms for the DESTINY DMV system. Remote work option is available; 1099/W2/C2C employment types apply.

The role requires installation, upgrades, patches, migrations, performance tuning, and robust backup/recovery strategies to ensure high availability and data integrity across distributed environments.

Qualifications

• Bachelor’s degree in IT or related field.
• 15+ years hands-on IBM DB2 experience.
• Expert in database design and SQL optimization.
• Knowledge of high-availability technologies (HADR, replication, failover, clustering).
• Experience supporting complex, transactional, high‑volume systems (government or DMV systems preferred).
• Familiarity with ETL processes, Data Mining, Data Storage, Data warehousing.
• Knowledge of IBM batch jobs and integration with enterprise applications.
• Strong troubleshooting and performance tuning skills.

Responsibilities

• Support DESTINY by optimizing queries, stored procedures, packages, and triggers.
• Collaborate with developers to implement enhancements and fixes.
• Synchronize releases and data model changes with database environments.
• Maintain data integrity via validation, referential integrity, and error handling.
• Enforce database security standards and access controls per DC policies.
• Ensure compliance with privacy and data protection rules for DMV data.
• Use DB2 monitoring tools to identify performance bottlenecks.
• Analyze SQL performance and execution plans for optimizations.
• Tune memory, indexes, and storage structures for throughput.
• Support modernization efforts for DESTINY system and related components.
• Coordinate with infrastructure teams on server performance, storage, and network connectivity.
• Implement schema changes, table restructuring, indexing strategies, and partitioning as needed.
• Provide knowledge and support to district agencies and stakeholders.
• Perform other duties and coordinate application developers as needed.

Skills

IBM DB2 DBA

Mainframe DB2

HADR / Replication

SQL Tuning

Data Warehousing

Batch Jobs

Security & Auditing

Troubleshooting

ETL Familiarity

Team Collaboration

Education

Bachelor’s degree in IT/Related field

Job description

AHU Technologies Inc. seeks an experienced IBM DB2 Database Administrator to manage and maintain DB2 databases on mainframe platforms for the DESTINY DMV system. Remote work option is available; 1099/W2/C2C employment types apply.

The role requires installation, upgrades, patches, migrations, performance tuning, and robust backup/recovery strategies to ensure high availability and data integrity across distributed environments.