Текст заказа
Compensation & Location
Location: Marysville, OH
Schedule: Full-time contract
Work Type: Onsite 4 days and 1 day remote
Pay Range: $67.00 – $74.00 per hour (based on experience & internal equity)
Benefits: Health, Dental, Vision, Life Insurance, 401k, Continuing & On-Demand Education
Must be willing to work in Marysville, OH
Sponsorship is available for this role
W2 ONLY — No C2C, No 3rd Parties
Position Summary
We are seeking an experienced Senior IBM Db2 z/OS Database Administrator to manage, optimize, and support mission-critical mainframe database environments within a large-scale enterprise manufacturing organization.
This role requires 5–10 years of hands-on Db2 for z/OS database administration experience, with deep expertise in database performance tuning, subsystem monitoring, SQL optimization, database utilities, maintenance, and recovery.
The ideal candidate has a strong background supporting 24x7 enterprise production environments, troubleshooting complex mainframe database issues, and collaborating with application development teams to ensure database performance, scalability, security, and reliability.
This is a hands-on mainframe Db2 DBA position, not a distributed Db2, SQL Server, Oracle, or general database administration role.
What This Person Will Be Working On
* Serve as the primary Db2 DBA contact for application onboarding, upgrades, major enhancements, and enterprise projects.
* Administer and support IBM Db2 for z/OS databases and subsystems in a large enterprise environment.
* Monitor Db2 subsystem performance, including CPU utilization, I/O, buffer pools, locking, and SQL query execution.
* Identify and resolve database performance bottlenecks through SQL tuning, index optimization, and configuration adjustments.
* Use Omegamon, EXPLAIN, RMF, SMF, and native Db2 utilities to analyze database performance and troubleshoot issues.
* Collaborate with application development teams to optimize SQL statements, execution plans, indexes, and database access paths.
* Monitor database health, performance metrics, system availability, and security events.
* Configure monitoring alerts and proactively address potential database issues before they impact production.
* Plan and execute Db2 maintenance activities, including PTFs, service packs, patches, and version upgrades.
* Support database logging, backup, recovery, and high-availability processes.
* Troubleshoot database locking, contention, query performance, and subsystem resource utilization.
* Work with mainframe operations teams on z/OS datasets, JCL, batch processing, and job scheduling.
* Participate in large-scale infrastructure and application projects requiring database changes or enhancements.
* Support SOX compliance, audit requirements, database security, and access controls.
* Identify opportunities to improve database reliability, operational efficiency, and performance.
* Coordinate with application teams, infrastructure engineers, and business stakeholders to support critical production systems.
Required Skills & Experience
* 5–10 years of hands-on IBM Db2 for z/OS DBA experience in large enterprise environments, preferably supporting manufacturing operations.
* Strong knowledge of Db2 z/OS architecture, subsystems, database utilities, logging, and recovery.
* Experience supporting mission-critical production databases with 24x7 availability requirements.
* Deep experience with Db2 performance monitoring, SQL tuning, query optimization, and index optimization.
* Strong understanding of SQL execution plans, EXPLAIN, access paths, and database performance analysis.
* Experience monitoring CPU, I/O, buffer pools, locking, and database subsystem performance.
* Hands-on experience with Omegamon or comparable mainframe database performance monitoring tools.
* Familiarity with RMF, SMF, and native Db2 utilities for performance analysis and troubleshooting.
* Experience planning and executing Db2 PTFs, service packs, maintenance, and version upgrades.
* Strong understanding of mainframe operations, z/OS datasets, JCL, batch processing, and job scheduling.
* Experience with database backup, recovery, logging, and high-availability operations.
* Strong knowledge of SOX compliance, audit processes, and database security best practices.
* Experience supporting large-scale enterprise projects and coordinating with cross-functional technical teams.
* Ability to independently troubleshoot complex database issues and recommend performance improvements.
* Strong communication, analytical, problem-solving, and technical documentation skills.
Desired Skills
* Experience supporting Db2 z/OS databases within automotive or manufacturing environments.
* Experience managing high-volume, transaction-intensive enterprise databases.
* Experience with Db2 subsystem upgrades, maintenance planning, and production change management.
* Familiarity with Db2 utilities such as REORG, RUNSTATS, COPY, RECOVER, LOAD, and UNLOAD.
* Experience troubleshooting database locking, deadlocks, buffer pool performance, and resource contention.
* Knowledge of mainframe workload management, performance reporting, and capacity planning.
* Experience working with application teams on SQL performance improvements and database design.
* Familiarity with RACF, database authorization, access management, and audit controls.
* Experience supporting enterprise disaster recovery and database recovery testing.
* Knowledge of mainframe automation, operational monitoring, and proactive alerting.
* Experience supporting major application upgrades, migrations, or infrastructure modernization projects.