{"schemaVersion":"jobsearcher.job.v1","id":"de2fe03e89271d46aaaecf72","url":"https://jobsearcher.com/jobs/de2fe03e89271d46aaaecf72","canonicalUrl":"https://jobsearcher.com/jobs/de2fe03e89271d46aaaecf72","title":"SQL Tuning & Mainframe DBA","description":"SQL Tuning & Mainframe DBARole: SQL Tuning & Mainframe DBA - Cincinnati, OH - Day 1 Onsite5-10 years of experience as a Mainframe DBA with strong expertise in DB2 on z/OS.Proven hands-on experience with SQL performance tuning and query optimization in large-scale environments.Strong knowledge of DB2 utilities (REORG, RUNSTATS, LOAD, COPY, RECOVER, etc.).Expertise in database monitoring tools (e.g., OMEGAMON, BMC, CA tools).Solid understanding of database indexing, locking, partitioning, and access path analysis (EXPLAIN, PLAN_TABLE).Experience with batch processing and online transaction processing (OLTP) systems.Knowledge of JCL, COBOL, or other mainframe languages is a plus.Excellent problem-solving, analytical, and communication skills.","company":"United It","rawCompany":"united it","city":"Dayton","state":"OH","isRemote":false,"isActive":false,"createdAt":"2026-08-22T12:32:15.920Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"SQL Tuning & Mainframe DBA","description":"SQL Tuning & Mainframe DBARole: SQL Tuning & Mainframe DBA - Cincinnati, OH - Day 1 Onsite5-10 years of experience as a Mainframe DBA with strong expertise in DB2 on z/OS.Proven hands-on experience with SQL performance tuning and query optimization in large-scale environments.Strong knowledge of DB2 utilities (REORG, RUNSTATS, LOAD, COPY, RECOVER, etc.).Expertise in database monitoring tools (e.g., OMEGAMON, BMC, CA tools).Solid understanding of database indexing, locking, partitioning, and access path analysis (EXPLAIN, PLAN_TABLE).Experience with batch processing and online transaction processing (OLTP) systems.Knowledge of JCL, COBOL, or other mainframe languages is a plus.Excellent problem-solving, analytical, and communication skills.","datePosted":"2026-08-22T12:32:15.920Z","dateModified":"2026-08-22T12:32:15.920Z","hiringOrganization":{"@type":"Organization","name":"United It","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Dayton","addressRegion":"OH","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"de2fe03e89271d46aaaecf72"},"url":"https://jobsearcher.com/jobs/de2fe03e89271d46aaaecf72"}}