DB2 z/OS DBA
- Marysville, OH, United States
$55 to $65 USD / hour
Applications open in a new tab.
Job details
- Pay
- $55 to $65 USD / hour
- Apply by
- Experience
- 5-10 years of hands-on experience with DB2 for z/OS in large enterprise environments, preferably within manufacturing or automotive settings.
- Posting language
- English
- Posted
Original job description
We are looking for a DBA SQL Level II to support database administration and performance improvement efforts for an automotive environment in Marysville, Ohio. This is a Long-term Contract position requiring an onsite presence four days per week, where you will partner with application and infrastructure teams to guide database-related initiatives and maintain reliable production operations. The role focuses on strengthening availability, scalability, and security across critical database platforms while helping teams make sound technical decisions for upcoming work.
Responsibilities:
- Partner with application stakeholders to gather business and technical needs, then recommend practical database strategies for new and evolving projects.
- Improve database efficiency by analyzing workloads, refining SQL performance, and enhancing indexing, caching, and configuration settings.
- Oversee database health through ongoing monitoring, using platform-native and third-party tools to identify trends and address emerging risks.
- Investigate and resolve performance constraints by tuning queries, adjusting system parameters, and applying appropriate database utilities.
- Establish and maintain alerts for availability, performance, and security conditions so issues can be addressed before they affect operations.
- Support highly available production databases in a large enterprise setting, ensuring stable service for mission-critical workloads.
- Contribute to recovery readiness by maintaining knowledge of logging, backup, and restoration processes aligned with mainframe database operations.
- Work closely with cross-functional teams on large-scale initiatives, coordinating database activities, timelines, and technical dependencies.
- 5-10 years of hands-on experience with DB2 for z/OS in large enterprise environments, preferably within manufacturing or automotive settings.
- Proven background supporting production database systems that require continuous availability and dependable operational performance.
- Strong expertise in database performance tuning, utility execution, and execution plan analysis for complex SQL workloads.
- Deep understanding of DB2 for z/OS architecture, including subsystems, utilities, logging, and recovery concepts.
- Experience with monitoring platforms such as Omegamon and familiarity with interpreting mainframe performance metrics.
- Working knowledge of z/OS concepts, including datasets, batch processing, and job scheduling practices.
- Solid understanding of database security controls, audit considerations, and operational best practices.
- Ability to collaborate effectively across technical teams while contributing to planning and delivery for large-scale projects.
More about this job
Skills
- IBM DB2
- SQL
- Database administration
- Database management systems
- Scheduling