Worldpay · 13 hours ago

DB2 Database Administrator Senior (z/OS)

United States

Full-time

Remote

Senior Level

$105K/yr - $177K/yr

7+ years exp

Maximize your interview chances

BankingPayments

Insider Connection @Worldpay

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Optimize Db2 resource utilization by tuning queries, recommending indexes, design architecture and configuring database parameters

Lead, mentor and/or provide guidance to less experienced database DBAs where applicable including guidance for troubleshooting escalated issues

Provide team oncall rotational 24/7 Incident Response

Provide project support in alignment with business goals

Support compliance and regulatory requirements

Provide database metrics to promote cost reduction and capacity planning

Maintain data integrity within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities (disaster recovery)

Deploy database changes in strict accordance with Service Management policies and procedures

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

DB2z database administrationDb2z V12 experiencePerformance tuning of SQLsIDAAIDAA Bulk LoaderCDC ReplicationDb2 Transparent ArchivingREXX scriptingStored ProceduresDb2 Connect installationsDb2 Client configurationDatabase PartitioningIBM Db2 Admin tool suiteQuery MonitorOmegamon (Db2 PE)Db2 utilities

Required

Bachelor's degree in CS/MIS or equivalent experience

Minimum of 7 years of heavy Db2z database administration experience and production support requiring Db2z V12 experience

Hands on experience with performance tuning of SQLs

Db2 Connect and Db2 Client installations and configuration

Experience working with very large database Partitioning (> billion rows)

Experience working with large systems in data sharing sysplex environment

Experience working with IBM Db2 Admin tool suite, Query Monitor, and Omegamon (Db2 PE) and in-depth knowledge of Db2 utilities such as LOAD, UNLOAD, High Speed Unload, RUNSTAT, REORG, COPY, COPYTOCOPY, MERGECOPY, MODIFY and SPUFI.