Sign upLog in

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

Sharp Decisions, Inc

Marysville, OH

Apply
JOB DETAILS
SKILLS
Analysis Skills, Best Practices, CPU (Central Processing Unit), Caching, Cross-Functional, Data Sets, Database Administration, Database Technology, High Availability, High Reliability, IBM DB2, IBM z-OS Operating System, Information/Data Security (InfoSec), Input/Output, JCL (Job Control Language), Mainframe Computer, Onboarding, Performance Analysis, Performance Metrics, Performance Tuning/Optimization, Problem Solving Skills, Production Support, Production Systems, Project/Program Coordination, Query Optimization, Risk Analysis, SQL (Structured Query Language), Sarbanes-Oxley Act (SOX), Security Attacks, Software Upgrades
LOCATION
Marysville, OH
POSTED
30+ days ago

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

About the Company

S

Sharp Decisions, Inc

For over two decades, Sharp Decisions has provided superior, award-winning service in strategic business and technology consulting services to government agencies at all levels, as well as domestic and global corporations. With subject matter expertise in Investment Banking, Finance, Healthcare, Media & Telecommunications, and Manufacturing, Sharp Decisions is well equipped to serve your needs.

Established in 1990 with headquarters in New York City, and locations in Princeton, Charlotte, Los Angeles, Phoenix, Europe and Canada, Sharp Decisions has been the technology backbone for a client portfolio that includes an array of well-known companies. As a Certified Woman-Owned Business Enterprise and approved vendor, Sharp Decisions offers a powerful, cost-effective advantage. We actively partner with other MBEs to add value and meet diversity program requirements.

Sharp Decisions is also committed to hiring and training post-9/11, tech-savvy U.S. armed forces veterans through our V.E.T.S.â„¢ (Vocation, Education and Training for Service members) Program, but we cannot do it alone. Companies like EmblemHealth, Freddie Mac and Experian have stepped up to bring aboard our highly qualified and skilled veterans. We need more companies like them to take a stand and bring our veterans aboard. Our clients have told us that our veterans are more effective than their college hires because two weeks on the job for them equates to 2-3 years of experience! Learn more at www.sharpdecisions.com/vetsprogram.

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1990

Resume Resources

Free Resume TemplatesFree Resume Builder