Mainframe DB2 Database Administrator

Position : DB2 Database Administrator

Salary : $140,000 - $155,000 DOE + great benefits

100% REMOTE

Direct Hire -not able to accommodate C2C or H1 VISA candidates at this time.

Well established IT firm is seeking an experienced Mainframe DB2 Administrator to support their largest enterprise client. You will work remote and will install, customize, upgrade, maintain, and tune up a massive DB2 database environment.

Responsibilities

• Act as a Principal / Lead DBA for complex DB2 environments on both z / OS and Distributed (LUW -
• Linux, Unix, Windows) platforms, providing senior-level guidance and mentorship.
• DB2 database design, configuration, review, and administration.
• Maintain and operate DB2 software, and tools.
• Diagnose and resolve DB2 reason codes and SQL errors.
• Design, implement, and manage DB2 Connect configurations to enable seamless communication between distributed applications and the mainframe DB2 subsystem.
• Perform advanced, end-to-end performance tuning across application, database, and system levels, including detailed SQL query optimization and access path analysis (using tools like EXPLAIN).
• Provide on-call break / fix database support and respond within the agreed SLA.
• Support Disaster Recovery exercises.
• Manage changes within standard control processes and mechanisms using ITIL / ITSM practices.
• Produce clear technical documentation and conform to any audit requirements.

Qualifications

#danieln