DBA SQL Level II

UNICON International Inc.; Marysville (OH); On-site; USD 132,000 - 137,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k)

Standard benefits

Job summary

UNICON International Inc. in Marysville, OH is seeking a DBA SQL Level II with 5-10 years of experience in DB2 for z/OS. The role involves fine-tuning database systems and monitoring performance to ensure reliability.

The ideal candidate should possess strong skills in performance tuning, SQL execution plan analysis, and mainframe operations. This is an onsite position requiring interaction with cross-functional teams and critical production systems.

Qualifications

• 5-10 years of hands-on DB2 for z/OS DBA experience in enterprise environments.
• Experience supporting critical production systems with 24x7 availability.
• Deep knowledge of DB2 z/OS architecture, utilities, and recovery.
• Strong knowledge of SOX and database security best practices.

Responsibilities

• Fine-tune database systems for performance and reliability.
• Monitor database performance and identify bottlenecks.
• Act as primary DBA contact during application onboarding.
• Plan and execute DB2 maintenance activities.

Skills

DB2 for z/OS

Performance tuning

SQL tuning

Mainframe operations

Monitoring tools

Job description

Position Overview

Meet with application teams to understand requirements and recommend high-level direction and approach to upcoming projects.

Job Details

• Job Title: DBA SQL Level II
• Location: Marysville, OH
• Work Model: Onsite
• Work Type: Onsite 4 days per week
• Travel: 5%
• Overtime: No
• Compensation: $132k–137k
• Local Candidates Only

Responsibilities

• Fine-tune database systems to enhance performance, scalability, and reliability, monitoring and optimizing database query performance, indexing, and caching.
• Monitor database performance using built-in tools and third‑party solutions; identify and resolve performance bottlenecks through query optimization, index tuning, and configuration adjustments.
• Utilize monitoring tools to track database health, performance metrics, and security events; set up alerts to notify administrators of potential issues.
• 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.

Qualifications

• 5–10 years of hands‑on DB2 for z/OS (Manufacturing) 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.

Compensation and Benefits

• Medical, dental, and vision insurance.
• 401(k).
• Other standard benefits as applicable.

UNICON is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.