DB2 Database Administrator

Overview

Remote
$65+
Contract - W2
Contract - 6 Month(s)
Able to Provide Sponsorship

Skills

DB2 v10+ on IBM z/OS
DB2 on AIX
IBM IMS V12
CICS Transaction Server
COBOL with embedded DB2
REXX scripting
Assembler troubleshooting
Oracle Transparent Gateway
IBM InfoSphere Replication Server
BMC BPPM Monitoring
IBM Tivoli LDAP on AIX
Backup & Recovery
Database Reorgs
Runstats
Performance Tuning
Disaster Recovery
Payroll/Financial Applications Support.

Job Details

Job Description:
We are seeking an experienced DB2 Database Administrator with strong expertise in supporting DB2 v10+ on IBM z/OS. This role will involve supporting payroll and pension payroll applications, handling installation, migration, performance tuning, recovery, and troubleshooting. The DBA will collaborate with application teams, system administrators, and support staff to ensure optimal database performance and reliability.

Key Responsibilities:

  • Install, configure, and upgrade DB2 databases on z/OS and AIX platforms.

  • Support execution of data fixes and manage database recovery functions.

  • Perform standard database tuning procedures: runstats, reorgs, performance optimization.

  • Troubleshoot DB2 issues, including those embedded within COBOL programs.

  • Author and validate database procedures and automation scripts (REXX).

  • Work on disaster recovery drills and production migrations.

  • Support IMS V12, CICS Transaction Server, and IBM Tivoli LDAP server on AIX.

  • Collaborate with development teams for data propagation solutions using IBM InfoSphere Replication Server.

  • Implement monitoring solutions with BMC BPPM.

  • Design and implement Oracle Transparent Gateway integrations.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Sierra Software Solutions