DBA SQL Level II

UNICON International, Inc.

Marysville, OH

Apply

JOB DETAILS

SALARY

$132,000–$137,000 Per Year

SKILLS

Analysis Skills, Best Practices, CPU (Central Processing Unit), Caching, Cross-Functional, Data Sets, Database Administration, Database Optimization, Database Technology, Dental Insurance, High Availability, High Reliability, IBM DB2, IBM z-OS Operating System, Information/Data Security (InfoSec), Input/Output, JCL (Job Control Language), Mainframe Computer, Manufacturing, 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, Vision Plan, Willing to Travel

LOCATION

Marysville, OH

POSTED

30+ days ago

Job Title: DBA SQL Level II
Location: Marysville, OH
Work Model: Onsite
Compensation: $132-137k

Work Type: Onsite 4 days per week
Travel: 5%
Overtime: No

POSITION OVERVIEW
Meet with application teams to understand requirements and recommend high-level direction and approach to upcoming projects.
• Fine-tuning database systems to enhance performance, scalability, and reliability. This includes monitoring and optimizing database query performance, indexing, and database 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.

WHAT YOU WILL BE DOING
• 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.

WHAT’S NEEDED
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 & BENEFITS
• Medical, dental, and vision insurance
• 401(k)
• Other standard benefits as applicable

ABOUT UNICON
UNICON is a workforce solutions provider with over 35 years of experience supporting organizations across a variety of industries. We partner with our clients to deliver skilled professionals while maintaining a strong focus on quality, compliance, and long-term relationships. 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.

About the Company

UNICON International, Inc.

Resume Resources

Free Resume Templates Free Resume Builder