← Back to jobs

Avance Consulting Logo
Senior Database Administrator (DB2 z/OS)

Avance Consulting

 

Omaha, NE, United States

Posted On: 30+ days ago
Experience: 5+ years
Availability: Hybrid
Openings: 2
Category: Database Administrators
Tenure: Full-time Only
Related Jobs

No related jobs found

Description

You will manage and maintain DB2 z/OS database environments within a 24x7 production support model. You own database definitions, object creation, and access control via Grant/Revoke processes.

Responsibilities

  • Execute data maintenance activities including REORG, RUNSTATS, ICOPY, LOAD, and QUIESCENCE.
  • Plan and implement backup, recovery, and disaster recovery strategies, including point-in-time recovery.
  • Monitor package performance, suggest query tuning, and provide capacity and utilization reporting.
  • Perform root cause analysis for infrastructure issues and maintain SOP documentation for daily operations.
  • Coordinate with application owners, security, and release management teams to resolve system issues.

Required Skills

  • At least 5 years of relevant experience in DB2 z/OS administration.
  • Expertise in designing and developing logical and physical data models.
  • Hands-on experience with DB2 Administration Tool, Log Analysis Tool, Object Comparison Tool, Query Monitor, and DB2 Utilities Suite.
  • Proficiency running DB2 Utilities and Commands to monitor database status.
  • Experience executing Bind PLANS/PACKAGES and managing production data refreshes.
  • Ability to participate in an on-call rotation for 24x7 production support.
  • Experience working in a global delivery environment with offshore teams.
  • Bachelor’s degree or foreign equivalent from an accredited institution.

Preferred Skills

  • Experience in disaster recovery planning and implementation.
  • Background working in the banking or finance domain.

Key Skills
Education

Bachelor’s degree or foreign equivalent required from an accredited institution

Related Jobs

No related jobs found

← Back to jobs