Mainframe Database Administrator at DS Technologies Inc in AZ-Chandler-85224 Hybrid - US

Job description

• DS Technologies Inc is looking for Mainframe Database Administrator role for one of our premier clients.

Responsibilities

• 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.
• 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.
• 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 high‑availability configurations such as data sharing groups and sysplex architectures.
• 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.
• 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.
• 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.
• 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.

Requirements

• 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.
• 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).

Skills

Required

• DB2 for z/OS
• IMS DB/DC
• SQL
• z/OS environment
• JES2/JES3
• VSAM datasets
• SMF/RMF data analysis
• Parallel Sysplex
• Diagnostic and problem-solving

Preferred

• OMEGAMON
• MainView
• CA Detector
• Apptune
• DevOps practices for mainframe

Benefits

• Flexible work from home options available.