Sql dba • gilbert 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
Our client, a leading organization in the technology sector, is seeking a dedicated SQL DBA to join their dynamic team.As a SQL DBA, you will be an integral part of the IT department supporting dat... Mostrar más
Are You Ready to TURNIP the BEET on What Kids Eat®?Sticky Fingers Cooking is looking for an enthusiastic part-time Chef Teacher to bring hands-on cooking classes to kids with Gilbert Public Schools... 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
In an increasingly challenging environment marked by disruptive tech like AI, market uncertainty, and regulatory change, finance and global business services leaders recognize the opportunity to be... Mostrar más
International Solution Sources, Inc.Director Product Management in Mesa, AZ.Job duration: 40 Hours/Week, Permanent position, Full time.Job duties include collaborating with the company's top leader... Mostrar más
Outstanding long-term contract opportunity! A well-known Financial Services Company is looking for a Software Engineer in Chandler, AZ (Hybrid).Work with the brightest minds at one of the largest f... Mostrar más
Central Self Storage is known for developing extraordinary leaders who drive business success by doing the right thing for our customers.As a Central Self Storage leader, you take action to make a ... Mostrar más
Senior Analyst - Analytics & Reporting.As a Senior Analyst - Analytics and Reporting you'll play a critical role in driving data-driven decision-making across the organization.You'll develop, maint... Mostrar más
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... 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
In most jobs, everyone doesnt spontaneously erupt into applause and start raining down high-fives.At Buffalo Wild Wings, thats just a Thursday night.This is the place to start the next phase of you... Mostrar más
Arizona Liver Health (ALH) is dedicated to driving high standards of care and advancing medical innovation through leading clinical trials, ensuring patient safety and regulatory compliance, and ge... Mostrar más
WFH:HYBRID-COGNIZANT IS LOOKING FOR CONTRACTOR 1.Technical Product Manager/Lead Experience (4-6 years).Net, Angular, MS SQL, Kafka/AMQP, Cloud PaaS/SaaS solutions, Azure Architecture, Kubernetes, D... Mostrar más
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... Mostrar más
The Store Manager serves as the face of ACE Cash Express to our customers.On top of providing customer service and facilitating sales, you will also build professional relationships with customers,... Mostrar más
A General Manager with Barnett Management Company, dba Burger King, is responsible for overseeing the operation of the restaurant.Individuals in this position manage a group of line-level employees... Mostrar más
Business Execution Consultant - GenAI & Wholesale Data Management.Data Insight use case: strong data management experience is needed.Business Execution Consultant - GenAI & Wholesale Data Managemen... Mostrar más
Management in Training (MIT) - Hot Deli Department Manager.Ranch Market is one of the largest Asian supermarket chains in the United States, with over 70 store locations in California, Nevada, Texa... 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
