Sql database administrator • 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 ... Mostrar más
The Dynamics365 Administrator will be responsible for the configuration, maintenance, and optimization of the LATICRETE Microsoft Dynamics365 platform, with a focus on Marketing and Customer Insigh... Mostrar más
Relocation Authorized: National - Family.Telework Type: Full-Time Office/Project.Extraordinary teams building inspiring projects:.Since 1898, we have helped customers complete more than 25,000 proj... Mostrar más
Home Matters Caregiving, East Valley -.Home Matters Caregiving, East Valley.Compassionate Care You Can Depend On.We are seeking a dedicated and compassionate.Home Matters Caregiving, East Valley.As... Mostrar más
Kaiser Aluminum Alexco Chandler Arizona located 6520 W Allison Rd, Chandler, AZ is seeking an Operations Administrator to join our team in a fast-paced aluminum extrusion facility.Kaiser Aluminum i... Mostrar más
Facilities Management Administrator.Hims & Hers is the leading health and wellness platform, on a mission to help the world feel great through the power of better health.We are redefining healthcar... Mostrar más
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... Mostrar más
Join our client as a Subcontract Administrator in Chandler, AZ! Requires a B.EPC subcontract formation/administration skills.Partner with a global leader delivering generation-defining projects tha... Mostrar más
The Customer Support Business Group focuses on enabling our customers with premier customer support throughout their lifecycle with Lam.We drive performance, productivity, safety, and quality of cu... Mostrar más
Wye Electric, Inc is looking for a full-time, detailed-oriented Office Administrator to help with the organization and the running of daily administrative operations of the company.This is an excel... Mostrar más
FUJIFILM Electronic Materials, U.We have an exciting opportunity for a Procore Administrator!.The Procore Administrator plays a vital role throughout the life of construction projects from startup ... Mostrar más
Who We AreGPS Insight offers leading technology for organizations that have drivers and technicians in the field, fleets of vehicles, trailers, and other mobile assets.We provide innovative fleet s... Mostrar más
Extraordinary Teams Building Inspiring Projects.Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown econom... Mostrar más
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... Mostrar más
Bolte Homes is a residential construction company based in Scottsdale, Arizona.Our projects include custom homes, semi-custom homes, single-family attached homes, and multi-family homes.We’re seeki... Mostrar más
As a Front office Administrator are you in an environment where you can provide the best care possible and be rewarded for it OR, is something missing?.Our Front office Administrators are val... Mostrar más
Systems Administrator | IT Operations.At DollarDays, our mission is simple: Make a difference for those who are making a difference.Since 2001, DollarDays has partnered with nonprofits, schools, ch... Mostrar más
When you join Ancestry, you join a human-centered company where every person’s story is important.Ancestry®, the global leader in family history, connects everyone with their past so they can disco... Mostrar más
Requires bachelor's degree (or international equivalent) and 5-8 years of relevant experience or 9-12 years of relevant work experience.Knowledge of service acquisition & procurement regulations, p... Mostrar más
Progress Residential Lease Administrator.Ready to make an impact with a dynamic, forward-thinking company?.As a leading property manager of single-family rental homes nationwide, we take great prid... Mostrar más
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
