> Markdown version of [/jobs/ext/1133508-db2-dba-74-00](https://www.wearedevelopers.com/jobs/ext/1133508-db2-dba-74-00). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # DB2 DBA $74.00 - **Company:** Calance Consulting Corporation - **Location:** Marysville, OH, United States - **Experience:** Expert - **Salary:** $141,440.0 - $153,920.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Batch Processing, Databases, IBM DB2, Database Security, Monitoring of Systems, Job Control Language (JCL), Mainframes, Performance Tuning, Query Optimization, Service Pack, Subsystems, Z/OS, Data Logging, System Availability, Database Performance, Indexer, Omegamon, Sql Tuning, Database Tools and Utilities - **Published:** July 2, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=4900f22c25166539 ## About the Role 5+ 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. ## Description 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. 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. DAILY TASKS 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. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [".Net is too slow" was not an option](https://www.wearedevelopers.com/videos/100176-net-is-too-slow-was-not-an-option) ## Related Articles - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Software Developer Salary in Switzerland [2023]](https://www.wearedevelopers.com/magazine/215-software-developer-salary-in-switzerland-2023) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)