Find JobsSalary EstimateCareer AdviceUpload ResumeEmployers / Post JobProfileMessage Center

Mainframe Database Administrator

Artech LLC

Chandler, AZ

Apply
JOB DETAILS
SKILLS
ACF2 (Access Control Facility 2), Administrative Skills, Analysis Skills, Auditing, Automation, Change Management, Compuware File-aid, Cryptography, Data Analysis, Data Description Language (DDL), Data Quality, Data Recovery, Data Sets, Database Administration, Database Design, Database Technology, DevOps, Documentation, High Availability, IBM DB2, IBM IMS Database, IBM Job Entry Subsystem, IBM Product Family, IBM Sysplex, IBM z-OS Operating System, IMS DB/DC, Identify Issues, Information/Data Security (InfoSec), Mainframe Computer, Maintain Compliance, Microsoft Access Database, Performance Analysis, Performance Metrics, Problem Solving Skills, QMF, RACF (Resource Access Control Facility), Registered Training Organisation (RTO), Regulatory Compliance, Release Management/Engineering, Root Cause Analysis, SQL (Structured Query Language), Software Administration, Software Patches, Systems Administration/Management, Systems Maintenance, Testing
LOCATION
Chandler, AZ
POSTED
5 days ago

Job Title: Mainframe Database Administrator

Location: Chandler AZ (Hybrid)

Duration: 6-12months

 

Mainframe Database Administrator:

  • Install, configure, and maintain mainframe database subsystems (e.g., DB2 for z/OS, IMS DB/DC).
  • Manage database objects, including tablespaces, databases, tables, indexes, views, and buffer pools.
  • Perform routine administrative tasks such as reorganizations, RUNSTATS, image copies, and space management.
  • Apply database maintenance, patches, and version upgrades while minimizing service disruption.

Performance Monitoring & Tuning

  • Monitor and tune SQL queries, application packages, buffer pools, and overall subsystem performance.
  • Analyze SMF records and performance metrics using tools such as OMEGAMON, MainView, or IBM Data Server Manager.
  • Identify and resolve performance bottlenecks in batch and online workloads.

Backup, Recovery & High Availability

  • Develop, implement, and test backup/recovery strategies using tools such as IBM RECOVER, COPY, and log management utilities.
  • Ensure compliance with recovery time (RTO) and recovery point objectives (RPO).
  • Support and maintain highavailability configurations such as data sharing groups and sysplex architectures.

Data Integrity & Security

  • Implement database security, including RACF/ACF2 rules, roles, privileges, and auditing.
  • Ensure data protection, encryption standards, and regulatory compliance.
  • Validate database changes through controlled release and change management processes.

Application & Development Support

  • Support application teams with schema design, query tuning, and access path optimization.
  • Review DDL changes, SQL code, and performance impacts during development and deployments.
  • Provide expertise during application migrations, new releases, and modernization initiatives.

Problem Management & Troubleshooting

  • Diagnose and resolve database incidents, failures, locking/contention issues, and subsystem degradations.
  • Participate in root-cause analysis (RCA) for recurring database or performance issues.
  • Serve as subject matter expert during incidents affecting critical systems.

Automation, Tools & Documentation

  • Use and configure database tools such as IBM DB2 Utilities, IMS tools, QMF, Data Studio, or File-AID.
  • Automate routine tasks and reporting using REXX, CLIST, JCL, or modern scripting where applicable.
  • Maintain comprehensive documentation for database standards, procedures, and recovery instructions.

 

Required Qualifications

  • Hands-on experience with DB2 for z/OS, IMS DB/DC, or equivalent mainframe database systems.
  • Strong SQL skills and in-depth knowledge of database internals, access paths, and optimization.
  • Understanding of z/OS environment, JES2/JES3, datasets (VSAM), and utilities.
  • Experience with SMF/RMF data analysis and performance reporting.
  • Familiarity with high availability and data sharing concepts (e.g., Parallel Sysplex).
  • Strong diagnostic and problem-solving skills.

 

Preferred Qualifications

  • Experience with IBM tools such as OMEGAMON, MainView, CA Detector, or Apptune.
  • Knowledge of DevOps practices for mainframe environments.
  • Exposure to modern data integration or modernization platforms.
  • Relevant certifications (e.g., IBM Certified Database Administrator – DB2 for z/OS).

About the Company

A

Artech LLC