Database • mesa az
Mainframe Db2 Database Administrator (DBA) .Chandler, Arizona; Plano, Texas; Charlotte, North Carolina; Jersey City, New Jersey.Hybrid – 3 days onsite and 2 days remote per week.We are seeking an ... Show more
We are searching for a friendly and professional deli clerk to join our restaurant staff.As the first point of contact, you will greet and assist customers as they enter our restaurant.In this posi... Show more
This GPS Security role supports compliant personnel security processing for classified, CUI/Public Trust, and agency-sensitive programs under NISPOM, government agency, and firm requirements.The po... Show more
As an Account Associate - State Farm Agent Team Member for Matt Funicello - State Farm Agent, you are vital to our daily business operations and customers’ success.You grow our agency through meani... Show more
DriveTime Family of Brands is the largest privately owned used car sales finance & servicing company in the nation.Headquartered in Tempe, Arizona and Dallas, Texas, we create opportunities and... Show more
Job Title Data Control Analyst 2 Job Category Exempt Reports To Team Lead and/or Project Director Location Scottsdale, AZ (Hybrid) Job Description & Overview Gathers, organizes, and catalogs te... Show more
We are seeking a highly motivated and analytical Account Executive to join our dynamic team at FASTSIGNS of Gilbert.The ideal candidate will be responsible for analyzing our existing customer datab... Show more
Assistant Director of Development, W.The principal activity of the Assistant Director of Development is to be externally focused, with responsibility for engaging a portfolio of individuals, corpor... Show more
PacSci EMC is seeking a Manufacturing Trainer to prepare employees for safe, consistent work in our manufacturing environment.This role delivers hands-on training for new employees and coordinates ... Show more
The Release Manager owns the mechanics of moving code from merge to production across every Delivery Team.You are air traffic control for each release: you know what is in it and what is not, you c... Show more
Northrop Grumman Logistics Management Analyst Level 3.At Northrop Grumman, our employees have incredible opportunities to work on revolutionary systems that impact people's lives around the world t... Show more
Do you love talking to people and selling a product you believe in? We’re growing our team and looking for a driven inside sales representative ready to take the next step in their career.You’ll wo... Show more
As Account Associate - State Farm Agent Team Member for David Dorman - State Farm Agent, you are vital to our daily business operations and customers’ success.You grow our agency through meaningful... Show more
Become Your Own Boss At Caliver Beach Mortgage.Do you have strong relationship building skills? Have you built your business largely on referrals? Are you an entrepreneur at heart? If so, then we h... Show more
EchoStar is reimagining the future of connectivity.Our business reach spans satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans an... Show more
Sr AWS/Postgres Database Engineer.At The Intersect Group, we partner with industry-leading technology organizations A technology-driven organization operating large-scale, highly available SaaS pla... Show more
Mortgage Loan Officer - Hybrid.Division: Consumer-Direct Retail.Founded in 2014 and headquartered in Emeryville, CA, Newfi Lending is owned by Apollo Global Management, one of the largest private e... Show more
The Stocktaker is responsible for ensuring all products in the warehouse are properly accounted for.They must count merchandise on the warehouse floor and compare it to information maintained in a ... Show more
Arizona Spine and Joint Hospital .This is a full-time position, in person position.Under the supervision of the CFO, the.Receiving invoices from vendors, matching invoices with purchase orders... Show more
Reboot Monkey is a global datacenter services provider headquartered in Haarlem, Netherlands, operating.We deliver colocation, IP transit, smart hands, remote hands, and managed datacenter services... Show more
The average salary range is between $ 70,963 and $ 140,000 year , with the average salary hovering around $ 99,978 year .
Mainframe Db2 Database Administrator (DBA)
Duration: 6–12 Months(NO BENEFITS)
Work Locations: Chandler, Arizona; Plano, Texas; Charlotte, North Carolina; Jersey City, New Jersey
Work Arrangement: Hybrid – 3 days onsite and 2 days remote per week
Job Overview
We are seeking an experienced Mainframe Db2 Database Administrator (DBA) with strong hands-on expertise in IBM Db2 for z/OS to support large-scale, business-critical mainframe environments.
The ideal candidate will have extensive experience in database administration, performance tuning, maintenance, availability, backup and recovery, and production troubleshooting. This role involves close collaboration with application development, systems programming, infrastructure, security, and operations teams to ensure database reliability, performance, and data integrity.
Key Responsibilities Db2 Database Administration
Administer and support IBM Db2 for z/OS databases across development, testing, and production environments.
Create, maintain, and manage database objects, including databases, tablespaces, tables, indexes, views, and storage definitions.
Manage Db2 catalog objects, partitions, and database structures.
Monitor database health, capacity, performance, and space utilization.
Ensure database availability, integrity, and operational reliability.
Database Maintenance & Utilities
Execute and manage Db2 utilities, including REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, and REBUILD INDEX.
Perform database reorganization, statistics collection, data loading, integrity checking, and recovery operations.
Develop and maintain JCL for Db2 utilities and database maintenance processes.
Troubleshoot utility failures and implement appropriate corrective actions.
Performance Tuning & Optimization
Analyze and tune SQL statements and database performance.
Review Db2 access paths, indexing strategies, and query execution behavior.
Identify and resolve performance bottlenecks, locking issues, and concurrency problems.
Recommend improvements to SQL statements, indexes, and database design.
Optimize database objects to maintain performance and availability.
Backup, Recovery & Production Support
Support database backup, recovery, and disaster recovery activities.
Troubleshoot Db2 errors, SQL issues, performance degradation, and production incidents.
Participate in incident resolution, root cause analysis, and preventive action implementation.
Support database schema changes and application deployments through controlled implementation processes.
Assist with Db2 upgrades, maintenance, migrations, and modernization initiatives.
Documentation & Collaboration
Collaborate with application developers, systems programmers, infrastructure teams, and production operations.
Maintain technical documentation, database standards, operational procedures, and recovery plans.
Follow established change management and production deployment processes.
Support highly available enterprise mainframe environments.
Required Qualifications
Strong hands-on experience with IBM Db2 for z/OS.
Extensive knowledge of Db2 database administration and object management.
Strong understanding of tablespaces, tables, indexes, partitions, views, and the Db2 catalog.
Experience with SQL development support, query analysis, and performance tuning.
Hands-on experience with Db2 utilities, including REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, and REBUILD INDEX.
Knowledge of database backup, recovery, and disaster recovery procedures.
Experience with database performance monitoring, locking, concurrency, and troubleshooting.
Knowledge of Db2 storage and space management.
Strong experience with JCL.
Good working knowledge of IBM z/OS.
Experience supporting large-scale, highly available production mainframe environments.
Experience with production incident management, problem resolution, and controlled change implementation.
Preferred Technical Skills
IBM Db2 Administration Tool
IBM OMEGAMON for Db2
Db2 Query Monitor or equivalent performance monitoring tools
IBM or third-party Db2 utility products
REXX scripting
TSO/ISPF
SDSF
Db2 data sharing and IBM Parallel Sysplex environments
){kind=logo}
