Search

Senior Mainframe Db2 DBA z/OS

PublishedPublished: 6/14/2022
Technology

Job Description

Job Description

\n


\n

What You’ll Be Doing

\n

Database design and change management

\n

    \n
  • Reviews and approves physical database designs (tablespaces, partitioning, indexing, referential integrity, compression) for new and changed applications.
  • \n

  • Implements DDL and configuration changes through the ITIL change management process; maintains DDL, object inventory, and standards under version control.
  • \n

  • Manages subsystem parameters (ZPARM), buffer pool configuration, and storage allocation.
  • \n

\n

Performance management

\n

    \n
  • Monitors subsystem, thread, and application performance; establishes and tracks baselines.
  • \n

  • Analyzes access paths using EXPLAIN and related tooling; identifies and remediates inefficient SQL in partnership with application and data engineering teams.
  • \n

  • Schedules and tunes Db2 utilities (REORG, RUNSTATS, COPY, MODIFY, RECOVER) and maintains the utility calendar.
  • \n

\n


\n

Best Regards,

\n

Akhilesh Gupta

\n

Senior Recruiter

\n


\n

Note – VBeyond is fully committed to Diversity and Equal Employment Opportunity.

\n


\n


Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...