DB2 DBA ( z/OS ) Level II ( 4268 - Ohio )

Marysville, OH, US • Posted 5 hours ago • Updated 5 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

Scalability
Query Optimization
Caching
Onboarding
CPU
Risk Management Framework
RMF
SMF
Optimization
Collaboration
High Availability
Database Administration
Performance Tuning
Database
IBM DB2
Recovery
SQL Tuning
IBM OMEGAMON
Mainframe
Performance Metrics
z/OS
JCL
Batch Processing
Scheduling
Sarbanes-Oxley
Auditing
Database Security

Summary

Job Description: DB2 DBA (z/OS) Level II
Location: Marysville, OH (Hybrid)
Key Responsibilities

Meet with application teams to understand requirements and recommend high-level direction and approach to upcoming projects.
Fine-tune database systems to enhance performance, scalability, and reliability, including query optimization, indexing, and caching.
Monitor database performance using built-in and third-party tools; identify and resolve bottlenecks through tuning and configuration adjustments.
Utilize monitoring tools to track database health, performance metrics, and security events; configure alerts for potential issues.

What Will the Person Be Working On

Act as the primary DBA contact during application onboarding, upgrades, and major enhancements.
Monitor DB2 subsystem performance (CPU, I/O, buffer pools, locking, queries).
Analyze and resolve performance issues using tools such as Omegamon, EXPLAIN, RMF, SMF, and native DB2 utilities.
Perform SQL performance tuning and index optimization in collaboration with application teams.
Plan and execute DB2 maintenance activities including PTFs, service packs, and version upgrades.
Proactively identify risks and improvement opportunities to ensure high availability and reliability.

Requirements (Wants)

5-10 years of hands-on DB2 for z/OS DBA experience in large enterprise environments.
Experience supporting critical production systems with 24x7 availability requirements.
Strong experience in performance tuning, database utilities, and mainframe operations.
Experience working on large-scale projects and coordinating with cross-functional teams.
Deep knowledge of DB2 z/OS architecture, subsystems, utilities, logging, and recovery.
Strong SQL tuning and execution plan analysis skills.
Experience with monitoring tools (e.g., Omegamon) and mainframe performance metrics.
Understanding of z/OS concepts including datasets, JCL, batch processing, and scheduling.
Strong knowledge of SOX, audit processes, and database security best practices.

#LI-KR4

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.

Dice Id: sharpdec
Position Id: 52455
Posted 5 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior Engineering Manager Database

Remote or Columbus, Ohio

•

Today

McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve - we care. What you do at McKesson matters. We foster a culture where you can grow, make an impact, and are empowered to bring new ideas. Together, we thrive as we shape the future of health for patien

Full-time

USD 118,100.00 - 196,900.00 per year

Specialist, Data Engineer

Columbus, Ohio

•

Yesterday

{"description": "If you're passionate about being part of a dynamic organization that enables a Fortune 100 company with nearly $70 billion in annual sales to drive innovation and adopt new technologies that deliver business results, then Nationwide's Technology team could be the place for you! At Nationwide , \"on your side\" goes beyond just words. Our customers are at the center of everything we do and we're looking for associates who are passionate about delivering extraordinary care. We are

Full-time

USD 95,500.00 - 177,500.00 per year

Senior PostgreSQL Database Engineer

Columbus, Ohio

•

Today

Description Summary: Huntington is seeking a Senior PostgreSQL Database Engineer's with experience supporting enterprise-grade database environments. The ideal candidate brings strong technical leadership, excels in performance tuning and automation, and enjoys mentoring junior team members while driving best-in-class database reliability and security. *This position is available to be filled at any Huntington Corporate office location* Duties and Responsibilities: Lead and participate in co

Full-time

Support Engineer II

Ohio

•

Today

Job#: 3024032 Job Description: Job Title: Support Engineer II Location: Remote (EST Hours) Length: 9 Months Pay: $27-$31 THIS IS A 3RD SHIFT POSITION, MONDAY-FRIDAY: NIGHTS (MIDNIGHT - 8AM), ROTATING WEEKENDS AND HOLIDAYS General Function The position is responsible for monitoring and supporting mainframe, open systems, and server backup production schedules and workflow processes. This includes troubleshooting operational issues, resolving problems, and escalating when necessary to ensure

Easy Apply

Full-time

Compensation information provided in the description

Search all similar jobs